1. Eric Verhorstert
  2. PowerBuilder
  3. Tuesday, 6 February 2018 22:21 PM UTC

I try to convert a program to a mobile app (Appeon). After we connect to the database we create a lot of variables in the database (create or replace variable vVariable ....).

These variables are also used in the sql statements of the datawindows.

When we retrieve data in the App it seems if the variables are not there (column vVariable not found).

Is the use of variables in the database not possible?

 

Thanks

Who is viewing this page
Appeon Support Team Accepted Answer Pending Moderation
  1. Wednesday, 7 February 2018 00:50 AM UTC
  2. PowerBuilder
  3. # 1

Hi Eric,

In PowerBuilder application (client/server), once the client establishes connection to the database, a unique session will be created in database and maps to the application session, this is so called long connection, so it's a one-to-one relationship. However on Web application (browser/server), it uses the connection cache to connect to the database, the client does not connect to DB server directly, and all connect cache are managed by the Appeon Server. one Appeon IE session maps to more than one session in the database; when data retrieval or procedure is executed, the cache pool will automatically allocate a connection to connect to the database. When transaction is completed, the connection will be rolled back to the cache pool, this is so called short connection. One Web application may have many transactions, so it's a one-to-many relationship.

Please try the long connection solution below to see if is satisfy your request. you can use db user id to identity session with this solution.
http://support.appeon.com/appeon/Long_Connection.doc

Regards,
Zhaoka

Comment
  1. Eric Verhorstert
  2. Wednesday, 7 February 2018 14:32 PM UTC
Thanks for the info. But now i have error "Invalid username or password" when I start the app on my phone.



I first changed the data sources (server | resources | data source) in AEM.



Datasourcetype: ODBC driver

ODBC Data Source: PigExpert

Maximum connection pool size: 1

Minimum connection pool size: 1

Connection timeout (seconds) : 120

Command timeout (seconds): 30

Connection Lifetime (seconds): 0

Dynamic Database connection: On checked

Pooling: On checked



In Powerserver there is also a tab "DB settings". So, now I have 3 settings.

The first in our programm, in AEM and in Powerserver. Where are these settings saved?



Problem is that in "PowerServer toolkit | DB Settings | Transaction object" the User name and Password change to 21 and ** after a full application deployment.



  1. Helpful
  1. Appeon Support Team
  2. Thursday, 8 February 2018 00:45 AM UTC
Hi Eric,



Please use the script like below to specify the user/password to connect to the database.



SQLCA.LogId = %your id%

SQLCA.LogPass=%your pass%



Regards,

ZhaoKai

  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.