is the any special issue regarding the insertion in msacess 2007

[javastuden]

Hi all
Is there any special feature to be keep in mind when iserting data to msacess 2007

my problem regarding the insertion executeUpdate is getting op as 1 but when i open the databse's tabel the value i entered progrmicaly is not there

if the same pgm if i put the query to select then the output will be correct

is the any special issue regarding the insertion in msacess 2007


Thank You

[masijade]

Are you closing the statement and connection before checking whether the record is there. With MS Access you must close at least the statement, if not also the connection, before the changes take effect.

[javastuden]

thanks for the reply

i got by bug correcected i didn't close the connection so the problem arise.

in ms acess2007 i set password as opened with open exclusively option and set a password 123456
my config file is

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Config{
public Connection con=null;
public Config(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//String filename = "D://database//Man.mdb";
String filename = "E://sss.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}";
con = DriverManager.getConnection( database ,"","");

/* Class.forName("com.mysql.jdbc.Driver").newInstance ();
con=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=root");*/

}catch(Exception ex){
System.out.println("exception in com.manasa.config-------"+ex);
}


}

}

how the password is set in the url

thank in advence

[masijade]

Use the three argument version of getConnection. See the API docs. But, in any case, doesn't that "password=" tell you anything? And, BTW, that is not a config file.