File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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 :

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

/ Sam
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33113

Welcome to JavaRanch!

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Sam Phillip

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

/ Sam
I agree. Here's the link:
subject: Oracle driver vs Weblogic driver
It's not a secret anymore!