import java.sql.*;public class JDBCExample1
{ /**
* @param args the command line arguments
*/
public static void main(String[] args)
{
String connectionURL = "jdbc:postgresql://192.168.0.110:1433/pubs;user = sa;password = Abcd_1231";
// TODO code application logic here
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con = DriverManager.getConnection(connectionURL);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select job_id from jobs ");
while (rs.next())
{
System.out.println("****************"+"\n"+rs.getString("job_id"));
}
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
//con.close();
}错误:
init:
deps-jar:
Compiling 1 source file to H:\JAVA\Connect\build\classes
compile:
run:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at JDBCExample1.main(JDBCExample1.java:26)sqlserver已经打了sp4的补丁,三个jar也已添加到工程,jdbc+sp3
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(connectionURL,"sa","Abcd_1231");url写错了!
异常显示没有合适的驱动,再仔细检查检查
那么URL怎么写呢?
to 二楼
我应该怎么检查?
三楼:
换什么样的驱动?
既然是用的SQLServer,这样写的Url就不对了吧!不过错误提示好像不是这里出的问题啊!还是再看看你的驱动是不是真的打上了
拷贝到 tommcat目录下 shared/lib下
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url=
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
我连的是sql2000,但还是有问题解决不了啊
c:\>telnet 192.168.1.254 1433看看是不是可以正确连接,不能就是sqlserver 没设好,防火强的问题
我改正之后,但现在又有新的问题了,ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at JDBCExample1.main(JDBCExample1.java:26)
网上有资料说,是SQL的登录模式,我的就是混合登录的啊....