db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wzhao6898@gmail.com" <wzhao6...@gmail.com>
Subject Re: no suitable driver
Date Wed, 02 Dec 2009 21:38:58 GMT
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 <akcday@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 <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