JDBC Problem

[nitishjtm]

Hi, I am Nitish Kumar. I have written the following program of jdbc:

package nitish.jdbc.first;
import java.sql.*;
import java.util.*;

public class JdbcEx1{
public static void main(String []s){
try{
Class c = Class.forName("oracle.jdbc.driver.OracleDriver");
Driver d = (Driver)c.newInstance();
Properties p = new Properties();
p.setProperty("user","scott");
p.setProperty("password","tiger");
Connection con = d.connect("jdbc:oracle:oci8@xe",p);
Statement st = con.createStatement();
String query = "insert into student_details values(1,'Nitish',5000);";
int recordsInserted = st.executeUpdate(query);
System.out.println("Record Inserted::"+ recordInserted);
}//try
catch(ClassNotFoundException cnfe){}
catch(InstantiationException ine){}
catch(IllegalAccessException iae){}
catch(SQLException sqle){}
}//main
}//class

The problem is that I am not getting the output. Means I am unable to connect to the database. When executing this program, it returns nothing. Instead, it should return an integer value. Even I changed the drivers also, but that also didn't help me. I am using Oracle 10g Enterprise Edition release 2. Please suggest me what to do.

Thank you

[masijade]

Well, don't ignore exceptions. Add a printStackTrace to everyone of those catch blocks. How do you think to ever hear the siren when you've plugged your ears?

[nitishjtm]

Well, don't ignore exceptions. Add a printStackTrace to everyone of those catch blocks. How do you think to ever hear the siren when you've plugged your ears?

Thanks, but the problem was due to ; which I inserted in the last of query. Now, I always use behaviors to catch the exceptions.

[masijade]

Thanks, but the problem was due to ; which I inserted in the last of query. Now, I always use behaviors to catch the exceptions.

And actually placing something in the catch blocks would have told you that.

Edit: And, BTW, I have no idea what you mean by

Now, I always use behaviors to catch the exceptions.

. If you mean some API designed to allow you to "ignore" exceptions in your coding and still be able to handle them, then it sounds like a simple crutch for someone not willing to do the work properly. If that's not what you mean, then I'm sorry I said that, but I thought it needed to be said, if that is what it is.

[nitishjtm]

Edit: And, BTW, I have no idea what you mean by . If you mean some API designed to allow you to "ignore" exceptions in your coding and still be able to handle them, then it sounds like a simple crutch for someone not willing to do the work properly. If that's not what you mean, then I'm sorry I said that, but I thought it needed to be said, if that is what it is.

Extremely sorry sir, I did't wrote clearly. I mean to say, I use printStackTrace() or getMessage() for getting description of exception.