File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connect to Oracle with JNDI Environment Context Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connect to Oracle with JNDI Environment Context " Watch "Connect to Oracle with JNDI Environment Context " New topic

Connect to Oracle with JNDI Environment Context

Leslie Smyth

Joined: Dec 17, 2009
Posts: 2
Using Weblogic 10, Oracle 10, and java jdk 1.6 -
attempting to obtain a java code connection to Oracle database
using the named JNDI datasource.

Have created a DataSource, "MY_DataSource" with associated
JNDI name ""MY_DataSource".

Went to View JNDI Tree and could see the MY_DataSource name
listed right above the weblogic attribute.

Went to Monitoring tab for MY_DataSource, checked the AdminServer
upon which MY_DataSource is running, and pressed the TestDataSource
button; the message returned was that the test was successful.

Am unable to obtain a non-null connection value in my java code
using the JNDI name with environment and context variables.
Code is below:

weblogic.jndi.Environment env = new Environment();
javax.naming.Context context = env.getInitialContext();

javax.sql.DataSource dataSource = (DataSource)context.lookup(MY_DataSource);

java.swl.Connection connect = dataSource.getConnection();

In Debug mode, the context structure has a value of null for the env variable.

Would appreciate help in solving this problem.
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
This link explains how to in weblogic under section Obtaining a Client Connection Using a DataSource. You may find it useful.


Leslie Smyth

Joined: Dec 17, 2009
Posts: 2
Thanks for the reference.

Have read this documentation before. Did check the honor global transactions.
Believe that I am already doing what is in the documentation, but am obviously
missing something. Am using a thin Oracle Driver - does this make a difference?
Some of the code example create an Environment object and then create a context
from that - see initial posting. See some code example that create a hashtable
object and then they set Initial_Context_factory and Provider_URL properties.
Have tried both ways - neither appears to work - which one is preferred?
What would be the provider_URL - t3://localhost:7001 for weblogic running on
local machine?
I agree. Here's the link:
subject: Connect to Oracle with JNDI Environment Context
It's not a secret anymore!