作者kevindd (gg)
看板java
标题[问题] 设定JDBC连线informix资料库的问题
时间Wed Oct 24 23:27:14 2012
目前我只想要测试程式是否能够和informix连线成功
主机在其他电脑上,本机应该只要装JDBC driver不用装Tomcat之类的
但我的程式只能执行到System.out.println("Driver OK")
所以我想请教hwae5500是否一定要改成ip,另外hwae5500後面没有加port
是不是和ODBC不同不能省略,一定要加port才正确
或者错误讯息有其他的问题
public class DBConnection {
public static void main(String args[]) {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
String dbURL = "jdbc:informix-sqli://hwae5500/affil/:INFORMIXSERVER="+
"shme5500;user=test;password=test;";
try {
Class.forName("com.informix.jdbc.IfxDriver");
System.out.println("Driver OK");
connection =DriverManager.getConnection(dbURL);
System.out.println("connection OK");
}
catch (SQLException s) {
//System.out.println("SQLException ");
s.printStackTrace();
}
catch (Exception e) {
System.out.println("Exception :"+e.toString());
}
}
}
错误讯息:
Driver OK
java.sql.SQLException: Message text will be provided in later releases
java.lang.NullPointerException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:487)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1429)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBConnection.main(DBConnection.java:19)
Caused by: java.lang.NullPointerException
at com.informix.asf.Connection.prepareIP_PortInfo(Connection.java:2073)
at com.informix.asf.Connection.prepareForConnect(Connection.java:2004)
at com.informix.asf.Connection.<init>(Connection.java:322)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1055)
... 8 more
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 36.226.25.150