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

Resolved MySQL ODBC 5.3 ANSI

  1. Issue
0
Votes
Undo
  1. Tom McArdle
    Tom McArdle
  2. PowerBuilder
  3. Thursday, 5 July 2018 17:42 PM UTC

Hello

This is my first posting to the Appeon community. I am hoping someone can help me?

I have written an app using the MySQL database and PB2017. There are 8

Concurrent users. I am tracking the user as they sign in, but I

have noticed that I do not see their entries until I exit and get back in again.

 

Seems like the update is not ‘Committed’ even thought I do use the ‘Commit;’

at the end of each update.

 

When I exit and get back in I can then see those database entries.

 

Any guidance would be appreciated.

 

Tom

 

  1. Build
  2. MySQL
RUN WEB SERVICE ( from project object )
GhostScript Question
Accepted Answer
Bruce Armstrong
Bruce Armstrong Accepted Answer Pending Moderation
  1. Thursday, 5 July 2018 19:00 PM UTC
  2. PowerBuilder
  3. # Permalink

Which storage engine did you use? 

Are the connections set for autocommit?  

What transaction isolation level are you using?

The latter defaults to REPEATABLE_READ and you might want to use READ_COMMITTED instead.

Comment
Tom McArdle
  1. Tom McArdle
  2. Thursday, 5 July 2018 20:55 PM UTC
Thank you very much Bruce.



Those changes did the trick Bruce.



Thank you so much.



 



SQLCA.Lock = "RC"

SQLCA.AutoCommit = True



Tom

  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 5 July 2018 18:03 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tom;

  Unfortunately at this time, MySQL is not a supported DBMS by PowerBuilder - only byt PowerServer.

Regards ... Chris

Comment
Tom McArdle
  1. Tom McArdle
  2. Thursday, 5 July 2018 19:47 PM UTC
Thanks Chris.



ODBC for the most part works fine. Is there any pans to fully support MySQL?



or should I consider converting to PostGreSQL?



Tom

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 5 July 2018 19:56 PM UTC
Hi Tom;



   Nothing for MySQL in the short term. PB 2018 will focus on C#.Net Web API and C# .Net Assemblies - with some GUI improvements for Classic Apps.



Regards ... Chris

  1. Helpful
Tom McArdle
  1. Tom McArdle
  2. Thursday, 5 July 2018 20:57 PM UTC
Thank You Chris



I made the changes Bruce recommended and that did the trick.



SQLCA.Lock = "RC"

SQLCA.AutoCommit = True

  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.