Just migrated a project to mysql, and now all methods that used the ERXEOControlUtilities.objectWithPrimaryKey() method no longer work and throw the following exception:

Sep 18 15:21:38 Analytics[55555] (ERXNSLogLog4jBridge.java:41) WARN NSLog - <com.codefab.analytics.DirectAction>: Exception in performActionNamed() on the action "pkFetchWithMySQLProblem" with the message: com.webobjects.jdbcadaptor.JDBCAdaptorException: The attribute id should be assigned a Number, but the value was the String "1000002"
java.lang.reflect.InvocationTargetException
[2008-09-18 15:21:38 EDT] <WorkerThread5> com.webobjects.jdbcadaptor.JDBCAdaptorException: The attribute id should be assigned a Number, but the value was the String "1000002" at com.webobjects.jdbcadaptor.JDBCColumn.takeInputValue(JDBCColumn.java: 557) at com .webobjects .jdbcadaptor .JDBCChannel ._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:226) at com .webobjects .jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:303) at com .webobjects .jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:261) at com .webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java: 185)

This was working in FB no problem. I was initially passing the string representing the decoded id from the request as the argument to the method. But, I've tried all the EOUtilitiesMethods, converting the pk string into a GID or converting it into an Integer, but I always get this value massaged into a string. Here's the current call:

EOUtilities.objectWithPrimaryKeyValue(ec, entityName, new Integer(pkValue)); where pkValue is a string, ec and entityName are pretty obvious hopefully;-)

What am I doing wrong? Could this be a bug?

Bill



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to