1. Olan Knight
  2. PowerBuilder
  3. Thursday, 19 May 2022 14:23 PM UTC

PB2019R3, b2703
Window 10, 64 bit platform, VM


What is the way to integrate JDBC into the Database Painter?

We have installed Zulu Java, it's our replacement for Sun Java --> Oracle Java --> no longer free.
We have instaledd EBD PostgreSQL as our new database.
I just installed the EDB JDBC driver, then added the location of the JAR file to the PATH. I also created a CLASSPATH = jar file path,

Opened PB and expanded the JDBC section. Nada.

This is a list of our PostgreSQL databases using an ODBC driver.


   I kind of expected to see a JDBC administrator, like the ODBC administrator, but apparently that's not a real tool.  :(

   Anyway, I want to open the PostGresql databases using the JDBC driver inside the PB DB Painter in order to do some performance testing/comparisons. How do I do this?


Thank You,
Olan


~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Zulu Java:


EDB JDBC:


Tools used to install PG drivers and Zulu Java:












Accepted Answer
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 19 May 2022 17:09 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Olan,

DON'T !

Appeon is dropping all support for JDBC connections in the (soon) coming release.

Here's some extra information: 

https://docs.appeon.com/pb2019/connecting_to_your_database/ch03s01.html

https://community.appeon.com/index.php/qna/q-a/could-not-initialize-javavm-pb19-converted-from-pb12-jdbc-connection-not-working-in-deployment

regards.

MiguelL

Comment
  1. Miguel Leeuwe
  2. Thursday, 19 May 2022 21:09 PM UTC
- Did you install the Zulu Java 32 bit driver?

- Did you add the necessary information in the Java tabpage within "Tools > System Options"?

  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 May 2022 17:05 PM UTC
  2. PowerBuilder
  3. # 1

For Postgres I recommend to use ODBC for two reasons: 1) ODBC is the officially supported interface to Postgres, and 2) Java support has been discontinued in PB 2022 and newer.  

Comment
  1. Olan Knight
  2. Friday, 20 May 2022 13:37 PM UTC
Wow! Thanks for the info, Armeen.

May I ask why we would drop support for JDBC?



Thanks,

Olan
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 20 May 2022 15:08 PM UTC
Not much demand for Java features. Upkeep is extremely expensive with all the security problems.
  1. Helpful 2
  1. Miguel Leeuwe
  2. Saturday, 21 May 2022 03:31 AM UTC
Actually that's a very valid point Armeen.
  1. Helpful 1
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.