Oracle 10G Express edition connection issue

Highlighted
One Star

Oracle 10G Express edition connection issue

I'm working on Windows 7 and Oracle 10G Express edition database.
When I try to create a new database connection with the followings parameters :
Login : system
Password : admin
DBTYPE : Oracle with SID

DBURL
Hostname : localhost
Port : 8080
SID : 100
Schema : myapp

I have the here below error message :

"Chech connection failure:Exception d'E/S:Got minus one from a read call"

Thanks in advance for your support.

Damien.
Employee

Re: Oracle 10G Express edition connection issue

here are my settings that worked from within TIS and I assume TOS. I'm assuming you want to connect to the sample HR app contained within the 10gExpress download.

DB Type=Oracle with SID
Db Version=Oracle10
Login=hr
Password=hr
Server=localhost
Port=1521
Sid=XE
Schema=HR

I hope this helps.
One Star

Re: Oracle 10G Express edition connection issue

Getting below mention error.
please help me out

Starting job EXCEPTION_UPDATE at 15:08 06/04/2012.

[statistics] connecting to socket on port 3717
[statistics] connected
Exception in component tOracleOutput_1
java.sql.SQLException: Got minus one from a read call
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.tOracleInput_1Process(EXCEPTION_UPDATE.java:1771)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.runJobInTOS(EXCEPTION_UPDATE.java:5747)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.main(EXCEPTION_UPDATE.java:5592)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:243)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 9 more
[statistics] disconnected
Job EXCEPTION_UPDATE ended at 15:26 06/04/2012. [exit code=1]
One Star

Re: Oracle 10G Express edition connection issue

I have a job
toracleinput===>tflowtoiterate====>tdb2input====>tmap====>toracleoutput

i am facing error

Starting job EXCEPTION_UPDATE at 15:08 06/04/2012.

[statistics] connecting to socket on port 3717
[statistics] connected
Exception in component tOracleOutput_1
java.sql.SQLException: Got minus one from a read call
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.tOracleInput_1Process(EXCEPTION_UPDATE.java:1771)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.runJobInTOS(EXCEPTION_UPDATE.java:5747)
at bsli_mis.exception_update_0_1.EXCEPTION_UPDATE.main(EXCEPTION_UPDATE.java:5592)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:243)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 9 more
[statistics] disconnected
Job EXCEPTION_UPDATE ended at 15:26 06/04/2012. [exit code=1]

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read