Re: WebObjects and Informix

It looks to me that you need to have a LOGGING database. you could use "ontape -s -L 0 -U <database>" to convert it. Steve Romankiw ----- Original Message ----- From: "QueriX 4GL / Mehdi" <mehdi@querix.com> To: <informix-list@iiug.org> Sent: Thursday, June 15, 2000 6:33 AM Subject: Re: WebObjects and Informix > > > icrra@my-deja.com wrote: > > > Yes, the user has DBA permissions! > > > > In article <39463FE4.8CB72355@querix.com>, > > QueriX 4GL / Mehdi <mehdi@querix.com> wrote: > > > > > > > > > icrra@my-deja.com wrote: > > > > > > > Hello: > > > > > > > > I'm trying to use WebObjects application server > > > > on Windows NT to connect to an Informix > > > > database. Reading from the database is fine, but > > > > whenever I try to update an existing record, I > > > > get this error: > > > > > > > > NSInternalInconsistencyException exception > > > > occurred while handling request: > > > > NSInternalInconsistencyException: Exception > > > > occured while evaluating 'saveChanges', on > > > > target:<Main 0xb0c480>: > > > > beginTransaction -- InformixContext 0xaeeab0: > > > > Unable to begin transaction > > > > > > > > Can anyone tell me what I am doing incorrectly? > > > > > > > > -thanks > > > > > > > > Sent via Deja.com http://www.deja.com/ > > > > Before you buy. > > > > > > Have you checked the privileges on the database for the user trying to > > > update the database? > > > > Have you checked that the same data can be updated using a different tool > such as dbaccess? > Is there any data integrity you are not aware off ? > Is there any locks on the records that are not cleared? > Have you tried update statistics from dbaccess? > > It would pay off to give more information about the Informix database > version, your application and whether you are trying to access and write > data to an existing database which has been created by and in use of another > program. There may be stored procedures which would stop you from changing > a recored unless you go through a specific sequence of events, etc. > > > -- > Compliments of QueriX > -------------------------------------------------------------------------- ------------------------ > > QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other > RDBMS such as Oracle. > > Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere > Phoenix Windows GUI. (Front End to 4GL) > Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) > Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) > > ESQL/C Compiler > > For more details visit: http://www.querix.com/ > -------------------------------------------------------------------------- ------------------------- > > > >