Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does PowerBuilder support Oracle s JDBC-compliant Thin driver and OCI driver via JDBC JDB/JDS/JDM?

April 26, 2017driver jdb JDBC OCI Oracle powerbuilder s support

0

Posted

Does PowerBuilder support Oracle s JDBC-compliant Thin driver and OCI driver via JDBC JDB/JDS/JDM?

1 Answer

0

Posted

We support both the Thin and the OCI drivers. The Thin driver is preferable because the OCI driver routes all JDBC calls through C/C++ to access the OCI API. However, both drivers should work. Q: When should I use the JDM interface and when should I use the JDS or JDB interface? A: When you are developing a DataWindow object to be used in a DataWindow Web control for Microsoft ActiveX in PowerBuilder 8.0, you can use the JDM or JDB version of the JDBC interface. For PowerBuilder 9.0 and 10, use the JDB interface. Q: Is there a tool that PowerBuilder provides to trace any database connection through the JDBC interface? A: Yes, the JDBC Driver Manager Trace tool is used to trace any database connection that you access in PowerBuilder through the JDBC interface. The trace tool is also available on all supported PowerBuilder platforms. The JDBC Driver Manager Trace logs errors and informational messages originating from the Driver object currently loaded (such as Sybase’s jConnect JDBC dri