is CofeePot supposed to be spelled with 1 f or 2?
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Tarik Makota
Sent: Wednesday, August 09, 2000 11:37 AM
To: [EMAIL PROTECTED]
Subject: DB Access problem
This is my acctual bean that is supposetly to connect to DB:
I put the 'markers' so that i know where it stops.
As soon as it hits Connection conn = ... it stops
because in my jsp page print the propert userName
so that i know wher do i get stuck.
JSP page is displayed without any errors
My DSN is ok because i have tried User and System.
----------------------------------------------------------
package foo;
import java.util.*;
import java.sql.*;
import java.net.URL.*;
public class DBLoginBean6{
private boolean isValid = false;
private String userName;
private String userPassword;
public DBLoginBean6() {
userName="Initalized";
userPassword="";
String url = "jdbc:odbc:CofeePot";
String query = "SELECT * FROM EMPLOYEES";
String firstName;
String lastName;
boolean more;
try
{
userName="First Try";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (java.lang.ClassNotFoundException ex)
{
ex.printStackTrace();
}
userName=" connection begin";
Connection con = DriverManager.getConnection(url,"","");
userName="I connected";
Statement stmt = con.createStatement();
userName="i created statement";
ResultSet rs = stmt.executeQuery(query);
userName="i executed statement";
while (more = rs.next())
{
firstName = rs.getString("FIRSTNAME");
lastName = rs.getString("LASTNAME");
System.out.println( firstName + " " + lastName);
userName = "I was executed";
}
userName="I did while";
rs.close();
stmt.close();
con.close();
userName="And i ewxited";
}
catch (SQLException ex)
{
ex.printStackTrace();
}
}
public String getuserName() {
return userName;
}
public String getuserPassword() {
return "I am user Password";
}
}
----------------------------
===========================================================================
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
