JDBC & Orbix
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET
Hello ! I have a problem connecting to Informix using JDBC. The application runs on application server that gets the request from netscape webserver. OrbixWeb3 is the middelware between the servers. Both servers are on sun machines. While tring to connect the DB I don't get an SQLException but when tring to create statement I get the following message : Cursor define on closed connection. The applcation ran before without orbix and there were no problems connecting to the database. The code is : try{ Class.forName("informix.api.jdbc.JDBCDriver"); }catch(ClassNotFoundException e){ Message.DEBUG_INFO("DlJDBCServices.connectDB() ---> "+ e.getMessage()); } try{ String url = "jdbc:informix-api-direct:;system=dtl1;database=stores7"; m_connection = DriverManager.getConnection(url); Statement st = m_connection.createStatement(); }catch(SQLException ex){ System.out.println(ex.getMessage()); }catch(Exception ex){ System.out.println(ex.getMessage()); } Thank you for your help limor.