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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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: 32628

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!