insert statement is not working

[deepak mehta]

import java.sql.*;
class studentConnection
{
	public static Connection getConnection()
	{
		Connection con=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:student","","");
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
		return con;
	}
	public static ResultSet executeQuery(String stSQL)throws Exception
	{
		Connection cn=getConnection();
		Statement st=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		ResultSet rs=st.executeQuery(stSQL);
		return rs;
	}
	public static int executeUpdate(String stSQL)throws Exception
	{
		Connection cn=getConnection();
		Statement st=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		int n=st.executeUpdate(stSQL);
		st.close();
		return n;
	}
	public static void main(String ags[])
	{
		studentConnection c=new studentConnection();
		try{
		
	/*	ResultSet rs=c.executeQuery("select * from tblstud");
		rs.first();
		rs.next();
		System.out.println(rs.getString(2));*/
		
		int m=c.executeUpdate("insert into tblstud (Studid,Name,Age) values(19,'vikram',89)");
		System.out.println(m);
		
		}catch(Exception ex)
		{
			System.out.println(ex.getMessage());
		}
	}
}

insert statement is not working it is not giving any error
it giving correct result when i giving select statement
thanks
from
deepak mehta

[Paul Sturrock]

nsert statement is not working it is not giving any error
it giving correct result when i giving select statement

I'm confused - you say the insert is not working, but you can select the data as expected? Can you explain?

[Smitesh Shinde]

Deepak,
What is the values printed when you do

 System.out.println(m);  

If it is non-zero then definitely your insert statement is working. I guess

it giving correct result when i giving select statement

means when you execute select you can actually see the data which you are trying to insert. If this is the case how can you say that your insert statement is not working?

[Tim McGuire]

Paul Sturrock wrote:

nsert statement is not working it is not giving any error
it giving correct result when i giving select statement

I'm confused - you say the insert is not working, but you can select the data as expected? Can you explain?

I think he means that when he uses the commented out "select" statement in his code, he gets some results. In other words, his connection works.

This code works fine for me. The only thing I can think of is that you are trying to insert a duplicate key and are somehow not seeing the error message.

[wang lei]

what is the reason for this error?

[deepak mehta]

select statement is working
connection made to database successfully but when i inserting it is returning n=1 but when i saw in the database for changes no changes occured in database table
please please solve it
from
Deepak Mehta

[Tim McGuire]

deepak mehta wrote:select statement is working
connection made to database successfully but when i inserting it is returning n=1 but when i saw in the database for changes no changes occured in database table
please please solve it
from
Deepak Mehta

is it possible that these transactions are not being committed? This used to happen to me sometimes that the insert would run and I'd check it with a select and not see the new data.... and then remember to issue a commit.

[prasenjitkumar das]

try class loader with "newInstance()" method.

i.e.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

Regards,
Prasenjit

[Paul Sturrock]

prasenjit.svnit das wrote:try class loader with "newInstance()" method.

i.e.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

Regards,
Prasenjit

Why?