Angela, how about trying with other database/driver just to check your config?
I have had "ClassNotFoundException" when a .jar was _twice_ in the classpath. You might want to check that too. Troubleshooting this kind of error is like trying to hit a "Piñata", isn't it? Good luck! Álvaro Coronel. ________________________________ From: Angela Day <akc...@yahoo.com> To: Apache Torque Users List <torque-user@db.apache.org> Sent: Wed, December 2, 2009 8:05:09 PM Subject: Re: no suitable driver Yes, there were significant changes. I had to merge the old server.xml with the new version of 3.3 server.xml, so I am not sure my new server.xml file is correct. I do have the gen jar in place and get the same error. Angela Day National Autism Association of Central Texas http://www.naacentraltexas.org formally FEAT Austin ________________________________ From: "wzhao6...@gmail.com" <wzhao6...@gmail.com> To: Apache Torque Users List <torque-user@db.apache.org> Sent: Wed, December 2, 2009 3:38:58 PM Subject: Re: no suitable driver There may have been many syntax changes in Torque 3.3 from Torque 1.0, you may want to look into this. I think you need to specify database server and user/password information in the "build.properties" file (at least in our set up). Try to download the torque-3.3-gen package, and run a ant -f build-torque.xml jdbc or something similar with you existing build.properties file in the same directory to see if you can get this task to run successfully (ant -f build-torque.xml jdbc generates the schema.xml from your database). Good luck, David On Wed, Dec 2, 2009 at 1:15 PM, Angela Day <akc...@yahoo.com> wrote: > 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