Solved

How to connect to MS Access using JNDI with Tomcat 5 ?

Posted on 2003-10-28
7
304 Views
Last Modified: 2010-04-01
Hi,

I got


/usr/local/tomcat5/webapps/Advanced/connect.jsp
=========================================
<html>
<head>
<title>Connection Test</title>
</head>
<body>

<%
com.wrox.library.Connect con = new com.wrox.library.Connect();
con.init();
%>

<h2>Connection Result</h2>
<%= con.getstat() %>
</body>
</html>
=====================================================


/usr/local/tomcat5/webapps/Advanced/WEB-INF/classes/com/wrox/libraryConnect.java
====================================================
package com.wrox.library;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class Connect {

String stat = "Not Connected !!";

public void init() {
try {
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Oops - No Context");

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/BooksDB");

if (ds != null) {
Connection conn = ds.getConnection();

if(conn != null) {
stat = " Got Connection "+conn.toString();
conn.close();
}
}
}
catch(Exception e) {
e.printStackTrace();
}
}

public String getstat() {
return stat;
}
}
============================================================

/usr/local/tomcat5/webapps/Advanced/WEB-INF/web.xml
============================================================
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<description>mySQL Test App</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/BooksDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
============================================================

/usr/local/tomcat5/conf/server.xml
============================================================
.......................

<Context path="/Advanced" docBase="Advanced" debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="Wrox_Advanced_log."
suffix=".txt" timestamp="true"/>
<Resource name="jdbc/BooksDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/BooksDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>180</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>username</name>
<value>booksuser</value>
</parameter>
<parameter>
<name>password</name>
<value>bookspass</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://192.1.3.139:3306/books?autoReconnect=true</value>
</parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server>
============================================================

The above is to connect to MySQL database. How about if I wanna connect to MS Access DB ? How should I change the above code and setting or configuration ? Where should I put the MS Access file ?

FYI, I m using Tomcat 5.0.11 !!

I was trying to change the Connect.java to

=================================
package com.wrox.library;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class Connect {

String stat = "Not Connected !!";

public void init() {
try {

Connection conn = null;
stat = " 1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
stat = " 2";
conn = DriverManager.getConnection("jdbcdbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=FRONT.mdb","Admin","123456");
stat = " 3";


stat = " Got Connection "+conn.toString();
conn.close();


}
catch(ClassNotFoundException classnotfoundexception)
{
System.out.println("Could not find class: " + classnotfoundexception);
return;
}
catch(SQLException sqlexception)
{
System.out.println(sqlexception + "");
return;
}
catch(Exception e) {
e.printStackTrace();
}
}

public String getstat() {
return stat;
}
}
===========================================

but it stuck between stat = "2" and stat = " 3"

pls help !!
0
Comment
Question by:spacetime
  • 5
7 Comments
 
LVL 3

Expert Comment

by:applekanna
Comment Utility
JNDI is of rdirecoty systems

chek this thread
http://www.mail-archive.com/j2ee@p2p.wrox.com/msg00432.html
0
 
LVL 3

Expert Comment

by:applekanna
Comment Utility
are you trying to do connection pooling for a db? There are other ways to do it also .

You can write your own connection pool or u can use the tutorial from java

http://developer.java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html

Hope this helps
Cheers!
0
 
LVL 3

Accepted Solution

by:
applekanna earned 125 total points
Comment Utility
0
 
LVL 3

Expert Comment

by:applekanna
Comment Utility
Hi spacetime,
I think I spent some time and tried answering you question earlier before in the thread

http://oldlook.experts-exchange.com/Web/Web_Languages/JSP/Q_20774349.html

and it doesnt seem to help either ....
0
 
LVL 3

Expert Comment

by:applekanna
Comment Utility
spacetime/eexcel

I am bring a mod in

Cheers!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Find out what Office 365 Transport Rules are, how they work and their limitations managing Office 365 signatures.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now