is the MySQL Connector Jar file in the $CATALINA_HOME/common/lib directory?
Kito Holliday <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
