> Dear sir,
>
> I have a problem about using a connection pool in a
> servlet.Server giving
> error(java.sql.SQLException:Pool
> cnnect failed:weblogic.common.ResourceException:None
> available).I create a new connection pool name
> Pool.Iam using sqlserver7.0.In Jdbc connection pool
> section in URL
> section:-jdbc:weblogic:pool:biku(where
> biku is my system DSN name)in Driver
> classname:-weblogic.jdbc.pool.Driver.In key=value
> section(user=sa
> password=none because in sqlserver there is no
> password).And in "target" section I chosen
> myserver.Please guide me where I done a mistake.
> Following r my codes:-
>
> It is my servlet file:-
> ------------------------
> import java.io.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.util.*;
> import java.sql.*;
>
> public class Pool extends HttpServlet
> {
> String queery,queery1=null;
> public void doPost(HttpServletRequest
> req,HttpServletResponse res)
> throws
> ServletException,IOException
>
> {
> Connection
> con=null;
> ResultSet rs=null;
> Statement
> stmt=null;
> PrintWriter out =
> res.getWriter();
>
> res.setContentType("text/html");
> String
> str1=req.getParameter("Name");
> String
> str2=req.getParameter("Password");
> String
> str3=req.getParameter("Address");
> String
> str4=req.getParameter("ContactNo");
> out.println(str1);
> out.println(str2);
> out.println(str3);
> out.println(str4);
> try
> {
> Driver myDriver=(Driver)
>
>
Class.forName("weblogic.jdbc.pool.Driver").newInstance();
> }
> catch(Exception e)
> {
> System.out.println("Error from
> Driver:" +
> e.toString());
> }
> try
> {
>
>
>
con=DriverManager.getConnection("jdbc:weblogic:pool:Pool",null);
>
>
> }
> catch(Exception e)
> {
> System.out.println("Error from
> getConnection:" +
> e.toString());
> }
>
>
> try
> {
> stmt=con.createStatement();
> }
> catch(Exception e)
> {
> System.out.println("Error from
> Statement:" +
> e.toString());
> }
> try
> {
> queery="INSERT INTO TABLE3
> (Name,Password) VALUES
> ('"+str1+"',"+str2+")";
>
> }
> catch(Exception e)
> {
> System.out.println("Error from
> sqlStatement:" +
> e.toString());
> }
> try
> {
> stmt.executeUpdate(queery);
>
> }
> catch(Exception e)
> {
> System.out.println("Error from
> Excecution:" +
> e.toString());
> }
>
> try
> {
> queery1="INSERT INTO TABLE4
> (Address,ContactNo)
> VALUES ('"+str3+"',"+str4+")";
>
> }
> catch(Exception e)
> {
> System.out.println("Error from
> sqlStatement:" +
> e.toString());
> }
> try
> {
> stmt.executeUpdate(queery1);
>
> }
> catch(Exception e)
> {
> System.out.println("Error from
> Excecution:" +
> e.toString());
> }
>
> }
> }
>
>
> It is my html file:-
> -----------------------<html>
> <head>An example</head>
> <title>Test</title>
> <body>
> <form method="post"
> action="http://127.0.0.1:7001/Start5";>
> <b><i>Enter Your Name</i></B>
> <input type="text" name="Name" size="25"><br>
> <b><i>Enter Your Password</b></i>
> <input type="password" name="Password"
> size="25"><br>
> <b><i>Enter Your Address</i></B>
> <input type="text" name="Address" size="25"><br>
> <b><i>Enter Your ContactNo.</b></i>
> <input type="text" name="ContactNo" size="25"><br>
> <input type="Submit" value="Submit">
> <input type="Reset" value="Reset">
> </form>
> </body>
> </html>
> With regards
> Bikash
>
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.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
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.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
