Hi,I have tested and not found any problem.
The follows is the datasource configuration part in the server.xml .
factory
com.hxtt.sql.HxttObjectFactory
subprotocol
DBF
database
f:/DBFfiles
And here is my code in my jsp file.
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
DataSource ds1 = (DataSource) envContext.lookup("jdbc/testDBFPool3");
Connection conn1 = ds1.getConnection();
out.println("testDBFPool1 OK:) ");
PreparedStatement stmt1 = conn1.prepareStatement("select * from test where testfield=?");
stmt1.setString(1,"644");
ResultSet rs1 = stmt1.executeQuery();
while (rs1.next())
out.println(rs1.getString(1) + ":) ");
You can download the latest HXTT Package to solve this issue.
|