-
it works on Oracle with 0.2.1, thanks!
2005-12-13 09:09:52 UTC by nobody
-
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().
2005-12-13 00:15:22 UTC by duff3
-
duff3 committed patchset 9 of module db2dot to the db2dot CVS repository, changing 2 files.
2005-12-13 00:12:43 UTC by duff3
-
duff3 committed patchset 8 of module db2dot to the db2dot CVS repository, changing 1 files.
2005-12-12 22:47:29 UTC by duff3
-
duff3 committed patchset 7 of module db2dot to the db2dot CVS repository, changing 2 files.
2005-12-12 22:39:56 UTC by 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...
2005-11-21 23:31:16 UTC by duff3
-
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
db.
2005-11-21 09:22:07 UTC by nobody
-
Ah, that is much better looking. Are you sure there are foreign keys in the schema? In mysql (and a quick look at postgresql's docs) one way of doing that is with create table constrains like this:
CREATE TABLE tbl2 ( ForeignCol int );
CREATE TABLE Foo (
Bar int,
CONSTRAINT AnyWord
FOREIGN KEY (Bar) REFERENCES tbl2 (ForeignCol)
)
If the tables don't have foreign keys, it can't figure...
2005-11-20 20:11:07 UTC by duff3
-
no, mmusic2 is the database name, which is on localhost.
2005-11-20 19:47:23 UTC by bhoel
-
Good news (somehow):
>java -jar db2dot-0.2.jar driver_path=/usr/share/pgsql/postgresql-8.0-311.jdbc3.jar driver=org.postgresql.Driver url=jdbc:postgresql:mmusic2 user=postgres
Loading library /usr/share/pgsql/postgresql-8.0-311.jdbc3.jar
digraph Db2dot {
No foreign keys in artist
artist;
No foreign keys in audio_tape
audio_tape;
No foreign keys in cd
cd;
No...
2005-11-20 19:38:32 UTC by bhoel
