Hi
My entity has a java.net.URL property:

My DB is a mysql, and i m using Spring and JPA:

This creates the table with a tinyblob column for the URL, and then when persisting, the URL is saved by serializing it (which that alone is not good anyway). The problem is that when reading from the table, i get:

I've tried adding:

to the property. This persisted the URL as String, but when reading i got the same problem! Looks like it was written as String and read as blob.

How can i make the URL field be persisted as string (and read as one...)?

I've used userType. Seems quite basic, isn't there some default URLUserType class implemented by hibernate or spring?

Hi Reformy,

I am using annotations, but I would assume you can most certainly do the same with XML mapping as it has the same features if not more than the annotations provide. I store java.io.File objects in my database so I don't have to mess with prefixes and determining then where files are. It is very trivial:

@Lob
@Column
public File getFile()
{return(file);}


In your case, you'd probably want to use:

@Lob
@Column
public URL getURL()
{return(url);}

java.net.URL is serializable, so this should work. If you're trying to store binary data as a char (text) by specifying the type as varchar(1024), you're bound to get corruption, hibernate is smart enough to figure out if the column needs to be binary or not.


Walter

Thanks for your answer.


I m using annotations too...


I don't want to serialize the URL object, and I think you shouldn't either... serialization of objects to DB may cause you problems in the future when the serialized class changes.

You have a good point - a String is also human-readable so you're SQL insert scripts would be more maintainable.

Walter