From torque-user-return-8251-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Dec 02 21:39:22 2009 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 67473 invoked from network); 2 Dec 2009 21:39:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Dec 2009 21:39:22 -0000 Received: (qmail 2154 invoked by uid 500); 2 Dec 2009 21:39:22 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 2119 invoked by uid 500); 2 Dec 2009 21:39:22 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 2109 invoked by uid 99); 2 Dec 2009 21:39:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Dec 2009 21:39:22 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00,HTML_MESSAGE,NORMAL_HTTP_TO_IP,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of weizhao6898@gmail.com designates 209.85.160.56 as permitted sender) Received: from [209.85.160.56] (HELO mail-pw0-f56.google.com) (209.85.160.56) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Dec 2009 21:39:19 +0000 Received: by pwj6 with SMTP id 6so505304pwj.15 for ; Wed, 02 Dec 2009 13:38:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to :content-type; bh=a1NQTzINH861StUoO2traBQXsKDYQIANb6HQ2aNdgE4=; b=vBFixirjG/jFfpMBHfkg1KLUm2BHq7cUvqvO6KNXbDjsM3Pt8O2Emaz3aZRhWf+fqM 58oYmngnEJWLrmNs62eikohLERIjWEU1IO1Y4OvowjkExAJuiDdPQMFB3h7EomhgLvXJ l4MkfCXqCtK/G3NBiJGriWISLGJUrL5Uh9Qm8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:content-type; b=S0OWfaNwVb57abqhMO/8d1VddK4bvzg/h/1eCR19nB8/4yPgjuWgWfOWj7Pji/Vazr wAYlYlRE8uADuMjTK3KLAW+7txF2F1cL2wcaihrqIGSznRdO4qZgzUG2Rbs/SXBI+8HK vZtif4VH7+ohNlKY903l9CMqE+4q4KxnSXbqs= MIME-Version: 1.0 Sender: weizhao6898@gmail.com Received: by 10.143.27.41 with SMTP id e41mr77934wfj.218.1259789938941; Wed, 02 Dec 2009 13:38:58 -0800 (PST) In-Reply-To: <905025.48588.qm@web33308.mail.mud.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> Date: Wed, 2 Dec 2009 13:38:58 -0800 X-Google-Sender-Auth: 42fc68470b669f3d Message-ID: <4d036f890912021338j4b69307fifccf511664e9ca44@mail.gmail.com> Subject: Re: no suitable driver From: "wzhao6898@gmail.com" To: Apache Torque Users List Content-Type: multipart/alternative; boundary=00504502cd11cd5f430479c5b3a6 --00504502cd11cd5f430479c5b3a6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 i= n 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 wrote: > It is an existing database and application that I am upgrading from Torqu= e > 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 > To: Apache Torque Users List > 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 wrote: > > > I am going crazy with a problem I have had for a few days now. It seem= s > 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=3D0 time=3D0/125 config=3Dnull > > 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.j= ava:912)TorqueInstance.java:891)Torque.java:300)CurrentConnection.java:32)D= ispatcher.java:375)Dispatcher.java:307)GenericServlet.java:212)StandardWrap= per.java:1173)StandardWrapper.java:993)StandardContext.java:4149)StandardCo= ntext.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 > > > > > > > > className=3D"org.apache.catalina.core.AprLifecycleListener"/> > > > > > > > > className=3D"org.apache.catalina.mbeans.ServerLifecycleListener"/> > > className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"= /> > > > > > > > > > > value=3D"C:\\workspace\\contract\\conf\\contract.properties"/> > > http://localhost:8080/aims2/aims" type=3D"java.lang.String"/> > > value=3D"C:\\apache-tomcat-6.0.20\\webapps\\csea\\WEB-INF\\csea.propertie= s"/> > > http://localhost:8080/alligator" type=3D"java.lang.String"/> > > type=3D"java.lang.String"/> > > type=3D"java.lang.String" /> > > value=3D"23049mdx903lzd93jag9845a0gjsscvm" type=3D"java.lang.String"/> > > > > > > > > > > factory > > org.apache.commons.dbcp.BasicDataSourceFactory > > > > > > driverClassName > > oracle.jdbc.driver.OracleDriver > > > > > > url > > jdbc:oracle:thin:sysadm2@atlow.tdhca.state.tx.us:1521 > :dev > > > > > > username > > xxx > > > > > > password > > xxx > > > > > > maxActive > > 10 > > > > > > maxIdle > > 5 > > > > > > > > maxWait > > 10000 > > > > > > testWhileIdle > > true > > > > > > validationQuery > > select 1 from dual > > > > > > updated and saved" > factory=3D"org.apache.catalina.users.MemoryUserDatabaseFactory" > name=3D"UserDatabase" pathname=3D"conf/tomcat-users.xml" > type=3D"org.apache.catalina.UserDatabase"/> > > > > > > > > > > > > > > > > > > > > redirectPort=3D"8443"/> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > resourceName=3D"UserDatabase"/> > > > > unpackWARs=3D"true" xmlNamespaceAware=3D"false" xmlValidation=3D"false"> > > > > > > > > > > > directory=3D"logs" prefix=3D"localhost_log." suffix= =3D".txt" > > timestamp=3D"true"/> > > > > reloadable=3D"true" crossContext=3D"true"> > > > > > > > > > > > > > > type=3D"javax.sql.DataSource" /> > > > > > > global=3D"contractPropertiesFile"/> > > > > > > > > > > > > > > > > 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 --00504502cd11cd5f430479c5b3a6--