Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved PB 2022 (Version 1878) and JDBC connectivity

  1. Issue
0
Votes
Undo
  1. Dhanya K
    Dhanya K
  2. PowerBuilder
  3. Thursday, 4 January 2024 11:42 AM UTC

Hello Team,

We are recently facing one issue in PB2022(Version 1878). We have one feature in our application where we export/unload data directly from the exasol DB using PB2022. However, Exasol DB requires JDBC connection and since JDBC connection is discontinued in PB 2022. We are getting one error message and unable to perform export/unload from our exasol DB.Kindly find the error message below.

DBMS JDBC is not supported in your current installation.

We request you to kindly help us with an alternative solution for the same.

  1. JDBC
  2. PowerBuilder (Appeon)
PB 2022 R3
SMTPClient async log file
Responses (4)
kitty he @Appeon
kitty he @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 9 January 2024 02:21 AM UTC
  2. PowerBuilder
  3. # 1

Hi Dhanya,

 

  1. First, you need to upgrade your PB version to PB2022 1892 or a newer version.

 

  1. The JDK version we officially support is 1.6. If you are using 1.8, the basic PB functions in the runtime environment should not be affected. In the IDE environment, create a folder named "jdk1.6.0_24" in the PB IDE directory, copy all the files in the JDK installation directory you are using to this folder, and follow the other steps as described in https://www.appeon.com/developers/get-help/knowledgebase/4434.

 

Regards,

Kitty

Comment
There are no comments made yet.
Dhanya K
Dhanya K Accepted Answer Pending Moderation
  1. Monday, 8 January 2024 10:51 AM UTC
  2. PowerBuilder
  3. # 2

Hello Miguel,

Thanks for your previous reply.

We have tried following this blog from Appeon 

How to connect to a database using JDBC | Appeon

However, as we are using an Exasol DB and the DB requires jre >=1.8 to run properly.

And in the blog it is specifically mentioned that the workaround will work only for jdk 1.6.0.24. I think that's why we are facing a new error while implementing the workaround.

Kindly find the new error: 

'Could not initialize JavaVM!'

It would be really kind of you if you could help us with this issue. Thanks

Comment
There are no comments made yet.
Dhanya K
Dhanya K Accepted Answer Pending Moderation
  1. Friday, 5 January 2024 06:17 AM UTC
  2. PowerBuilder
  3. # 3

Thank you for the response. Kindly let us know whether there is a solution to this by keeping the PB2022 version as 1878 itself.

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Friday, 5 January 2024 18:25 PM UTC
No, you need to upgrade to the slightly newer build 1892 to get this capability.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 4 January 2024 14:39 PM UTC
  2. PowerBuilder
  3. # 4

We faced the same problem:

https://community.appeon.com/index.php/qna/q-a/pb-connect-to-google-big-query-how?limitstart=0#reply-42993 

It's still possible to get JDBC working. https://www.appeon.com/developers/get-help/knowledgebase/4434 

regards.

Comment
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.