DataBrowser is a cross-database, cross-platform data access tool written entirely in Java. The project is stable, feature rich, and mature (initially released in 1999).
Here are some key features of "DataBrowser":
· 100% Java, compatible with Java 2 versions 1.4 and 1.5.
· Connect to ANY database with a JDBC driver. (user must supply JDBC compliant drivers)
· Connectors included for ODBC, Oracle, DB2, PostgreSQL, MS SQL Server, MySQL, InstantDB,
· Generic connector will work with literally any driver
· Maintains a list of recent connections, so you donýt have to constantly re-type connection information.
· Browse a databaseýs tables and view schemas in an intuitive treeview
· Limit your browsing to a particular catalog, schema, or type
· Right click to view typical data in a given table
· Open multiple browser windows connected to various different databases. You can browse Oracle, Access, SQLServer and DB2 all at the same time.
· Syntax-highlighting sql editor.
· Add data to tables with a GUI interface.
· Update data in tables.
· Dynamic SQL Support
· Execute any SQL statement
· Save complex SQL with a "SQL Bookmark" for later use.
· Easy to use interface allows less technical users to browse enterprise databases. Much easier to use than SQL Plus, DB Access, while at the same time more lightweight than MS Access.
· Use in the course of software development to develop queries, then simply copy and paste your query into your code.
· Java 1.4.2 or later
What's New in This Release:
· This release adds SQLLog to DataBrowser, and now logs all SQL statements executed over time to an internal HSQL database.