wood burning stoves 2.0*
The moose likes JDBC and the fly likes Oracle OCI Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle OCI Driver" Watch "Oracle OCI Driver" New topic

Oracle OCI Driver

scott gaidos

Joined: Jan 30, 2002
Posts: 6
I'm trying to use Oracle OCI drivers to connect to a Oracle 8.1.6 database on a Solaris box with Weblogic 5.1 sp11. The connection pool gets created successfully but when I try to run a query I get the following error:
java.sql.SQLException: Invalid column type
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(Oracl
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(Oracl
at weblogic.jdbcbase.pool.Statement.registerOutParameter(Statement.java:
The code works with the standard weblogic drivers.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

what is code for the prepared statements (and the binding of variable to them) and the Oracle column types for each column in the prepared statement?
I agree. Here's the link: http://aspose.com/file-tools
subject: Oracle OCI Driver
Similar Threads
UTF8 conversion
jdbc in Unix
JDBC connection troubles
Installation of JDriver (weblogic 5.1) for Oracle on Solaris