db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wei Zhao <weizhao6...@gmail.com>
Subject Re: no suitable driver
Date Wed, 02 Dec 2009 20:49:49 GMT
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 <akcday@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:sysadm2@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-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message