Hello; I am not using JSON here, I certainly could but that is not what the customer has requested. They want serialized Java Objects, not Java Script Object Notation. Java Serialized objects are byte arrays, much like a stream of file contents read from a disk with Reader object.
I have checked all my types and they are fine, I have even tried different types (var binary, BLOB, etc) all puke on a byte array. None of the other columns have an issue, if I comment out getSelectedTile().takeStoredValueForKey(Session.<TileStorage>convertObject(new TileStorage(this)),"serial”); the object inserts into the EC and save works. Thanks, Don > On Aug 11, 2020, at 09:30, Jesse Tayler <jtay...@oeinc.com> wrote: > > Well, I’m sure there is validation for JSON since that has issues with format > and encodings, so I’d expect some of that sort of thing here. > > I don’t really see the value or whatever expected type, so I’d find that > value that breaks it and test it — > > One thing I wonder is about text encoding, are you certain you’ve got all > your types correct? > > I mean, it is gaging on a value somewhere, it could be a small as an invalid > character or sequence. > >> On Aug 11, 2020, at 8:26 AM, Don Lindsay <pccd...@me.com> wrote: >> >> The value entered for <b>Serial</b> is not a valid <b>?</b>. >> >> ERXVaidationException >> >> I have setup no Validation, so it must be Wonder or WebObjects base >> validation that is throwing the error >> >>> On Aug 10, 2020, at 18:20, Jesse Tayler <jtay...@oeinc.com> wrote: >>> >>> Did you list your error? >>> >>>> On Aug 10, 2020, at 6:08 PM, Don Lindsay via Webobjects-dev >>>> <webobjects-dev@lists.apple.com> wrote: >>>> >>>> Hello; >>>> >>>> I have an app that the ucxstomer has asked to store specific serialized >>>> objects into a MySQL database. I have stored serialized objects in MySQL >>>> many times, at customer request. I get an error am trying to populate >>>> the field with incorrect data type. The convertObject method is a >>>> standard format method for serializing a java object. It is the same code >>>> we use for converting objects to byte arrays in another application that >>>> uses jdbc. The object is able to be serialized fine, but can’t be put >>>> into the column and then saved to the database by EOF. >>>> >>>> The Code: >>>> getSelectedTile().takeStoredValueForKey(Session.<TileStorage>convertObject(new >>>> TileStorage(this)),"serial"); >>>> >>>> Tile entity : >>>> >>>> attributes = ( >>>> {columnName = description; name = description; prototypeName = >>>> longText; }, >>>> { >>>> className = "java.lang.Number"; >>>> columnName = id; >>>> externalType = INT; >>>> name = id; >>>> precision = 10; >>>> valueType = l; >>>> }, >>>> {columnName = name; name = name; prototypeName = longText; }, >>>> { >>>> allowsNull = Y; >>>> className = "com.webobjects.foundation.NSData"; >>>> columnName = serial; >>>> externalType = BLOB; >>>> name = serial; >>>> width = 65535; >>>> }, >>>> { >>>> allowsNull = Y; >>>> className = "com.webobjects.foundation.NSData"; >>>> columnName = tilejson; >>>> externalType = BLOB; >>>> name = tilejson; >>>> width = 65535; >>>> }, >>>> { >>>> allowsNull = Y; >>>> className = "com.webobjects.foundation.NSData"; >>>> columnName = visualization; >>>> externalType = BLOB; >>>> name = visualization; >>>> width = 65535; >>>> } >>>> ); >>>> I have tried to set the classname of the serial field to the class being >>>> stored but that does not work either. I figure if all else fails I can >>>> do a RAW SQL and store the serialized object, but I would prefer that EOF >>>> handle all that. >>>> >>>> Thanks in advance for any help. >>>> >>>> Don >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/jtayler%40oeinc.com >>>> >>>> This email sent to jtay...@oeinc.com >>> >> > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com