That is what it seems like, but why? I haven't a clue. Angela Day National Autism Association of Central Texas
http://www.naacentraltexas.org formally FEAT Austin ________________________________ From: Apache Lists <apa...@rodentia.net> To: Apache Torque Users List <torque-user@db.apache.org> Sent: Wed, December 2, 2009 3:22:50 PM Subject: Re: no suitable driver > C:\workspace\contract\build-torque.XML:347: java.lang.ClassNotFoundException: > ${torque.database.driver} This looks a little odd to me - I'd expect to see a classname here. Is the property name not getting replaced with the value for some reason? On Dec 2, 2009, at 1:17 PM, Angela Day wrote: > This is what I got, which is essentially the same error: > > C:\workspace\contract>ant -f build-torque.XML jdbc > Buildfile: build-torque.XML > jdbc: > [echo] +-----------------------------------------------+ > [echo] | | > [echo] | Generating XML from JDBC connection ! | > [echo] | Woo hoo! | > [echo] | | > [echo] +-----------------------------------------------+ > [torque-jdbc-transform] Torque - JDBCToXMLSchema starting > [torque-jdbc-transform] Your DB settings are: > [torque-jdbc-transform] driver : ${torque.database.driver} > [torque-jdbc-transform] URL : ${torque.database.url} > [torque-jdbc-transform] user : ${torque.database.user} > [torque-jdbc-transform] schema : ${torque.database.schema} > BUILD FAILED > C:\workspace\contract\build-torque.XML:347: java.lang.ClassNotFoundException: > ${ > torque.database.driver} > > Any ideas what this means? > > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org