• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle driver with Weblogic

 
Harry Wordsworth
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • 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







 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • 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
 
Joe Ess
Bartender
Posts: 9337
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic