| Newsgroups |
gmane.comp.jakarta.turbine.torque.user |
| Message-ID |
<[email protected]> |
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 <[email protected]> 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 <[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]