• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem with Connection Pooling

 
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

------------------
 
mister krabs
Posts: 13974
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Run away! Run away! Here, take this tiny ad with you:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic