java - Microsoft Excel as SQL Database -

java - Microsoft Excel as SQL Database -

i have followed instructions provided in website content 5.3 , code works fine.

my plan create jar file (containing interface/gui), distribute jar file users, , have them read/write info should 1 excel file. when place excel file in local drive works, when place file in network folder/server, java creates problem:

java.exe has encountered problem , needs close. sorry inconvenience.

or

java result: -1073741811

any suggestions? give thanks you

public class testintoexcel { public string s; public double number; public date d; public void display()throws classnotfoundexception, sqlexception { class.forname("oracle.jdbc.driver.oracledriver"); connection writeconnection = drivermanager.getconnection ("jdbc:odbc:usersavedataodbc"); writeconnection.setreadonly(false); statement writestatement = writeconnection.createstatement(); writestatement.executeupdate("create table test_insert(col1 int,col2 varchar(10),col3 date)"); preparedstatement writestatement2 = writeconnection.preparestatement("insert test_insert(col1,col2,col3)values(?,?,?)"); for(int = 0; i<3;i++) { writestatement2.setdouble(1, i); writestatement2.setstring(2, "row" + i); writestatement2.setdate(3, new java.sql.date(new date().gettime())); writestatement2.execute(); } string query = "select *from[test_insert]"; resultset rset = writestatement.executequery(query); //system.out.println(rset); while(rset.next()) { number = rset.getdouble("col1"); s = rset.getstring("col2"); d = rset.getdate("col3"); system.out.println(number+"\n"+s+"\n"+d); } writestatement.close(); writestatement2.close(); writeconnection.close();

java excel odbc