我开始有oracle的数据库也连接不上,后来我用sqlserver的数据库又有问题 我以前用sqlserver的没有问题 就高手来解答!
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.kcs.Pet.Dao.BaseDao.getConn(BaseDao.java:15)
at net.kcs.Pet.Impl.PetOwnerDaoImpl.getAll(PetOwnerDaoImpl.java:65)
at Test.Test1.main(Test1.java:22)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)
... 7 more
这是sqlserver的异常! 连接成功 但是我操作里面的数据就会出现现在的问题了~!
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.kcs.Pet.Dao.BaseDao.getConn(BaseDao.java:15)
at net.kcs.Pet.Impl.PetOwnerDaoImpl.getAll(PetOwnerDaoImpl.java:65)
at Test.Test1.main(Test1.java:22)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)
... 7 more
这是sqlserver的异常! 连接成功 但是我操作里面的数据就会出现现在的问题了~!
解决方案 »
- include文件内容会不会随表单提交到同一个action
- session 关闭问题
- 关于APPFUSE的问题
- struts编写的B/S程序使用tomcat做服务器有时会无法访问????急!!!!!
- EJB组件的调用
- 急,POI的问题,不知道为什么会这样啊,怎么出现java.lang.NoClassDefFoundError: org/apache/log4j/Category
- PB中如何解决关于动态工资项目的问题?高手请进!
- 超级简单,小弟郁闷死了?
- EJB QL问题
- weblogic jms消息丢失的问题
- MVC模式 & 添加评论 & 获得系统时间&论坛
- js中怎么得到session中的值?
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.kcs.Pet.Dao.BaseDao.getConn(BaseDao.java:16)
at net.kcs.Pet.Impl.PetOwnerDaoImpl.getAll(PetOwnerDaoImpl.java:65)
at Test.Test1.main(Test1.java:22)
这个是我oracle数据库的异常 我测试的数据库连接是对的 但是操作里面的数据就出这个错!
2.SQL Server is not configured to use TCP/IP. Either enable TCP/IP from SQL Server's Network Utility app or have jTDS connect via named pipes (see the URL format for information on how to do this).
3.There is a firewall blocking port 1433 on the server.
To check whether TCP/IP is enabled and the port is not blocked you can use "telnet <server_host> 1433". Until telnet doesn't connect, jTDS won't either. If you can't figure out why, ask your network administrator for help.
好像根据这些异常看,是网络的问题,网络不是很稳定,你连的是本机的数据库,还是??
看这个异常,是这个类中的at net.kcs.Pet.Dao.BaseDao.getConn(BaseDao.java:16)
16行有问题。。
那行 我看过了 是 Connection con=DriverManager.getConnection(URL,UID,PWD);
就是这个啊 但是我连接的字符串没错啊 账号和密码也没错啊! 我开始到别的机子上运行过! 但是到了我的机子就不行了! oracle数据库也不行 现在连sqlserver的数据库也不行啊 我很不理解啊!