Retrieval problem

[pardhu]

Dear frnds,
I have created a table and inserted rows into it using insert query.
When I am trying to retrieve them using them I'm not getting them.

MY PROGRAM


import java.sql.*;
class imp
{
public static void main(String args[])throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:pardhu" ,"scott","tiger");
System.out.println("connection established");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from mca");
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
}
}
}

If I am using a java program to insert rows into the table, I am able to retrieve them.
But If I am inserting the rows using insert query, I am not able to retrieve the rows.

Can anyone help me plz......

[Mithilesh]

Create DSN as you mentioned in your program and then you must do commit after inserting some rows in database .After that you try to run this program hopefully it will work.

[Tolls]

Please use [code] tags [/code] when posting code.

What database are you using?
Is the above code throwing an exception? If so, what is the full exception including stack trace.
If not then are you seeing any data at all?