db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Angela Day <akc...@yahoo.com>
Subject Re: no suitable driver
Date Wed, 02 Dec 2009 21:15:23 GMT
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 <weizhao6898@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 <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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message