[Zope] RE HELP -> Non-Transaction Tables couldn't be rolled back

[Brian Withun]

I have prepended my database connection string with a hyphen and
my database continued to connect just fine.

I retested a known case where a rollback was attempted (which had
been resulting in an SQL error "non-transaction tables couldn't be
rolled back"  -- because I am purposefully using non-transaction-safe
tables [MyISAM]) and the rollback error did not occur.

Your suggestion apparently did the trick, at least for me!

Thank you Chris Keyes!!

------------
Brian Withun
Web Developer
Hilgraeve, Inc.
Monroe, Michigan 48161

| -----Original Message-----
| From: Schmidt, Allen J. [mailto:aschmidt@nv.cc.va.us]
| Sent: Friday, September 21, 2001 9:18 AM
| To: 'Chris Keyes'; brianw@hilgraeve.com
| Cc: zope@zope.org
| Subject: RE: [Zope] RE HELP -> Non-Transaction Tables couldn't be rolled
| back
|
|
| When I do this, I get an error stating it is not a valid database name.
|
| -----Original Message-----
| From: Chris Keyes [mailto:chrisk@nipltd.com]
| Sent: Friday, September 21, 2001 5:26 AM
| To: brianw@hilgraeve.com
| Cc: zope@zope.org
| Subject: [Zope] RE HELP -> Non-Transaction Tables couldn't be rolled
| back
|
|
| Hi Brian
|
| If I remember correctly I had this problem last week, and Andy Dustman who
| helped us out in the Zope-DB list had this solution...
| If your using the ZMySQL database adapter, start your conection
| string with
| a "-". This disables transactions :-)
| so
| -database@server.domain username password .....
| Putting a space after the - caused problems...
|
| Anyway hope that helps ;-)
|
| ChrisK
|
|
|
|
| _______________________________________________
| Zope maillist  -  Zope@zope.org
| http://lists.zope.org/mailman/listinfo/zope
| **   No cross posts or HTML encoding!  **
| (Related lists -
|  http://lists.zope.org/mailman/listinfo/zope-announce
|  http://lists.zope.org/mailman/listinfo/zope-dev )
|