Re: weblogic connection pool.

Wed, 25 Apr 2001 16:41:38 -0700 

Hello,

   The driver class name with the package structure is

"weblogic.jdbc.pool.Driver" and not
"weblogic.jdbc.pool.driver"
                    ^
Thanks,
Madhava


--- Charu Gupta <[EMAIL PROTECTED]> wrote:

<HR>
<html><DIV>Hi,</DIV>
<DIV>I&nbsp; am working on a jsp application which has
oracle database at the backend.</DIV>
<DIV>I am trying to get a connection from the
connection pool but am getting the following
compilation error which I can not resolve, please
help(I have pasted my jsp code after the error
message.)</DIV>
<DIV>&nbsp;</DIV>
<DIV>ERROR:</DIV>
<DIV>&nbsp;
<H3>From RFC 2068 <I>Hypertext Transfer Protocol --
HTTP/1.1</I>:</H3><FONT face=Helvetica size=3>
<H4>10.5.1 500 Internal Server Error</H4></FONT>
<P><FONT face="Courier New">The server encountered an
unexpected condition which prevented it from
fulfilling the request</FONT></P>
<P><FONT face="Courier New"></FONT>&nbsp;</P>
<P><FONT face="Courier New">JSP code:</FONT></P>
<P>&lt;%!</P>
<P>&nbsp;&nbsp;
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Driver
poolDriver = null;<BR>&nbsp;&nbsp;&nbsp; Properties
props = null;<BR>&nbsp;&nbsp;&nbsp;
<BR>&nbsp;&nbsp;&nbsp; public Connection
getConnection()<BR>&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Connection conn = null;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
try<BR>&nbsp;&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
if(poolDriver ==
null)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
poolDriver=(Driver)Class.forName("weblogic.jdbc.pool.driver").newInstance();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
props = new
Properties();<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
props.put("connectionPoolID",
"oraclePool");<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
}<BR>&nbsp;&nbsp;&nbsp;&nbsp;
}<BR>&nbsp;&nbsp;&nbsp;&nbsp; catch(Exception
ex)<BR>&nbsp;&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return
null;<BR>&nbsp;&nbsp;&nbsp;&nb!
sp; }<BR>&nbsp;&nbsp;&nbsp;&nbsp;
try<BR>&nbsp;&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; conn =
poolDriver.connect("weblogic.jdbc.pool.driver",props);<BR>&nbsp;&nbsp;&nbsp;&nbsp;
}<BR>&nbsp;&nbsp;&nbsp;&nbsp; catch(SQLException
ex)<BR>&nbsp;&nbsp;&nbsp;&nbsp;
{<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return
null;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
}<BR>&nbsp;&nbsp;&nbsp;&nbsp; return
conn;<BR>&nbsp;&nbsp;&nbsp; }<BR>&nbsp;&nbsp;
%&gt;<BR>&nbsp;&nbsp; &lt;%&nbsp;&nbsp;
<BR>&nbsp;&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp;
<BR>&nbsp;&nbsp;&nbsp;&nbsp; Connection tconn =
getConnection();<BR>&nbsp;&nbsp;&nbsp;&nbsp; Statement
stmt =
tconn.createStatement();<BR>&nbsp;&nbsp;&nbsp;&nbsp;
ResultSet rset = stmt.executeQuery("select * from
po_user");</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;
while(rset.next())<BR>&nbsp; {</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;
%&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;TR&gt;&lt;TD&gt;&lt;%= rset.getString("USER_PASS")
%&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/TD&gt;&lt;/TR&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
&lt;%<BR>&nbsp;&nbsp;&nbsp;&nbsp;
}<BR>&nbsp;&nbsp;&nbsp;&nbsp;
stmt.close();<BR>&nbsp;&nbsp;&nbsp;&nbsp;
tconn.close();</P>
<P>%&gt;</P>
<P>&nbsp;</P>
<P>&nbsp;</P>
<P>Thanks. </P>
<P>&nbsp;</P></DIV><br clear=all><hr>Get Your Private,
Free E-mail from MSN Hotmail at <a
href="http://www.hotmail.com";>http://www.hotmail.com</a>.<br></p></html>

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED]
and include in the body
of the message "signoff SERVLET-INTEREST".

Archives:
http://archives.java.sun.com/archives/servlet-interest.html
Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to