JDBC Error

2007-04-27 Thread Jonathan Miller
Hi, I'm getting this error now and again - is anyone familiar with it? Next exception:SQL State:S1000 -- error code: 0 -- msg: Unknown character set index for field '9521' received from server. com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression failed: gIn$MySQLExpression: "

Re: Problems setting up wo app to consume webservices

2007-04-27 Thread jerry porter
thanks for the pointers, I will take a look. --- Lachlan Deck <[EMAIL PROTECTED]> wrote: > Hi Jerry, > > On 28/04/2007, at 2:03 AM, jerry porter wrote: > > > I am trying to use WO to produces and consume WebServices and I am > > running into problems serializing and deserializing Complex Obj

Re: Problems setting up wo app to consume webservices

2007-04-27 Thread Lachlan Deck
Hi Jerry, On 28/04/2007, at 2:03 AM, jerry porter wrote: I am trying to use WO to produces and consume WebServices and I am running into problems serializing and deserializing Complex Objects. I have looked at the mailing list archives but did not see a solution. I am running WO 5.22 on win

Re: Integrity Constraints fire upon deletion.

2007-04-27 Thread Chuck Hill
Assuming that this exception is happening when EOF issues a commit (and that ClientTransaction._C83 is set to "Deferrable" and "Initially Deferred"), then that looks like EOF is getting confused between inserts, updates, and deletes. In otherwords, part way though delete ... it cha

Re: Integrity Constraints fire upon deletion.

2007-04-27 Thread Gaastra Dennis - WO Lists
Hi Chuck and List, Thanks for your intial help, but after setting all the "Check" and "Foreign Key" constraints to "Deferrable" and "Initially Deferred" in the "ClientTransaction" table, we still get a new type of exception once in a while: com.webobjects.jdbcadaptor.JDBCAdaptorException:

Re: Multiple clients in single DB

2007-04-27 Thread Chuck Hill
What class are the flattened tables? Usually join tables are EOGenericRecord in which case awakeFromInsertion will get called on EOGenericRecord, not in your code. Chuck On Apr 26, 2007, at 10:35 PM, Dave Elsner wrote: I spoke to soon, it seems that awakeFromInsertion does NOT register

Problems setting up wo app to consume webservices

2007-04-27 Thread jerry porter
Hello, I am trying to use WO to produces and consume WebServices and I am running into problems serializing and deserializing Complex Objects. I have looked at the mailing list archives but did not see a solution. I am running WO 5.22 on windows. I started with the Calculator client / server e

Re: Array variables in building a qualifier in EOModeler

2007-04-27 Thread Zak Burke
Saker Ghani wrote on 4/26/07 7:13 PM: Is there a simple way to build a qualifier in EOModeler such that it is possible to use a variable binding that is an array? So, for example, going beyond the traditional "city = $city", is it possible to bind in the fashion, "city = @cities", and have EOM

Re: Multiple clients in single DB

2007-04-27 Thread Ken Anderson
I have had similar issues with those flattened join tables, so I always make them a real entity so that I can control how things work. It's also useful in the event you decide that the join itself requires a new attribute. On Apr 27, 2007, at 1:35 AM, Dave Elsner wrote: I spoke to soon,