• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

Using other JDBC driver version within JDeveloper

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 8945
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 8945
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
http://otn.oracle.com/products/jdev/collateral/prodtour10g.html
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
strange, in above email, I typed remove from \<Item\> ...\</Item\> become ......, I guess it is the angled parenthesis escape.
 
John Zhou
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Boy, that sucks.
remove from item .... /item.
 
I'd appreciate it if you pronounced my name correctly. Pinhead, with a silent "H". Petite ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic