File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Problem with Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Problem with Connection Pooling" Watch "Problem with Connection Pooling" New topic
Author

Problem with Connection Pooling

Bikash Paul
Ranch Hand

Joined: Dec 04, 2001
Posts: 342
Hi there,
I have a problem about using a connection pool in a servlet.Server giving error(Can't open socket on MyPool:1433.check host and port number and make sure security manager allows this connection.You can also try running Socket Applet(java.net .unknownhostException: MyPool).In Driver classname:-weblogic.jdbc.mssqlserver4.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 how I can slove this problem.I tried but could not find the way."MyPool" is my connection pool name.
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.mssqlserver4.Driver").newInstance();
}
catch(Exception e)
{
System.out.println("Error from Driver:" + e.getMessage());
}
try
{
con=DriverManager.getConnection("jdbc:weblogic:mssqlserver4:MyPool",null);

}
catch(Exception e)
{
System.out.println("Error from getConnection:" + e.getMessage());
}


try
{
stmt=con.createStatement();
}
catch(Exception e)
{
System.out.println("Error from Statement:" + e.getMessage());
}
try
{
queery="INSERT INTO TABLE3 (Name,Password) VALUES ('"+str1+"',"+str2+")";

}
catch(Exception e)
{
System.out.println("Error from sqlStatement:" + e.getMessage());
}
try
{
stmt.executeUpdate(queery);

}
catch(Exception e)
{
System.out.println("Error from Excecution:" + e.getMessage());
}

try
{
queery1="INSERT INTO TABLE4 (Address,ContactNo) VALUES ('"+str3+"',"+str4+")";

}
catch(Exception e)
{
System.out.println("Error from sqlStatement:" + e.getMessage());
}
try
{
stmt.executeUpdate(queery1);

}
catch(Exception e)
{
System.out.println("Error from Excecution:" +e.getMessage());
}

}
}


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">
Enter Your Name
<input type="text" name="Name" size="25">

Enter Your Password
<input type="password" name="Password" size="25">

Enter Your Address
<input type="text" name="Address" size="25">

Enter Your ContactNo.
<input type="text" name="ContactNo" size="25">

<input type="Submit" value="Submit">
<input type="Reset" value="Reset">
</form>
</body>
</html>
Thanks for ur valuable Time
Bikash

------------------
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Let's try the JDBC forum.
------------------
Tom
Sun Certified Programmer for the Java� 2 Platform
Moderator of the forums:
J2EE and EJB
Other Java APIs


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with Connection Pooling