Re: Postgresql Adaptor?
Re: Postgresql Adaptor?
- Subject: Re: Postgresql Adaptor?
- From: Randall Perry <email@hidden>
- Date: Mon, 09 Feb 2004 14:52:49 -0500
Just used eomodeler for the 1st time since upgrading to PgSQL 7.4 and get
the following error when trying to connect to the db via jdbc:
"Set autocommit off is no longer supported"
I assume the PostgresqlPlugIn, PostgresqlPlugInBundle need to be updated
to work with 7.4?
>> Le 03 dic. 2003, ` 09:29, arturo a icrit :
>>>> I've scoured the web for a PostgreSQL adaptor for WO 5 and haven't
>>>> been
>>>> able to find one.
>>>
>>> The adaptor I use is from hexdreams (.com, I think). I just
>>> recompiled it
>>> for 5 (up to 5.2.2) and it's working fine.
>>
>> But I've checked this adaptor and it seems to lack to turn off the
>> default auto-commit behavior of the PostgreSQL JDBC driver (see
>> http://omnigroup.com/mailman/archive/webobjects-dev/2003-November/
>> 037493.html).
>>
>> Unfornunately, the driver doesn't seem to have an URL parameter to set
>> this auto-commit to off, so I guess it must be done by the EOF adaptor,
>> calling "setAutoCommit(false)" method of the Connection instance.
>>
>
> When I've checked my database after a failed transaction I see it in the
> state I expect. That
> is, no new data. I'm going to have to check this again, though. I am using
> all 7.4 PGSQL stuff,
> BTW.
>
> What's the evidence suggesting that autocommit is turned on? I think that
> email originally
> talked about SQLServer.
> _______________________________________________
> webobjects-dev mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
> Do not post admin requests to the list. They will be ignored.
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales
http://www.systame.com/
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.