hmmm…what’s your model look like? Or how are you setting up the storage of that data?
Sounds like you want a string and might watch the encoding of it before storage — It sounds perhaps like this error could occur because your data types are mismatched in a way that results in a validation error that doesn’t sound helpful or familiar… Sometimes databases or models have fancy options when really you just need a string and it’s no big deal and so, you might look that over for sanity... > On Aug 11, 2020, at 3:17 PM, Don Lindsay <pccd...@me.com> wrote: > > 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