The moose likes JDBC and the fly likes Oracle driver vs Weblogic driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle driver vs Weblogic driver" Watch "Oracle driver vs Weblogic driver" New topic

Oracle driver vs Weblogic driver

Sam Phillip

Joined: Oct 05, 2004
Posts: 5
Hi All,

I am using weblogic 8.1 sp2 with Oracle 9i.
Following is an excerpt from my code :

Connection conn = getDataSource().getConnection();
PreparedStatement statement = conn.prepareStatement("SELECT
statement.setString(1, "9999");
ResultSet resultSet = statement.executeQuery();

The problem I am facing is AOF is of type CHAR, when the column type is
changed to VARCHAR2 both drivers ( weblogic and oracle )find the record.
I can't find the record with oracle.jdbc.driver.OracleDriver when the column type is defined as CHAR?

Weblogic driver : weblogic.jdbc.oracle.OracleDriver

Please help me as this is acting as a show stopper.

/ Sam
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

Welcome to JavaRanch!

That is one weird error. Does it work with varchar2 if you do the query from sqlplus?

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Sam Phillip

Joined: Oct 05, 2004
Posts: 5
Jeanne, it works from sqlplus with varchar2

/ Sam
Don't get me started about those stupid light bulbs.
subject: Oracle driver vs Weblogic driver
Similar Threads
PreparedStatement binding not working properly (Oracle Problem?)
How to store & retrieve a video file from database?
Reading UDT values using JDBC
Inserting image into the oracle database
Oracle Driver vs Weblogic Driver