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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.