Hi all,
I'm Tony. I've got a trouble when trying to connect to FoxPro DB using
JDBC ODBC Bridge.
I create an ODBC bridge on System DSN with:
Here's my coding:
try {
// load driver...
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
// create connection...
String url = "jdbc:odbc:TestDBF";
Connection con = DriverManager.getConnection(url);
//
test sql prepared statement...
String sql = "SELECT count(*) as count_result FROM USERS";
PreparedStatement stmt = con.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
int count = 0;
while(rs.next()) {
count = rs.getInt("count_result");
System.out.println(count);
}
rs.close();
stmt.close();
con.close();
}
catch(Exception exc) {
exc.printStackTrace();
}
It run properly if I deploy as a
Java Application.
But when I deployed on Web Application using WebSphere Application Server 6.0, it throws the errors:
- java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]File 'users.dbf' does not exist.