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 <[email protected]>
To: Apache Torque Users List <[email protected]>
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 <[email protected]> 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:[email protected]: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: [email protected]
For additional commands, e-mail: [email protected]
