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