U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » [solved]when to reconnect to the sql database?

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

[solved]when to reconnect to the sql database? [message #46643]

Tue, 21 June 2016 03:00

akebee
Messages: 90
Registered: August 2011
Location: China

Member

In my skylark web server app i use mysql server to store data.
the SqlSession didn`t have method such as "IsConnected()" so i can not hold the session
and have no choice but to connect to the server every time Embarassed

[Updated on: Tue, 21 June 2016 09:18]

Report message to a moderator

Re: when to reconnect to the sql database? [message #46644 is a reply to message #46643]

Tue, 21 June 2016 06:13

dolik.rce
Messages: 1791
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

akebee wrote on Tue, 21 June 2016 03:00

In my skylark web server app i use mysql server to store data.
the SqlSession didn`t have method such as "IsConnected()" so i can not hold the session
and have no choice but to connect to the server every time

Hi akabee,

There is IsOpen() method that probably does exactly what you expected from IsConnected(). Check the docs Wink

Best regards,
Honza

Report message to a moderator

Re: when to reconnect to the sql database? [message #46646 is a reply to message #46644]

Tue, 21 June 2016 09:18

akebee
Messages: 90
Registered: August 2011
Location: China

Member

thank you
dolik.rce
i see Cool

Report message to a moderator

Re: [solved]when to reconnect to the sql database? [message #46647 is a reply to message #46643]

Tue, 21 June 2016 19:39

Zbych
Messages: 327
Registered: July 2009

Senior Member

akebee wrote on Tue, 21 June 2016 03:00

In my skylark web server app i use mysql server to store data.
the SqlSession didn`t have method such as "IsConnected()" so i can not hold the session
and have no choice but to connect to the server every time

You can use global SQL and SQLR and connect to your database when skylark threads are created (just once when your program starts)
Take a look at skylark tutorial - 9. Connecting SQL database

Report message to a moderator

Previous Topic:	[solved]crash when execute sql command
Next Topic:	grid control hidden field sql accept

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 09 20:26:59 CEST 2025

Total time taken to generate the page: 0.00867 seconds