JDBC instead of ODBC
Bernard Devlin
revolution at knowledgeworks.plus.com
Sat Oct 4 15:02:01 EDT 2003
>>But what about all those database engines that can use JDBC?
Todd, maybe you are thinking of things in the converse. Are you seeing
Rev stacks as databases, and asking for a JDBC driver so that people could
connect to a stack from a Java application? That is the only sense in
which the databases you mention have JDBC drivers - so that Java
applications can connect to them.
Rev uses ODBC in the opposite way - that is, so that Rev _applications_
can connect to these _other_ databases.
The Rev drivers for Oracle, MySQL, Valentina etc. are the Rev equivalents
of the JDBC drivers - drivers which enable an application to make direct
(network) calls to a database (that may be local) from within the
application.
With the databases you cite, the JDBC drivers are provided (effectively)
by the database providers to enable Java applications to communicate with
their DB.
As for Rev apps, there is only really three ways to interface with an
external database:
1) the Runrev-supplied drivers
2) ODBC (or maybe a JDBC-ODBC bridge, although usually they are the other
way round)
3) Shelling out to a command line SQL processor
I expect some more imaginative individual may come up with others....
Regards,
Bernard
More information about the use-livecode
mailing list