Thread: pg74 --> SET AUTOCOMMIT TO OFF is no longer supported
Hi people! I have a problem when save() a object and i autocommit to false. The error is "SET AUTOCOMMIT TO OFF is no longer supported" I am working with postgresql 7.4 from tarball, j2ee 1.4.2 and postgresql jdbc driver is pg74jdbc3.jar. I read in this forum that i can have problems with versions, but i try change de postgresql driver version and i get the same error. Any ideas?? ___________________________________________________ Yahoo! Messenger - Nueva versión GRATIS Super Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es
are you using setAutoCommit(false) or are you doing this manually? Dave On Wed, 2004-04-07 at 07:25, Sez Sez wrote: > Hi people! > I have a problem when save() a object and i > autocommit to false. The error is "SET AUTOCOMMIT TO > OFF is no longer supported" I am working with > postgresql 7.4 from tarball, j2ee 1.4.2 and postgresql > jdbc driver is pg74jdbc3.jar. > > I read in this forum that i can have problems with > versions, but i try change de postgresql driver > version and i get the same error. > > Any ideas?? > > ___________________________________________________ > Yahoo! Messenger - Nueva versión GRATIS > Super Webcam, voz, caritas animadas, y más... > http://messenger.yahoo.es > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Dave Cramer 519 939 0336 ICQ # 14675561
Yes, i do conexion.setAutoCommit(false) in a java code. And my pg74jdbc driver is build 213. --- Dave Cramer <pg@fastcrypt.com> escribió: > are you using setAutoCommit(false) or are you doing > this manually? > > Dave > On Wed, 2004-04-07 at 07:25, Sez Sez wrote: > > Hi people! > > I have a problem when save() a object and i > > autocommit to false. The error is "SET AUTOCOMMIT > TO > > OFF is no longer supported" I am working with > > postgresql 7.4 from tarball, j2ee 1.4.2 and > postgresql > > jdbc driver is pg74jdbc3.jar. > > > > I read in this forum that i can have problems with > > versions, but i try change de postgresql driver > > version and i get the same error. > > > > Any ideas?? > > > > > ___________________________________________________ > > Yahoo! Messenger - Nueva versión GRATIS > > Super Webcam, voz, caritas animadas, y más... > > http://messenger.yahoo.es > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please > send an appropriate > > subscribe-nomail command to > majordomo@postgresql.org so that your > > message can get through to the mailing list > cleanly > > > -- > Dave Cramer > 519 939 0336 > ICQ # 14675561 > ___________________________________________________ Yahoo! Messenger - Nueva versión GRATIS Super Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es
Are you sure you don't have another postgresql.jar in the path, looking at the code there is no 'set autocommit to off' in the current code. Dave On Wed, 2004-04-07 at 08:18, Sez Sez wrote: > Yes, i do conexion.setAutoCommit(false) in a java > code. And my pg74jdbc driver is build 213. > > > --- Dave Cramer <pg@fastcrypt.com> escribió: > are > you using setAutoCommit(false) or are you doing > > this manually? > > > > Dave > > On Wed, 2004-04-07 at 07:25, Sez Sez wrote: > > > Hi people! > > > I have a problem when save() a object and i > > > autocommit to false. The error is "SET AUTOCOMMIT > > TO > > > OFF is no longer supported" I am working with > > > postgresql 7.4 from tarball, j2ee 1.4.2 and > > postgresql > > > jdbc driver is pg74jdbc3.jar. > > > > > > I read in this forum that i can have problems with > > > versions, but i try change de postgresql driver > > > version and i get the same error. > > > > > > Any ideas?? > > > > > > > > ___________________________________________________ > > > Yahoo! Messenger - Nueva versión GRATIS > > > Super Webcam, voz, caritas animadas, y más... > > > http://messenger.yahoo.es > > > > > > ---------------------------(end of > > broadcast)--------------------------- > > > TIP 3: if posting/reading through Usenet, please > > send an appropriate > > > subscribe-nomail command to > > majordomo@postgresql.org so that your > > > message can get through to the mailing list > > cleanly > > > > > -- > > Dave Cramer > > 519 939 0336 > > ICQ # 14675561 > > > > ___________________________________________________ > Yahoo! Messenger - Nueva versión GRATIS > Super Webcam, voz, caritas animadas, y más... > http://messenger.yahoo.es > -- Dave Cramer 519 939 0336 ICQ # 14675561
Yes! In my eclipse project i have only pg74jdbc, but I remembered that in my tomcat library i have pg73jdbc... I think that tomcat catch this library and fails, although I have pg74jdbc in my eclipse project! Thanks! --- Dave Cramer <pg@fastcrypt.com> escribió: > Are you sure you don't have another postgresql.jar > in the path, looking > at the code there is no 'set autocommit to off' in > the current code. > > Dave > On Wed, 2004-04-07 at 08:18, Sez Sez wrote: > > Yes, i do conexion.setAutoCommit(false) in a java > > code. And my pg74jdbc driver is build 213. > > > > > > --- Dave Cramer <pg@fastcrypt.com> escribió: > > are > > you using setAutoCommit(false) or are you doing > > > this manually? > > > > > > Dave > > > On Wed, 2004-04-07 at 07:25, Sez Sez wrote: > > > > Hi people! > > > > I have a problem when save() a object and i > > > > autocommit to false. The error is "SET > AUTOCOMMIT > > > TO > > > > OFF is no longer supported" I am working with > > > > postgresql 7.4 from tarball, j2ee 1.4.2 and > > > postgresql > > > > jdbc driver is pg74jdbc3.jar. > > > > > > > > I read in this forum that i can have problems > with > > > > versions, but i try change de postgresql > driver > > > > version and i get the same error. > > > > > > > > Any ideas?? > > > > > > > > > > > > ___________________________________________________ > > > > Yahoo! Messenger - Nueva versión GRATIS > > > > Super Webcam, voz, caritas animadas, y más... > > > > http://messenger.yahoo.es > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > > TIP 3: if posting/reading through Usenet, > please > > > send an appropriate > > > > subscribe-nomail command to > > > majordomo@postgresql.org so that your > > > > message can get through to the mailing > list > > > cleanly > > > > > > > -- > > > Dave Cramer > > > 519 939 0336 > > > ICQ # 14675561 > > > > > > > > ___________________________________________________ > > Yahoo! Messenger - Nueva versión GRATIS > > Super Webcam, voz, caritas animadas, y más... > > http://messenger.yahoo.es > > > -- > Dave Cramer > 519 939 0336 > ICQ # 14675561 > ___________________________________________________ Yahoo! Messenger - Nueva versión GRATIS Super Webcam, voz, caritas animadas, y más... http://messenger.yahoo.es