This has been on my todo list for quite some time.  I would imagine that for each session alias, you could specify a list of multiple table:column:class configurations such that if the table and column match, the class would be consulted to render the column value as a string.  Obviously, this could be tricky for editing such columns (i.e. How to provide a GUI that lets you set properties on any generic object which is then serialized into the blob field as the original class type).  But, at least for rendering, the implementation would be straight forward.  The problem with that is the current plugin API only allows custom renderer's by session type and SQL data(column) type.  Yet looking ahead, I can see that these new mappings might not be limited to being plugin-specific.  So, a new core feature that allows you to map columns in certain tables to renderer's that can load classes to de-serialize BLOBs into Strings seems to be called for here.  Feel free to submit a feature request for this.


On Wed, Sep 7, 2011 at 3:38 PM, KARR, DAVID <dk068x@att.com> wrote:
I have a situation where some columns in some tables are BLOBs representing Java serialized objects.  Another column specifies the Java type of that serialized object. It would be very nice if I had an easy way to view the deserialized version of those BLOBs.

I'm aware of the fact that SQuirreL has a plugin architecture, but I don't know much about it.  Would it be reasonable to consider writing a custom plugin that when executed on a row of a particular table, assuming it was configured to know which column has the BLOB and which column has the type, and a classpath for the associated classes, to essentially run a "ToStringBuilder()" on the object to print out the fields in a dialog?

I imagine this would be quite a bit of work, but is it even possible?

Using storage to extend the benefits of virtualization and iSCSI
Virtualization increases hardware utilization and delivers a new level of
agility. Learn what those decisions are and how to modernize your storage
and backup environments for virtualization.
Squirrel-sql-users mailing list