I am going crazy with a problem I have had for a few days now. It
seems so simple, but I cannot solve the problem. Any help would
be appreciated. I have ojdbc14.jar in the classpath for the env
variable path and in the build-torque.xml file. I am using java
1.5 and torque 3.3 and eclipse 3.5.1 and velocity 1.5
Dec 2, 2009 2:02:45 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Dec 2, 2009 2:02:45 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1960 ms
Dec 2, 2009 2:02:45 PM org.apache.catalina.core.StandardService
start
INFO: Starting service Catalina
Dec 2, 2009 2:02:45 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009
2:02:47 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /alligator threw load()
exceptionjava.sql.SQLException
at java.sql.DriverManager.getDriver(Unknown Source)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(
at org.apache.torque.TorqueInstance.getConnection(
at org.apache.torque.TorqueInstance.getConnection(
at org.apache.torque.Torque.getConnection(
at tdhca.torque.CurrentConnection.getConnection(
at tdhca.maverick.Dispatcher.initTorque(
at tdhca.maverick.Dispatcher.init(
at javax.servlet.GenericServlet.init(
at org.apache.catalina.core.StandardWrapper.loadServlet(
at org.apache.catalina.core.StandardWrapper.load(
at org.apache.catalina.core.StandardContext.loadOnStartup(
at org.apache.catalina.core.StandardContext.start(
at org.apache.catalina.core.ContainerBase.start(
at org.apache.catalina.core.StandardHost.start(
at org.apache.catalina.core.ContainerBase.start(
at org.apache.catalina.core.StandardEngine.start(
at org.apache.catalina.core.StandardService.start(
at org.apache.catalina.core.StandardServer.start(
at org.apache.catalina.startup.Catalina.start(
at sun.reflect.NativeMethodAccessorImpl.invoke0(
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(
at org.apache.catalina.startup.Bootstrap.main(
Dec 2, 2009 2:02:47 PM org.apache.catalina.core.ApplicationContext
log
INFO: Use of the properties initialization parameter 'properties'
has been deprecated by 'org.apache.velocity.properties'
Dec 2, 2009 2:02:49 PM org.apache.catalina.core.ApplicationContext
log
INFO: ContextListener: contextInitialized()
Dec 2, 2009 2:02:49 PM org.apache.catalina.core.ApplicationContext
log
INFO: SessionListener: contextInitialized()
Dec 2, 2009 2:02:50 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Dec 2, 2009 2:02:50 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Dec 2, 2009 2:02:50 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/125 config=null
Dec 2, 2009 2:02:50 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 4885 ms: No suitable
driverBasicDataSource.java:1143)BasicDataSource.java:880)
TorqueInstance.java:912)TorqueInstance.java:891)Torque.java:300)
CurrentConnection.java:32)Dispatcher.java:375)Dispatcher.java:307)
GenericServlet.java:212)StandardWrapper.java:1173)
StandardWrapper.java:993)StandardContext.java:4149)
StandardContext.java:4458)ContainerBase.java:1045)
StandardHost.java:722)ContainerBase.java:1045)StandardEngine.java:
443)StandardService.java:516)StandardServer.java:710)Catalina.java:
583)Native Method)Bootstrap.java:288)Bootstrap.java:413)
Server.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed
with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License,
Version 2.0
(the "License"); you may not use this file except in compliance
with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
implied.
See the License for the specific language governing permissions and
limitations under the License.
--><!-- Note: A "Server" is not itself a "Container", so you may
not
define subcomponents such as "Valves" at this level.
Documentation at /docs/config/server.html
--><Server port="8005" shutdown="SHUTDOWN">
<!--APR library loader. Documentation at /docs/apr.html -->
<Listener SSLEngine="on"
className="org.apache.catalina.core.AprLifecycleListener"/>
<!--Initialize Jasper prior to webapps are loaded. Documentation
at /docs/jasper-howto.html -->
<Listener className="org.apache.catalina.core.JasperListener"/>
<!-- JMX Support for the Tomcat server. Documentation at /docs/
non-existent.html -->
<Listener
className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
<Listener
className
="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>
<!-- Global JNDI resources
Documentation at /docs/jndi-resources-howto.html
-->
<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users -->
<Environment name="envName" type="java.lang.String" value="DEV"/>
<Environment name="contractPropertiesFile" type="java.lang.String"
value="C:\\workspace\\contract\\conf\\contract.properties"/>
<Environment name="cmts-url" value="http://localhost:8080/aims2/aims
" type="java.lang.String"/>
<Environment name="cseaPropertiesFile" type="java.lang.String"
value="C:\\apache-tomcat-6.0.20\\webapps\\csea\\WEB-INF\\csea.properties
"/>
<Environment name="cdb-url" value="http://localhost:8080/alligator
" type="java.lang.String"/>
<Environment name="liarRealm"
value="tdhca.liar.ReniRealm" type="java.lang.String"/>
<Environment name="tdhca.liar.useDomain"
value="false" type="java.lang.String" />
<Environment name="tdhca.liar.hashSalt"
value="23049mdx903lzd93jag9845a0gjsscvm" type="java.lang.String"/>
<Resource name="jdbc/cmts" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/cmts">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</
value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:sysa...@atlow.tdhca.state.tx.us:
1521:dev</value>
</parameter>
<parameter>
<name>username</name>
<value>xxx</value>
</parameter>
<parameter>
<name>password</name>
<value>xxx</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
<parameter>
<!-- time to wait for a connection before giving up in
milliseconds -->
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>testWhileIdle</name>
<value>true</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select 1 from dual</value>
</parameter>
</ResourceParams>
<Resource auth="Container" description="User database that can
be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
name="UserDatabase" pathname="conf/tomcat-users.xml"
type="org.apache.catalina.UserDatabase"/>
</GlobalNamingResources>
<!-- A "Service" is a collection of one or more "Connectors" that
share
a single "Container" Note: A "Service" is not itself a
"Container",
so you may not define subcomponents such as "Valves" at
this level.
Documentation at /docs/config/service.html
-->
<Service name="Catalina">
<!--The connectors can use a shared executor, you can define
one or more named thread pools-->
<!--
<Executor name="tomcatThreadPool" namePrefix="catalina-exec-"
maxThreads="150" minSpareThreads="4"/>
-->
<!-- A "Connector" represents an endpoint by which requests are
received
and responses are returned. Documentation at :
Java HTTP Connector: /docs/config/http.html (blocking &
non-blocking)
Java AJP Connector: /docs/config/ajp.html
APR (HTTP/AJP) Connector: /docs/apr.html
Define a non-SSL HTTP/1.1 Connector on port 8080
-->
<Connector connectionTimeout="20000" port="8080" protocol="HTTP/
1.1" redirectPort="8443"/>
<!-- A "Connector" using the shared thread pool-->
<!--
<Connector executor="tomcatThreadPool"
port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
-->
<!-- Define a SSL HTTP/1.1 Connector on port 8443
This connector uses the JSSE configuration, when using
APR, the
connector should be using the OpenSSL style configuration
described in the APR documentation -->
<!--
<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"
maxThreads="150" scheme="https" secure="true"
clientAuth="false" sslProtocol="TLS" />
-->
<!-- Define an AJP 1.3 Connector on port 8009 -->
<Connector port="8009" protocol="AJP/1.3" redirectPort="8443"/>
<!-- An Engine represents the entry point (within Catalina)
that processes
every request. The Engine implementation for Tomcat
stand alone
analyzes the HTTP headers included with the request, and
passes them
on to the appropriate Host (virtual host).
Documentation at /docs/config/engine.html -->
<!-- You should set jvmRoute to support load-balancing via AJP
ie :
<Engine name="Catalina" defaultHost="localhost" jvmRoute="jvm1">
-->
<Engine defaultHost="localhost" name="Catalina">
<!--For clustering, please take a look at documentation at:
/docs/cluster-howto.html (simple how to)
/docs/config/cluster.html (reference documentation) -->
<!--
<Cluster
className="org.apache.catalina.ha.tcp.SimpleTcpCluster"/>
-->
<!-- The request dumper valve dumps useful debugging
information about
the request and response data received and sent by
Tomcat.
Documentation at: /docs/config/valve.html -->
<!--
<Valve
className="org.apache.catalina.valves.RequestDumperValve"/>
-->
<!-- This Realm uses the UserDatabase configured in the
global JNDI
resources under the key "UserDatabase". Any edits
that are performed against this UserDatabase are
immediately
available for use by the Realm. -->
<Realm
className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
<!-- Define the default virtual host
Note: XML Schema validation will not work with Xerces
2.2.
-->
<Host appBase="webapps" autoDeploy="true" name="localhost"
unpackWARs="true" xmlNamespaceAware="false" xmlValidation="false">
<!-- SingleSignOn valve, share authentication between web
applications
Documentation at: /docs/config/valve.html -->
<!--
<Valve
className="org.apache.catalina.authenticator.SingleSignOn" />
-->
<!-- Access log processes all example.
Documentation at: /docs/config/valve.html -->
<!--
<Valve
className="org.apache.catalina.valves.AccessLogValve"
directory="logs"
prefix="localhost_access_log." suffix=".txt"
pattern="common" resolveHosts="false"/>
-->
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log."
suffix=".txt"
timestamp="true"/>
<Context path="/alligator" docBase="alligator" debug="0"
reloadable="true" crossContext="true">
<ResourceLink name="liarRealm" global="liarRealm"/>
<ResourceLink name="tdhca.liar.useDomain"
global="tdhca.liar.useDomain"/>
<ResourceLink name="tdhca.liar.hashSalt"
global="tdhca.liar.hashSalt"/>
<ResourceLink name="cmts-url" global="cmts-url"/>
<ResourceLink name="mf-url" global="mf-url"/>
<ResourceLink name="cdb-url" global="cdb-url"/>
<ResourceLink name="jdbc/cdb" global="jdbc/cmts"
type="javax.sql.DataSource" />
<Environment name="serverName" type="java.lang.String"
value="contract"/>
<ResourceLink name="envName" global="envName"/>
<ResourceLink name="contractPropertiesFile"
global="contractPropertiesFile"/>
</Context>
</Host>
</Engine>
</Service>
</Server>
Thanks for your help.
Angela Day
National Autism Association of Central Texas
http://www.naacentraltexas.org
formally FEAT Austin