tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kito Holliday <holli...@phys.psu.edu>
Subject Re: jdbc driver
Date Tue, 20 Sep 2005 13:24:29 GMT

Thanks for the quick reply...

Yes the .jar file is in common/lib. I fear the problem lies in the
server.xml since jndi is binding datasource jdbc/TestDB to
org.hsql.jdbcDriver

On Mon, 19 Sep 2005, andy gordon wrote:

> is the MySQL Connector Jar file in the $CATALINA_HOME/common/lib  directory?
>
> Kito Holliday <holliday@phys.psu.edu> wrote:Attempting to use connector-java-3.3.10
with tomcat 4.0 and mysql and
> servlets. The Java code:
> InitialContext ctx = new InitialContext();
> DataSource ds = (DataSource)lookup("jdbc/TestDB");
>
> throws the exception:
> Exception creating DataSource: org.hsql.jdbcDriver
>
> The problem is that my .xml files never mentions the hsql jdbcDriver.
> Obviously tomcat is ignoring my
>
> Specifically, I have a web.xml having:
> **************
>
> PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
> "http://java.sun.com/dtd/web-app_2_3.dtd">
>
>
> DB Connection
> jdbc/TestDB
> javax.sql.DataSource
> Container
>
>
> ***************
>
> and a server.xml having
>
> *****************Sorry for the long server.xml**********
>
>
>
> port="8080" minProcessors="5" maxProcessors="75"
> enableLookups="true" redirectPort="8443" acceptCount="10"
> debug="0" connectionTimeout="60000" />
>
> prefix="standaloneEngine_log." suffix=".txt"
> timestamp="true"/>
>
>
> directory="logs" prefix="localhost_access_log." suffix=".txt"
> pattern="common" />
> directory="logs" prefix="standaloneHost_log." suffix=".txt"
> timestamp="true" />
>
> privileged="true">
> prefix="standalone_manager_log." suffix=".txt"
> timestamp="true" />
>
> reloadable="true" crossContext="true">
> prefix="standalone_examples_log." suffix=".txt"
> timestamp="true" />
> value="15" />
>
> override="false" />
> type="javax.mail.Session" />
>
>
> mail.smtp.host
> localhost
>
>
>
>
> crossContext="true">
> prefix="standalone_DBTest_log." suffix=".txt"
> timestamp="true" />
> type="javax.sql.DataSource"
> driverClassName="com.mysql.jdbc.Driver" />
>
>
>
> factory
> org.apache.commons.dbcp.BasicDataSourceFactory
>
>
>
>
> factory
> com.mysql.jdbc.jdbc2.optional.
> MysqlConnectionPoolDataSource
>
>
>
>
> maxActive
> 100
>
>
>
>
> maxIdle
> 30
>
>
>
>
> maxWait
> 10000
>
>
>
>
> username
> javauser
>
>
>
>
> password
> javadude
>
>
>
>
> driverClassName
> com.mysql.jdbc.Driver
>
>
>
>
> url
> jdbc:mysql://localhost:3306
> /javatest?autoReconnect=true
>
>
>
>
> removeAbandoned
> true
>
>
>
>
> removeAbandonedTimeout
> 60
>
>
>
>
> logAbandoned
> true
>
>
>
>
>
>
>
>
> prefix="tomcat_apache_service." suffix=".txt"
> timestamp="true"/>
> port="8008" minProcessors="5" maxProcessors="75"
> enableLookups="true" appBase="webapps" acceptCount="10"
> debug="0" />
> name="Apache" localHost="127.0.0.1" debug="5">
> prefix="tomcatapacheEngine." suffix=".txt" timestamp="true"/>
>
> unpackWARs="true">
> directory="logs" prefix="tomcatapacheHost_log."
> suffix=".txt" timestamp="true" />
>
> reloadable="true" crossContext="true" useNaming="false">
> prefix="tomcatapache_DBTest_log." suffix=".txt"
> timestamp="true" />
> type="javax.sql.DataSource"
> driverClassName="com.mysql.jdbc.Driver"
> username="javauser" password="javadude"
> url="jdbc:mysql://localhost:3306
> /javatest?autoReconnect=true"
> factory="org.apache.commons.dbcp.
> BasicDataSourceFactory"
> maxActive="100"
> maxIdle="30"
> validationQuery="SELECT 1"
> testOnBorrow="true"
> testWhileIdle="true"
> timeBetweenEvictionRunsMillis="10000"
> minEvictableIdletime="60000"
> maxWait="10000"
> removeAbandoned="true"
> removeAbandonedTimeout="60"
> logAbandoned="true" />
>
> - privileged="true">
> prefix="apachetomcat_manager_log." suffix=".txt"
> timestamp="true" />
>
> reloadable="true" crossContext="true">
> prefix="apachetomcat_examples_log." suffix=".txt"
> timestamp="true" />
> value="15" />
>
> override="false" />
> type="javax.mail.Session" />
>
>
>
> mail.smtp.host
> localhost
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message