Re: First use of v2.4 after 2.3.2 gets exception in Oracle driver called from SQLDatabaseMetaData.getColumns()

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 <david.karr@xxxxxxxx> 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
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

-------------------------------------------------------------------------
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