Consultor Eletrônico



Kbase P150836: Why does Java needs to be installed on the Progress Database Server When ODBC Client connects to thi
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   08/09/2009
Status: Unverified

GOAL:

Why does Java needs to be installed on the Progress Database Server When ODBC Client connects to this database?

GOAL:

Why do I need Java with sql-92 ODBC applications?

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x

FIX:

ODBC, JDBC and ESQL clients are all sql-92 clients which are serviced by the sql-92 server on the database server, sqlsrv2. Stored procedures are compiled into Java stored procedures by the sql-92 server and are executed by the JVM linked to the sql-92 server. This is the reason it is necessary to have the database server machine install Java: so it can be linked with sqlsrv2.
Java is not needed on the client machine unless JDBC is used.