MyJSQLView provides an easy to use Java based interface for viewing, adding, editing, or deleting entries in a HSQL, MySQL, Oracle, or PostgreSQL database.
All user tables and basic data type fields are available for access in the selected database. MyJSQLView only needs two other pieces of code, the Java Runtime Environment, and a Java Database Connectivity driver. The JDBC provides the interface between the Java SQL statements, and the database.
The JDBC driver for MySQL is called Connector/J, for Oracle just JDBC, and PostgreSQL JDBC3. The HSQL database has an integrated JDBC that is part of the application. The Connection Manager for MyJSQLView has been given default entries to help the user select the proper configuration for the desired database access.
The capability to connect to other databases has been fully build into the core architecture. The application has been purposely built to provide data access and is not a database management tool. All users including small to medium size businesses will find setup and using the tool to be simple and straight forward.
MyJSQLView once installed can provide a much quicker access/update to a database than a web based interface frontend and MyJSQLView supports transaction locking. If you want to quickly access a local or server based database for viewing, editing, and searching MyJSQLView provides an alternative that is simple and easy to use.
What's New in This Release:
· Bug fix for CSV imports of single digit month fields. Feature additions of LIMIT Control over CSV Summary Table Exports and overall interface font sizing. Finnish and Hebrew language support.