|
url = "jdbc:Cache://127.0.0.0:1972/USER";
==> url = "jdbc:Cache://127.0.0.1:1972/USER";
로 바꿔보세요.
-- 이문준 님이 쓰신 글:
>> 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";
>>===========================>127.0.0.1로 해보세요^^;
>> } 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...
>>
>> 고수님들의 도움 부탁합니다.
|
