import java.sql.*;
import com.intersys.jdbc.*;
public class JdbcTest {
public static void main (String[] args) throws SQLException {
String url;
String username="_SYSTEM";
String password="sys";
Connection conn;
try {
url = "jdbc:Cache://127.0.0.0:1972/USER";
} catch (Exception e) {
System.out.println("--------");
e.printStackTrace();
return ;
}
try {
Class.forName("com.intersys.jdbc.CacheDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.print(e.getMessage());
return ;
}
//--- Connect to the Datasource ---
try {
conn=DriverManager.getConnection(url,username,password);
} catch (SQLException e) {
e.printStackTrace();
return ;
}
Statement stmt;
ResultSet rs;
String stQuery="Select * from TableName";
System.out.println("List of Companies from the Stock Table\n");
stmt=conn.createStatement();
rs=stmt.executeQuery(stQuery);
ResultSetMetaData rsmd=rs.getMetaData();
int colnum=rsmd.getColumnCount();
while (rs.next()) {
for (int i=1;i<=colnum;i++) {
System.out.print(rs.getString(i)+" ");
}
System.out.println();
}
}
}
---------------------------------------------------------
위 소스의 //--- Connect to the Datasource --- 부분에서 다음과 같은
예외가 발생합니다.
java.sql.SQLException: Communication failure
at com.intersys.jdbc.InStream.readHeader(InStream.java:62)
at com.intersys.jdbc.CacheConnection.connect(CacheConnection.java:397)
at com.intersys.jdbc.CacheConnection.<init>(CacheConnection.java:77)
at com.intersys.jdbc.CacheDriver.connect(CacheDriver.java:65)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at JdbcTest.main(JdbcTest.java:53)
Press any key to continue...
고수님들의 도움 부탁합니다.
|