Error NoInitialContextException Tomcat

Question

I tried to find a solution here, but I can’t ... I have the following code and I get this error.

Am I missing something? Thanks:)

the code

package src; import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import java.sql.Wrapper; import java.util.Hashtable; import java.util.Properties; import java.io.*; import javax.*; import javax.activation.DataSource; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import oracle.jdbc.pool.OracleDataSource; public class TestServlet { @SuppressWarnings("unused") public static void main(String[] argv) throws SQLException, NamingException { Context initialContext = new InitialContext(); if ( initialContext == null){System.out.println("initialContext null");} else {System.out.println("initialContext");} // Get DataSource Context environmentContext = (Context)initialContext.lookup("java:/comp/env"); if ( environmentContext == null){System.out.println("envContext null.");} else {System.out.println("envContext");} DataSource ds = (DataSource)environmentContext.lookup("jdbc/testdb"); System.out.println("\n -------- Oracle JDBC Connection Testing ------"); try { Connection jdbcConnection = ((Statement) ds).getConnection(); OracleDataSource ods = ((Wrapper) ds).unwrap(OracleDataSource.class); jdbcConnection.close(); } catch (SQLException e) { System.out.println("Connection Failed! Check output console"); e.printStackTrace(); return; } String message = "You are connected!"; System.out.println(message); } } 

context.xml

 <Context> <Resource name="jdbc/testdb" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="dba01" password="qvE-g7Cacontext.xml" driverClassName="com.mysql.jdbc.Driver" url="jdbc:oracle:thin:@10.0.1.6:1521:xe"/> </Context> 

Error

 Exception in thread "main" 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(Unknown Source) at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.lookup(Unknown Source) at src.TestServlet.main(TestServlet.java:34) 

Please let me know if you need more information!

Answer 1

You need the initial factory context. For Tomcat, this is org.apache.naming.java.javaURLContextFactory :

  System.setProperty(Context.INITIAL_CONTEXT_FACTORY, "org.apache.naming.java.javaURLContextFactory"); 

Answer 2

So, is this code deployed on the server? It seems you are trying to access the Context using standard java, since you are calling static main (so I think you are calling TeestServlet.main from your runtime). The context will be configured on the web server (Tomcat), so it is only available after deploying your web application.

Answer 3

Please note that the driverClassName name you are using is incorrect. It should be "oracle.jdbc.OracleDriver" if you are trying to connect to an Oracle database.

 <Context> <Resource name="jdbc/testdb" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="dba01" password="qvE-g7Cacontext.xml" driverClassName="com.mysql.jdbc.Driver" url="jdbc:oracle:thin:@10.0.1.6:1521:xe"/> </Context>