J2EE server not connecting to database

Greenhorn

Posts: 25

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
//import javax.sql.*;
import java.sql.*;
 
public class Hello extends HttpServlet 
{
Connection dbcon=null;
int regno=0;

public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
{

try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbcon=DriverManager.getConnection("jdbc   :-o	   dbc:nirmaldb", "Admin", "");
System.out.println("Connection established");
}catch(ClassNotFoundException e)
{
System.out.println("Database driver not found");
System.out.println(e.toString());
}

catch(Exception e)
{
System.out.println(e.toString());
}

res.setContentType("text/html");
PrintWriter out=res.getWriter();
String firstname=req.getParameter("firstname");
String lastname=req.getParameter("lastname");
String address=req.getParameter("address");
String accounttype=req.getParameter("account");
String income=req.getParameter("income");
String phonenumber=req.getParameter("phonenumber");
//int annualincome=0;
//Integer temp=Integer.valueOf(income);
//annualincome=temp.intValue();

int rows=0;
try
{
PreparedStatement s=dbcon.prepareStatement("insert into registration
 (cFirst_name, cLast_name, cAddress, cAccount_type, mAnnual_income, 
cPhone_no) values (?, ?, ?, ?, ?, ?)");
s.setString(1, firstname);
s.setString(2, lastname);
s.setString(3, address);
s.setString(4, accounttype);
s.setString(5, income);
s.setString(6, phonenumber);
rows=s.executeUpdate();
}
catch(Exception e)
{
System.out.println(e.toString());
}
if(rows==0)
{
System.out.println("Error inserting data in the registration table");
}
else
{
System.out.println("The values have been inserted in the table successfully");
}
//String regno=new String(" ");
try
{
PreparedStatement s=dbcon.prepareStatement("select max(cRegistration_id) from registration");
ResultSet r=s.executeQuery();
r.next();
regno=r.getInt(1);
}
catch(Exception e)
{
System.out.println(e.toString());
}
out.println("<html>");
out.println("<head><title>Online Banking with Earnest</title></head>");
out.println("<body bgcolor=pink>");
out.println("Thank you for registering in our web site " + firstname);
out.println("<br>");
out.println("Your registration ID is: <b> " + regno +"</b>");
out.println("<br>");
out.println("</body></html>");
try
{
dbcon.close();
}
catch(Exception e)
{
System.out.println(e.toString());
}
}
}

The above is my code which works using Tomcat Server, but while using J2EE server it gives error message as client code at null in the command prompt.
Please help me. Thank you in advace.

Nirmal Jeya Chandra

[edited to add code tags]
[ October 09, 2005: Message edited by: Jeanne Boyarsky ]

Jeanne Boyarsky

author & internet detective

Posts: 42154

937

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Nirmal,
Welcome to JavaRanch!

What error message are you getting in the logs? I suspect it is a classpath issue if it works in one server and not another. Double check the JDBC driver is in your classpath.

I recommend changing the code to do everything in one try/catch block. If you can't load the driver, do you really want to attempt a database connection? This leads to confusing error messages.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Nirmal JeyaChandra

Greenhorn

Posts: 25

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks a lot for your reply.

Actually, I did not place the class file, which has the JDBC statements in the j22ee/lib/classes folder. This was the mistake.

Now I got the database connectivity. Everything is working fine.

Jeanne Boyarsky

author & internet detective

Posts: 42154

937

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Nirmal,
Glad to hear it is working. Thanks for sharing the solution with us.

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?