You didn't import the Informix Driver Package. > -----Original Message----- > From: Thang Nguyen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 25, 2000 4:06 PM > To: [EMAIL PROTECTED] > Subject: JSP with Informix JDBC > > > Hi, > > I had a problem to get this jsp page to work (basically, it > can not establish the > connection to the Informix database). However, if I write a > stand alone java > module with the same driver and URL as described below, then > it worked just fine. > There seemed to be a problem if I tried to do this within > JSP. My webserver is > Tomcat (stand alone) and it worked fine except when it tried > to connect to the > database. I can assure with you that the driverName and > dbUrl are correct, I > checked them so many times. The code can only execute up > to the line of > "Testing2... ha ha ha". The error I got is simply said > that it could not > connect to the database. Do you see what I have done > wrong? please suggest a way > for me to debug. Below is my JSP page. Thanks much in advance. > > > <%@ page import="java.sql.*" %> > > <html> > <body> > > <% > String driverName = "com.informix.jdbc.IfxDriver"; > String dbUrl = > "jdbc:informix-sqli://143.183.67.14:1529/test31:INFORMIXSERVER > =tng93;user=infotest;password=i5u"; > > out.println("<br>" + "Testing1...h ha ha ha"); > try { > // Step 1. Load the driver > Class.forName(driverName); > > out.println("<br>" + "Testing2...h ha ha ha"); > // Step 2: Get a connection > out.println(dbUrl); > Connection myConn = DriverManager.getConnection (dbUrl); > out.println("<br>" + "Testing3...h ha ha ha"); > > // Step 3: Create and execute the SQL statement > Statement myStmt = myConn.createStatement (); > ResultSet myRs = myStmt.executeQuery ("SELECT * from > pdscddata"); > out.println("<br>" + "Testing4...h ha ha ha"); > > // Step 4: Process the Result Set > while (myRs.next()) { > out.println("<br>" + myRs.getString ("pdsname")); > } > } > catch (SQLException exc) { > out.println("<br> ERROR: failed to connect !"); > exc.printStackTrace(); > } > catch (ClassNotFoundException exc) { > out.println("<br> ERROR: failed to find a class !"); > exc.printStackTrace(); > } > %> > > </body> > </html> > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: > "signoff JSP-INTEREST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.html > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
