U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Patch: Reconnecting PostgreSQL Automatically on Unstable Networks

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

Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks [message #26402 is a reply to message #26399]

Fri, 30 April 2010 01:41

zsolt
Messages: 698
Registered: December 2005
Location: Budapest, Hungary

Contributor

I don't use DECLARE CURSOR and FECTH SQL statements, only simple SELECTS.

If you iterate on the result of a SELECT, it iterates on a table in RAM, AFAIK, so reconnection is not an issue here.

BTW, I changed PostgreSQLSession::Rollback() to:

void PostgreSQLSession::Rollback()
{
	ExecTrans("rollback");
	if(level>0) level--;
}

and my app is quite usable now on unstable networks.

Report message to a moderator

[Message index]

		Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 27 April 2010 19:21
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Tue, 27 April 2010 20:21
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 27 April 2010 21:19
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Wed, 28 April 2010 14:31
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Thu, 29 April 2010 23:55
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Fri, 30 April 2010 01:41
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Fri, 30 April 2010 10:53
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Tue, 04 May 2010 12:11
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: mirek on Mon, 17 May 2010 14:47
		Re: Patch: Reconnecting PostgreSQL Automatically on Unstable Networks By: zsolt on Mon, 17 May 2010 15:44

Previous Topic:	Any way to generate sch from database?
Next Topic:	SQLITE3: Bind parameter by name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat May 11 15:07:32 CEST 2024

Total time taken to generate the page: 0.03381 seconds