The DBF-xBase-FoxPro JDBC driver is provided by DbSchema DBF Designer
- Connect to DBF files
- Execute SELECT with JOINS, WHERE, GROUP BY, ORDER BY queries
- INSERT, UPDATE, DELETE data
- Create new tables, add or remove columns, etc.
jdbc:dbschema:dbf:?[charset=ISO_8859_1]
Connection con = DriverManager.getConnection( "jdbc:dbschema:dbf:/sample_dbf_folder" );
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from cars")
while( rs.next() ){
....
}
The driver loads all DBF data into an H2 cache database stored in <user.home>/.DbSchema/dbf-jdbc-driver/ The data can be modified, any kind of queries can be executed. To save back data to dbf files use:
Statement st = connection.createStatement();
st.execute("save dbf to <folder_path>");
We save data to a different path, just to avoid any storage issues and don't loose any information. We appreciate any contributions to this repository.
BSD License-3. Free to use, distribution forbidden. Improvements of the driver accepted only in https://bitbucket.org/dbschema/dbf-jdbc-driver.
The driver can be tested by downloading and installing DbSchema DBF and FoxPro Designer. DbSchema can be evaluated 15 for free.
There is no need to register or download the driver - DbSchema will do everything for you.
After connecting DbSchema will reverse engineer the database structure and show it as diagrams.
Use the Query Editor to execute queries with JOINS, GROUP BY and ORDER BY.
Use the Relational Data Browse to explore data from multiple tables simultaneously. DbSchema can create virtual foreign keys which will be used in the Data Browse.
