- This topic has 4 replies, 3 voices, and was last updated 20 years, 6 months ago by
Scott Anderson.
-
AuthorPosts
-
LeTourneauMemberHello, I need to setup a JDBC connection to a MYSQL using JNDI with all of it running on a Tomcat v4 server. What is the best way to do this? Is there some way I can configure all of that in MyEclipse? Or is the best way to do it to directly modify the tomcat configuration files to add the JNDI references?
Luke Mauldin
support-michaelKeymasterME does not provide a data-source configuration wizard for any app-server (although it would be nice). We have a number of test databases and I frequently use the DatabaseExplorer to test my JDBC connection details. Once the JDBC connection is properly connecting to my DB I then copy the driver configuration and connection details to my tomcat server.xml file. Saves me from having to debug connection string issues on a deployed server.
LeTourneauMemberI have my database working in DatabaseExplorer. However, when I try to transfer the information over to tomcat’s server.xml I get errors saying: Cannot create JDBC driver of class ” for connect URL
‘null’. I am also posting the relevant code of my application. The
strange thing is I can get a connection if I use DriverManager, but I
cannot if I try to use JNDI.application:
Context ctx = new InitialContext();
Context envCtx = (Context) ctx.lookup(“java:comp/env”);
DataSource ds = (DataSource) envCtx.lookup(“jdbc/tutor”);
//DataSource ds = (DataSource)ctx.lookup(“java:comp/env/jdbc/tutor”);
//Class.forName(“com.mysql.jdbc.Driver”); this works
//Connection conn = DriverManager.getConnection(“jdbc:mysql://localhost/tutor?user=tutor_user&password=cosc”);
Connection conn = ds.getConnection();
ResultSet rs = null;
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(“select * from tutor;”);
rs.next();stmt.close();
conn.close();web.xml:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/tutor</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>server.xml:
<?xml version=’1.0′ encoding=’utf-8′?>
<Server className=”org.apache.catalina.core.StandardServer” debug=”0″ port=”8005″ shutdown=”SHUTDOWN”>
<Listener className=”org.apache.catalina.mbeans.ServerLifecycleListener” debug=”0″ jsr77Names=”false”/>
<Listener className=”org.apache.catalina.mbeans.GlobalResourcesLifecycleListener” debug=”0″/>
<GlobalNamingResources>
<Environment value=”30″ type=”java.lang.Integer” override=”true” name=”simpleValue”/>
<Resource type=”org.apache.catalina.UserDatabase” scope=”Shareable” description=”User database that can be updated and saved” auth=”Container” name=”UserDatabase”/>
<Resource type=”javax.sql.DataSource” auth=”Container” name=”jdbc/tutor”/>
<ResourceParams name=”UserDatabase”>
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
<ResourceParams name=”jdbc/tutor”>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/tutor?autoReconnect=true</value>
</parameter>
<parameter>
<name>password</name>
<value>cosc</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>tutor_user</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service className=”org.apache.catalina.core.StandardService” debug=”0″ name=”Tomcat-Standalone”>
<Connector className=”org.apache.coyote.tomcat4.CoyoteConnector” connectionUploadTimeout=”300000″ maxSpareProcessors=”5″ acceptCount=”100″ connectionTimeout=”20000″ connectionLinger=”-1″ serverSocketTimeout=”0″ scheme=”http” port=”8080″ tcpNoDelay=”true” tomcatAuthentication=”true” compression=”off” maxProcessors=”75″ useURIValidationHack=”false” proxyPort=”0″ secure=”false” bufferSize=”2048″ redirectPort=”8443″ protocolHandlerClassName=”org.apache.coyote.http11.Http11Protocol” useBodyEncodingForURI=”true” debug=”0″ enableLookups=”true” allowTrace=”false” maxKeepAliveRequests=”100″ minProcessors=”5″ disableUploadTimeout=”true”>
<Factory className=”org.apache.catalina.net.DefaultServerSocketFactory”/>
</Connector>
<Connector className=”org.apache.coyote.tomcat4.CoyoteConnector” connectionUploadTimeout=”300000″ maxSpareProcessors=”5″ acceptCount=”10″ connectionTimeout=”0″ connectionLinger=”-1″ serverSocketTimeout=”0″ scheme=”http” port=”8009″ tcpNoDelay=”true” tomcatAuthentication=”true” compression=”off” maxProcessors=”75″ useURIValidationHack=”false” proxyPort=”0″ secure=”false” bufferSize=”2048″ redirectPort=”8443″ protocolHandlerClassName=”org.apache.jk.server.JkCoyoteHandler” useBodyEncodingForURI=”true” debug=”0″ enableLookups=”true” allowTrace=”false” maxKeepAliveRequests=”100″ minProcessors=”5″ disableUploadTimeout=”false”>
<Factory className=”org.apache.catalina.net.DefaultServerSocketFactory”/>
</Connector>
<Engine className=”org.apache.catalina.core.StandardEngine” defaultHost=”localhost” debug=”0″ mapperClass=”org.apache.catalina.core.StandardEngineMapper” name=”Standalone”>
<Host className=”org.apache.catalina.core.StandardHost” deployXML=”true” liveDeploy=”true” appBase=”webapps” name=”localhost” contextClass=”org.apache.catalina.core.StandardContext” unpackWARs=”true” errorReportValveClass=”org.apache.catalina.valves.ErrorReportValve” debug=”0″ mapperClass=”org.apache.catalina.core.StandardHostMapper” autoDeploy=”true” configClass=”org.apache.catalina.startup.ContextConfig”>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”true” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/admin” docBase=”../server/webapps/admin” path=”/admin” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Administration Application”>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_admin_log.” verbosity=”1″ timestamp=”true”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/webdav” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/webdav” path=”/webdav” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Webdav Content Management”>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”true” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/examples” docBase=”examples” path=”/examples” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”true” displayName=”Tomcat Examples”>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_examples_log.” verbosity=”1″ timestamp=”true”/>
<Parameter value=”context.param.value” name=”context.param.name” override=”false”/>
<Ejb type=”Entity” name=”ejb/EmplRecord” remote=”com.wombat.empl.EmployeeRecord” home=”com.wombat.empl.EmployeeRecordHome”/>
<Ejb type=”Entity” description=”Example EJB Reference” name=”ejb/Account” remote=”com.mycompany.mypackage.Account” home=”com.mycompany.mypackage.AccountHome”/>
<Environment value=”15″ type=”java.lang.Integer” override=”true” name=”maxExemptions”/>
<Environment value=”10″ type=”java.lang.Integer” override=”true” name=”foo/name4″/>
<Environment value=”1″ type=”java.lang.Integer” override=”true” name=”minExemptions”/>
<Environment value=”true” type=”java.lang.Boolean” override=”true” name=”foo/bar/name2″/>
<Environment value=”1″ type=”java.lang.Integer” override=”true” name=”name3″/>
<Environment value=”value1″ type=”java.lang.String” override=”true” name=”foo/name1″/>
<LocalEjb local=”com.mycompany.mypackage.ProcessOrder” type=”Session” description=”Example Local EJB Reference” name=”ejb/ProcessOrder” home=”com.mycompany.mypackage.ProcessOrderHome”/>
<Resource type=”javax.sql.DataSource” scope=”Shareable” auth=”SERVLET” name=”jdbc/EmployeeAppDb”/>
<Resource type=”javax.mail.Session” scope=”Shareable” auth=”Container” name=”mail/Session”/>
<ResourceParams name=”jdbc/EmployeeAppDb”>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:HypersonicSQL:database</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.hsql.jdbcDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
<ResourceParams name=”mail/Session”>
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
<ResourceLink name=”linkToGlobalResource” type=”java.lang.Integer” global=”simpleValue”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/Sql-Test1″ docBase=”/opt/jakarta-tomcat-4.1.31/webapps/Sql-Test1″ path=”/Sql-Test1″ charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false”>
<Resource type=”javax.sql.DataSource” scope=”Shareable” description=”DB Connection” auth=”Container” name=”jdbc/tutor”/>
<ResourceLink name=”tutor.data.source” type=”javax.sql.DataSource” global=”jdbc/tutor”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/tomcat-docs” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/tomcat-docs” path=”/tomcat-docs” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Documentation”>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”true” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/manager” docBase=”../server/webapps/manager” path=”/manager” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Manager Application”>
<ResourceLink name=”users” type=”org.apache.catalina.UserDatabase” global=”UserDatabase”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/_” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/ROOT” path=”” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Welcome to Tomcat”>
</Context>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_log.” verbosity=”1″ timestamp=”true”/>
</Host>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”catalina_log.” verbosity=”1″ timestamp=”true”/>
<Realm className=”org.apache.catalina.realm.UserDatabaseRealm” debug=”0″ validate=”true” resourceName=”UserDatabase”/>
</Engine>
</Service>
</Server>
LeTourneauMemberI was able to get it to working by changing my server.xml to the following:
<?xml version=’1.0′ encoding=’utf-8′?>
<Server className=”org.apache.catalina.core.StandardServer” debug=”0″ port=”8005″ shutdown=”SHUTDOWN”>
<Listener className=”org.apache.catalina.mbeans.ServerLifecycleListener” debug=”0″ jsr77Names=”false”/>
<Listener className=”org.apache.catalina.mbeans.GlobalResourcesLifecycleListener” debug=”0″/>
<GlobalNamingResources>
<Environment value=”30″ type=”java.lang.Integer” override=”true” name=”simpleValue”/>
<Resource type=”org.apache.catalina.UserDatabase” scope=”Shareable” description=”User database that can be updated and saved” auth=”Container” name=”UserDatabase”/>
<Resource type=”javax.sql.DataSource” auth=”Container” name=”jdbc/tutor”/>
<ResourceParams name=”UserDatabase”>
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
<ResourceParams name=”jdbc/tutor”>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/tutor?autoReconnect=true</value>
</parameter>
<parameter>
<name>password</name>
<value>cosc</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>tutor_user</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service className=”org.apache.catalina.core.StandardService” debug=”0″ name=”Tomcat-Standalone”>
<Connector className=”org.apache.coyote.tomcat4.CoyoteConnector” connectionUploadTimeout=”300000″ maxSpareProcessors=”5″ acceptCount=”100″ connectionTimeout=”20000″ connectionLinger=”-1″ serverSocketTimeout=”0″ scheme=”http” port=”8080″ tcpNoDelay=”true” tomcatAuthentication=”true” compression=”off” maxProcessors=”75″ useURIValidationHack=”false” proxyPort=”0″ secure=”false” bufferSize=”2048″ redirectPort=”8443″ protocolHandlerClassName=”org.apache.coyote.http11.Http11Protocol” useBodyEncodingForURI=”true” debug=”0″ enableLookups=”true” allowTrace=”false” maxKeepAliveRequests=”100″ minProcessors=”5″ disableUploadTimeout=”true”>
<Factory className=”org.apache.catalina.net.DefaultServerSocketFactory”/>
</Connector>
<Connector className=”org.apache.coyote.tomcat4.CoyoteConnector” connectionUploadTimeout=”300000″ maxSpareProcessors=”5″ acceptCount=”10″ connectionTimeout=”0″ connectionLinger=”-1″ serverSocketTimeout=”0″ scheme=”http” port=”8009″ tcpNoDelay=”true” tomcatAuthentication=”true” compression=”off” maxProcessors=”75″ useURIValidationHack=”false” proxyPort=”0″ secure=”false” bufferSize=”2048″ redirectPort=”8443″ protocolHandlerClassName=”org.apache.jk.server.JkCoyoteHandler” useBodyEncodingForURI=”true” debug=”0″ enableLookups=”true” allowTrace=”false” maxKeepAliveRequests=”100″ minProcessors=”5″ disableUploadTimeout=”false”>
<Factory className=”org.apache.catalina.net.DefaultServerSocketFactory”/>
</Connector>
<Engine className=”org.apache.catalina.core.StandardEngine” defaultHost=”localhost” debug=”0″ mapperClass=”org.apache.catalina.core.StandardEngineMapper” name=”Standalone”>
<Host className=”org.apache.catalina.core.StandardHost” deployXML=”true” liveDeploy=”true” appBase=”webapps” name=”localhost” contextClass=”org.apache.catalina.core.StandardContext” unpackWARs=”true” errorReportValveClass=”org.apache.catalina.valves.ErrorReportValve” debug=”0″ mapperClass=”org.apache.catalina.core.StandardHostMapper” autoDeploy=”true” configClass=”org.apache.catalina.startup.ContextConfig”>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”true” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/admin” docBase=”../server/webapps/admin” path=”/admin” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Administration Application”>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_admin_log.” verbosity=”1″ timestamp=”true”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/webdav” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/webdav” path=”/webdav” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Webdav Content Management”>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”true” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/examples” docBase=”examples” path=”/examples” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”true” displayName=”Tomcat Examples”>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_examples_log.” verbosity=”1″ timestamp=”true”/>
<Parameter value=”context.param.value” name=”context.param.name” override=”false”/>
<Ejb type=”Entity” name=”ejb/EmplRecord” remote=”com.wombat.empl.EmployeeRecord” home=”com.wombat.empl.EmployeeRecordHome”/>
<Ejb type=”Entity” description=”Example EJB Reference” name=”ejb/Account” remote=”com.mycompany.mypackage.Account” home=”com.mycompany.mypackage.AccountHome”/>
<Environment value=”15″ type=”java.lang.Integer” override=”true” name=”maxExemptions”/>
<Environment value=”10″ type=”java.lang.Integer” override=”true” name=”foo/name4″/>
<Environment value=”1″ type=”java.lang.Integer” override=”true” name=”minExemptions”/>
<Environment value=”true” type=”java.lang.Boolean” override=”true” name=”foo/bar/name2″/>
<Environment value=”1″ type=”java.lang.Integer” override=”true” name=”name3″/>
<Environment value=”value1″ type=”java.lang.String” override=”true” name=”foo/name1″/>
<LocalEjb local=”com.mycompany.mypackage.ProcessOrder” type=”Session” description=”Example Local EJB Reference” name=”ejb/ProcessOrder” home=”com.mycompany.mypackage.ProcessOrderHome”/>
<Resource type=”javax.sql.DataSource” scope=”Shareable” auth=”SERVLET” name=”jdbc/EmployeeAppDb”/>
<Resource type=”javax.mail.Session” scope=”Shareable” auth=”Container” name=”mail/Session”/>
<ResourceParams name=”jdbc/EmployeeAppDb”>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:HypersonicSQL:database</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.hsql.jdbcDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
<ResourceParams name=”mail/Session”>
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
<ResourceLink name=”linkToGlobalResource” type=”java.lang.Integer” global=”simpleValue”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/Sql-Test1″ docBase=”/opt/jakarta-tomcat-4.1.31/webapps/Sql-Test1″ path=”/Sql-Test1″ charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false”>
<ResourceLink name=”jdbc/tutor” global=”jdbc/tutor”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/tomcat-docs” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/tomcat-docs” path=”/tomcat-docs” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Documentation”>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”true” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/manager” docBase=”../server/webapps/manager” path=”/manager” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Tomcat Manager Application”>
<ResourceLink name=”users” type=”org.apache.catalina.UserDatabase” global=”UserDatabase”/>
</Context>
<Context className=”org.apache.catalina.core.StandardContext” wrapperClass=”org.apache.catalina.core.StandardWrapper” privileged=”false” crossContext=”false” swallowOutput=”false” cookies=”true” workDir=”work/Standalone/localhost/_” docBase=”/opt/jakarta-tomcat-4.1.31/webapps/ROOT” path=”” charsetMapperClass=”org.apache.catalina.util.CharsetMapper” useNaming=”true” debug=”0″ mapperClass=”org.apache.catalina.core.StandardContextMapper” cachingAllowed=”true” reloadable=”false” displayName=”Welcome to Tomcat”>
</Context>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”localhost_log.” verbosity=”1″ timestamp=”true”/>
</Host>
<Logger className=”org.apache.catalina.logger.FileLogger” debug=”0″ directory=”logs” suffix=”.txt” prefix=”catalina_log.” verbosity=”1″ timestamp=”true”/>
<Realm className=”org.apache.catalina.realm.UserDatabaseRealm” debug=”0″ validate=”true” resourceName=”UserDatabase”/>
</Engine>
</Service>
</Server>
Scott AndersonParticipantLuke,
Thanks for the followup. Glad you figured it out. Often what needs to be done to support database drivers in application servers is to specifically add the driver jar to the server classpath configuration at Window > Preferences > MyEclipse > Application Servers > Tomcat 5 > Paths. And, add any native libraries to the library path on the same preference page.
-
AuthorPosts