I cannot seem to get this
tomcat configuration to work. Here is what I do.
In my connection bean below is my code:
import java.sql.*;
import java.io.*;
import java.text.*;
import java.util.*;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class connectionBean{
public connectionBean(){
}
public static Connection getConnection(){
Connection cnt=null;
try{
InitialContext initialContext=new InitialContext();
Context context=(Context)initialContext.lookup("java:comp/env");
DataSource ds=(DataSource) context.lookup("jdbc/PMDB");
cnt=ds.getConnection();
}catch(Exception exp){}
return cnt;
}
}
In web.xml i put in the <resource-ref> at the top as below:
<?xml version="1.0"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <!-- General description of the Application -->
<resource-ref>
<res-ref-name>jdbc/PMDB</res-ref-name>
<res-type>jdbc/PMDB</res-type>
<res-auth>jdbc/PMDB</res-auth>
</resource-ref>
<display-name>scrmypm</display-name>
<description>
This is the development application
</description>
<
servlet>
<display-name>ProServlet</display-name>
<servlet-name>ProServlet</servlet-name>
<servlet-class>Servlet.ProServlet</servlet-class>
</servlet>
...
In the conf/server.xml I put in the Resource Param below towards the end.
<Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" docBase="C:\jwsdp-1_0_01\webapps\ROOT" mapperClass="org.apache.catalina.core.StandardContextMapper" path="" privileged="false" reloadable="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
</Context>
<DefaultContext>
<Resource name="jdbc/PMDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/PMDB">
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>
jdbc:mysql://192.9.201.28/PMDB</value>
</parameter>
</ResourceParams>
</DefaultContext>
</Host>
<Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="jwsdp_log." suffix=".txt" timestamp="true" verbosity="1"/>
<Realm className="org.apache.catalina.realm.UserDatabaseRealm" debug="0" resourceName="UserDatabase" validate="true"/>
<Valve className="org.apache.catalina.valves.AccessLogValve" debug="0" directory="logs" pattern="%h %l %u %t "%r" %s %b" prefix="access_log." resolveHosts="false" suffix=".txt"/>
</Engine>
</Service>
</Server>
Anyone with ideas?