From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request
JSP code:
<%!
Driver poolDriver = null;
Properties props = null;
public Connection getConnection()
{
Connection conn = null;
try
{
if(poolDriver == null)
{
poolDriver=(Driver)Class.forName("weblogic.jdbc.pool.driver").newInstance();
props = new Properties();
props.put("connectionPoolID", "oraclePool");
}
}
catch(Exception ex)
{
return null;
&nb!
sp; }
try
{
conn = poolDriver.connect("weblogic.jdbc.pool.driver",props);
}
catch(SQLException ex)
{
return null;
}
return conn;
}
%>
<%
Connection tconn = getConnection();
Statement stmt = tconn.createStatement();
ResultSet rset = stmt.executeQuery("select * from po_user");
while(rset.next())
{
%>
<TR><TD><%= rset.getString("USER_PASS") %>
</TD></TR>
<%
}
stmt.close();
tconn.close();
%>
Thanks.
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
