Its in the server.xml.
See below: --There are many more like this depending on context. Should
these database definitions be defined in the local contexts?
Usernames and passwords are held in the tomcat-users.xml file.
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource name="jdbc/Admin" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/Admin">
<parameter><name>factory</name><value>org.apache.tomcat.dbcp.dbcp.BasicD
ataSourceFactory</value></parameter>
<parameter><name>username</name><value>xxx</value></parameter>
<parameter><name>driverClassName</name><value>com.mysql.jdbc.Driver</val
ue></parameter>
<parameter><name>url</name><value>jdbc:mysql://xxx.xxx.com/Admin</value>
</parameter>
<parameter><name>connectionProperties</name><value
elideSetAutoCommits=true;jdbcCompliantTruncation=false;useLocalSessionSt
ate=true;alwaysSendSetIsolation=false;maintainTimeStats=false</value></p
arameter>
<parameter><name>removeAbandoned</name><value>true</value></parameter>
<parameter><name>removeAbandonedTimeout</name><value>12600</value></para
meter>
<parameter><name>logAbandoned</name><value>false</value></parameter>
<parameter><name>maxActive</name><value>0</value></parameter>
<parameter><name>minIdle</name><value>0</value></parameter>
<parameter><name>maxIdle</name><value>50</value></parameter>
<parameter><name>validationQuery</name><value>SELECT
1</value></parameter>
<parameter><name>testOnBorrow</name><value>false</value></parameter>
<parameter><name>testWhileIdle</name><value>false</value></parameter>
<parameter><name>timeBetweenEvictionRunsMillis</name><value>20000</value
></parameter>
<parameter><name>numTestsPerEvictionRun</name><value>1</value></paramete
r>
<parameter><name>minEvictableIdleTimeMillis</name><value>600000</value><
/parameter>
</ResourceParams>
The error is saying that it can't find the class and the url is null.
Not sure why.....is there something syntactically wrong with the above?
Here is the main part of the error.
Cannot create JDBC driver of class '' for connect URL 'null'
All of these params came from a tomcat 5 config except I modified the
factory param to reflect the new location of the BasicDataSourceFactory
class. I assumed most of the tomcat 5.0.25 params would be ok to port
over, but I claim to be no expert.
thanks
-dustin
-----Original Message-----
From: Pid [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 11:56 AM
To: Tomcat Users List
Subject: Re: javax/mail/address
Post your JDBC/Datasource config(s), (sans passwords obviously).
Where is it defined, in a context.xml or server.xml?
p
Dustin Fortin wrote:
> In catalina.out this error is new:
>
> Cannot create JDBC driver of class '' for connect URL 'null'
> java.lang.NullPointerException
> at
> sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(JdbcOdbcDriver.java:507)
> at
> sun.jdbc.odbc.JdbcOdbcDriver.knownURL(JdbcOdbcDriver.java:476)
> at
> sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(JdbcOdbcDriver.java:307)
> at java.sql.DriverManager.getDriver(DriverManager.java:253)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicData
> So
> urce.java:1143)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSou
> rc
> e.java:880)
> at com.airs.utilities.server.Entity.connect(Entity.java:547)
> at com.airs.utilities.server.Entity.find(Entity.java:1334)
> at com.airs.utilities.server.Entity.find(Entity.java:1252)
> at
> com.airs.portal.entities.Configuration.findConfiguration(Configuration
> .j
> ava:208)
> at
> com.airs.portal.entities.Configuration.findConfiguration(Configuration
> .j
> ava:175)
> at
> com.airs.portal.entities.Configuration.findConfiguration(Configuration
> .j
> ava:157)
> at
> com.airs.portal.entities.Configuration.findConfiguration(Configuration
> .j
> ava:143)
> at com.airs.portal.Bugman.bugReportImpl(Bugman.java:317)
> at com.airs.portal.Bugman.bugReport(Bugman.java:183)
> at com.airs.portal.Bugman.bugReport(Bugman.java:141)
> at
>
com.airs.portal.entities.Configuration.entityFailure(Configuration.java:
> 123)
> at com.airs.utilities.server.Entity.failure(Entity.java:1235)
> at com.airs.utilities.server.Entity.find(Entity.java:1531)
> at com.airs.utilities.server.Entity.find(Entity.java:1376)
> at
>
com.airs.portal.entities.TypeEncoding.makeSymbols(TypeEncoding.java:812)
> at
>
com.airs.portal.entities.TypeRegistry.theTypeRegistry(TypeRegistry.java:
> 108)
> at com.airs.portNov 20, 2007 11:39:19 AM
> org.apache.catalina.core.ApplicationContext log
>
> When I did the kill -3 on the tomcat process I get this information:
>
> "SocketTimeout" daemon prio=10 tid=0xb4819000 nid=0x1d5e waiting on
> condition [0xb4d90000..0xb4d90f20]
> java.lang.Thread.State: TIMED_WAITING (sleeping)
> at java.lang.Thread.sleep(Native Method)
> at HTTPClient.SocketTimeout.run(StreamDemultiplexor.java:919)
>
> "RMI TCP Accept-0" daemon prio=10 tid=0x08285000 nid=0x1d5c runnable
> [0xb505a000..0xb505b020]
> java.lang.Thread.State: RUNNABLE
> at java.net.PlainSocketImpl.socketAccept(Native Method)
> at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:384)
> - locked <0x0fe70118> (a java.net.SocksSocketImpl)
> at java.net.ServerSocket.implAccept(ServerSocket.java:450)
> at java.net.ServerSocket.accept(ServerSocket.java:421)
> at
> sun.rmi.transport.tcp.TCPTransport$AcceptLoop.executeAcceptLoop(TCPTra
> ns
> port.java:369)
> at
>
sun.rmi.transport.tcp.TCPTransport$AcceptLoop.run(TCPTransport.java:341)
> at java.lang.Thread.run(Thread.java:619)
>
> "Low Memory Detector" daemon prio=10 tid=0x0808cc00 nid=0x1d5b
> runnable [0x00000000..0x00000000]
> java.lang.Thread.State: RUNNABLE
>
> "CompilerThread0" daemon prio=10 tid=0x0808b000 nid=0x1d5a waiting on
> condition [0x00000000..0xb52f0bb8]
> java.lang.Thread.State: RUNNABLE
>
> "Signal Dispatcher" daemon prio=10 tid=0x08089c00 nid=0x1d59 waiting
> on condition [0x00000000..0x00000000]
> java.lang.Thread.State: RUNNABLE
>
> "Finalizer" daemon prio=10 tid=0x08081800 nid=0x1d58 in Object.wait()
> [0xb5592000..0xb5592e20]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x0fe70418> (a
java.lang.ref.ReferenceQueue$Lock)
> at
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:116)
> - locked <0x0fe70418> (a java.lang.ref.ReferenceQueue$Lock)
> at
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:132)
> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:159)
>
> "Reference Handler" daemon prio=10 tid=0x08080800 nid=0x1d57 in
> Object.wait() [0xb55e3000..0xb55e3ea0]
> java.lang.Thread.State: WAITING (on object monitor)
> at java.lang.Object.wait(Native Method)
> - waiting on <0x0fe704a8> (a java.lang.ref.Reference$Lock)
> at java.lang.Object.wait(Object.java:485)
> at
> java.lang.ref.Reference$ReferenceHandler.run(Reference.java:116)
> - locked <0x0fe704a8> (a java.lang.ref.Reference$Lock)
>
> "main" prio=10 tid=0x08058800 nid=0x1d55 runnable
> [0xb7fde000..0xb7fdf1f8]
> java.lang.Thread.State: RUNNABLE
> at java.net.SocketInputStream.socketRead0(Native Method)
> at java.net.SocketInputStream.read(SocketInputStream.java:129)
> at
> HTTPClient.BufferedInputStream.fillBuff(BufferedInputStream.java:174)
> at
> HTTPClient.BufferedInputStream.read(BufferedInputStream.java:112)
> at
> HTTPClient.StreamDemultiplexor.read(StreamDemultiplexor.java:275)
> - locked <0x0f29d360> (a HTTPClient.StreamDemultiplexor)
> at HTTPClient.RespInputStream.read(RespInputStream.java:157)
> - locked <0x0f2a48e8> (a HTTPClient.RespInputStream)
> at HTTPClient.RespInputStream.read(RespInputStream.java:117)
> - locked <0x0f2a48e8> (a HTTPClient.RespInputStream)
> at HTTPClient.Response.readResponseHeaders(Response.java:973)
> at HTTPClient.Response.getHeaders(Response.java:695)
> - locked <0x0f2a4438> (a HTTPClient.Response)
> at HTTPClient.Response.getStatusCode(Response.java:265)
> at
> HTTPClient.RetryModule.responsePhase1Handler(RetryModule.java:85)
> at
HTTPClient.HTTPResponse.handleResponse(HTTPResponse.java:726)
> - locked <0x0f22c2a8> (a HTTPClient.HTTPResponse)
> at HTTPClient.HTTPResponse.getHeader(HTTPResponse.java:296)
> at HTTPClient.HTTPResponse.getText(HTTPResponse.java:539)
> - locked <0x0f22c2a8> (a HTTPClient.HTTPResponse)
> at
> com.airs.portal.ResumeRoadRunner$Category.discover(ResumeRoadRunner.ja
> va
> :702)
> at
> com.airs.portal.ResumeRoadRunner$Category.<init>(ResumeRoadRunner.java
> :6
> 78)
> at
> com.airs.portal.ResumeRoadRunner$Category.<init>(ResumeRoadRunner.java
> :6
> 48)
> at
> com.airs.portal.ResumeRoadRunner.<init>(ResumeRoadRunner.java:56)
> at
> com.airs.portal.ResumeRoadRunner.theResumeRoadRunner(ResumeRoadRunner.
> ja
> va:631)
> at com.airs.jobbot.Controller.init(Controller.java:293)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.j
> av
> a:1161)
> - locked <0x0ed897e0> (a
> org.apache.catalina.core.StandardWrapper)
> at
>
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
> - locked <0x0ed897e0> (a
> org.apache.catalina.core.StandardWrapper)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext
> .j
> ava:4045)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:43
> 51
> )
> - locked <0x0eb521f8> (a
> org.apache.catalina.core.StandardContext)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.
> ja
> va:791)
> - locked <0x0fe70f88> (a java.util.HashMap)
> at
>
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
> at
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java
> :9
> 20)
> at
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.ja
> va
> :883)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:
> 31
> 1)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycle
> Su
> pport.java:117)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> - locked <0x0fe70fb0> (a
org.apache.catalina.core.StandardHost)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
> - locked <0x0fe70fb0> (a
org.apache.catalina.core.StandardHost)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> - locked <0x0fe70cd8> (a
> org.apache.catalina.core.StandardEngine)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at
>
org.apache.catalina.core.StandardService.start(StandardService.java:516)
> - locked <0x0fe70cd8> (a
> org.apache.catalina.core.StandardEngine)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> - locked <0x0fe71278> (a [Lorg.apache.catalina.Service;)
> at
> org.apache.catalina.startup.Catalina.start(Catalina.java:566)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> av
> a:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> or
> Impl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> at
> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
>
> "VM Thread" prio=10 tid=0x08077000 nid=0x1d56 runnable
>
> "VM Periodic Task Thread" prio=10 tid=0x0828a400 nid=0x1d5d waiting on
> condition
>
> JNI global references: 765
>
> Heap
> def new generation total 70848K, used 57472K [0x0c0f0000,
0x10dd0000,
> 0x15e70000)
> eden space 62976K, 82% used [0x0c0f0000, 0x0f383c18, 0x0fe70000)
> from space 7872K, 72% used [0x0fe70000, 0x103fc688, 0x10620000)
> to space 7872K, 0% used [0x10620000, 0x10620000, 0x10dd0000)
> tenured generation total 945280K, used 0K [0x15e70000, 0x4f990000,
> 0x8c0f0000)
> the space 945280K, 0% used [0x15e70000, 0x15e70000, 0x15e70200,
> 0x4f990000)
> compacting perm gen total 12288K, used 11911K [0x8c0f0000,
> 0x8ccf0000,
> 0x940f0000)
> the space 12288K, 96% used [0x8c0f0000, 0x8cc91ee0, 0x8cc92000,
> 0x8ccf0000)
> ro space 8192K, 73% used [0x940f0000, 0x946ce548, 0x946ce600,
> 0x948f0000)
> rw space 12288K, 57% used [0x948f0000, 0x94fe16c0, 0x94fe1800,
> 0x954f0000)
>
>
>>From this it looks like part of the problem is threads are waiting on
> object monitor? Am I interpreting this correctly?
>
> -dustin
> -----Original Message-----
> From: Caldarale, Charles R [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 11:30 AM
> To: Tomcat Users List
> Subject: RE: javax/mail/address
>
>> From: Dustin Fortin [mailto:[EMAIL PROTECTED]
>> Subject: RE: javax/mail/address
>>
>> Thats the frustrating part, there is no thread dump.
>
> You have to take a thread dump; there won't be one generated
> automatically. Use kill -3 on Linux, ctrl-break on Windows.
>
> - Chuck
>
>
> THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
> PROPRIETARY MATERIAL and is thus for use only by the intended
> recipient. If you received this in error, please contact the sender
> and delete the e-mail and its attachments from all computers.
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe,
> e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe,
> e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe,
e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
