Hi Richard, Instead of the mysql driver, you have to include the postgresql driver in the classpath.
Thomas "Liu, Richard" <[EMAIL PROTECTED]> schrieb am 07.02.2006 19:40:31: > Hi, > > I have finally compiled the turque 3.2 tutorial demo and try to run > the "bookstore" demo (I have finished all the previous steps). > > I got the following error, can anyone give me some help ! > > > Thnaks > > Richard Liu > Software Engineer at Boeing > > ======================================================================== > ============== > > Running command: > > java -cp > classes:lib/avalon-framework-4.1.4.jar:lib/commons-beanutils-1.7.0.jar:l > ib/commons- > collections-3.1.jar:lib/commons-configuration-1.1.jar:lib/commons-dbcp-1 > .2.1.jar:lib/commons-lang-2.1.jar:lib/commo > ns-logging-1.0.4.jar:lib/commons-pool-1.2.jar:lib/jcs-20030822.182132.ja > r:lib/mysql-connector-java-3.1.6-bin.jar:li > b/torque-3.2.jar:lib/village-2.0.jar ideas.houston.boeing.Bookstore > > > Error: > > Feb 7, 2006 12:24:58 PM > org.apache.torque.dsfactory.AbstractDataSourceFactory setProperty > SEVERE: Property: driver value: org.postgresql.Driver is not supported > by DataSource: org.apache.commons.dbcp.cpdsa > dapter.DriverAdapterCPDS > Feb 7, 2006 12:24:58 PM org.apache.torque.oid.IDBroker <init> > WARNING: IDBroker is being used with db 'bookstore', which does not > support transactions. IDBroker attempts to use > transactions to limit the possibility of duplicate key generation. > Without transactions, duplicate key generation > is possible if multiple JVMs are used or other means are used to write > to the database. > org.apache.torque.TorqueException: java.sql.SQLException: No suitable > driver > at > org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:825) > at org.apache.torque.Torque.getConnection(Torque.java:272) > at > org.apache.torque.util.Transaction.beginOptional(Transaction.java:80) > at org.apache.torque.util.Transaction.begin(Transaction.java:62) > at > ideas.houston.boeing.BasePublisher.save(BasePublisher.java:494) > at > ideas.houston.boeing.BasePublisher.save(BasePublisher.java:475) > at ideas.houston.boeing.Bookstore.main(Bookstore.java:25) > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(DriverManager.java:532) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at > org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnectio > n(DriverAdapterCPDS.java:160) > at > org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnectio > n(DriverAdapterCPDS.java:130) > at > org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(Insta > nceKeyDataSource.java:711) > at > org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool(Sh > aredPoolDataSource.java:188) > at > org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnec > tionAndInfo(SharedPoolDataSource > .java:157) > at > org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection( > InstanceKeyDataSource.java:631) > at > org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection( > InstanceKeyDataSource.java:615) > at > org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:821) > ... 6 more > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
