Thanks, Kyle and William,
That make sense! Good to know I am choosing the right side(.net vs
java).
In the end, I found a way to get aroud with that problem, see below:
///////////////////////////////////
//change DBQ and sql statement as your
//local setting
package database;
import java.io.*;
import java.sql.*;
public class MobileDatabase {
public static void main(
String[] args) {
try {
//Load JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dbUrl =
"jdbc
dbc
river={Microsoft Access Driver (*.mdb)};UserCommitSync=Yes;Threads=3;SafeTransactions=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=MS Access;DriverId=281;DBQ=d:\\Kevin\\WSAD\\KevinTest.mdb";
Connection con = DriverManager.getConnection(dbUrl, "", "");
Statement state =
con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "SELECT document_name FROM Document;";
ResultSet rs = state.executeQuery(sql);
if (rs != null) {
while (rs.next()) {
System.out.println("\t" + rs.getString("document_name"));
}
rs.close();
con.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
////////////////////////
It works, but that's not the exact what I want to do: setting up DataSource in WSAD. Guess I will use another DBMS in WSAD for using that.
Kevin
