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()); }
} 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
0
