Main Page

From JDBWC Database Driver
Jump to: navigation

JDBWC Description

The Basic JDBWC Concept

NOTES: This projects source was last updated during mid 2012. I haven't had the opportunity to do further work on the source since then, but do have a sketchy roadmap for the next version that I will publish at some point.
Regards,
TG (2018-11-15).

JDBWC is a Type-3 JDBC Driver, written in Java for connecting to a range of database types across computer networks. Supported databases are MySQL and PostgreSQL with plans for more. Suited to Java applications that require JDBC access across networks like the internet or a local lan but do not wish to expose the remote database-server through the remote hosts firewall. JDBWC is an acronym for Java-Data-Base-Web-Connector. JDBWC has its own middleware server-written-in-PHP which is where the Web-Connector part of the name comes from.

JDBWC is open-source and currently released under the GNU General Public License.

Features

  • JDBC Driver.
  • Works with multiple database types.
  • Designed to work around firewalls.
  • Network Driver with SSL Support.
  • Advanced multiple ResultSet handling.

Brief Specifications

The JDBWC Driver connects a Java application to a hosts database using PHP. The web-server does not need to be running Java or application servers and its databases can be completely hidden by the hosts firewall.

JDBWC is a 2 part system consisting of a Java JDBC driver and a lightweight PHP based server. The driver can connect to a range of different database servers and communicate across computer networks (including the internet).

SSL connections are supported and recommended. The URL protocol is specified when creating a new JDBC connection (https, http, etc.).

The Driver is suitable for communicating with shared, virtual and dedicated web-server platforms and in most cases doesn’t require any special settings or software to be installed on the web-server except PHP and the lightweight JDBWC server. The PHP portion has tight security as it’s designed to be exposed to public networks.