Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: jtds problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: jtds problems

Subject: Re: jtds problems
From: Luís Pacheco <email@hidden>
Date: Thu, 18 Jan 2007 17:03:05 -0300
Organization: Moleque de Idéias

Chuck,

great tips, thanks. They solved the SELECT .. FOR UPDATE problem, it was a configuration trap indeed. I just deleted all non sqlserver prototypes and connection dictionaries and I can now edit and save objects. But the primary key problem is still ON when saving new objects, and this particular error I've read someone saying that was caused by jtds driver etc etc.. I've already tried microsoft driver and other problems came up, different ones. So, if you or anybody else have a clue of what's going on in this case, I'd be very grateful.

Here is the error msg:

java.lang.IllegalStateException: Adaptor com.webobjects.jdbcadaptor.JDBCAdaptor@f11de2 failed to provide new primary keys for entity 'Profile' at com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator(EODatabaseContext.java:5885) at com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:409) at com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3226) at er.extensions.ERXEC._saveChanges(ERXEC.java:832) at er.extensions.ERXEC.saveChanges(ERXEC.java:760) at com.moleque.certificacao.componentes.permission.GerenciaPrivilegioPage.save(GerenciaPrivilegioPage.java:131) ...

Regards,
Luis

Chuck Hill wrote:

Hi Luis,
SELECT...FOR UPDATE indicates a configuration problem. However, I can't recall exactly what it means. Some things to check:

1. is the jdbc2info in the connection dictionary for another database / driver / version? If so, delete it and try again. 2. Check the value type and external type in the EOModel / EOPrototypes to see ensure they are correct. The external types may be case sensitive.
Chuck
On Jan 18, 2007, at 10:30 AM, Luís Pacheco wrote:
Hi,
I'm having some problems with WO and sqlserver and I suspect that has something to do with jtds driver. Problems related with not generating primary keys and other querys that is not supported (SELECT ... FOR UPDATE). Does anybody have experienced the same situation ? Thanks in advance, Luis
--\o/ Luís Pacheco, Moleque de Idéias Educação e Tecnologia Ltda
 |  Phone: 55-21-2710-0178 E-mail: email@hidden
/ \ http://www.moleque.com.br
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
-- Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects


--
\o/ Luís Pacheco, Moleque de Idéias Educação e Tecnologia Ltda
 |  Phone: 55-21-2710-0178 E-mail: email@hidden
/ \ http://www.moleque.com.br

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden Follow-Ups: Re: jtds problems From: Luís Pacheco <email@hidden> References: >jtds problems (From: Luís Pacheco <email@hidden>) >Re: jtds problems (From: Chuck Hill <email@hidden>) Prev by Date: Re: WebServices Material on Wiki Next by Date: Re: jtds problems Previous by thread: Re: jtds problems Next by thread: Re: jtds problems Index(es): Date Thread