Thread: [Squirrel-sql-users] First use of v2.4 after 2.3.2 gets exception in Oracle driver called from SQLD
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Karr, D. <dav...@wa...> - 2007-01-13 21:49:31
|
I installed v2.4, and then changed the bat file to point to my Java 5 distro. When I brought it up, I connected to an alias I already had defined. It brought up the window showing the tables, but when I tried to view a table, nothing displayed in the pane. I noticed there was an error in the log file, which might be relevant. I didn't have this problem with v2.3.2. I assume v2.4 is using the same aliases and driver settings that I had set in v2.3.2. I can't view any table information with this version. I don't see a bug like this in the bug list. java.sql.SQLException: Io exception: invalid arguments in call at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) at oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502) at oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2416) at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. java:2803) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS tatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt atement.java:536) at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaD ata.java:242) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa tabaseMetaData.java:1834) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa tabaseMetaData.java:1855) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.ta ble.ColumnsTab.createDataSet(ColumnsTab.java:69) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Ba seDataSetTab$1.run(BaseDataSetTab.java:123) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java: 82) at java.lang.Thread.run(Thread.java:595) |
From: Robert M. <rob...@gm...> - 2007-01-14 00:45:23
|
That is a very peculiar exception. First, it's happening when we attempt to get the columns of a table using DatabaseMetaData which is a perfectly valid and necessary thing to do in this case. Second, it looks like OracleStatement.freeLine made a mistake by calling a procedure/method with the wrong arguments. Do you have the latest JDBC driver? Does it happen consistently or only some of the time. What if you refresh the tree? Do you have the Oracle plugin and have you set any Alias properties (like only load certain objects from some schemas, etc.) ? I haven't seen this behavior before and I use the 10g driver to connect to 9i and 10g much of the time. Rob On 1/13/07, Karr, David <dav...@wa...> wrote: > I installed v2.4, and then changed the bat file to point to my Java 5 > distro. When I brought it up, I connected to an alias I already had > defined. It brought up the window showing the tables, but when I tried > to view a table, nothing displayed in the pane. I noticed there was an > error in the log file, which might be relevant. I didn't have this > problem with v2.3.2. I assume v2.4 is using the same aliases and driver > settings that I had set in v2.3.2. I can't view any table information > with this version. I don't see a bug like this in the bug list. > > java.sql.SQLException: Io exception: invalid arguments in call > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) > at > oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502) > at > oracle.jdbc.driver.OracleConnection.needLine(OracleConnection.java:2416) > at > oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. > java:2803) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS > tatement.java:608) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt > atement.java:536) > at > oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaD > ata.java:242) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa > tabaseMetaData.java:1834) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumns(SQLDa > tabaseMetaData.java:1855) > at > net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.ta > ble.ColumnsTab.createDataSet(ColumnsTab.java:69) > at > net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Ba > seDataSetTab$1.run(BaseDataSetTab.java:123) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java: > 82) > at java.lang.Thread.run(Thread.java:595) > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: Karr, D. <dav...@wa...> - 2007-01-14 01:05:08
|
Well, never mind. I was a little sloppy and installed 2.4 on top of 2.3.2. After I did it more carefully and installed it in a separate location, 2.4 worked fine.=20 > -----Original Message----- > From: squ...@li...=20 > [mailto:squ...@li...] On=20 > Behalf Of Karr, David > Sent: Saturday, January 13, 2007 1:49 PM > To: squ...@li... > Subject: [Squirrel-sql-users] First use of v2.4 after 2.3.2=20 > gets exceptionin Oracle driver called from=20 > SQLDatabaseMetaData.getColumns() >=20 > I installed v2.4, and then changed the bat file to point to=20 > my Java 5 distro. When I brought it up, I connected to an=20 > alias I already had defined. It brought up the window=20 > showing the tables, but when I tried to view a table, nothing=20 > displayed in the pane. I noticed there was an error in the=20 > log file, which might be relevant. I didn't have this problem=20 > with v2.3.2. I assume v2.4 is using the same aliases and=20 > driver settings that I had set in v2.3.2. I can't view any=20 > table information with this version. I don't see a bug like=20 > this in the bug list. >=20 > java.sql.SQLException: Io exception: invalid arguments in call > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) > at > oracle.jdbc.driver.OracleStatement.freeLine(OracleStatement.java:6502) > at > oracle.jdbc.driver.OracleConnection.needLine(OracleConnection. > java:2416) > at > oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:574) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement. > java:2803) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl > ePreparedS > tatement.java:608) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracle > PreparedSt > atement.java:536) > at > oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDat > abaseMetaD > ata.java:242) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCol > umns(SQLDa > tabaseMetaData.java:1834) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getCol > umns(SQLDa > tabaseMetaData.java:1855) > at > net.sourceforge.squirrel_sql.client.session.mainpanel.objecttr > ee.tabs.ta > ble.ColumnsTab.createDataSet(ColumnsTab.java:69) > at > net.sourceforge.squirrel_sql.client.session.mainpanel.objecttr > ee.tabs.Ba > seDataSetTab$1.run(BaseDataSetTab.java:123) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExec > uter.java: > 82) > at java.lang.Thread.run(Thread.java:595) >=20 > -------------------------------------------------------------- > ----------- > Take Surveys. Earn Cash. Influence the Future of IT Join=20 > SourceForge.net's Techsay panel and you'll get the chance to=20 > share your opinions on IT & business topics through brief=20 > surveys - and earn cash=20 > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge &CID=3DDEVDEV > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >=20 |