• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle OCI Driver

 
scott gaidos
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic