MSAccess and Tomcat JNDI Configuration

[muthulingam Jayakanthan]

1. I have a MS Access file and I made a DSN to that call jkdb in the Windows Control Panel

2. I setup the JNDI datasource configuration in http://localhost:8080/admin like below :-
JNDI name : jdbc/jkdb
Datasource URL : jdbc dbc:jkdb
JDBC Driver Class : sun.jdbc.odbc.JdbcOdbcDriver

3. in the java file I made a method like below

Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env/");
DataSource ds = (DataSource)envContext.lookup("jdbc/jkdb");
conn = ds.getConnection();

It gives error like
"javax.naming.NoInitialContextException: Need to specify class name in environment or system property,................"

I wonder whether my Configuration is correct or not. Tomcat JNDI Documentation not talk about MS Access connection details Please jelp me on this Thanks

[muthulingam Jayakanthan]

Hi everybody,

I went through some forum and found that it is not possible to use JNDI DataSource Connection setup to MS Access.

I can use DriverManager to do that. But I need to make sure whether it is possible to use Tomcat (5) Web Server To configure MS Access and Call with JNDI naming concept.

Please help me on discussing regarding.