java.sql.SQLException: Invalid column name while porting from 6.1 sp2 to 7.0 sp2

[Harshad Nanal]

I have an application running well on wls 6.1 sp2
It uses oracle thin driver pacjkaged with wls 6.1 sp2
It talks to Oracl 7.3.4 using connection pool and non Tx data source

i have ported this onto WLs 7.0 sp2. It results in following exception
Is this an issue with version of thin driver
What is the oracle thin driver version packaged with WLS 7.0sp2
I couldnt find any OracleDriver class in weblogic.jar

I also see that in the directory
\bea\weblogic700\server\ext there are oracle drivers 817, 901, 920
which of these is default?

Whats the solution?

Exception trace
-----------------

Invalid column name : java.sql.SQLException: Invalid column name

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:269)

at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:5971)

at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1527)

at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)

at weblogic.jdbc.pool.ResultSet.getString(ResultSet.java:269)

at weblogic.jdbc.rmi.internal.ResultSetImpl.getString(ResultSetImpl.java:439)

at weblogic.jdbc.rmi.internal.ResultSetStraightReader.getString(ResultSetStraightReader.java:117)

at weblogic.jdbc.rmi.SerialResultSet.getString(SerialResultSet.java:375)

at com.bt.btsecs.module.registration.dao.RegDAO.getLob(RegDAO.java:2299)

[Joe Weinstein]

Hi. This may indeed be an oracle thin driver version issue.
You should download the latest appropriate thin driver for
your DBMS, directly from oracle, and you should then read the
weblogic startup script to see how it constructs the -classpath
argument for starting weblogic. Edit the script to make sure your
downloaded driver is ahead of the weblogic.jar file so we use your
driver instead of the one in weblogic.jar which is different than
the one in 61sp2.
Joe

[Slava Imeshev]

Hi Harshad,

"Harshad Nanal" <har...@mahindrabt.com> wrote in message news:3fbcb425$1...@newsgroups.bea.com...

> I have an application running well on wls 6.1 sp2
> It uses oracle thin driver pacjkaged with wls 6.1 sp2
> It talks to Oracl 7.3.4 using connection pool and non Tx data source

It looks like you retrieve the String value from result set
by column name, not by index. To localize the problem,
before accessing the column, I'd print content from
ResultSetMetadata and see if this column is present
in the ResultSet and it has the expected name.

Hope this helps,

Regards,

Slava Imeshev