Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Io exception: Got minus one from a read call

 
sanket jani
Ranch Hand
Posts: 47
C++ Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello friends,

i have a problem with the database ,

i used oracle 10g express edition , running it on port 3010

in the eclipse kepler Database Development perspective i press the Test Connection button it give me the following error..

oracle server is running completely ..

please help me to solve this..

i have attached screenshot of its.

java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
datadev.png
[Thumbnail for datadev.png]
prgrmf.png
[Thumbnail for prgrmf.png]
database.png
[Thumbnail for database.png]
 
Anindya Roy
Ranch Hand
Posts: 76
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try with below steps

1. turn off your machines's Wi-fi, if it's already running.
2. Stop Oracle Service.
3. Start Oracle Service. Now try to connect with DataBase using JDBC.
 
sanket jani
Ranch Hand
Posts: 47
C++ Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry friend but its not working...

error are still there...
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure you are using the correct connection URL and driver?
 
chris webster
Bartender
Posts: 2407
33
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your screenshot shows you are using port 3010 for your Oracle web server, but the JDBC port is different. The default JDBC port for XE is usually 1521, so try using 1521 in your connection details. Also, you may not need to include the database name in the JDBC URL as XE only gives you one local database anyway.

http://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25320/getconn.htm#CACGJJFE

Also, you could install the very useful free Oracle tool SQL Developer and make sure you can connect to your database from there.

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
 
sanket jani
Ranch Hand
Posts: 47
C++ Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
chris webster wrote:Your screenshot shows you are using port 3010 for your Oracle web server, but the JDBC port is different. The default JDBC port for XE is usually 1521, so try using 1521 in your connection details. Also, you may not need to include the database name in the JDBC URL as XE only gives you one local database anyway.

http://docs.oracle.com/cd/B25329_01/doc/appdev.102/b25320/getconn.htm#CACGJJFE

Also, you could install the very useful free Oracle tool SQL Developer and make sure you can connect to your database from there.

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html


thanks brother .....problem solved...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic