FAQ's - APPX Software, Inc.: Our developers wants to know if Appx has Dharma JDBC Driver?

APPX Knowledge Base Support answers, product how-tos, and troubleshooting guidance

Back to appx.com

FAQ's - APPX Software, Inc. :

APPX Utility :

APPX System Administration :
Our developers wants to know if Appx has Dharma JDBC Driver?

Appx doesn't have Dharma JDBC driver, but does have Dharma ODBC driver. Depends on what users are trying to do/access. The AppxODBC driver (Dharma ODBC) lets you read/write Appx-hosted data (that is, data stored in an AppxIO file) from some other application, i.e. Access, SQL, Postress or Oracle.
You can certainly use the AppxODBC driver with a Java program. AppxODBC will function as a type 1 JDBC driver. A type 1 driver uses the JDBC/ODBC bridge to connect a Java application to an ODBC data source (a very common practice). Type 1 drivers don't perform as well as a type 4 driver, but that may not be a problem (in fact, given the performance of a typical Java application, the difference between a type 1 driver and a type 4 driver may be undetectable).
When you use the JDBC/ODBC bridge, the JDBC URL is structured like this:

 jdbc:odbc:appxodbc

If you want to include the username and password in the URL:

 jdbc:odbc:appxodbc;UID=appx;PWD=password

2005-Feb-08 9:11am

Previous:	List of Environmental Variables
Next:	Is there an environment variable that records a log of the user interface?

This document is: https://faq.appx.com/cgi-bin/fom.cgi?file=552

	[Search]	[Appearance]
This is a Faq-O-Matic 2.719.