Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)
Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)
Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)
解决方案 »
- java在linux下的问题
- 几个枚举类
- 大家好,我做的JAVA IDE初步完成了,但是论文不知怎么样写,请各位提点建议吗?
- validator 运行时出错
- 请各位推荐Swing开源控件,回答就给分!
- 请问JDBC中如何获取某个表的外键的所有信息?
- 对象的比较的问题?
- 一个有关applet的问题??
- 菜鸟求救: 请高手推荐几个好的Java网站
- Interger.tohexstring(int i)这个方法返回的是一个16进制数,我想让他返回的结果前面自动补0
- 使用RMI时抛出 error during JRMP connection establishment; nested exception is:java.io.EOFException]
- 谁能帮我解释一下这Java代码
import java.sql.DriverManager;
import java.sql.*;public class StatementTest { /**
* @param args
*/
public static String Driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private Connection conn=null;
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
StatementTest t =new StatementTest();
t.initConn();
}
private void initConn() throws Exception{
Class.forName(Driver);
String url= "jdbc:microsoft:sqlserver://192.168.1.133:1433/FYAMS";
this.conn=DriverManager.getConnection(url,"sa","");
this.conn.setAutoCommit(false);
}}我用java程序连接的,也包错,这是错误
Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at StatementTest.initConn(StatementTest.java:22)
at StatementTest.main(StatementTest.java:16)
String url= "jdbc:microsoft:sqlserver://192.168.1.133:1433/FYAMS"; 这句有错
a、驱动字符串: com.microsoft.sqlserver.jdbc.SQLServerDriver
b、数据库连接字符串 jdbc:sqlserver://<server_name>:<port>[;databaseName=<dbname>]
2000Sqlserver
a、驱动字符串: com.microsoft.jdbc.sqlserver.SQLServerDriver
b、数据库连接字符串 jdbc:microsoft:sqlserver://<server_name>:<port>[;databaseName=<dbname>]
改为:
String url= "jdbc:microsoft:sqlserver://127.0.0.1:1433/FYAMS"; 试试
不是这样么?
我刚少写了个3
那别人为什么能访问你呢?
[/Quote是的啊 ,我很奇怪了,别人都可以访问我,我从企业管理器上也可以访问,就是在java中就不可以了,我刚刚改了String url= "jdbc:microsoft:sqlserver://192.168.1.133:1433;databasename=FYAMS";
包错
Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at StatementTest.initConn(StatementTest.java:25)
重启机器,再试试。
你的测试过程,最好加上conn.close();