aspose file tools*
The moose likes JDBC and the fly likes Connection Pooling Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Pooling Problem" Watch "Connection Pooling Problem" New topic
Author

Connection Pooling Problem

Bikash Paul
Ranch Hand

Joined: Dec 04, 2001
Posts: 342
Dear sir,
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>
With regards
Bikash

------------------
Bikash Paul
Ranch Hand

Joined: Dec 04, 2001
Posts: 342
Hi,
I forgot to write iam trying to connect weblogic6.0 to sqlserver7.0 through connection pooling.Iam trying to enter data from html from through servlet.
Thanks for ur valuable Time
Bikash
------------------
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Since this question is already in this forum HERE and I already fixed the formatting of that version, I'm going to close this thread.
Dave.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Pooling Problem