It is an existing database and application that I am upgrading from Torque 1.0 and JDK1.4, so I am pretty sure the database is setup right. Do you have something in mind?
Thanks, Angela Day National Autism Association of Central Texas http://www.naacentraltexas.org formally FEAT Austin ________________________________ From: Wei Zhao <weizhao6...@gmail.com> To: Apache Torque Users List <torque-user@db.apache.org> Sent: Wed, December 2, 2009 2:49:49 PM Subject: Re: no suitable driver What about your build.properties file? I'd try to do a " ant -f build-torque.XML jdbc" or some other ant task tomake sure the database is set up right. David On Dec 2, 2009, at 12:33 PM, Angela Day <akc...@yahoo.com> wrote: > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org
