In my experience, the driver in driverClassName should be a Driver class as in com.mysql.jdbc.Driver, not a Datasource like com.mysql.jdbc.jdbc2.optional.MysqlDataSource. However, individual mileage may vary. ;-)

--David


Larry Meadors wrote:

Hahah, similar reasoning wth my symlink question...shouldn't matter,
but...



[EMAIL PROTECTED] 10/14/04 10:47 AM >>>



Hi, It might not, but it's always a question, because it's part of the KISS principle. The simpler the environment, the easier it is for the OP to test and for others to reproduce the OP's test results. The less moving pieces, the less chance for error.

Yoav Shapira http://www.yoavshapira.com




-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 14, 2004 12:38 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL driver randomly not found?

Interesting question...how does that impact classloading?



[EMAIL PROTECTED] 10/14/04 10:15 AM >>>


Hi,
Does it happen without the connectors/Apache in front?

Yoav Shapira http://www.yoavshapira.com




-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 14, 2004 12:13 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL driver randomly not found?

Just curious...Why are you using a symlink?



[EMAIL PROTECTED] 10/14/04 9:59 AM >>>


Hello! I'm having an interesting problem wherein about 5-10% of the
time, for
no apparent reason whatsover, the MySQL driver just can not be found.


I


have
a symlink to it in TOMCAT_DIR/common/lib.  I just replaced the symlink
with a
copy of the actual library to see if that would make a difference, but
it
doesn't make sense that it would work 90-95% of the time and then fail
the
rest of the time if that were the problem.

The traceback I get is as follows:

// NOTE: replaced org.apache. with ''.
Cannot load JDBC driver class
'com.mysql.jdbc.jdbc2.optional.MysqlDataSource'
java.lang.ClassNotFoundException:
com.mysql.jdbc.jdbc2.optional.MysqlDataSource
at
catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java


:


854)


at
catalina.loader.StandardClassLoader.loadClass(StandardClassLoader.java


:


721)


at


java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)


at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at
commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760


)


at
commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
RequestFilterServlet.getUrlMapping(RequestFilterServlet.java:187)
at


RequestFilterServlet.doFilter(RequestFilterServlet.java:277)


at
catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilte


r


Chai


n.java:186)
at
catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j


a


va:1


57)
at
catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:21


4


)


at
catalina.core.StandardValveContext.invokeNext(StandardValveContext.jav


a


:104


)
at
catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
catalina.core.StandardContextValve.invokeInternal(StandardContextValve


.


java


:198)
at
catalina.core.StandardContextValve.invoke(StandardContextValve.java:14


4


)


at
catalina.core.StandardValveContext.invokeNext(StandardValveContext.jav


a


:104


)
at
catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
catalina.core.StandardValveContext.invokeNext(StandardValveContext.jav


a


:104


)
at
catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at
catalina.core.StandardValveContext.invokeNext(StandardValveContext.jav


a


:102


)
at
catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at
catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
catalina.core.StandardValveContext.invokeNext(StandardValveContext.jav


a


:104


)
at
catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at


coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)


at jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at
jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at
tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683


)


      at java.lang.Thread.run(Thread.java:534)

Any suggestions welcome.  Thanks.

--Kaleb

PS: I'm using tomcat 5.0.28 and version 3.0.15 of the MySQL connector.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential,
proprietary and/or privileged.  This e-mail is intended only for the
individual(s) to whom it is addressed, and may not be saved, copied,
printed, disclosed or used by anyone else.  If you are not the(an)
intended recipient, please immediately delete this e-mail from your
computer system and notify the sender.  Thank you.


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential,
proprietary and/or privileged.  This e-mail is intended only for the
individual(s) to whom it is addressed, and may not be saved, copied,
printed, disclosed or used by anyone else.  If you are not the(an)
intended recipient, please immediately delete this e-mail from your
computer system and notify the sender.  Thank you.


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]




--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to