Dear sir,
I have a problem about using a connection pool in a servlet.I am trying to connect weblogic6.0 to sqlserver7.0 trough connection pooling.But 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
------------------