db2dot

Tracker: Bugs

5 Error when connecting to Oracle - ID: 1362634

Last Update: Comment added ( nobody )

Details:

Loading library
java.sql.SQLException: Invalid operation for forward
only resultset : first
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.driver.BaseResultSet.first(BaseResultSet.java:84)
at db2dot.db.DbMisc.columnToList(DbMisc.java:27)
at
db2dot.db.Inquisitor.getTableNames(Inquisitor.java:54)
at
db2dot.db.Inquisitor.getTableNames(Inquisitor.java:47)
at db2dot.Db2dot.outputDot(Db2dot.java:51)
at db2dot.Db2dot.main(Db2dot.java:169)

Submitted:

Nobody/Anonymous ( nobody ) - 2005-11-21 09:22

Priority:

Status:

Closed

Resolution:

Fixed

Assigned:

duff3

Category:

DB access

Group:

None

Visibility:

Public

Comments ( 3 )

Date: 2005-12-13 09:09 Sender: nobody Logged In: NO it works on Oracle with 0.2.1, thanks!
Date: 2005-12-13 00:15 Sender: duff3 Logged In: YES user_id=1380208 I believe the latest version will work, it has the ResultSet.first() calls taken out and replaced with just .next().
Date: 2005-11-21 23:31 Sender: duff3 Logged In: YES user_id=1380208 It looks like the Oracle driver is only JDBC 1.0 which means it doesn't support scrollable cursors and my use of ResultSet.first() was not appreciated. I've attached a patch to CVS which removes the offending method calls. I don't have Oracle so I cannot duplicate your bug to see if it is all fixed, so if you could give it a try and let me know if it works it would be appreciated.

Log in to comment.

Attached File ( 1 )

Filename	Description	Download
db2dot.bug-1362634.patch	Possible fix	Download

Changes ( 6 )

Field	Old Value	Date	By
status_id	Open	2005-12-13 00:15	duff3
resolution_id	None	2005-12-13 00:15	duff3
close_date	-	2005-12-13 00:15	duff3
category_id	None	2005-11-21 23:34	duff3
assigned_to	nobody	2005-11-21 23:34	duff3
File Added	157119: db2dot.bug-1362634.patch	2005-11-21 23:31	duff3

db2dot

Tracker: Bugs

Comments ( 3 )

Log in to comment.

Attached File ( 1 )

Changes ( 6 )

About SourceForge

Find Software

Develop Software

Community

Help