aspose file tools*
The moose likes Other Java Products and Servers and the fly likes Using other JDBC driver version within JDeveloper Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Using other JDBC driver version within JDeveloper" Watch "Using other JDBC driver version within JDeveloper" New topic
Author

Using other JDBC driver version within JDeveloper

Robert Willems
Ranch Hand

Joined: Apr 14, 2003
Posts: 32
Hello everybody,
Does anybody know how can i use a different Oracle JDBC driver within JDeveloper? If i remove the Oracle JDBC library from the project (JDeveloper uses version 9.0.1.4.0) and add the classes12.zip file (version 8.1.7 drivers) to the WEB-INF lib directory and run the application, it still uses the driver from JDeveloper.
I now have removed the JDBC directory from my JDeveloper installation and enduring a some errors (no datasource will work, JDeveloper can't connect to a database), the application now works correctly.
How can i do this 'the right way'? Without losing JDeveloper functionality and getting the 'old' Oracle JDBC drivers (which don't contain some very annoying bugs).
Regards,
Robert Willems of Brilman


Regards,<br />Robert Willems of Brilman<br /> <br />----------------------<br /> <br />SCJP 1.4<br />SCWCD 1.3<br />SCWCD 1.4 (beta)<br />SCDJWS 1.4 (beta)<br />SCBCD 1.3 (studying)
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8898

Right click on your project and then select project settings.
In the window opened select libraries and then add your JDBC driver jar file and select the newly added entry for the project.


Groovy
Dasong
Ranch Hand

Joined: Apr 05, 2002
Posts: 36
JDeveloper is the most stupid IDE in the world. Cause When config the 3rd party jdbc. I chose a correct driver name but wrong (libary)package. after I click ok. I could never change the driver' libary. the driver's name is already in a drop-down list. It could not be removed or redefined. when I try to redefined the driver. it popup a message told me the driver has been defined. how stupid it is.
[ April 04, 2004: Message edited by: Dasong ]
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8898

http://otn.oracle.com/products/jdev/collateral/prodtour10g.html
John Zhou
Greenhorn

Joined: Jul 22, 2004
Posts: 3
Here is how you can remove a jdbc driver entry.
1) close jdeveloper.
2) edit ~/jdevhome/system9.0.3.1.1107/settings.xml, find the driver name and remove from <Item> ......</Item>, save your changes and exit.
3) start jdeveloper, you will see the driver name is no longer there.
Do not edit settings.xml with jdeveloper opened, because jdeveloper will save all settings when you close it.
John Zhou
Greenhorn

Joined: Jul 22, 2004
Posts: 3
strange, in above email, I typed remove from \<Item\> ...\</Item\> become ......, I guess it is the angled parenthesis escape.
John Zhou
Greenhorn

Joined: Jul 22, 2004
Posts: 3
Boy, that sucks.
remove from item .... /item.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using other JDBC driver version within JDeveloper
 
Similar Threads
Connecting to Oracle 7 thru jdbc
No suitable driver java.sql.SQLException: No suitable driver
Java 1.5 and Oracle 8 database
How to connect Oracle with Java
Web Application Class Loader and Weblogic