问题描述
环境参数OS：WindowsServer2008R2EnterpriseDB:PostgreSQL-8.4.5-1WEB服务器:Tomcat6OEM:Apahcetorquedriver包：postgresql-8.4-702.jdbc4.jartorque.properties文件定义torque.dsfactory.bsp.connection.driver=org.postgresql.Drivertorque.dsfactory.bsp.connection.url=jdbc:postgresql://192.168.0.25:5432/pdm2torque.dsfactory.bsp.connection.user=pdm2torque.dsfactory.bsp.connection.password=pdm2问题已经把driver包导入到lib目录下了，可是还是出现一下错误，奇怪的是在WindowsServer2008上面运行时正常的。为什么在WindowsServer2008R2就不行了呢，请各高手指点一下2011/02/1010:04:35ERRORorg.apache.torque.dsfactory.AbstractDataSourceFactory.setProperty(AbstractDataSourceFactory.java:177)-Property:drivervalue:org.postgresql.DriverisnotsupportedbyDataSource:org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS2011/02/1010:04:35ERRORbsp.logv4.server.db.PrcBatchLookoutEventDao.doSelectManager(PrcBatchLookoutEventDao.java:56)-org.apache.torque.TorqueException:java.sql.SQLException:Nosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2atorg.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:919)atorg.apache.torque.Torque.getConnection(Torque.java:314)atorg.apache.torque.util.Transaction.beginOptional(Transaction.java:108)atorg.apache.torque.util.BasePeer.doSelect(BasePeer.java:753)atbsp.logv4.server.db.table.BaseManagerPeer.doSelectVillageRecords(BaseManagerPeer.java:388)atbsp.logv4.server.db.table.BaseManagerPeer.doSelectVillageRecords(BaseManagerPeer.java:361)atbsp.logv4.server.db.table.BaseManagerPeer.doSelect(BaseManagerPeer.java:329)atbsp.logv4.server.db.PrcBatchLookoutEventDao.doSelectManager(PrcBatchLookoutEventDao.java:52)atbsp.logv4.server.app.prcbatchlookoutevent.PrcBatchLookoutEvent.setSleepTime(PrcBatchLookoutEvent.java:546)atbsp.logv4.server.app.prcbatchlookoutevent.PrcBatchLookoutEvent.init(PrcBatchLookoutEvent.java:126)atbsp.logv4.server.app.prcbatchlookoutevent.PrcBatchLookoutEvent.run(PrcBatchLookoutEvent.java:587)atbsp.logv4.server.app.prcbatchlookoutevent.PrcBatchLookoutEvent.main(PrcBatchLookoutEvent.java:634)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)atjava.lang.reflect.Method.invoke(Method.java:597)atcom.exe4j.runtime.LauncherEngine.launch(UnknownSource)atcom.exe4j.runtime.WinLauncher.main(UnknownSource)Causedby:java.sql.SQLException:Nosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2atjava.sql.DriverManager.getConnection(DriverManager.java:602)atjava.sql.DriverManager.getConnection(DriverManager.java:185)atorg.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)atorg.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)atorg.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:749)atorg.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool(SharedPoolDataSource.java:202)atorg.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:159)atorg.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)atorg.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)atorg.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)...17more
解决方案
解决方案二：
org.postgresql.DriverisnotsupportedbyDataSource:org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDSNosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2用连接池了吗？还是驱动包的问题...换驱动
解决方案三：
Causedby:java.sql.SQLException:Nosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2路径构建一下！应该驱动包没有正确的导入造成的！
解决方案四：
Nosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2关键就这一句。
解决方案五：
org.postgresql.DriverisnotsupportedbyDataSource:org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDSNosuitabledriverfoundforjdbc:postgresql://192.168.0.25:5432/pdm2用连接池了吗？还是驱动包的问题...换驱动①我用的是Torque作为OEM来进行数据库链接操作的torque.properties文件定义torque.dsfactory.bsp.connection.driver=org.postgresql.Drivertorque.dsfactory.bsp.connection.url=jdbc:postgresql://192.168.0.25:5432/pdm2torque.dsfactory.bsp.connection.user=pdm2torque.dsfactory.bsp.connection.password=pdm2②驱动包用过一下两个都不行postgresql-8.4-702.jdbc4.jarpostgresql-9.0-801.jdbc4.jar
解决方案六：
驱动包的问题，或者是导入路径的问题吧
解决方案七：
细节问题，网上有很多解决方案！初学者要做到仔细认真，资深人士同样也是！