Inserting Data Into MS Access Thru JDBC

[sujitopics]

Hi Friends

Can Anybody give Insertion Query to insert data into MS ACCESS Database thru JDBC Application

I am using the following Query

st.execute("insert into Testaccess values ('abcde','abcde')"

But the above query is not inserting data into ms access

Thanksinadvance

Yours
Rajesh

 

[Reddy316]

Hi,
There is nothing wrong with that query, unless u are setting autocommit to false and then not commiting the transaction after the insert. just put a try catch around that statement and then check if there are any sql exceptions being thrown. U could also use the Statement.executeUpdate(String query) method which is the one prescribed for insert, update and delete methods.

Hope this helps,
Reddy316

 

[sujitopics]

I got the Solution for my problem

The Code should be like this to insert the data into ms access 2000 thru jdbc

import java.sql.*;

public class TestAccess
{
public static void main(String[] args)
{
Connection con=null;;
Statement st=null;;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver&quot.newInstance();
System.out.println(" Connected To Jdbc - Odbc Driver"
con= DriverManager.getConnection("Jdbc:Odbc:admin","",""
st=con.createStatement();
try
{
st.executeUpdate("insert into testaccess values ('aa','bb')"
System.out.println("Record Inserted"
}
catch (Exception create)
{
System.out.println("Exception in Inserting "+create);
}
}
catch(Exception e)
{
System.out.println(e);
}
finally
{
try
{
st.close();
con.close();
}
catch (Exception e)
{
System.out.println(e);
}
}
}
}