problem in creating mysql datasource on weblogic 10.3.4

[RajivAwadhesh kumar]

package com.rajiv;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class TestDB {
	
	public static void main(String[] args) {
		
		readDataFromDataSource();
	}
	
	
	
	static void readDataFromDataSource() {

		Connection connection = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			
		    
            
		 
		    int empId;
		    String empName;
		    
		    //connection = DriverManager.getConnection(url, username, password);
		    Context ctx = new InitialContext();
		    DataSource ds = (DataSource) ctx.lookup("jdbc/myDataSource");
		    connection = ds.getConnection("xx", "xx");
		    stmt = connection.createStatement();
		    rs = stmt.executeQuery("select * from rajiv.emp");
		    
		    while (rs.next()) {
		    	empId = rs.getInt(1);
		    	empName = rs.getString(2);
		    	System.out.println("empId=" + empId);
		    	System.out.println("empName=" + empName);
		    	} //end while
		    
		}
		catch(NamingException ne) {
			ne.printStackTrace();
		}
		catch(SQLException sqe) {
			sqe.printStackTrace();
		}
		finally {
			try {
				if(null != connection) {
					connection.close();
				}
				if(null != stmt) {
					stmt.close();
				}
				if(null != rs) {
					rs.close();
				}
			}
			catch(Exception e) {
				e.printStackTrace();
			}
		}
	
	}

}

When I execute the above code I get the following error

javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)
at javax.naming.InitialContext.lookup(InitialContext.java:392)
at com.rajiv.TestDB.readDataFromDataSource(TestDB.java:96)
at com.rajiv.TestDB.main(TestDB.java:18)


I am using MySQL 5.5 and Weblogic 10.3.4 .. Please suggest what is the problem?

[Jan Cumps]

We moved your post to our WebLogic forum.

[Kuldip Shetty]

You need to set few Context properties like Context.INITIAL_CONTEXT_FACTORY, Context.PROVIDER_URL before performing the JNDI Lookup.

Hashtable ht = new Hashtable();  
ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");  
ht.put(Context.PROVIDER_URL, "t3://hostname:port");

ctx = new InitialContext(ht);

Click here for more details