hi all,
i am now coding in win2k platform with resin and interbase6 as the jsp server and
database server,but today when i try to connect to interbase by
Class.forName("inserbase.interclient.Driver") the resin give out the following error:
Communication error: A socket exception occurred while trying to establish a socket
connection to server localhost. The message of the SocketException is "Connection
refused: connect". See API reference for exception
interbase.interclient.CommunicationException
sample code:
try {
Class.forName("interbase.interclient.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.out.println("Classnotfounderror,"+e.getMessage());
}
try {
Connection
conn=DriverManager.getConnection("jdbc:interbase://localhost:3060/d:/Study/Java/data/bookshop.gdb","PROGRAM","jspuser");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from userinfo");
if(rs.next()) {
out.println("<hr>records get!");
}
else {
out.println("no records found,but connect successful!");
}
rs.close();
rs=null;
stmt.close();
stmt=null;
conn.close();
conn=null;
}
catch(SQLException ex) {
out.println("sqlerr"+ex.getMessage());
}
The interclient.jar and jdbc2_0-stdext.jar had all been add to class path
Best regards,
jeans kupher
[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
