Re: java.sql.SQLException: Bigger type length than Maximum

sandro.salari_at_gmail.com wrote:

> Hi,
> I use:
> WebLogic Platform 8.1 Service Pack 5
> Oracle9i Enterprise Edition Release 9.2.0.5.0
> Web application that use Oracle JDBC driver Version 10.1.0.2.0 to query
> the DB.

...
> Bigger type length than Maximum
> java.sql.SQLException: Bigger type length than Maximum
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled
> Code))

Hi. First, are you absolutely sure that's the driver version actually being used? WebLogic packages an earlier version of the thin driver, which can be found in the installation's server\lib directory. Unless you replaced that one, or edited your start-weblogic script and altered the CLASSPATH variable constructed in the script to list your driver ahead of weblogic.jar, you may not be using the driver you think. You can always check with your code, by doing:

       System.out.println("The driver is " + c.getMetaData().getDriverVersion() );

You can also get quick WebLogic/JDBC related help by posting to the BEA newsgroup.
Let me know...
Joe weinstein at BEA Systems Received on Thu Mar 02 2006 - 10:04:07 CST