torque-user@db.apache.org Archives http://mail-archives.apache.org/mod_mbox/db-torque-user/ 2009-12-08T11:26:08Z Re: no suitable driver Thomas Vandahl <tv@apache.org> urn:uuid:%3c4B1A992B-4010509@apache-org%3e 2009-12-05T17:32:27Z 
Angela Day wrote:
> Thomas,
> Thank you so much for the tip on the xml syntax.  That got rid of the no suitable driver
and all other errors.  No I just get a 404 in the browser when I try to bring up the application.
 The example tomcat servlets all work.  It is never getting to my application because I put
debug statements into the very first and nothing.  Any ideas for why tomcat would just 404
me without getting to the application?

Well this depends a lot on what your application actually does and not
much on Torque. But let's have a look at your web.xml. Last time it
didn't make it to the list.

Bye, Thomas.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c754053-33380-qm@web33301-mail-mud-yahoo-com%3e 2009-12-04T16:21:12Z 
Thomas,
Thank you so much for the tip on the xml syntax.  That got rid of the no suitable driver and
all other errors.  No I just get a 404 in the browser when I try to bring up the application. 
The example tomcat servlets all work.  It is never getting to my application because I put
debug statements into the very first and nothing.  Any ideas for why tomcat would just 404
me without getting to the application?
Thanks,

 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: Thomas Vandahl <tv@apache.org>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Thu, December 3, 2009 2:18:52 PM
Subject: Re: no suitable driver

Angela Day wrote:
> INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009 2:02:47 PM org.apache.catalina.core.StandardContext
loadOnStartup
...
> <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>

This doesn't fit. The Tomcat 6.0 configuration uses attributes instead
of ResourceParams elements to configure a data source. See
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
for examples.

The problem usually arises if the web application has no access to the
configured data source. Let's see your Torque.properties and the web.xml
of your application, please.

Bye, Thomas.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c291859-26348-qm@web33301-mail-mud-yahoo-com%3e 2009-12-03T20:28:37Z 
Attached you will find the web.xml and build-torque.properties files.  Thanks so much for your
help.

Thanks,
 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: Thomas Vandahl <tv@apache.org>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Thu, December 3, 2009 2:18:52 PM
Subject: Re: no suitable driver

Angela Day wrote:
> INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009 2:02:47 PM org.apache.catalina.core.StandardContext
loadOnStartup
...
> <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>

This doesn't fit. The Tomcat 6.0 configuration uses attributes instead
of ResourceParams elements to configure a data source. See
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
for examples.

The problem usually arises if the web application has no access to the
configured data source. Let's see your Torque.properties and the web.xml
of your application, please.

Bye, Thomas.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Thomas Vandahl <tv@apache.org> urn:uuid:%3c4B181D2C-9080106@apache-org%3e 2009-12-03T20:18:52Z 
Angela Day wrote:
> INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009 2:02:47 PM org.apache.catalina.core.StandardContext
loadOnStartup
...
> <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>

This doesn't fit. The Tomcat 6.0 configuration uses attributes instead
of ResourceParams elements to configure a data source. See
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
for examples.

The problem usually arises if the web application has no access to the
configured data source. Let's see your Torque.properties and the web.xml
of your application, please.

Bye, Thomas.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Alvaro Coronel <alvarocoronel67@yahoo.com> urn:uuid:%3c53771-1348-qm@web50801-mail-re2-yahoo-com%3e 2009-12-02T22:56:31Z 
Angela, how about trying with other database/driver just to check your config?

I have had "ClassNotFoundException" when a .jar was _twice_ in the classpath. You might want
to check that too.

Troubleshooting this kind of error is like trying to hit a "Piñata", isn't it? Good luck!

Álvaro Coronel.



________________________________
From: Angela Day <akcday@yahoo.com>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Wed, December 2, 2009 8:05:09 PM
Subject: Re: no suitable driver

Yes, there were significant changes.  I had to merge the old server.xml with the new version
of 3.3 server.xml, so I am not sure my new server.xml file is correct.  I do have the gen
jar in place and get the same error.
 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: "wzhao6898@gmail.com" <wzhao6898@gmail.com>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Wed, December 2, 2009 3:38:58 PM
Subject: Re: no suitable driver

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
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c2623-68374-qm@web33304-mail-mud-yahoo-com%3e 2009-12-02T22:05:09Z 
Yes, there were significant changes.  I had to merge the old server.xml with the new version
of 3.3 server.xml, so I am not sure my new server.xml file is correct.  I do have the gen
jar in place and get the same error.
 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: "wzhao6898@gmail.com" <wzhao6898@gmail.com>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Wed, December 2, 2009 3:38:58 PM
Subject: Re: no suitable driver

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
Re: no suitable driver "wzhao6898@gmail.com" <wzhao6898@gmail.com> urn:uuid:%3c4d036f890912021338j4b69307fifccf511664e9ca44@mail-gmail-com%3e 2009-12-02T21:38:58Z 
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
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c674201-60600-qm@web33308-mail-mud-yahoo-com%3e 2009-12-02T21:33:02Z 
That is what it seems like, but why?  I haven't a clue.
 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: Apache Lists <apache@rodentia.net>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Wed, December 2, 2009 3:22:50 PM
Subject: Re: no suitable driver

> C:\workspace\contract\build-torque.XML:347: java.lang.ClassNotFoundException: ${torque.database.driver}

This looks a little odd to me - I'd expect to see a classname here. Is the property name not
getting replaced with the value for some reason?

On Dec 2, 2009, at 1:17 PM, Angela Day wrote:

> 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 <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


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Apache Lists <apache@rodentia.net> urn:uuid:%3c84E55F84-7460-410F-B6EC-64443306DBB6@rodentia-net%3e 2009-12-02T21:26:37Z 
After seeing my own response, I realized that it may look like I am  
claiming to be part of Apache. I am not; I just have an email account  
I use to subscribe to Apache lists. I've changed the real name on the  
account to be less misleading.

I'm not associated with Apache in any way, I'm trying to learn these  
technologies too :)

On Dec 2, 2009, at 1:22 PM, Apache Lists wrote:

>> C:\workspace\contract\build-torque.XML:347:  
>> java.lang.ClassNotFoundException: ${torque.database.driver}
>
> This looks a little odd to me - I'd expect to see a classname here.  
> Is the property name not getting replaced with the value for some  
> reason?
>
> On Dec 2, 2009, at 1:17 PM, Angela Day wrote:
>
>> 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 <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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Apache Lists <apache@rodentia.net> urn:uuid:%3cBE071041-FD4D-4248-812E-684AD6A7C828@rodentia-net%3e 2009-12-02T21:22:50Z 
> C:\workspace\contract\build-torque.XML:347:  
> java.lang.ClassNotFoundException: ${torque.database.driver}

This looks a little odd to me - I'd expect to see a classname here. Is  
the property name not getting replaced with the value for some reason?

On Dec 2, 2009, at 1:17 PM, Angela Day wrote:

> 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 <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


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c124684-53064-qm@web33308-mail-mud-yahoo-com%3e 2009-12-02T21:17:55Z 
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 <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
Re: no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c905025-48588-qm@web33308-mail-mud-yahoo-com%3e 2009-12-02T21:15:23Z 
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
Re: no suitable driver Wei Zhao <weizhao6898@gmail.com> urn:uuid:%3c9161C81B-47A4-40EB-BF28-2527B7CB48E4@gmail-com%3e 2009-12-02T20:49:49Z 
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
no suitable driver Angela Day <akcday@yahoo.com> urn:uuid:%3c755835-25575-qm@web33308-mail-mud-yahoo-com%3e 2009-12-02T20:33:45Z 
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
Re: Not Generating Base Classes Angela Day <akcday@yahoo.com> urn:uuid:%3c482199-43817-qm@web33308-mail-mud-yahoo-com%3e 2009-11-24T15:20:47Z 
I am getting this error in the velocity log:
RHS of #set statement is null. Context will not be modified. om/Control.vm [line 105, column
1], one for each table.  line 105 is 

        #set ($retVar = $builderArray.add("${packagePeer}.${tbl.JavaName}Peer") )


I started over when the templates and still have the same problem.  If I move the code from
the BaseControl.vm to the Control.vm then it generates the base classes, but that is not the
ultimate answer. 

Also, another problem, I cannot get the base classes to build into a separate directory. 
I used the torque.subpackage.base in the default.properties, but it does not work.

Thanks for your help.

 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: Thomas Fischer <fischer@seitenbau.net>
To: Apache Torque Users List <torque-user@db.apache.org>
Sent: Tue, November 24, 2009 1:22:31 AM
Subject: Re: Not Generating Base Classes

> Upgraded to Torque 3.3 and now not generating Base Classes.  All
> other classes created.  No errors generating.  What am I doing wrong?

In the standard setup out of the box, Torque generates base classes. So
either there should be an error message in the velocity.log, or you have
changed the setup such that base classes are no longer created. In the
latter case, it would be helpful to know in which ways your setup differs
from the standard setup.

I'd recommend downloading the torque generator anew, runnung it on your
schema and then figure out the differences between your setup and the
standard setup. Maybe it is apparent which change it is, or otherwise you
need to apply the changes one after another and check which has this
effect.

        Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Not Generating Base Classes Thomas Fischer <fischer@seitenbau.net> urn:uuid:%3cOF9423894D-F607D2F3-ONC1257678-00233DBE-C1257678-00288506@seitenbau-net%3e 2009-11-24T07:22:31Z 
> Upgraded to Torque 3.3 and now not generating Base Classes.  All
> other classes created.  No errors generating.  What am I doing wrong?

In the standard setup out of the box, Torque generates base classes. So
either there should be an error message in the velocity.log, or you have
changed the setup such that base classes are no longer created. In the
latter case, it would be helpful to know in which ways your setup differs
from the standard setup.

I'd recommend downloading the torque generator anew, runnung it on your
schema and then figure out the differences between your setup and the
standard setup. Maybe it is apparent which change it is, or otherwise you
need to apply the changes one after another and check which has this
effect.

        Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Not Generating Base Classes Angela Day <akcday@yahoo.com> urn:uuid:%3c344717-65992-qm@web33306-mail-mud-yahoo-com%3e 2009-11-23T19:30:08Z 
Upgraded to Torque 3.3 and now not generating Base Classes.  All other classes created.  No
errors generating.  What am I doing wrong?

Thanks,

 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin
Problem with goal datasql "Ludwig Magnusson" <ludwig@itcatapult.com> urn:uuid:%3c000001ca693d$72f01a60$58d04f20$@com%3e 2009-11-19T17:26:36Z 
Hi!

I have a problem with the maven 2 plugin and the goal datasql.

When I run mvn torque:datasql, maven prints:

 

[INFO] XmlToAppData - Parsing file: 'schema.xml'

[INFO] XmlToData - Resolver: used
file:///c:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webap
ps/myproject/torque/schema/torque-data.dtd
<file:///c:\Program%20Files\Apache%20Software%20Foundation\Tomcat%206.0\weba
pps\myproject\torque\schema\torque-data.dtd> 

 

After that, nothing prints and a while later I get a OutOfMemoryError. 

I have specified my data.xml file in <dataXmlFile>

Is there something I am missing or doing wrong?

/Ludwig
Re: Criteria needs write permissions? Thomas Vandahl <tv@apache.org> urn:uuid:%3c4B02F4A3-5040308@apache-org%3e 2009-11-17T19:08:19Z 
Greg Monroe wrote:
> Connection srcConn = Torque.getConnection("databaseA");
> Connection destConn = Torque.getConnection("databaseB");

Don't want to be picky, but the recommended method is

	Connection srcConn = Transaction.begin("databaseA");

> } finally {
> 	Torque.closeConnection(srcConn);

and Transaction.commit(srcConn), respectively.

BTW: The limitations with your described approach look serious to me.
You would need a lot of comments to explain what you're about to do,
wouldn't you?

Bye, Thomas.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Criteria needs write permissions? Greg Monroe <Greg.Monroe@dukece.com> urn:uuid:%3c55B8568AFA5F144F886F18186BAD5B2C05FA44C76A@durham-e2k7mb1-dukece-com%3e 2009-11-17T14:23:20Z 
The schema databasemap name (e.g. defaultDB) will always be hard coded to the
name in the XML file.  So, it will never be found in another "Database" object.

Your code snippet doesn't connect the "nondefaultDB" pool name to anything
the criteria/SQLBuilder uses.  But your debugging showed it was looking for 
this name. I suspect this is because your runtime torque.database.default 
property set to "nondefaultDB".

This property is the "name" that Torque uses for the default if none is specified.

Try either changing your runtime settings to use "defaultDB" or specify the 
"defaultDB" name on your criteria constructor, e.g. new Criteria("defaultDB").
This will make sure that the "name" used will match the schema name.

> -----Original Message-----
> From: Sheldon Ross [mailto:sross@simmgene.com]
> Sent: Monday, November 16, 2009 5:19 PM
> To: Apache Torque Users List
> Subject: Re: Criteria needs write permissions?
> 
> "Second, create all criteria element using the *Peer objects.  The
> DatabaseMap is populated when a *Peer class is loaded (static init).
> So, all tables "Maps" you will be referencing will exist in a Database
> object keyed to the DB Schema Name."
> 
> This seems to be where I'm failing. Yes some queries will work. But I
> don't think
> the metadata areas will work. If this is what you meant, then I
> apologize.
> 
> For example. Use an OrderBy clause for selecting from a database
> connection pool
> that is not from the default schema for that object.
> 
> Connection srcConn = Torque.getConnection("nondefaultDB");
> Criteria critera = new Criteria();
> criteria.addAscendingOrderByColumn(TableAPeer.COLA);
> TableAPeer.doSelect(criteria,srcConn);
> 
> This doesn't work for me because TableA does not exist in the dbMap
> for "nondefaultDB". It does exist in the dbMap for "defaultDB" because
> that's
> what's coded via the schema name.
> 
> SQLBuilder succeeds at building the query for
> 
> c.add(TableAPeer.COLA, 4);
> 
> because it doesn't reference any metadata.
> 
> It fails on the processOrderBy(db, dbMap, crit, query);
> because this function assumes the metadata is there.
> 
> 
> Ross
> 
> 
DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4B01CFD7-9000108@simmgene-com%3e 2009-11-16T22:19:03Z 
"Second, create all criteria element using the *Peer objects.  The
DatabaseMap is populated when a *Peer class is loaded (static init).
So, all tables "Maps" you will be referencing will exist in a Database 
object keyed to the DB Schema Name."

This seems to be where I'm failing. Yes some queries will work. But I don't think
the metadata areas will work. If this is what you meant, then I apologize.

For example. Use an OrderBy clause for selecting from a database connection pool
that is not from the default schema for that object.

Connection srcConn = Torque.getConnection("nondefaultDB");
Criteria critera = new Criteria();
criteria.addAscendingOrderByColumn(TableAPeer.COLA);
TableAPeer.doSelect(criteria,srcConn);

This doesn't work for me because TableA does not exist in the dbMap
for "nondefaultDB". It does exist in the dbMap for "defaultDB" because that's
what's coded via the schema name.

SQLBuilder succeeds at building the query for 

c.add(TableAPeer.COLA, 4); 

because it doesn't reference any metadata.

It fails on the processOrderBy(db, dbMap, crit, query);
because this function assumes the metadata is there.


Ross


Greg Monroe wrote:
> Sorry for the delay, out for a long weekend (gotta stay in bed on Fri 13th!).
>
> Simple Torque Objects CAN be used with two different connection pools.  
> I have done this myself.  However, there are some special limitations. I 
> spent some time wandering the code and refreshing my memory and here's 
> what I found.
>
> First, you need to understand some definitions:
>
> Simple Torque Objects - Just the core record information methods. The methods 
> generated by the complexObjectModel build property (e.g. the ones which 
> generate the methods to get the related foreign key and children objects) 
> do not work. The autogenerated code assumes a lot about which connection
> to use.
>
> DBSchema Name - This is a string key defined via the XML schema database 
> name attribute. It is used internally by Torque to tie together all the
> schema "metadata" in a "DatabaseMap".  This is used by Torque to determine
> things like table names, column attributes, and the like.  
>
> DatabaseMap - This is the object that contains all the meta data *Map 
> objects related to a specific DBSchema name.
>
> DB Connection Pool Name - This is a string key that is defined in the 
> Torque runtime properties, e.g. the torque.dsfactory.<DB Connection Name>.*
> properties.  This is eventually stored in a Database object in the 
> TorqueInstance.
>
> Database Object - This is a container for information relating to a 
> database, e.g. the connection pool info, the dbmap, the idbroker info,
> and the like.  However, you can have a Database Object that does not
> contain all this info (e.g. a Database object with just connection 
> info).
>
> Because of historical design purposes lost in antiquity, the DB Schema
> name and the DB Connection Name tend to be considered to be the same.
> Many of the references to "DBName" are not clearly labeled as to which
> name is meant. This has lead to some poor internal coding and a lot of 
> confusion.  One of the goals of Torque 4.0 is to try to correct this.
>
> So, how do you use Simple Torque objects with multiple DBs...
>
> First, set up your connection pools in the runtime properties.  E.g.
> torque.dsfactory.databaseA.* and torque.dsfactory.databaseB.
>
> Second, create all criteria element using the *Peer objects.  The
> DatabaseMap is populated when a *Peer class is loaded (static init).
> So, all tables "Maps" you will be referencing will exist in a Database 
> object keyed to the DB Schema Name.  
>
> NOTE: The dbName parameter on the Criteria constructor refers to the
> DB Schema Name and NOT directly to a DB Connection Pool Name.  If there
> is a DB Connection Pool defined with the same name, this will be used.
>
> You need to write your code to use the methods that have a connection 
> parameter.  E.g., TablePeer.doSelect(Criteria, Connection).
>
> You get the connection object to use with this via the 
> Toque.getConnection(String name) static method.  The name here is the
> DB Connection Pool name.
>
> To tie this all together with some sample code that will move data
> from one DB to another one:
>
> Criteria c = new Criteria();  
> c.add(TableAPeer.COLA, 4);
> Connection srcConn = Torque.getConnection("databaseA");
> Connection destConn = Torque.getConnection("databaseB");
> try {
>     List results = TableAPeer.doSelect(c,srcConn);
>     Iterator rIt = results.iterator();
>     while( rIt.hasNext() ) {
>         TableA rec = (TableA) rIt.next();
>         rec.save(destConn);      
>     }
>       
> } finally {
> 	Torque.closeConnection(srcConn);
>       Torque.closeConnection(destConn);
> }
>
>
>
>   
>> -----Original Message-----
>> From: Alvaro Coronel [mailto:alvarocoronel67@yahoo.com]
>> Sent: Friday, November 13, 2009 10:50 AM
>> To: Apache Torque Users List
>> Subject: Re: Criteria needs write permissions?
>>
>> Does that mean that a Torque object can be used with two different
>> connections as long as no pool is involved?
>>
>>
>>
>> ________________________________
>> From: Thomas Vandahl <tv@apache.org>
>> To: torque-user@db.apache.org
>> Sent: Fri, November 13, 2009 1:27:26 PM
>> Subject: Re: Criteria needs write permissions?
>>
>> On 13.11.09 08:12, Thomas Fischer wrote:
>>     
>>> I'm not sure whether this is a bug or not, I need to think about it. If
>>>       
>> i
>>     
>>> remember correctly, the database name is used for the database
>>>       
>> connection
>>     
>>> (including credentials) and the table layout. Probably there are some
>>>       
>> cases
>>     
>>> where this wants to be treated differently.
>>>       
>> As I see it, the limitation is that a Torque object can only be used
>> with one database connection pool. This might or might not be considered
>> a bug, however, the given application type does not look typical to me.
>>
>> Bye, Thomas.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>
>>     
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>   

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Criteria needs write permissions? Greg Monroe <Greg.Monroe@dukece.com> urn:uuid:%3c55B8568AFA5F144F886F18186BAD5B2C05FA44C767@durham-e2k7mb1-dukece-com%3e 2009-11-16T16:03:17Z 
Sorry for the delay, out for a long weekend (gotta stay in bed on Fri 13th!).

Simple Torque Objects CAN be used with two different connection pools.  
I have done this myself.  However, there are some special limitations. I 
spent some time wandering the code and refreshing my memory and here's 
what I found.

First, you need to understand some definitions:

Simple Torque Objects - Just the core record information methods. The methods 
generated by the complexObjectModel build property (e.g. the ones which 
generate the methods to get the related foreign key and children objects) 
do not work. The autogenerated code assumes a lot about which connection
to use.

DBSchema Name - This is a string key defined via the XML schema database 
name attribute. It is used internally by Torque to tie together all the
schema "metadata" in a "DatabaseMap".  This is used by Torque to determine
things like table names, column attributes, and the like.  

DatabaseMap - This is the object that contains all the meta data *Map 
objects related to a specific DBSchema name.

DB Connection Pool Name - This is a string key that is defined in the 
Torque runtime properties, e.g. the torque.dsfactory.<DB Connection Name>.*
properties.  This is eventually stored in a Database object in the 
TorqueInstance.

Database Object - This is a container for information relating to a 
database, e.g. the connection pool info, the dbmap, the idbroker info,
and the like.  However, you can have a Database Object that does not
contain all this info (e.g. a Database object with just connection 
info).

Because of historical design purposes lost in antiquity, the DB Schema
name and the DB Connection Name tend to be considered to be the same.
Many of the references to "DBName" are not clearly labeled as to which
name is meant. This has lead to some poor internal coding and a lot of 
confusion.  One of the goals of Torque 4.0 is to try to correct this.

So, how do you use Simple Torque objects with multiple DBs...

First, set up your connection pools in the runtime properties.  E.g.
torque.dsfactory.databaseA.* and torque.dsfactory.databaseB.

Second, create all criteria element using the *Peer objects.  The
DatabaseMap is populated when a *Peer class is loaded (static init).
So, all tables "Maps" you will be referencing will exist in a Database 
object keyed to the DB Schema Name.  

NOTE: The dbName parameter on the Criteria constructor refers to the
DB Schema Name and NOT directly to a DB Connection Pool Name.  If there
is a DB Connection Pool defined with the same name, this will be used.

You need to write your code to use the methods that have a connection 
parameter.  E.g., TablePeer.doSelect(Criteria, Connection).

You get the connection object to use with this via the 
Toque.getConnection(String name) static method.  The name here is the
DB Connection Pool name.

To tie this all together with some sample code that will move data
from one DB to another one:

Criteria c = new Criteria();  
c.add(TableAPeer.COLA, 4);
Connection srcConn = Torque.getConnection("databaseA");
Connection destConn = Torque.getConnection("databaseB");
try {
    List results = TableAPeer.doSelect(c,srcConn);
    Iterator rIt = results.iterator();
    while( rIt.hasNext() ) {
        TableA rec = (TableA) rIt.next();
        rec.save(destConn);      
    }
      
} finally {
	Torque.closeConnection(srcConn);
      Torque.closeConnection(destConn);
}



> -----Original Message-----
> From: Alvaro Coronel [mailto:alvarocoronel67@yahoo.com]
> Sent: Friday, November 13, 2009 10:50 AM
> To: Apache Torque Users List
> Subject: Re: Criteria needs write permissions?
> 
> Does that mean that a Torque object can be used with two different
> connections as long as no pool is involved?
> 
> 
> 
> ________________________________
> From: Thomas Vandahl <tv@apache.org>
> To: torque-user@db.apache.org
> Sent: Fri, November 13, 2009 1:27:26 PM
> Subject: Re: Criteria needs write permissions?
> 
> On 13.11.09 08:12, Thomas Fischer wrote:
> > I'm not sure whether this is a bug or not, I need to think about it. If
> i
> > remember correctly, the database name is used for the database
> connection
> > (including credentials) and the table layout. Probably there are some
> cases
> > where this wants to be treated differently.
> 
> As I see it, the limitation is that a Torque object can only be used
> with one database connection pool. This might or might not be considered
> a bug, however, the given application type does not look typical to me.
> 
> Bye, Thomas.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 
DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Alvaro Coronel <alvarocoronel67@yahoo.com> urn:uuid:%3c67020-35310-qm@web50801-mail-re2-yahoo-com%3e 2009-11-13T15:50:02Z 
Does that mean that a Torque object can be used with two different connections as long as no
pool is involved?



________________________________
From: Thomas Vandahl <tv@apache.org>
To: torque-user@db.apache.org
Sent: Fri, November 13, 2009 1:27:26 PM
Subject: Re: Criteria needs write permissions?

On 13.11.09 08:12, Thomas Fischer wrote:
> I'm not sure whether this is a bug or not, I need to think about it. If i
> remember correctly, the database name is used for the database connection
> (including credentials) and the table layout. Probably there are some cases
> where this wants to be treated differently.

As I see it, the limitation is that a Torque object can only be used
with one database connection pool. This might or might not be considered
a bug, however, the given application type does not look typical to me.

Bye, Thomas.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Thomas Vandahl <tv@apache.org> urn:uuid:%3c4AFD7ADE-5020201@apache-org%3e 2009-11-13T15:27:26Z 
On 13.11.09 08:12, Thomas Fischer wrote:
> I'm not sure whether this is a bug or not, I need to think about it. If i
> remember correctly, the database name is used for the database connection
> (including credentials) and the table layout. Probably there are some cases
> where this wants to be treated differently.

As I see it, the limitation is that a Torque object can only be used
with one database connection pool. This might or might not be considered
a bug, however, the given application type does not look typical to me.

Bye, Thomas.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Thomas Fischer <fischer@seitenbau.net> urn:uuid:%3cOF3F043174-D2719177-ONC125766D-0026D957-C125766D-002797DE@seitenbau-net%3e 2009-11-13T07:12:25Z 
> Ok, I apologize for the traffic.

No reason to apologize for anything. This is a perfectly valid question.

> Here goes, when you build the database objects, it hardcodes in the
> database name that exists in your schema.xml. The code is in the
> doBuild() method of the  ${Table}MapBuild.java
>
> public void doBuild() throws TorqueException
>     {
>         dbMap = Torque.getDatabaseMap("defaultdb");
>
> Therefore when you query against a different database, the table names
> never get added to the tables hash for that database.
>
> I would consider this a bug as I don't think this would affect only me.
> Should I report it to the dev mailing list or something. Not sure of the
> etiquette there.

I'm not sure whether this is a bug or not, I need to think about it. If i
remember correctly, the database name is used for the database connection
(including credentials) and the table layout. Probably there are some cases
where this wants to be treated differently.

But please open a jira issue on this (
https://issues.apache.org/jira/secure/Dashboard.jspa), so it will not be
forgotten.

    Thomas


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFC8D82-3070306@simmgene-com%3e 2009-11-12T22:34:42Z 
"So, people get confused when it seems like you can't use the DB objects
with more than one database connection.  But that's not true.  To use
more than one connection pool, you need to use the methods that take a
connection object."

In this case the query still fails even if you specify the connection.

The SqlBuilder assumes that the table name has been added to the dbMap at
the point where its crashing. But the table names only get added to the 
default dbMap.



Greg Monroe wrote:
> OK, I think I understand what's going on here.  It's really a semi-bug
> part but part a definitional issue.  This is because the term database 
> name/dbname actually has two meaning in Torque.  
>
> The first is the "schema database name", i.e. the name in your schema 
> XML.  This is used to group all the database schema's Metadata in the
> Database structure. 
>
> The second meaning for this is the "database connection pool name".  This
> is the name used in the runtime config to define the DB connection info.
>
> Unfortunately, for historical reasons, these two names are "tied" 
> together.  Mostly for convenience reasons... but there are a few cases 
> in the utility classes where a subquery or something needs to be done
> and the default DB name is used.
>
> So, people get confused when it seems like you can't use the DB objects
> with more than one database connection.  But that's not true.  To use
> more than one connection pool, you need to use the methods that take a
> connection object. 
>
> To get an alternate connection, you define this in your runtime with 
> a different name.  E.g. set up a different set of torque.dsfactory.
> properties.
>
> Then use the Torque.getConnection(String) to get a connection from this
> pool. 
>
> FWIW, I put forth a plan for Torque 4 to separate the connection pool
> name from the schema name.  This would require objects and criteria
> to track which pool they came from.
>   
>
>   
>> -----Original Message-----
>> From: Sheldon Ross [mailto:sross@simmgene.com]
>> Sent: Thursday, November 12, 2009 4:28 PM
>> To: Apache Torque Users List
>> Subject: Re: Criteria needs write permissions?
>>
>> Ok, I think this maybe a bug. After watching the addTable method in
>> DatabaseMap, It appears to add the table to the default database dbMap
>> even if the criteria is querying against a different database.
>>
>>
>> Sheldon Ross wrote:
>>     
>>> That would probably work, but It seems a little overkill. Do you know
>>> where the lazy loading happens?
>>> When I run with r/w connection, the dbmap tables hash does appear to
>>> load that way.
>>> However when I run the readonly connection, it just stays empty.
>>>
>>> Thanks
>>>
>>> Greg Monroe wrote:
>>>       
>>>> FWIW, the dbMap object get populated in a "lazy" manner by default.
>>>> However,
>>>> there is a way to force it to be fully loaded via a code call.  You
>>>> do this by calling:
>>>>
>>>> org.apache.torque.linkage.DefaultMapInit.init();
>>>>
>>>> Not that this class actually exists in the generated classes and not
>>>> in the Torque package.  This is because it provided a "known" class
>>>> that "knows" (via extension) the "user settable" om package.
>>>>
>>>>
>>>>         
>>>>> -----Original Message-----
>>>>> From: Sheldon Ross [mailto:sross@simmgene.com]
>>>>> Sent: Thursday, November 12, 2009 3:25 PM
>>>>> To: Apache Torque Users List
>>>>> Subject: Re: Criteria needs write permissions?
>>>>>
>>>>> The why is a good question, the table is not found. The tables
>>>>>           
>> hashmap
>>     
>>>>> in the dbMap appears to be empty.
>>>>> It of course is found when using the other db connection. It looks
>>>>>           
>> like
>>     
>>>>> I'm gonna have to dig for awhile.
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Thomas Fischer wrote:
>>>>>
>>>>>           
>>>>>> The null ointer exception seems to come from reading the table or
>>>>>>
>>>>>>             
>>>>> column
>>>>>
>>>>>           
>>>>>> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
>>>>>>
>>>>>>             
>>>>> the
>>>>>
>>>>>           
>>>>>> table or the column cannot be found (and why it is not found)?
>>>>>>
>>>>>>     Thomas
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>>> Ok so I was trying to make our site a little safer from sql
>>>>>>>
>>>>>>>               
>>>>> injections,
>>>>>
>>>>>           
>>>>>>> so I made a database connection that connects with a user that
only
>>>>>>>
>>>>>>>               
>>>>> has
>>>>>
>>>>>           
>>>>>>> SELECT permissions. And edited Criteria like such
>>>>>>>
>>>>>>> public Criteria()
>>>>>>>     {
>>>>>>>         this(DEFAULT_CAPACITY);
>>>>>>>         this.setDbName("readonlydatabase");
>>>>>>>     }
>>>>>>>
>>>>>>> Now it seems to work for must things, but a couple queries fail
>>>>>>>               
>> with
>>     
>>>>>>> throws java.lang.Exception java.lang.NullPointerException
>>>>>>>     at org.apache.torque.util.SQLBuilder.processOrderBy
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>> (SQLBuilder.java:497)
>>>>>>
>>>>>>
>>>>>>             
>>>>>>>     at
>>>>>>>
>>>>>>>
>>>>>>>               
>> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
>>     
>>>>>>>     at
>>>>>>>               
>> org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>>     
>>>>>>> This error disappears as soon as I let the criteria use a database
>>>>>>> connection with write privileges.
>>>>>>> I know the user that it connects with has select privileges on
>>>>>>>               
>> every
>>     
>>>>>>> public table in the database.
>>>>>>>
>>>>>>> Does criteria need update privileges to work or something?
>>>>>>>
>>>>>>> The query the criteria constructs work fine when I connect as
the
>>>>>>> readonly user and run it manually.
>>>>>>>
>>>>>>> Any thoughts?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> --
>>>>>>> Sheldon Ross
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> -------------------------------------------------------------------
>>>>>>>               
>> --
>>     
>>>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>               
>>>>>> --------------------------------------------------------------------
>>>>>>             
>> -
>>     
>>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>> --
>>>>> Sheldon Ross
>>>>> Software Development
>>>>> American Simmental Association
>>>>> sross@simmgene.com
>>>>> (406)587-4531 ext 102
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>
>>>>>           
>>>> DukeCE Privacy Statement:
>>>> Please be advised that this e-mail and any files transmitted with
>>>> it are confidential communication or may otherwise be privileged or
>>>> confidential and are intended solely for the individual or entity
>>>> to whom they are addressed. If you are not the intended recipient
>>>> you may not rely on the contents of this email or any attachments,
>>>> and we ask that you please not read, copy or retransmit this
>>>> communication, but reply to the sender and destroy the email, its
>>>> contents, and all copies thereof immediately. Any unauthorized
>>>> dissemination, distribution or copying of this communication is
>>>> strictly prohibited.
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>
>>>>
>>>>
>>>>         
>> --
>> Sheldon Ross
>> Software Development
>> American Simmental Association
>> sross@simmgene.com
>> (406)587-4531 ext 102
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>     
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>   

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Criteria needs write permissions? Greg Monroe <Greg.Monroe@dukece.com> urn:uuid:%3c55B8568AFA5F144F886F18186BAD5B2C05FA44C765@durham-e2k7mb1-dukece-com%3e 2009-11-12T22:10:45Z 
OK, I think I understand what's going on here.  It's really a semi-bug
part but part a definitional issue.  This is because the term database 
name/dbname actually has two meaning in Torque.  

The first is the "schema database name", i.e. the name in your schema 
XML.  This is used to group all the database schema's Metadata in the
Database structure. 

The second meaning for this is the "database connection pool name".  This
is the name used in the runtime config to define the DB connection info.

Unfortunately, for historical reasons, these two names are "tied" 
together.  Mostly for convenience reasons... but there are a few cases 
in the utility classes where a subquery or something needs to be done
and the default DB name is used.

So, people get confused when it seems like you can't use the DB objects
with more than one database connection.  But that's not true.  To use
more than one connection pool, you need to use the methods that take a
connection object. 

To get an alternate connection, you define this in your runtime with 
a different name.  E.g. set up a different set of torque.dsfactory.
properties.

Then use the Torque.getConnection(String) to get a connection from this
pool. 

FWIW, I put forth a plan for Torque 4 to separate the connection pool
name from the schema name.  This would require objects and criteria
to track which pool they came from.
  

> -----Original Message-----
> From: Sheldon Ross [mailto:sross@simmgene.com]
> Sent: Thursday, November 12, 2009 4:28 PM
> To: Apache Torque Users List
> Subject: Re: Criteria needs write permissions?
> 
> Ok, I think this maybe a bug. After watching the addTable method in
> DatabaseMap, It appears to add the table to the default database dbMap
> even if the criteria is querying against a different database.
> 
> 
> Sheldon Ross wrote:
> > That would probably work, but It seems a little overkill. Do you know
> > where the lazy loading happens?
> > When I run with r/w connection, the dbmap tables hash does appear to
> > load that way.
> > However when I run the readonly connection, it just stays empty.
> >
> > Thanks
> >
> > Greg Monroe wrote:
> >> FWIW, the dbMap object get populated in a "lazy" manner by default.
> >> However,
> >> there is a way to force it to be fully loaded via a code call.  You
> >> do this by calling:
> >>
> >> org.apache.torque.linkage.DefaultMapInit.init();
> >>
> >> Not that this class actually exists in the generated classes and not
> >> in the Torque package.  This is because it provided a "known" class
> >> that "knows" (via extension) the "user settable" om package.
> >>
> >>
> >>> -----Original Message-----
> >>> From: Sheldon Ross [mailto:sross@simmgene.com]
> >>> Sent: Thursday, November 12, 2009 3:25 PM
> >>> To: Apache Torque Users List
> >>> Subject: Re: Criteria needs write permissions?
> >>>
> >>> The why is a good question, the table is not found. The tables
> hashmap
> >>> in the dbMap appears to be empty.
> >>> It of course is found when using the other db connection. It looks
> like
> >>> I'm gonna have to dig for awhile.
> >>>
> >>> Thanks.
> >>>
> >>> Thomas Fischer wrote:
> >>>
> >>>> The null ointer exception seems to come from reading the table or
> >>>>
> >>> column
> >>>
> >>>> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
> >>>>
> >>> the
> >>>
> >>>> table or the column cannot be found (and why it is not found)?
> >>>>
> >>>>     Thomas
> >>>>
> >>>>
> >>>>
> >>>>> Ok so I was trying to make our site a little safer from sql
> >>>>>
> >>> injections,
> >>>
> >>>>> so I made a database connection that connects with a user that only
> >>>>>
> >>> has
> >>>
> >>>>> SELECT permissions. And edited Criteria like such
> >>>>>
> >>>>> public Criteria()
> >>>>>     {
> >>>>>         this(DEFAULT_CAPACITY);
> >>>>>         this.setDbName("readonlydatabase");
> >>>>>     }
> >>>>>
> >>>>> Now it seems to work for must things, but a couple queries fail
> with
> >>>>>
> >>>>> throws java.lang.Exception java.lang.NullPointerException
> >>>>>     at org.apache.torque.util.SQLBuilder.processOrderBy
> >>>>>
> >>>>>
> >>>> (SQLBuilder.java:497)
> >>>>
> >>>>
> >>>>>     at
> >>>>>
> >>>>>
> >>>
> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
> >>>
> >>>>>     at
> org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
> >>>>>
> >>>>> This error disappears as soon as I let the criteria use a database
> >>>>> connection with write privileges.
> >>>>> I know the user that it connects with has select privileges on
> every
> >>>>> public table in the database.
> >>>>>
> >>>>> Does criteria need update privileges to work or something?
> >>>>>
> >>>>> The query the criteria constructs work fine when I connect as the
> >>>>> readonly user and run it manually.
> >>>>>
> >>>>> Any thoughts?
> >>>>>
> >>>>> Thanks
> >>>>>
> >>>>> --
> >>>>> Sheldon Ross
> >>>>>
> >>>>>
> >>>>>
> >>>>> -------------------------------------------------------------------
> --
> >>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>>>> For additional commands, e-mail: torque-user-help@db.apache.org
> >>>>>
> >>>>>
> >>>>>
> >>>> --------------------------------------------------------------------
> -
> >>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>>> For additional commands, e-mail: torque-user-help@db.apache.org
> >>>>
> >>>>
> >>>>
> >>>>
> >>> --
> >>> Sheldon Ross
> >>> Software Development
> >>> American Simmental Association
> >>> sross@simmgene.com
> >>> (406)587-4531 ext 102
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >>> For additional commands, e-mail: torque-user-help@db.apache.org
> >>>
> >>
> >> DukeCE Privacy Statement:
> >> Please be advised that this e-mail and any files transmitted with
> >> it are confidential communication or may otherwise be privileged or
> >> confidential and are intended solely for the individual or entity
> >> to whom they are addressed. If you are not the intended recipient
> >> you may not rely on the contents of this email or any attachments,
> >> and we ask that you please not read, copy or retransmit this
> >> communication, but reply to the sender and destroy the email, its
> >> contents, and all copies thereof immediately. Any unauthorized
> >> dissemination, distribution or copying of this communication is
> >> strictly prohibited.
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >> For additional commands, e-mail: torque-user-help@db.apache.org
> >>
> >>
> >>
> >
> 
> --
> Sheldon Ross
> Software Development
> American Simmental Association
> sross@simmgene.com
> (406)587-4531 ext 102
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFC8289-7020701@simmgene-com%3e 2009-11-12T21:47:53Z 
Ok, I apologize for the traffic.

Here goes, when you build the database objects, it hardcodes in the 
database name that exists in your schema.xml. The code is in the 
doBuild() method of the  ${Table}MapBuild.java

public void doBuild() throws TorqueException
    {
        dbMap = Torque.getDatabaseMap("defaultdb");

Therefore when you query against a different database, the table names 
never get added to the tables hash for that database.

I would consider this a bug as I don't think this would affect only me. 
Should I report it to the dev mailing list or something. Not sure of the 
etiquette there.

Anyway thanks all.

Sheldon Ross wrote:
> Ok, I think this maybe a bug. After watching the addTable method in 
> DatabaseMap, It appears to add the table to the default database dbMap 
> even if the criteria is querying against a different database.
>
>
> Sheldon Ross wrote:
>> That would probably work, but It seems a little overkill. Do you know 
>> where the lazy loading happens?
>> When I run with r/w connection, the dbmap tables hash does appear to 
>> load that way.
>> However when I run the readonly connection, it just stays empty.
>>
>> Thanks
>>
>> Greg Monroe wrote:
>>> FWIW, the dbMap object get populated in a "lazy" manner by default.  
>>> However,
>>> there is a way to force it to be fully loaded via a code call.  You 
>>> do this by calling:
>>>
>>> org.apache.torque.linkage.DefaultMapInit.init();
>>>
>>> Not that this class actually exists in the generated classes and not
>>> in the Torque package.  This is because it provided a "known" class
>>> that "knows" (via extension) the "user settable" om package.
>>>
>>>  
>>>> -----Original Message-----
>>>> From: Sheldon Ross [mailto:sross@simmgene.com]
>>>> Sent: Thursday, November 12, 2009 3:25 PM
>>>> To: Apache Torque Users List
>>>> Subject: Re: Criteria needs write permissions?
>>>>
>>>> The why is a good question, the table is not found. The tables hashmap
>>>> in the dbMap appears to be empty.
>>>> It of course is found when using the other db connection. It looks 
>>>> like
>>>> I'm gonna have to dig for awhile.
>>>>
>>>> Thanks.
>>>>
>>>> Thomas Fischer wrote:
>>>>   
>>>>> The null ointer exception seems to come from reading the table or
>>>>>       
>>>> column
>>>>   
>>>>> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
>>>>>       
>>>> the
>>>>   
>>>>> table or the column cannot be found (and why it is not found)?
>>>>>
>>>>>     Thomas
>>>>>
>>>>>
>>>>>     
>>>>>> Ok so I was trying to make our site a little safer from sql
>>>>>>         
>>>> injections,
>>>>   
>>>>>> so I made a database connection that connects with a user that only
>>>>>>         
>>>> has
>>>>   
>>>>>> SELECT permissions. And edited Criteria like such
>>>>>>
>>>>>> public Criteria()
>>>>>>     {
>>>>>>         this(DEFAULT_CAPACITY);
>>>>>>         this.setDbName("readonlydatabase");
>>>>>>     }
>>>>>>
>>>>>> Now it seems to work for must things, but a couple queries fail with
>>>>>>
>>>>>> throws java.lang.Exception java.lang.NullPointerException
>>>>>>     at org.apache.torque.util.SQLBuilder.processOrderBy
>>>>>>
>>>>>>         
>>>>> (SQLBuilder.java:497)
>>>>>
>>>>>     
>>>>>>     at
>>>>>>
>>>>>>         
>>>> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302) 
>>>>
>>>>   
>>>>>>     at 
>>>>>> org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>>>>>>
>>>>>> This error disappears as soon as I let the criteria use a database
>>>>>> connection with write privileges.
>>>>>> I know the user that it connects with has select privileges on every
>>>>>> public table in the database.
>>>>>>
>>>>>> Does criteria need update privileges to work or something?
>>>>>>
>>>>>> The query the criteria constructs work fine when I connect as the
>>>>>> readonly user and run it manually.
>>>>>>
>>>>>> Any thoughts?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> -- 
>>>>>> Sheldon Ross
>>>>>>
>>>>>>
>>>>>>
>>>>>> ---------------------------------------------------------------------

>>>>>>
>>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>>
>>>>>>
>>>>>>         
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>
>>>>>
>>>>>
>>>>>       
>>>> -- 
>>>> Sheldon Ross
>>>> Software Development
>>>> American Simmental Association
>>>> sross@simmgene.com
>>>> (406)587-4531 ext 102
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>     
>>>
>>> DukeCE Privacy Statement:
>>> Please be advised that this e-mail and any files transmitted with
>>> it are confidential communication or may otherwise be privileged or
>>> confidential and are intended solely for the individual or entity
>>> to whom they are addressed. If you are not the intended recipient
>>> you may not rely on the contents of this email or any attachments,
>>> and we ask that you please not read, copy or retransmit this
>>> communication, but reply to the sender and destroy the email, its
>>> contents, and all copies thereof immediately. Any unauthorized
>>> dissemination, distribution or copying of this communication is
>>> strictly prohibited.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>>
>>>   
>>
>

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFC7DF1-6050806@simmgene-com%3e 2009-11-12T21:28:17Z 
Ok, I think this maybe a bug. After watching the addTable method in 
DatabaseMap, It appears to add the table to the default database dbMap 
even if the criteria is querying against a different database.


Sheldon Ross wrote:
> That would probably work, but It seems a little overkill. Do you know 
> where the lazy loading happens?
> When I run with r/w connection, the dbmap tables hash does appear to 
> load that way.
> However when I run the readonly connection, it just stays empty.
>
> Thanks
>
> Greg Monroe wrote:
>> FWIW, the dbMap object get populated in a "lazy" manner by default.  
>> However,
>> there is a way to force it to be fully loaded via a code call.  You 
>> do this by calling:
>>
>> org.apache.torque.linkage.DefaultMapInit.init();
>>
>> Not that this class actually exists in the generated classes and not
>> in the Torque package.  This is because it provided a "known" class
>> that "knows" (via extension) the "user settable" om package.
>>
>>  
>>> -----Original Message-----
>>> From: Sheldon Ross [mailto:sross@simmgene.com]
>>> Sent: Thursday, November 12, 2009 3:25 PM
>>> To: Apache Torque Users List
>>> Subject: Re: Criteria needs write permissions?
>>>
>>> The why is a good question, the table is not found. The tables hashmap
>>> in the dbMap appears to be empty.
>>> It of course is found when using the other db connection. It looks like
>>> I'm gonna have to dig for awhile.
>>>
>>> Thanks.
>>>
>>> Thomas Fischer wrote:
>>>    
>>>> The null ointer exception seems to come from reading the table or
>>>>       
>>> column
>>>    
>>>> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
>>>>       
>>> the
>>>    
>>>> table or the column cannot be found (and why it is not found)?
>>>>
>>>>     Thomas
>>>>
>>>>
>>>>      
>>>>> Ok so I was trying to make our site a little safer from sql
>>>>>         
>>> injections,
>>>    
>>>>> so I made a database connection that connects with a user that only
>>>>>         
>>> has
>>>    
>>>>> SELECT permissions. And edited Criteria like such
>>>>>
>>>>> public Criteria()
>>>>>     {
>>>>>         this(DEFAULT_CAPACITY);
>>>>>         this.setDbName("readonlydatabase");
>>>>>     }
>>>>>
>>>>> Now it seems to work for must things, but a couple queries fail with
>>>>>
>>>>> throws java.lang.Exception java.lang.NullPointerException
>>>>>     at org.apache.torque.util.SQLBuilder.processOrderBy
>>>>>
>>>>>         
>>>> (SQLBuilder.java:497)
>>>>
>>>>      
>>>>>     at
>>>>>
>>>>>         
>>> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
>>>    
>>>>>     at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>>>>>
>>>>> This error disappears as soon as I let the criteria use a database
>>>>> connection with write privileges.
>>>>> I know the user that it connects with has select privileges on every
>>>>> public table in the database.
>>>>>
>>>>> Does criteria need update privileges to work or something?
>>>>>
>>>>> The query the criteria constructs work fine when I connect as the
>>>>> readonly user and run it manually.
>>>>>
>>>>> Any thoughts?
>>>>>
>>>>> Thanks
>>>>>
>>>>> -- 
>>>>> Sheldon Ross
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>>
>>>>>
>>>>>         
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>
>>>>
>>>>
>>>>       
>>> -- 
>>> Sheldon Ross
>>> Software Development
>>> American Simmental Association
>>> sross@simmgene.com
>>> (406)587-4531 ext 102
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>     
>>
>> DukeCE Privacy Statement:
>> Please be advised that this e-mail and any files transmitted with
>> it are confidential communication or may otherwise be privileged or
>> confidential and are intended solely for the individual or entity
>> to whom they are addressed. If you are not the intended recipient
>> you may not rely on the contents of this email or any attachments,
>> and we ask that you please not read, copy or retransmit this
>> communication, but reply to the sender and destroy the email, its
>> contents, and all copies thereof immediately. Any unauthorized
>> dissemination, distribution or copying of this communication is
>> strictly prohibited.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>   
>

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFC7C2A-5070102@simmgene-com%3e 2009-11-12T21:20:42Z 
That would probably work, but It seems a little overkill. Do you know 
where the lazy loading happens?
When I run with r/w connection, the dbmap tables hash does appear to 
load that way.
However when I run the readonly connection, it just stays empty.

Thanks

Greg Monroe wrote:
> FWIW, the dbMap object get populated in a "lazy" manner by default.  However,
> there is a way to force it to be fully loaded via a code call.  You 
> do this by calling:
>
> org.apache.torque.linkage.DefaultMapInit.init();
>
> Not that this class actually exists in the generated classes and not
> in the Torque package.  This is because it provided a "known" class
> that "knows" (via extension) the "user settable" om package.
>
>   
>> -----Original Message-----
>> From: Sheldon Ross [mailto:sross@simmgene.com]
>> Sent: Thursday, November 12, 2009 3:25 PM
>> To: Apache Torque Users List
>> Subject: Re: Criteria needs write permissions?
>>
>> The why is a good question, the table is not found. The tables hashmap
>> in the dbMap appears to be empty.
>> It of course is found when using the other db connection. It looks like
>> I'm gonna have to dig for awhile.
>>
>> Thanks.
>>
>> Thomas Fischer wrote:
>>     
>>> The null ointer exception seems to come from reading the table or
>>>       
>> column
>>     
>>> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
>>>       
>> the
>>     
>>> table or the column cannot be found (and why it is not found)?
>>>
>>>     Thomas
>>>
>>>
>>>       
>>>> Ok so I was trying to make our site a little safer from sql
>>>>         
>> injections,
>>     
>>>> so I made a database connection that connects with a user that only
>>>>         
>> has
>>     
>>>> SELECT permissions. And edited Criteria like such
>>>>
>>>> public Criteria()
>>>>     {
>>>>         this(DEFAULT_CAPACITY);
>>>>         this.setDbName("readonlydatabase");
>>>>     }
>>>>
>>>> Now it seems to work for must things, but a couple queries fail with
>>>>
>>>> throws java.lang.Exception java.lang.NullPointerException
>>>>     at org.apache.torque.util.SQLBuilder.processOrderBy
>>>>
>>>>         
>>> (SQLBuilder.java:497)
>>>
>>>       
>>>>     at
>>>>
>>>>         
>> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
>>     
>>>>     at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>>>>
>>>> This error disappears as soon as I let the criteria use a database
>>>> connection with write privileges.
>>>> I know the user that it connects with has select privileges on every
>>>> public table in the database.
>>>>
>>>> Does criteria need update privileges to work or something?
>>>>
>>>> The query the criteria constructs work fine when I connect as the
>>>> readonly user and run it manually.
>>>>
>>>> Any thoughts?
>>>>
>>>> Thanks
>>>>
>>>> --
>>>> Sheldon Ross
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>
>>>>
>>>>         
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>>
>>>
>>>       
>> --
>> Sheldon Ross
>> Software Development
>> American Simmental Association
>> sross@simmgene.com
>> (406)587-4531 ext 102
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>     
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>   

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Criteria needs write permissions? Greg Monroe <Greg.Monroe@dukece.com> urn:uuid:%3c55B8568AFA5F144F886F18186BAD5B2C05FA44C764@durham-e2k7mb1-dukece-com%3e 2009-11-12T21:10:43Z 
FWIW, the dbMap object get populated in a "lazy" manner by default.  However,
there is a way to force it to be fully loaded via a code call.  You 
do this by calling:

org.apache.torque.linkage.DefaultMapInit.init();

Not that this class actually exists in the generated classes and not
in the Torque package.  This is because it provided a "known" class
that "knows" (via extension) the "user settable" om package.

> -----Original Message-----
> From: Sheldon Ross [mailto:sross@simmgene.com]
> Sent: Thursday, November 12, 2009 3:25 PM
> To: Apache Torque Users List
> Subject: Re: Criteria needs write permissions?
> 
> The why is a good question, the table is not found. The tables hashmap
> in the dbMap appears to be empty.
> It of course is found when using the other db connection. It looks like
> I'm gonna have to dig for awhile.
> 
> Thanks.
> 
> Thomas Fischer wrote:
> > The null ointer exception seems to come from reading the table or
> column
> > map. Can you put a breakpoint in SQLBuilder.java:497 and see whether
> the
> > table or the column cannot be found (and why it is not found)?
> >
> >     Thomas
> >
> >
> >> Ok so I was trying to make our site a little safer from sql
> injections,
> >> so I made a database connection that connects with a user that only
> has
> >> SELECT permissions. And edited Criteria like such
> >>
> >> public Criteria()
> >>     {
> >>         this(DEFAULT_CAPACITY);
> >>         this.setDbName("readonlydatabase");
> >>     }
> >>
> >> Now it seems to work for must things, but a couple queries fail with
> >>
> >> throws java.lang.Exception java.lang.NullPointerException
> >>     at org.apache.torque.util.SQLBuilder.processOrderBy
> >>
> > (SQLBuilder.java:497)
> >
> >>     at
> >>
> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
> >>     at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
> >>
> >> This error disappears as soon as I let the criteria use a database
> >> connection with write privileges.
> >> I know the user that it connects with has select privileges on every
> >> public table in the database.
> >>
> >> Does criteria need update privileges to work or something?
> >>
> >> The query the criteria constructs work fine when I connect as the
> >> readonly user and run it manually.
> >>
> >> Any thoughts?
> >>
> >> Thanks
> >>
> >> --
> >> Sheldon Ross
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> >> For additional commands, e-mail: torque-user-help@db.apache.org
> >>
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> >
> >
> 
> --
> Sheldon Ross
> Software Development
> American Simmental Association
> sross@simmgene.com
> (406)587-4531 ext 102
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFC6F14-4070807@simmgene-com%3e 2009-11-12T20:24:52Z 
The why is a good question, the table is not found. The tables hashmap 
in the dbMap appears to be empty.
It of course is found when using the other db connection. It looks like 
I'm gonna have to dig for awhile.

Thanks.

Thomas Fischer wrote:
> The null ointer exception seems to come from reading the table or column
> map. Can you put a breakpoint in SQLBuilder.java:497 and see whether the
> table or the column cannot be found (and why it is not found)?
>
>     Thomas
>
>   
>> Ok so I was trying to make our site a little safer from sql injections,
>> so I made a database connection that connects with a user that only has
>> SELECT permissions. And edited Criteria like such
>>
>> public Criteria()
>>     {
>>         this(DEFAULT_CAPACITY);
>>         this.setDbName("readonlydatabase");
>>     }
>>
>> Now it seems to work for must things, but a couple queries fail with
>>
>> throws java.lang.Exception java.lang.NullPointerException
>>     at org.apache.torque.util.SQLBuilder.processOrderBy
>>     
> (SQLBuilder.java:497)
>   
>>     at
>> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
>>     at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>>
>> This error disappears as soon as I let the criteria use a database
>> connection with write privileges.
>> I know the user that it connects with has select privileges on every
>> public table in the database.
>>
>> Does criteria need update privileges to work or something?
>>
>> The query the criteria constructs work fine when I connect as the
>> readonly user and run it manually.
>>
>> Any thoughts?
>>
>> Thanks
>>
>> --
>> Sheldon Ross
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>     
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>   

-- 
Sheldon Ross
Software Development
American Simmental Association
sross@simmgene.com
(406)587-4531 ext 102 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Postgresql table aliases Andrea Bertucci <abertucci@aitek.it> urn:uuid:%3c4AFC39BD-6070005@aitek-it%3e 2009-11-12T16:37:17Z 
Greg Monroe wrote:
> I also wonder if this isn't a PostGres version issue.  If I remember the 
> SQL standards correctly, the query that PostGres is choking on is perfectly
> valid SQL.  PostGres, like MySQL and the like, have all been working to 
> follow the SQL Standard more closely.  This could be a standards bug in
> your version of PostGres.
>   
Thank you!
Few minutes ago I understand that the problem was a mistake in my code.

In some cases I'm composing the update query using column names defined 
in OM Peer (for some reason I can't use Criteria) and execute query with
executeStatement function.
In this classes, automatically generated by torque using my schema 
definition, each column has a prefix
that is table name. This has generated the query error, because I obtain 
query of the form:
update a set a.b=c
that it's not a right syntax for postgres

I correct the problem deleting table prefix in the query generated by hand.

Andrea.

-- 

Andrea Bertucci
Aitek S.p.A. - Via della Crocetta, 15 - I-16122 Genova
tel.: +39 010 846731 
fax: +39 010 8467350 - e-mail: abertucci@aitek.it

---
Questo  messaggio di posta elettronica e gli allegati sono riservati e destinati esclusivamente
alle persone cui sono indirizzati. Se avete ricevuto questo messaggio per errore, Vi preghiamo
di rispedirlo al mittente o cancellarlo dal Vostro sistema. La pubblicazione, l'uso, la diffusione,
l'inoltro, la stampa o la copia non autorizzati di questo messaggio e degli allegati sono
vietati.

This e-mail and any files transmitted with it are confidential and intended solely for the
use of the individual to whom it is addressed. If you have received this email in error please
send it back. Unauthorized publication, use, disclosure, forwarding, printing or copying of
this email and its associated attachments is strictly prohibited.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Postgresql table aliases Thomas Fischer <fischer@seitenbau.net> urn:uuid:%3cOF3183BB46-6C5B4B31-ONC125766C-00541670-C125766C-00544934@seitenbau-net%3e 2009-11-12T15:20:36Z 
> I also wonder if this isn't a PostGres version issue.  If I remember the
> SQL standards correctly, the query that PostGres is choking on is
perfectly
> valid SQL.  PostGres, like MySQL and the like, have all been working to
> follow the SQL Standard more closely.  This could be a standards bug in
> your version of PostGres.

I checked that postgres 8.4 indeed chokes on updates with fully qualified
column names. Dunno about earlier versions.

> > ...
> > > ...
> > > Now I'm trying to migrate everything for Postgresql but the main
> > problem
> > > is that when
> > > I execute an UPDATE query I receive an error from torque, because the
> > > update query automatically
> > > generated are of the form
> > >     update a set a.b = c;
> > > that in PostgreSQL it's an error because table name can't be a prefix
> > > for a column in set statement.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Postgresql table aliases Greg Monroe <Greg.Monroe@dukece.com> urn:uuid:%3c55B8568AFA5F144F886F18186BAD5B2C05FA44C760@durham-e2k7mb1-dukece-com%3e 2009-11-12T14:55:31Z 
I also wonder if this isn't a PostGres version issue.  If I remember the 
SQL standards correctly, the query that PostGres is choking on is perfectly
valid SQL.  PostGres, like MySQL and the like, have all been working to 
follow the SQL Standard more closely.  This could be a standards bug in
your version of PostGres.

> -----Original Message-----
> From: Thomas Fischer [mailto:fischer@seitenbau.net]
> Sent: Thursday, November 12, 2009 3:22 AM
> To: Apache Torque Users List
> Subject: RE: Postgresql table aliases
> 
> I cannot reproduce this. When I run the DataTest.testUpdate in the test
> project I see the following update statement in the save() method of an
> updated author:
> 
> UPDATE author SET name = ? WHERE author_id = ?
> 
> Could you provide more detail how the update clause is produced ?
> 
>    Thomas
> 
> > ...
> > Now I'm trying to migrate everything for Postgresql but the main
> problem
> > is that when
> > I execute an UPDATE query I receive an error from torque, because the
> > update query automatically
> > generated are of the form
> >     update a set a.b = c;
> > that in PostgreSQL it's an error because table name can't be a prefix
> > for a column in set statement.
> >
> > Do you know how it's possible to say torque to avoid column prefix in
> > this case?
> >
> > Thanks in advance,
> > Andrea.
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Postgresql table aliases Thomas Fischer <fischer@seitenbau.net> urn:uuid:%3cOFFB150BDC-ED9A30A5-ONC125766C-002DC356-C125766C-002DF9BC@seitenbau-net%3e 2009-11-12T08:22:09Z 
I cannot reproduce this. When I run the DataTest.testUpdate in the test
project I see the following update statement in the save() method of an
updated author:

UPDATE author SET name = ? WHERE author_id = ?

Could you provide more detail how the update clause is produced ?

   Thomas

> ...
> Now I'm trying to migrate everything for Postgresql but the main problem
> is that when
> I execute an UPDATE query I receive an error from torque, because the
> update query automatically
> generated are of the form
>     update a set a.b = c;
> that in PostgreSQL it's an error because table name can't be a prefix
> for a column in set statement.
>
> Do you know how it's possible to say torque to avoid column prefix in
> this case?
>
> Thanks in advance,
> Andrea.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Criteria needs write permissions? Thomas Fischer <fischer@seitenbau.net> urn:uuid:%3cOF22405C1D-22F7FA12-ONC125766C-0025E21A-C125766C-0026553F@seitenbau-net%3e 2009-11-12T06:58:41Z 
The null ointer exception seems to come from reading the table or column
map. Can you put a breakpoint in SQLBuilder.java:497 and see whether the
table or the column cannot be found (and why it is not found)?

    Thomas

> Ok so I was trying to make our site a little safer from sql injections,
> so I made a database connection that connects with a user that only has
> SELECT permissions. And edited Criteria like such
>
> public Criteria()
>     {
>         this(DEFAULT_CAPACITY);
>         this.setDbName("readonlydatabase");
>     }
>
> Now it seems to work for must things, but a couple queries fail with
>
> throws java.lang.Exception java.lang.NullPointerException
>     at org.apache.torque.util.SQLBuilder.processOrderBy
(SQLBuilder.java:497)
>     at
> org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
>     at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)
>
> This error disappears as soon as I let the criteria use a database
> connection with write privileges.
> I know the user that it connects with has select privileges on every
> public table in the database.
>
> Does criteria need update privileges to work or something?
>
> The query the criteria constructs work fine when I connect as the
> readonly user and run it manually.
>
> Any thoughts?
>
> Thanks
>
> --
> Sheldon Ross
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Criteria needs write permissions? Sheldon Ross <sross@simmgene.com> urn:uuid:%3c4AFB4EC8-4040005@simmgene-com%3e 2009-11-11T23:54:48Z 
Ok so I was trying to make our site a little safer from sql injections, 
so I made a database connection that connects with a user that only has 
SELECT permissions. And edited Criteria like such

public Criteria()
    {
        this(DEFAULT_CAPACITY);
        this.setDbName("readonlydatabase");
    }

Now it seems to work for must things, but a couple queries fail with

throws java.lang.Exception java.lang.NullPointerException
    at org.apache.torque.util.SQLBuilder.processOrderBy(SQLBuilder.java:497)
    at 
org.apache.torque.util.SQLBuilder.buildQueryClause(SQLBuilder.java:302)
    at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:730)

This error disappears as soon as I let the criteria use a database 
connection with write privileges.
I know the user that it connects with has select privileges on every 
public table in the database.

Does criteria need update privileges to work or something?

The query the criteria constructs work fine when I connect as the 
readonly user and run it manually.

Any thoughts?

Thanks

-- 
Sheldon Ross



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: [torrque-maven-plugin] Colliding parameters for different goals. "Ludwig Magnusson" <ludwig@itcatapult.com> urn:uuid:%3c003d01ca62f6$f1cbc2a0$d56347e0$@com%3e 2009-11-11T17:46:48Z 
Thank you for the link.
It cleared up a lot for me.
The project now works as I want.
/Ludwig

-----Original Message-----
From: Thomas Fischer [mailto:fischer@seitenbau.net] 
Sent: den 10 november 2009 11:40
To: Apache Torque Users List
Subject: RE: [torrque-maven-plugin] Colliding parameters for different
goals.

Oops- sorry. My example was wrong, did not look careful enough. These tags
were meant to be <id />tags. The phase should be generate-sources. So it
should read:

           <execution>
             <id>generate-om</id>
             <phase>generate-sources</id>
             <goals>
               <goal>om</goal>
               <goal>sql</goal>
             </goals>
           </execution>

and the same for the following execution definitions.

There are more phases than you think. See the list at the bottom of
http://maven.apache.org/guides/introduction/introduction-to-the-lifecycle.ht
ml
for the available phases.

    Thomas

> RE: [torrque-maven-plugin] Colliding parameters for different goals.
>
> Then I was mislead by the maven documentation.
> I thought the only valid values for <phase/> were clean, compile, test,
> build, install, verify.
>
> But the phases generate-om and generate-sql are defined in torque?
> Are there any documentation on what phases there are in torque?
> I can't find it on the plugin page.
> /Ludwig
>
>
> -----Original Message-----
> From: Thomas Fischer [mailto:fischer@seitenbau.net]
> Sent: den 10 november 2009 11:06
> To: Apache Torque Users List
> Subject: RE: [torrque-maven-plugin] Colliding parameters for different
> goals.
>
> > I have encountered a problem running the M2 plugin for torque. The
goals
> I
> > run are basically om, sql and sqlExec. There are a lot of parameters
that
> > can be specified for these goals so I do it in my projects pom.xml.
> However,
> > all these three goals have some parameters that have the same name, e.g
> the
> > outputDir parameter. For om, I want this to point to my source
directory,
> > for sql I want another directory where the sql-file will be generated.
> But
> > Maven2 is limited here and it is not possible to map different values
for
> > the same parameter to different goals.
>
> This is not true. You need to define more than one execution.
> In principle, you have the following options:
>
> 1) use the same configuration for all goals (this is what you currently
do)
>       <plugin>
>         <groupId>org.apache.torque</groupId>
>         <artifactId>torque-maven-plugin</artifactId>
>         <version>3.3</version>
>         <configuration>
>           ...
>         </configuration>
>         <executions>
>           <execution>
>             <phase>generate-om</phase>
>             <goals>
>               <goal>om</goal>
>               <goal>sql</goal>
>             </goals>
>           </execution>
>         </executions>
>       </plugin>
> 2) define different executions, and define the complete configuration for
> each execution
>       <plugin>
>         <groupId>org.apache.torque</groupId>
>         <artifactId>torque-maven-plugin</artifactId>
>         <version>3.3</version>
>         <executions>
>           <execution>
>             <phase>generate-om</phase>
>             <goals>
>               <goal>om</goal>
>             </goals>
>             <configuration>
>               ...
>             </configuration>
>           </execution>
>           <execution>
>             <phase>generate-sql</phase>
>             <goals>
>               <goal>sql</goal>
>             </goals>
>             <configuration>
>               ...
>             </configuration>
>           </execution>
>         </executions>
>       </plugin>
> The following does not work:
> 3) Define some parameters for all executions and some for a specific
> execution
>       <plugin>
>         <groupId>org.apache.torque</groupId>
>         <artifactId>torque-maven-plugin</artifactId>
>         <version>3.3</version>
>         <configuration>
>           ...
>         </configuration>
>         <executions>
>           <execution>
>             <phase>generate-om</phase>
>             <goals>
>               <goal>om</goal>
>             </goals>
>             <configuration>
>               ...
>             </configuration>
>           </execution>
>           <execution>
>             <phase>generate-sql</phase>
>             <goals>
>               <goal>sql</goal>
>             </goals>
>             <configuration>
>               ...
>             </configuration>
>           </execution>
>         </executions>
>       </plugin>
>
> As 1) does not meet your requiremets your only option is 2)
>
>    Thomas
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: [Torque] Using Torque again Angela Day <akcday@yahoo.com> urn:uuid:%3c493183-94495-qm@web33305-mail-mud-yahoo-com%3e 2009-11-10T21:23:10Z 
That was it.  The previous developer has some custom vm files out there that are choking. 
I replaced them with the files from the templates jar and it builds successfully.  Now the
only problem is figuring out what he did that was custom and integrating it into the new environment.
 He had it doing flips and creating custom form classes and om classes with extra methods.
 I have my work cut out for me.

Thanks for all of your help,

 
Angela Day
National Autism Association of Central Texas

http://www.naacentraltexas.org
formally FEAT Austin





________________________________
From: Thomas Vandahl <tv@apache.org>
To: torque-user@db.apache.org
Sent: Tue, November 10, 2009 2:51:43 PM
Subject: Re: [Torque] Using Torque again

On 10.11.09 20:52, Angela Day wrote:
> Here is my default.properties file.  my build.properties file is empty.  The problem
seems to be referencing from the vm files that generate the om files.  Has there been an update
to those vm files for 3.3?  There is very little documentation on velocity that I can gleen
anything from.

Absolutely. Actually, there is not much left from the original template
files from 3.2 to 3.3, let alone 1.0.

> project = cdb
> database = oracle
> targetPackage = org.apache.torque
> 
> torque.project = ${project}
> torque.database = ${database}
> torque.targetPackage = ${targetPackage}
> torque.runOnlyOnSchemaChange = false

The file looks mostly OK to me.

> outputDirectory = src
> schemaDirectory = conf
> templatePath = templates
> useClasspath = true
> 
> torque.output.dir = ${torque.home}/${outputDirectory}
> torque.schema.dir = ${torque.home}/${schemaDirectory}
> torque.templatePath = ${templatePath}
> torque.useClasspath = ${useClasspath}

I'd probably put the templatePath out of the way. You should be fine
with the current templates from the JAR.

> torque.saveJavaName = ${sameJavaName}

This looks like a typo. But it could most probably not cause the
problems you are experiencing.

> overloadKeySetters = true
Dunno this one.

> useClasspath = false
[...]
> torque.useClasspath = ${useClasspath}

This is a dangerous duplication. You set this before further up and
overwrite it here with false. This might be your sole problem.

> # -------------------------------------------------------------------
> #
> #  C O N T R O L   T E M P L A T E S
> #
> # -------------------------------------------------------------------
> 
> SQLControlTemplate = sql/base/Control.vm
> OMControlTemplate = om/Control.vm
> idTableControlTemplate = sql/id-table/Control.vm
> DataDTDControlTemplate = data/Control.vm
> DataDumpControlTemplate = data/dump/Control.vm
> DataSQLControlTemplate = sql/load/Control.vm
> DocControlTemplate = doc/Control.vm
> 
> torque.template.sql = ${SQLControlTemplate}
> torque.template.om = ${OMControlTemplate}
> torque.template.idTable = ${idTableControlTemplate}
> torque.template.dataDtd = ${DataDTDControlTemplate}
> torque.template.dataDump = ${DataDumpControlTemplate}
> torque.template.dataSql = ${DataSQLControlTemplate}
> torque.template.doc = ${DocControlTemplate}
> torque.template.sqlDbInit = sql/db-init/Control.vm
> torque.template.ojb = ojb/repository/Control.vm
> torque.template.ojbModel = ojb/model/Control.vm

I don't think this is supported anymore.

Bye, Thomas

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org