我在Struts程序连接数据库,测试的时候报错,如下:
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.login.conn.DBConnection.getConn(DBConnection.java:24)
at org.login.conn.DBConnection.execuQuery(DBConnection.java:68)
at org.login.daoimpl.PersonDAOImpl.isLogin(PersonDAOImpl.java:17)
at org.login.struts.test.Test.main(Test.java:18)
Exception in thread "main" java.lang.NullPointerException
at org.login.conn.DBConnection.execuQuery(DBConnection.java:71)
at org.login.daoimpl.PersonDAOImpl.isLogin(PersonDAOImpl.java:17)
at org.login.struts.test.Test.main(Test.java:18)
这是怎么回事,请大家帮忙看一下,先谢了!!!
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.login.conn.DBConnection.getConn(DBConnection.java:24)
at org.login.conn.DBConnection.execuQuery(DBConnection.java:68)
at org.login.daoimpl.PersonDAOImpl.isLogin(PersonDAOImpl.java:17)
at org.login.struts.test.Test.main(Test.java:18)
Exception in thread "main" java.lang.NullPointerException
at org.login.conn.DBConnection.execuQuery(DBConnection.java:71)
at org.login.daoimpl.PersonDAOImpl.isLogin(PersonDAOImpl.java:17)
at org.login.struts.test.Test.main(Test.java:18)
这是怎么回事,请大家帮忙看一下,先谢了!!!
解决方案 »
- weblogic9配置as400数据连接池的问题
- List is a raw type. References to generic type List<E> should be parameterized
- 请问关于java项目前台的问题
- java网站中单人文字聊天室. 并且有交互性的同步电子画板.应该怎么做?
- 如何全库备份db2 利用java代码
- 怎样把checkbox所在的行删除
- 求助 ibatis问题!!!
- 请问目前java或者基于此的JSP开发有没有像.NET的visual studio那样好用的IDE?
- 用fileupload上传文件后,服务器为什么会自动把文件删除???
- 在JSP中如何将从数据库中取出的文章按照原来的段落显示?
- javascribe之document的一些事
- 求推荐本jsp入门书籍!有木有好的视频教程啊?
2.用户名密码不对。
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;databaseName=loginData
username=sa
password=lofty
这是连接代码:
String driverName=ReadStream.getInstance().getProperty("driver");
String url = ReadStream.getInstance().getProperty("url");
String userName = ReadStream.getInstance().getProperty("username");
String pass = ReadStream.getInstance().getProperty("password");
Connection conn = null;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(url,userName,pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
net.sourceforge.jtds.jdbc.Driverdriver=net.sourceforge.jtds.jdbc.Driver
url=jdbc:jtds:sqlserver://localhost:1433;databaseName=loginData
2.确认密码没问题么?
3.数据库打补丁了么?
4.在catch中加上System.exet(0);这样异常信息会更清晰一些。你现在的异常信息把后面的nullPoint都打出来了。
我怎么好像记得这个密码隐约见到过
要用自己装SQL Server时候设置的密码登陆额~