String dbUrl="jdbc:postgresql://localhost/weborder";
Driver driver = (Driver) Class.forName("org.postgresql.Driver").newInstance();
DriverManager.registerDriver(driver);
Connection dbCon = DriverManager.getConnection(dbUrl, "postgre", "postgre");
Statement statement=dbCon.createStatement();
上面是我的连接数据库的代码,C/S模式的程序,首先看看这段代码有问题吗?
为什么会总是报错,
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at weborder.DBConnectionManager$DBConnectionPool.newConnection(DBConnect
ionManager.java:138)
at weborder.DBConnectionManager$DBConnectionPool.getConnection(DBConnect
ionManager.java:88)
at weborder.DBConnectionManager.getConnection(DBConnectionManager.java:2
35)
at weborder.SQLDBOperator.<init>(SQLDBOperator.java:20)
at weborder.SQLDBOperator.getInstance(SQLDBOperator.java:161)
at weborder.WebOrderList.getItemSet(WebOrderList.java:31)
at weborderlist._WebOrderListImplBase._invoke(_WebOrderListImplBase.java
:40)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispa
tchToServant(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispa
tch(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
Request(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(U
nknown Source)
at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.call
back(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
(Unknown Source)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatc
h(Unknown Source)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(
Unknown Source)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.
run(Unknown Source)
知道为什么吗?是不是还要把postgresql下的jdbc的jar包复制到某个地方?
谢谢各位高手解答下,搞了一天,郁闷死了,都快没信心了
Driver driver = (Driver) Class.forName("org.postgresql.Driver").newInstance();
DriverManager.registerDriver(driver);
Connection dbCon = DriverManager.getConnection(dbUrl, "postgre", "postgre");
Statement statement=dbCon.createStatement();
上面是我的连接数据库的代码,C/S模式的程序,首先看看这段代码有问题吗?
为什么会总是报错,
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at weborder.DBConnectionManager$DBConnectionPool.newConnection(DBConnect
ionManager.java:138)
at weborder.DBConnectionManager$DBConnectionPool.getConnection(DBConnect
ionManager.java:88)
at weborder.DBConnectionManager.getConnection(DBConnectionManager.java:2
35)
at weborder.SQLDBOperator.<init>(SQLDBOperator.java:20)
at weborder.SQLDBOperator.getInstance(SQLDBOperator.java:161)
at weborder.WebOrderList.getItemSet(WebOrderList.java:31)
at weborderlist._WebOrderListImplBase._invoke(_WebOrderListImplBase.java
:40)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispa
tchToServant(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispa
tch(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
Request(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(U
nknown Source)
at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.call
back(Unknown Source)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest
(Unknown Source)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatc
h(Unknown Source)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(
Unknown Source)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.
run(Unknown Source)
知道为什么吗?是不是还要把postgresql下的jdbc的jar包复制到某个地方?
谢谢各位高手解答下,搞了一天,郁闷死了,都快没信心了
就把jar丢到JAVA_HOME\jre\lib\ext下面。
我的F:\Program Files\PostgreSQL\8.1\jdbc下面的jar包都复制到
E:\Program Files\Java\jdk1.5.0_04\jre\lib\ext下面
但还是出现问题,能在帮忙分析下问题好吗
我还是个学生,一点点的在学
希望多多指教
我的方法是在工程上右键,add external file,把org.postgresql.Driver给加进来
我是用的eclipse
我试试
你能再说清楚些吗
谢谢