hello all, I'am trying to connect to Oracle database using Type-4 driver. The problem is the driver gets loaded...I get the connection object. I also get the statement object form the con obj. But when i try to call executeQuery() on stmt I get the following error...
This particular one can show up when using a pre-9i driver with a 9i or later database; the best solution is to upgrade drivers. I think Oracle support may have a workaround if that's not an option.
It can also show up when the driver checks the local character set on the client side and finds it to be invalid.
Joined: Oct 24, 2005
The Driver that i am using is a 9i driver...this problem is specifically occuring for Type4 driver it doesn't occur for Type1... Somebody had suggested me to put the drivers path in the classpath variable in the config.xml file...but i am unable to locate the variable in the file....
I would suggest check the class path , if there are multiple jars available and you are pinting to a wrong one.
Also pick jar file from your oracle installation and use same.
Once I faced similar problem which got resolved by replacing driver.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Joined: Dec 15, 2005
The Driver that i am using is a 9i driver...
It wouldn't surprise me if you're actually using an older driver that's installed in Weblogic. It's pretty easy to find out...
Here's a main program I have lying around to get some driver/database info. You will need to convert it to a JSP and run it in your Weblogic installation. You'll also need to fix the database URL, user and password.