Hi,
I am unable to cofigure datasource in
tomcat 6.0 server.After solving all exceptions,Nw iam unable to get Data Source object.
I have configured contect.xml file in C:\Program Files\Apache Software Foundation\Tomcat 6.0\conf directory.
<Context path="/DiaryProj" crossContext="true" reloadable="true">
<Resource name="jdbc/diary" auth="Container"
type="org.apache.tomcat.dbcp.dbcp.BasicDataSource"
description="User database that can be updated and saved"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
pathname="conf/tomcat-users.xml"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/diary"
username="root"
password="root"
/>
</Context>
In my diary project application web.xml file i've configured
<resource-ref>
<description>Connection Pool</description>
<res-ref-name>jdbc/diary</res-ref-name>
<res-type>org.apache.tomcat.dbcp.dbcp.BasicDataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
This is my ConnectionManager class which contains my getConnection()
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class ConnectionManager {
private Connection con = null;
private DataSource ds = null;
private Context ctx = null;
private InitialContext ic = null;
private static ConnectionManager cm = null;
private ConnectionManager(){
}
public static ConnectionManager getInstance(){
if(cm==null)
cm = new ConnectionManager();
return cm;
}
public Connection getConnection(){
try {
ctx = new InitialContext();
// ctx.lookup("java:comp/env");
System.out.println("context object"+ctx);
try {
ds = (DataSource)ctx.lookup("java:comp/env/jdbc/diary");
System.out.println("data source object--->"+ds);
if(ds!=null)
con = ds.getConnection();
System.out.println("Connection object"+con);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
}
Please Ignore If any spelling mistakes and formatting mistakes...
Could anyone please suggest me to get data source...
Thanks in Advance,,