1. Yuri Denshchik
  2. PowerBuilder
  3. Monday, 31 July 2017 20:59 PM UTC

We found that PB provides support for JDBC connectivity. This could be a great relief for our customers because application may no longer require massive DB client installation in case of DB2 or Oracle. Are there any known limitations that we should know before we add  JDBC support to our app?

Thank you,

Yuri

Brad Mettee Accepted Answer Pending Moderation
  1. Tuesday, 1 August 2017 14:15 PM UTC
  2. PowerBuilder
  3. # 1

You're confusing JDBC, which is a different layer from the database driver, with the database driver itself. You can't connect to an Oracle DB without an Oracle driver of some type. JDBC is a glue layer just like ODBC, and only provides an interface between your app and the database driver itself. It's not designed to replace a database driver.

Comment
  1. Yuri Denshchik
  2. Tuesday, 1 August 2017 15:30 PM UTC
That is not correct. Oracle JDBC is a driver itself. It does not need anything else to be installed, just a "oracle driver.jar file to be included into the classpath. Same for SQL Server

  1. Helpful
There are no comments made yet.
Mike S Accepted Answer Pending Moderation
  1. Monday, 31 July 2017 22:09 PM UTC
  2. PowerBuilder
  3. # 2

for oracle, you can use the instant client.  much much smaller.

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 31 July 2017 21:20 PM UTC
  2. PowerBuilder
  3. # 3

I would recommend you use ADO.NET or ODBC rather than JDBC since the stated direction for PB is .NET rather than Java.  That doesn't mean we have plans to discontinue JDBC support, but if you are investing to switch to a different DB interface it would be prudent to go with a different DB interface.

Comment
  1. Miguel Leeuwee
  2. Thursday, 7 September 2017 01:16 AM UTC
Please keep supporting JDBC yes.



We are starting to offer TmaxSoft's Tibero as a database solution for our applications and so far their best connection is with JDBC



MiguelL

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.