1. Sivaprakash BKR
  2. PowerBuilder
  3. Monday, 23 March 2020 11:38 AM UTC

Hello,

PB 2017 R3, 1915 with Postgresql 11.6, Postgresql ODBC Driver(Unicode) 11.01

1.  Open a datawindow in the datawindow painter.
2.  Click the Datasource.   
3.  Design - Conver to Syntex.
4.  [Mis Spell] Type a field name.
5.  Close the data source window.  

Without reporting any error, that window get's closed.   After the closure of the window, we get the error message.  We find only the last saved query when we try to correct the mistyped fields, by opening the data source again.  

Why this is not reporting error, before closing the window?

This issue is not there when we use SQL Server with SNC driver or OLE-DB driver.  It reports an error and we get a chance to correct those errors before closing the window.  

Why there is a change in behaviour?

Happiness Always
BKR Sivaprakash

 

Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 March 2020 03:50 AM UTC
  2. PowerBuilder
  3. # 1

Hi BKR,

BTW, PB 12.6 has the same issue.

Regards,
ZhaoKai

Comment
  1. Sivaprakash BKR
  2. Tuesday, 24 March 2020 13:00 PM UTC
I think 12.6 doesn't support Postgres officially.
  1. Helpful
There are no comments made yet.
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 24 March 2020 03:31 AM UTC
  2. PowerBuilder
  3. # 2

Hi BKR,

Thanks for reporting this problem! We reproduced it on both PB 2017 and PB 2019 and will do further research to figure it out. We will keep you posted about the progress.

Please temporary work around this issue by using PostgreSQL JDBC driver.

Driver name: org.postgresql.Driver
Database URL: jdbc:postgresql://Hostname:DBPort/DBName

Regards,
ZhaoKai

Comment
  1. Kai Zhao @Appeon
  2. Wednesday, 25 March 2020 00:06 AM UTC
Hi,



The default JDK version in PowerBuilder is 1.6.0_24, please try postgresql-42.2.11.jre6.jar, which is work well on our end.

https://jdbc.postgresql.org/download/postgresql-42.2.11.jre6.jar



Please follow steps below.

1 Add classpath to refer to postgresql-42.2.11.jre6.jar.

2 Restart PowerBuilder.

3 Add JDBC connection to connect to your database.



Regards,

ZhaoKai
  1. Helpful
  1. Sivaprakash BKR
  2. Wednesday, 25 March 2020 05:37 AM UTC
Thanks. Working with postgresql-42-2.11.jre6.jar.

  1. Helpful
  1. Kai Zhao @Appeon
  2. Wednesday, 25 March 2020 05:40 AM UTC
Glad to hear that!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 23 March 2020 20:34 PM UTC
  2. PowerBuilder
  3. # 3

Hi BKR;

   Please open a Support Ticket for this issue.

Regards ... Chris

Comment
  1. Sivaprakash BKR
  2. Tuesday, 24 March 2020 13:01 PM UTC
Chris, Since it's accepted by Zhao Kai @Appeon, I'm not opening another support ticket for this issue.
  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.