Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=BxOwdRJhRHSg+wiYhHHdHdu+ogApj+3Q6aw4I7P8D6dwZ4I1d/l0vVlXXQzjMQmEbePIY7z3pnyRuPwr09sW8uin+19pBAdk1phnOAjJA4in0V3NqxZP/KnZJA/Ski3zWjanQ+iPhKweYc5+1gFEmCS1k98ATS6eARSoZIaZ7FU=;
Message-ID: <53771.1348.qm@web50801.mail.re2.yahoo.com>
References: <343031.28420.qm@web33307.mail.mud.yahoo.com>
  <55B8568AFA5F144F886F18186BAD5B2C05FA44C74F@durham-e2k7mb1.dukece.com>
  <926835.65373.qm@web33301.mail.mud.yahoo.com>  <4AF9C153.9080507@apache.org>
  <127653.99752.qm@web33301.mail.mud.yahoo.com>  <4AF9D25F.8090200@apache.org>
  <493183.94495.qm@web33305.mail.mud.yahoo.com>
  <755835.25575.qm@web33308.mail.mud.yahoo.com>
  <9161C81B-47A4-40EB-BF28-2527B7CB48E4@gmail.com>
  <905025.48588.qm@web33308.mail.mud.yahoo.com>
 <4d036f890912021338j4b69307fifccf511664e9ca44@mail.gmail.com>
 <2623.68374.qm@web33304.mail.mud.yahoo.com>
Date: Wed, 2 Dec 2009 14:56:31 -0800 (PST)
From: Alvaro Coronel <alvarocoronel67@yahoo.com>
Subject: Re: no suitable driver
To: Apache Torque Users List <torque-user@db.apache.org>
In-Reply-To: <2623.68374.qm@web33304.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-76238176-1259794591=:1348"

--0-76238176-1259794591=:1348
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Angela, how about trying with other database/driver just to check your conf=
ig?=0A=0AI have had "ClassNotFoundException" when a .jar was _twice_ in the=
 classpath. You might want to check that too.=0A=0ATroubleshooting this kin=
d of error is like trying to hit a "Pi=F1ata", isn't it? Good luck!=0A=0A=
=C1lvaro Coronel.=0A=0A=0A=0A________________________________=0AFrom: Angel=
a Day <akcday@yahoo.com>=0ATo: Apache Torque Users List <torque-user@db.apa=
che.org>=0ASent: Wed, December 2, 2009 8:05:09 PM=0ASubject: Re: no suitabl=
e driver=0A=0AYes, 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 sam=
e error.=0A =0AAngela Day=0ANational Autism Association of Central Texas=0A=
=0Ahttp://www.naacentraltexas.org=0Aformally FEAT Austin=0A=0A=0A=0A=0A=0A_=
_______________________________=0AFrom: "wzhao6898@gmail.com" <wzhao6898@gm=
ail.com>=0ATo: Apache Torque Users List <torque-user@db.apache.org>=0ASent:=
 Wed, December 2, 2009 3:38:58 PM=0ASubject: Re: no suitable driver=0A=0ATh=
ere may have been many syntax changes in Torque 3.3 from Torque 1.0, you=0A=
may want to look into this.=0AI think you need to specify database server a=
nd user/password information in=0Athe "build.properties" file (at least in =
our set up).=0ATry to download the torque-3.3-gen package, and run a ant -f=
=0Abuild-torque.xml jdbc or something similar with you existing=0Abuild.pro=
perties file in the same directory to see if you can get this task=0Ato run=
 successfully (ant -f build-torque.xml jdbc generates the schema.xml=0Afrom=
 your database).=0AGood luck,=0A=0ADavid=0A=0AOn Wed, Dec 2, 2009 at 1:15 P=
M, Angela Day <akcday@yahoo.com> wrote:=0A=0A> It is an existing database a=
nd application that I am upgrading from Torque=0A> 1.0 and JDK1.4, so I am =
pretty sure the database is setup right.  Do you=0A> have something in mind=
?=0A>=0A> Thanks,=0A>=0A> Angela Day=0A> National Autism Association of Cen=
tral Texas=0A>=0A> http://www.naacentraltexas.org=0A> formally FEAT Austin=
=0A>=0A>=0A>=0A>=0A>=0A> ________________________________=0A> From: Wei Zha=
o <weizhao6898@gmail.com>=0A> To: Apache Torque Users List <torque-user@db.=
apache.org>=0A> Sent: Wed, December 2, 2009 2:49:49 PM=0A> Subject: Re: no =
suitable driver=0A>=0A> What about your build.properties file? I'd try to d=
o a " ant -f=0A> build-torque.XML jdbc" or some other ant task tomake sure =
the database is=0A> set up right.=0A>=0A> David=0A>=0A> On Dec 2, 2009, at =
12:33 PM, Angela Day <akcday@yahoo.com> wrote:=0A>=0A> > I am going crazy w=
ith a problem I have had for a few days now.  It seems=0A> so simple, but I=
 cannot solve the problem.  Any help would be appreciated. I=0A> have ojdbc=
14.jar in the classpath for the env variable path and in the=0A> build-torq=
ue.xml file.  I am using java 1.5 and torque 3.3 and eclipse 3.5.1=0A> and =
velocity 1.5=0A> >=0A> > Dec 2, 2009 2:02:45 PM org.apache.coyote.http11.Ht=
tp11Protocol init=0A> > INFO: Initializing Coyote HTTP/1.1 on http-8080=0A>=
 > Dec 2, 2009 2:02:45 PM org.apache.catalina.startup.Catalina load=0A> > I=
NFO: Initialization processed in 1960 ms=0A> > Dec 2, 2009 2:02:45 PM org.a=
pache.catalina.core.StandardService start=0A> > INFO: Starting service Cata=
lina=0A> > Dec 2, 2009 2:02:45 PM org.apache.catalina.core.StandardEngine s=
tart=0A> > INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009 2=
:02:47 PM=0A> org.apache.catalina.core.StandardContext loadOnStartup=0A> > =
SEVERE: Servlet /alligator threw load() exceptionjava.sql.SQLException=0A> =
> at java.sql.DriverManager.getDriver(Unknown Source)=0A> > at org.apache.t=
omcat.dbcp.dbcp.BasicDataSource.createDataSource(=0A> > at org.apache.tomca=
t.dbcp.dbcp.BasicDataSource.getConnection(=0A> > at org.apache.torque.Torqu=
eInstance.getConnection(=0A> > at org.apache.torque.TorqueInstance.getConne=
ction(=0A> > at org.apache.torque.Torque.getConnection(=0A> > at tdhca.torq=
ue.CurrentConnection.getConnection(=0A> > at tdhca.maverick.Dispatcher.init=
Torque(=0A> > at tdhca.maverick.Dispatcher.init(=0A> > at javax.servlet.Gen=
ericServlet.init(=0A> > at org.apache.catalina.core.StandardWrapper.loadSer=
vlet(=0A> > at org.apache.catalina.core.StandardWrapper.load(=0A> > at org.=
apache.catalina.core.StandardContext.loadOnStartup(=0A> > at org.apache.cat=
alina.core.StandardContext.start(=0A> > at org.apache.catalina.core.Contain=
erBase.start(=0A> > at org.apache.catalina.core.StandardHost.start(=0A> > a=
t org.apache.catalina.core.ContainerBase.start(=0A> > at org.apache.catalin=
a.core.StandardEngine.start(=0A> > at org.apache.catalina.core.StandardServ=
ice.start(=0A> > at org.apache.catalina.core.StandardServer.start(=0A> > at=
 org.apache.catalina.startup.Catalina.start(=0A> > at sun.reflect.NativeMet=
hodAccessorImpl.invoke0(=0A> > at sun.reflect.NativeMethodAccessorImpl.invo=
ke(Unknown Source)=0A> > at sun.reflect.DelegatingMethodAccessorImpl.invoke=
(Unknown Source)=0A> > at java.lang.reflect.Method.invoke(Unknown Source)=
=0A> > at org.apache.catalina.startup.Bootstrap.start(=0A> > at org.apache.=
catalina.startup.Bootstrap.main(=0A> > Dec 2, 2009 2:02:47 PM org.apache.ca=
talina.core.ApplicationContext log=0A> > INFO: Use of the properties initia=
lization parameter 'properties' has=0A> been deprecated by 'org.apache.velo=
city.properties'=0A> > Dec 2, 2009 2:02:49 PM org.apache.catalina.core.Appl=
icationContext log=0A> > INFO: ContextListener: contextInitialized()=0A> > =
Dec 2, 2009 2:02:49 PM org.apache.catalina.core.ApplicationContext log=0A> =
> INFO: SessionListener: contextInitialized()=0A> > Dec 2, 2009 2:02:50 PM =
org.apache.coyote.http11.Http11Protocol start=0A> > INFO: Starting Coyote H=
TTP/1.1 on http-8080=0A> > Dec 2, 2009 2:02:50 PM org.apache.jk.common.Chan=
nelSocket init=0A> > INFO: JK: ajp13 listening on /0.0.0.0:8009=0A> > Dec 2=
, 2009 2:02:50 PM org.apache.jk.server.JkMain start=0A> > INFO: Jk running =
ID=3D0 time=3D0/125 config=3Dnull=0A> > Dec 2, 2009 2:02:50 PM org.apache.c=
atalina.startup.Catalina start=0A> > INFO: Server startup in 4885 ms: No su=
itable=0A> driverBasicDataSource.java:1143)BasicDataSource.java:880)TorqueI=
nstance.java:912)TorqueInstance.java:891)Torque.java:300)CurrentConnection.=
java:32)Dispatcher.java:375)Dispatcher.java:307)GenericServlet.java:212)Sta=
ndardWrapper.java:1173)StandardWrapper.java:993)StandardContext.java:4149)S=
tandardContext.java:4458)ContainerBase.java:1045)StandardHost.java:722)Cont=
ainerBase.java:1045)StandardEngine.java:443)StandardService.java:516)Standa=
rdServer.java:710)Catalina.java:583)Native=0A> Method)Bootstrap.java:288)Bo=
otstrap.java:413)=0A> >=0A> > Server.xml=0A> > <?xml version=3D"1.0" encodi=
ng=3D"UTF-8"?>=0A> > <!--=0A> >  Licensed to the Apache Software Foundation=
 (ASF) under one or more=0A> >  contributor license agreements.  See the NO=
TICE file distributed with=0A> >  this work for additional information rega=
rding copyright ownership.=0A> >  The ASF licenses this file to You under t=
he Apache License, Version 2.0=0A> >  (the "License"); you may not use this=
 file except in compliance with=0A> >  the License.  You may obtain a copy =
of the License at=0A> >      http://www.apache.org/licenses/LICENSE-2.0=0A>=
 >  Unless required by applicable law or agreed to in writing, software=0A>=
 >  distributed under the License is distributed on an "AS IS" BASIS,=0A> >=
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.=
=0A> >  See the License for the specific language governing permissions and=
=0A> >  limitations under the License.=0A> > --><!-- Note:  A "Server" is n=
ot itself a "Container", so you may not=0A> >      define subcomponents suc=
h as "Valves" at this level.=0A> >      Documentation at /docs/config/serve=
r.html=0A> >  --><Server port=3D"8005" shutdown=3D"SHUTDOWN">=0A> >  <!--AP=
R library loader. Documentation at /docs/apr.html -->=0A> >  <Listener SSLE=
ngine=3D"on"=0A> className=3D"org.apache.catalina.core.AprLifecycleListener=
"/>=0A> >  <!--Initialize Jasper prior to webapps are loaded. Documentation=
 at=0A> /docs/jasper-howto.html -->=0A> >  <Listener className=3D"org.apach=
e.catalina.core.JasperListener"/>=0A> >  <!-- JMX Support for the Tomcat se=
rver. Documentation at=0A> /docs/non-existent.html -->=0A> >  <Listener=0A>=
 className=3D"org.apache.catalina.mbeans.ServerLifecycleListener"/>=0A> >  =
<Listener=0A> className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecy=
cleListener"/>=0A> >  <!-- Global JNDI resources=0A> >        Documentation=
 at /docs/jndi-resources-howto.html=0A> >  -->=0A> >  <GlobalNamingResource=
s>=0A> >    <!-- Editable user database that can also be used by=0A> >     =
     UserDatabaseRealm to authenticate users  -->=0A> > <Environment name=
=3D"envName" type=3D"java.lang.String" value=3D"DEV"/>=0A> > <Environment n=
ame=3D"contractPropertiesFile" type=3D"java.lang.String"=0A> value=3D"C:\\w=
orkspace\\contract\\conf\\contract.properties"/>=0A> > <Environment name=3D=
"cmts-url"            value=3D"=0A> http://localhost:8080/aims2/aims" type=
=3D"java.lang.String"/>=0A> > <Environment name=3D"cseaPropertiesFile" type=
=3D"java.lang.String"=0A> value=3D"C:\\apache-tomcat-6.0.20\\webapps\\csea\=
\WEB-INF\\csea.properties"/>=0A> > <Environment name=3D"cdb-url"           =
   value=3D"=0A> http://localhost:8080/alligator"  type=3D"java.lang.String=
"/>=0A> > <Environment name=3D"liarRealm"            value=3D"tdhca.liar.Re=
niRealm"=0A>        type=3D"java.lang.String"/>=0A> > <Environment name=3D"=
tdhca.liar.useDomain" value=3D"false"=0A>        type=3D"java.lang.String" =
/>=0A> > <Environment name=3D"tdhca.liar.hashSalt"=0A> value=3D"23049mdx903=
lzd93jag9845a0gjsscvm" type=3D"java.lang.String"/>=0A> >=0A> > <Resource na=
me=3D"jdbc/cmts" auth=3D"Container" type=3D"javax.sql.DataSource"/>=0A> >  =
      <ResourceParams name=3D"jdbc/cmts">=0A> >          <parameter>=0A> > =
           <name>factory</name>=0A> >            <value>org.apache.commons.=
dbcp.BasicDataSourceFactory</value>=0A> >          </parameter>=0A> >      =
    <parameter>=0A> >            <name>driverClassName</name>=0A> >        =
    <value>oracle.jdbc.driver.OracleDriver</value>=0A> >          </paramet=
er>=0A> >          <parameter>=0A> >            <name>url</name>=0A> >     =
       <value>jdbc:oracle:thin:sysadm2@atlow.tdhca.state.tx.us:1521=0A> :de=
v</value>=0A> >          </parameter>=0A> >          <parameter>=0A> >     =
       <name>username</name>=0A> >            <value>xxx</value>=0A> >     =
     </parameter>=0A> >          <parameter>=0A> >            <name>passwor=
d</name>=0A> >            <value>xxx</value>=0A> >          </parameter>=0A=
> >          <parameter>=0A> >            <name>maxActive</name>=0A> >     =
       <value>10</value>=0A> >          </parameter>=0A> >          <parame=
ter>=0A> >            <name>maxIdle</name>=0A> >            <value>5</value=
>=0A> >          </parameter>=0A> >          <parameter>=0A> >            <=
!-- time to wait for a connection before giving up in=0A> milliseconds -->=
=0A> >            <name>maxWait</name>=0A> >            <value>10000</value=
>=0A> >          </parameter>=0A> >          <parameter>=0A> >            <=
name>testWhileIdle</name>=0A> >            <value>true</value>=0A> >       =
   </parameter>=0A> >          <parameter>=0A> >            <name>validatio=
nQuery</name>=0A> >            <value>select 1 from dual</value>=0A> >     =
     </parameter>=0A> >        </ResourceParams>=0A> >    <Resource auth=3D=
"Container" description=3D"User database that can be=0A> updated and saved"=
=0A> factory=3D"org.apache.catalina.users.MemoryUserDatabaseFactory"=0A> na=
me=3D"UserDatabase" pathname=3D"conf/tomcat-users.xml"=0A> type=3D"org.apac=
he.catalina.UserDatabase"/>=0A> >  </GlobalNamingResources>=0A> >  <!-- A "=
Service" is a collection of one or more "Connectors" that share=0A> >      =
  a single "Container" Note:  A "Service" is not itself a=0A> "Container",=
=0A> >        so you may not define subcomponents such as "Valves" at this=
=0A> level.=0A> >        Documentation at /docs/config/service.html=0A> >  =
  -->=0A> >  <Service name=3D"Catalina">=0A> >=0A> >    <!--The connectors =
can use a shared executor, you can define one or=0A> more named thread pool=
s-->=0A> >    <!--=0A> >    <Executor name=3D"tomcatThreadPool" namePrefix=
=3D"catalina-exec-"=0A> >        maxThreads=3D"150" minSpareThreads=3D"4"/>=
=0A> >    -->=0A> >=0A> >=0A> >    <!-- A "Connector" represents an endpoin=
t by which requests are=0A> received=0A> >          and responses are retur=
ned. Documentation at :=0A> >          Java HTTP Connector: /docs/config/ht=
tp.html (blocking &=0A> non-blocking)=0A> >          Java AJP  Connector: /=
docs/config/ajp.html=0A> >          APR (HTTP/AJP) Connector: /docs/apr.htm=
l=0A> >          Define a non-SSL HTTP/1.1 Connector on port 8080=0A> >    =
-->=0A> >    <Connector connectionTimeout=3D"20000" port=3D"8080" protocol=
=3D"HTTP/1.1"=0A> redirectPort=3D"8443"/>=0A> >    <!-- A "Connector" using=
 the shared thread pool-->=0A> >    <!--=0A> >    <Connector executor=3D"to=
mcatThreadPool"=0A> >                port=3D"8080" protocol=3D"HTTP/1.1"=0A=
> >                connectionTimeout=3D"20000"=0A> >                redirec=
tPort=3D"8443" />=0A> >    -->=0A> >    <!-- Define a SSL HTTP/1.1 Connecto=
r on port 8443=0A> >          This connector uses the JSSE configuration, w=
hen using APR, the=0A> >          connector should be using the OpenSSL sty=
le configuration=0A> >          described in the APR documentation -->=0A> =
>    <!--=0A> >    <Connector port=3D"8443" protocol=3D"HTTP/1.1" SSLEnable=
d=3D"true"=0A> >                maxThreads=3D"150" scheme=3D"https" secure=
=3D"true"=0A> >                clientAuth=3D"false" sslProtocol=3D"TLS" />=
=0A> >    -->=0A> >    <!-- Define an AJP 1.3 Connector on port 8009 -->=0A=
> >    <Connector port=3D"8009" protocol=3D"AJP/1.3" redirectPort=3D"8443"/=
>=0A> >=0A> >    <!-- An Engine represents the entry point (within Catalina=
) that=0A> processes=0A> >          every request.  The Engine implementati=
on for Tomcat stand alone=0A> >          analyzes the HTTP headers included=
 with the request, and passes=0A> them=0A> >          on to the appropriate=
 Host (virtual host).=0A> >          Documentation at /docs/config/engine.h=
tml -->=0A> >    <!-- You should set jvmRoute to support load-balancing via=
 AJP ie :=0A> >    <Engine name=3D"Catalina" defaultHost=3D"localhost" jvmR=
oute=3D"jvm1">=0A> >    -->=0A> >    <Engine defaultHost=3D"localhost" name=
=3D"Catalina">=0A> >      <!--For clustering, please take a look at documen=
tation at:=0A> >          /docs/cluster-howto.html  (simple how to)=0A> >  =
        /docs/config/cluster.html (reference documentation) -->=0A> >      =
<!--=0A> >      <Cluster className=3D"org.apache.catalina.ha.tcp.SimpleTcpC=
luster"/>=0A> >      -->=0A> >      <!-- The request dumper valve dumps use=
ful debugging information=0A> about=0A> >            the request and respon=
se data received and sent by Tomcat.=0A> >            Documentation at: /do=
cs/config/valve.html -->=0A> >      <!--=0A> >      <Valve className=3D"org=
.apache.catalina.valves.RequestDumperValve"/>=0A> >      -->=0A> >      <!-=
- This Realm uses the UserDatabase configured in the global JNDI=0A> >     =
       resources under the key "UserDatabase".  Any edits=0A> >            =
that are performed against this UserDatabase are immediately=0A> >         =
   available for use by the Realm.  -->=0A> >      <Realm className=3D"org.=
apache.catalina.realm.UserDatabaseRealm"=0A> resourceName=3D"UserDatabase"/=
>=0A> >      <!-- Define the default virtual host=0A> >            Note: XM=
L Schema validation will not work with Xerces 2.2.=0A> >        -->=0A> >  =
    <Host appBase=3D"webapps" autoDeploy=3D"true" name=3D"localhost"=0A> un=
packWARs=3D"true" xmlNamespaceAware=3D"false" xmlValidation=3D"false">=0A> =
>        <!-- SingleSignOn valve, share authentication between web=0A> appl=
ications=0A> >              Documentation at: /docs/config/valve.html -->=
=0A> >        <!--=0A> >        <Valve className=3D"org.apache.catalina.aut=
henticator.SingleSignOn"=0A> />=0A> >        -->=0A> >        <!-- Access l=
og processes all example.=0A> >              Documentation at: /docs/config=
/valve.html -->=0A> >        <!--=0A> >        <Valve className=3D"org.apac=
he.catalina.valves.AccessLogValve"=0A> directory=3D"logs"=0A> >            =
    prefix=3D"localhost_access_log." suffix=3D".txt"=0A> pattern=3D"common"=
 resolveHosts=3D"false"/>=0A> >        -->=0A> >        <Logger className=
=3D"org.apache.catalina.logger.FileLogger"=0A> >                  directory=
=3D"logs"  prefix=3D"localhost_log." suffix=3D".txt"=0A> >          timesta=
mp=3D"true"/>=0A> >=0A> > <Context path=3D"/alligator" docBase=3D"alligator=
" debug=3D"0"=0A> reloadable=3D"true" crossContext=3D"true">=0A> > <Resourc=
eLink name=3D"liarRealm" global=3D"liarRealm"/>=0A> > <ResourceLink name=3D=
"tdhca.liar.useDomain" global=3D"tdhca.liar.useDomain"/>=0A> > <ResourceLin=
k name=3D"tdhca.liar.hashSalt" global=3D"tdhca.liar.hashSalt"/>=0A> > <Reso=
urceLink name=3D"cmts-url" global=3D"cmts-url"/>=0A> > <ResourceLink name=
=3D"mf-url" global=3D"mf-url"/>=0A> > <ResourceLink name=3D"cdb-url" global=
=3D"cdb-url"/>=0A> > <ResourceLink name=3D"jdbc/cdb" global=3D"jdbc/cmts"=
=0A> type=3D"javax.sql.DataSource" />=0A> > <Environment name=3D"serverName=
" type=3D"java.lang.String" value=3D"contract"/>=0A> > <ResourceLink name=
=3D"envName" global=3D"envName"/>=0A> > <ResourceLink name=3D"contractPrope=
rtiesFile"=0A> global=3D"contractPropertiesFile"/>=0A> > </Context>=0A> >=
=0A> >      </Host>=0A> >    </Engine>=0A> >  </Service>=0A> > </Server>=0A=
> >=0A> > Thanks for your help.=0A> >=0A> > Angela Day=0A> > National Autis=
m Association of Central Texas=0A> >=0A> > http://www.naacentraltexas.org=
=0A> > formally FEAT Austin=0A>=0A> ---------------------------------------=
------------------------------=0A> To unsubscribe, e-mail: torque-user-unsu=
bscribe@db.apache.org=0A> For additional commands, e-mail: torque-user-help=
@db.apache.org=0A=0A=0A=0A      
--0-76238176-1259794591=:1348--