File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle OCI Driver" Watch "Oracle OCI Driver" New topic
Author

Oracle OCI Driver

scott gaidos
Greenhorn

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.
java:4028)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(Oracl
eCallableStatement.java:226)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(Oracl
eCallableStatement.java:376)
at weblogic.jdbcbase.pool.Statement.registerOutParameter(Statement.java:
437)
The code works with the standard weblogic drivers.
Thanks,
Scott
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
jdbc in Unix
Installation of JDriver (weblogic 5.1) for Oracle on Solaris
JDBC connection troubles
PreparedStatement.toString()
UTF8 conversion