TrainBeaser for iPhone
The moose likes JDBC and the fly likes Pool Manager with MySQL - JSP ... need help Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » JDBC
Reply Bookmark "Pool Manager with MySQL - JSP ... need help" Watch "Pool Manager with MySQL - JSP ... need help" New topic
Author

Pool Manager with MySQL - JSP ... need help

Sophia Oscario
Greenhorn

Joined: May 14, 2001
Posts: 22
posted
0
Quote
I try to use Pool Manager 2.0 to handle database connection to MySQL from JSP.
But it returns an execption :
Exception Report:
javax.servlet.ServletException: javax/sql/ConnectionEventListener
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:442)
at org.apache.jsp.JDBCtest_jsp._jspService(JDBCtest_jsp.java:123)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:453)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:254)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:194)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:875)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)
at java.lang.Thread.run(Thread.java:484)

Here's My code :
<html>
<head>
<title>JDBC - MySQL</title>
</head>
<%@ page language="java" import="java.sql.*,com.codestudio.util.*" %>
<body>







<%<br /> SQLManager myManager = SQLManager.getInstance();<br /> Connection myConn = myManager.requestConnection();<br /> Statement st = myConn.createStatement();<br /> ResultSet rs = st.executeQuery("select * from employee");<br /> if (rs != null)<br /> {<br /> while (rs.next())<br /> {<br /> String eid = rs.getString("empid");<br /> String name = rs.getString("lastname") + ", " + rs.getString("firstname");<br /> String extention = rs.getString("extention");<br /> %>





<%<br /> }<br /> }<br /> st.close();<br /> myManager.returnConnection(myConn);<br /> %>
ID Name Extention
<%=eid %> <%=name %> <%=extention %>


</body>
</html>
Please anybody can tell me what's wrong ...
Thanks

------------------
** Science belongs to the world **

** Science belongs to the world **
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
posted
0
Quote
Originally posted by Sophia Oscario:
I try to use Pool Manager 2.0 to handle database connection to MySQL from JSP.
But it returns an execption :
Exception Report:
javax.servlet.ServletException: javax/sql/ConnectionEventListener
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:442)
at org.apache.jsp.JDBCtest_jsp._jspService(JDBCtest_jsp.java:123)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:453)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:254)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:194)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2252)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:875)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:952)
at java.lang.Thread.run(Thread.java:484)

Here's My code :
<html>
<head>
<title>JDBC - MySQL</title>
</head>
<%@ page language="java" import="java.sql.*,com.codestudio.util.*" %>
<body>







<%<br /> SQLManager myManager = SQLManager.getInstance();<br /> Connection myConn = myManager.requestConnection();<br /> Statement st = myConn.createStatement();<br /> ResultSet rs = st.executeQuery("select * from employee");<br /> if (rs != null)<br /> {<br /> while (rs.next())<br /> {<br /> String eid = rs.getString("empid");<br /> String name = rs.getString("lastname") + ", " + rs.getString("firstname");<br /> String extention = rs.getString("extention");<br /> %>





<%<br /> }<br /> }<br /> st.close();<br /> myManager.returnConnection(myConn);<br /> %>
ID Name Extention
<%=eid %> <%=name %> <%=extention %>


</body>
</html>
Please anybody can tell me what's wrong ...
Thanks



I can't see you code. Try to resubmit just your code.
Sophia Oscario
Greenhorn

Joined: May 14, 2001
Posts: 22
posted
0
Quote
Sorry,
here is my code :
'<html>
'<head>
'<title>JDBC - MySQL</title>
'</head>
'<%@ page language="java" 'import="java.sql.*,com.codestudio.util.*" %><br /> '<body>
'
'
'
'
'
'
'
'<%<br /> SQLManager myManager = SQLManager.getInstance();<br /> Connection myConn = myManager.requestConnection();<br /> Statement st = myConn.createStatement();<br /> ResultSet rs = st.executeQuery("select * from employee");<br /> if (rs != null)<br /> {<br /> while (rs.next())<br /> {<br /> String eid = rs.getString("empid");<br /> String name = rs.getString("lastname") + ", " + rs.getString("firstname");<br /> String extention = rs.getString("extention");<br /> %>
'
'
'
'
'
<%<br /> }<br /> }<br /> st.close();<br /> myManager.returnConnection(myConn);<br /> %>
'
IDNameExtention
<%=eid %> <%=name %><%=extention %>

'
'</body>
'</html>

------------------
** Science belongs to the world **
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

I like...
Android Eclipse IDE Ubuntu
posted private message
0
Quote
Lets try this:

Hope this is clearer
Dave.

[ JavaRanch FAQ ][ Book Promotions ][ DbTamer ][ BumperStickers ][ JavaRanch Badges ]
Jayanthimeena
Greenhorn

Joined: Jul 24, 2001
Posts: 17
posted
0
Quote
The coding has to look similar to this
String manager = SQLManager.getInstance();
String conn = manager.requestConnection();
String stmt = conn.createStatement();
Resultset rs=null;
rs=stmt.excuteQuery("select * from employee");
if(rs.next())
string one=rs.getString(1);
.
.
.
similarly all
rs.close();
if you are using pool class then it has to be present in correct class path and in currently using "command" or "cmd" promt.
hope this might help you.
Sophia Oscario
Greenhorn

Joined: May 14, 2001
Posts: 22
posted
0
Quote
Here is my code :

Is there something wrong in it ?

------------------
** Science belongs to the world **
 
 
subject: Pool Manager with MySQL - JSP ... need help
 
Threads others viewed
java.sql.SQLException: Communication link failure: null
NullPointerException
Problem compiling JSPs on Tomcat
logic:iterate pls any body help me
Pool Manager with MySQL JDBC
MyEclipse, The Clear Choice