• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Oracle driver with Weblogic

 
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello, I am trying to learn more about connecting to databases.

First I used a java web application hosted on Tomcat and connected/manipulated a MySQL database
This was relatively straightforward. I downloaded the MySQL driver and included that driver in the specified locations in the project and/or tomcat and all was well.
There seems to be quite a lot of online documentation showing how to do these steps.

Now, I am stuck on my next challenge. I am using a java web application hosted on WebLogic version...
Oracle WebLogic Server 12cR2 (12.2.1.1)
and I am hoping to connect to an Oracle Express DB I have installed on my machine
Oracle 11g Express
To start off this challenge I looked for where I can find the driver for Oracle 11 Express and I found this site...
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
but I am not sure which of these to use or what steps might be required to get it to work with the WebLogic server.
Any pointers on this would be appreciated on which driver to use and any link to setup steps .

FWIW java version 1.8.0_91







 
Sheriff
Posts: 11604
178
Hibernate jQuery Eclipse IDE Spring MySQL Database AngularJS Tomcat Server Chrome Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Harry Wordsworth wrote:Any pointers on this would be appreciated on which driver to use and any link to setup steps .


To start you need (obviously) the appropriate driver. And the website you have mentioned is the correct one to download this driver. You only need odbc6.jar as stated in this description Certified with JDK 8, JDK 7 and JDK 6: It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types (unless you need of course NLS support).
And then you'll probably need to configure some JDBC data sources in WebLogic. How that can be done, can be found here.

Hope it helps!
Kind regards,
Roel
 
Bartender
Posts: 9626
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Roel De Nijs wrote:

Harry Wordsworth wrote:Any pointers on this would be appreciated on which driver to use and any link to setup steps .


To start you need (obviously) the appropriate driver.



According to this page, Oracle Express can use the Oracle Thin driver, which is built in to Weblogic 12.
The link Harry points to for creating a data source is for WLS 9.1.  I don't know if it is any different than the instructions for 12c
 
Your mother was a hamster and your father was a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic