i think anyhow u have to include that class file in the jsp page.
else u have to make a package for that class file and import it.
Manish.
----- Original Message -----
From: Predict AG - Christian Ribeaud <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 11:46 PM
Subject: <script></script> and database pool connection
> Hi,
>
> I am trying to write a .jsp. I work with a database pool connection. I
read the following in a faq (http://www.esperanto.org.nz/jsp/jspfaq.html) to
instantiate the DBConnectionManager (s. below). I am using the
JavaWebServer2.0 and I put the DBConnectionManager.class and the
DBConnectionManager$DBConnectionPool.class in the classes directory. So it
must be loaded by the system class loader. What ist wrong?
>
> Here is the script:
>
> <%@ page isThreadSafe="true" import="java.sql.*" %>
> <script RUNAT="SERVER">
> DBConnectionManager connMgr = DBConnectionManager.getInstance();
> </script>
> <%!
> String Password, Origin = "home.html";
> %>
> <%
> if (request.getParameter("Emp_ID") != "" && request.getParameter("Emp_ID")
!= null) {
> // DBConnectionManager connMgr = DBConnectionManager.getInstance();
> Connection con = connMgr.getConnection("access");
> if (con == null){
> out.println ( "<P><PRE>" );
> out.println("Can't get connection");
> out.println ( "</PRE><P>" );
> return;
> }
> try {
> Statement stmt = con.createStatement();
> ResultSet rs = stmt.executeQuery("select Emp_Password
where Emp_ID = " + request.getParameter("Emp_ID"));
> stmt.close();
> rs.next();
> Password = rs.getString("Emp_Password");
> }
> catch (SQLException ex) {
> out.println ( "<P><PRE>" );
> while (ex != null) {
> out.println("Message: " + ex.getMessage ());
> out.println("SQLState: " + ex.getSQLState ());
> out.println("ErrorCode: " + ex.getErrorCode ());
> ex = ex.getNextException();
> out.println("");
> }
> out.println ( "</PRE><P>" );
> }
>
> if (Password != null &&
Password.equalsIgnoreCase(request.getParameter("Emp_Passwort"))) {
> session.putValue("Emp_ID",
request.getParameter("Emp_ID"));
> if (request.getParameter("Origin") != null) Origin =
request.getParameter("Origin");
>
response.sendRedirect(response.encodeRedirectUrl(request.getParameter("Origi
n")));
> }
> connMgr.freeConnection("access",con);
> }
> %>
>
> And here the error I got:
>
> Error during compilation :
> E:\JavaWebServer2.0\tmpdir\default\pagecompile\jsp\_login.java:80:
Undefined variable or class name: connMgr
> Connection con = connMgr.getConnection("access");
> ^
> E:\JavaWebServer2.0\tmpdir\default\pagecompile\jsp\_login.java:111:
Undefined variable or class name: connMgr
> connMgr.freeConnection("access",con);
> ^
> Note: E:\JavaWebServer2.0\tmpdir\default\pagecompile\jsp\_login.java uses
or overrides a deprecated API. Recompile with "-deprecation" for details.
> 2 errors, 1 warning
>
> Thanks a lot for the help.
>
> Christian Ribeaud
> Predict AG
>
>
===========================================================================
> 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
