Greetings

I am using a "third party library" (Informa) a that is consequently using hibernate. There is a trouble saving attribute which has a java.net.URL type.
When Hibernate saves it to DB, it just leaves a blank string '' there (even if there are valid data in the object) and when loading this garbage it,logically, fails to deserialize the URL. My question is...what are we doing bad? What is the correct mapping of java.net.URL type in MySQL environments?

thanks for your time

Jakub Hozak

the mapping details follows:

Mapping documents:


Name and version of the database you are using:MySQL 4.1.11


column creating code:

Perhaps changing the type to serializable would help?

unfortunately it didn't help, maybe the 'varchar binary' is wrong?
with what should I replace it?

No idea what "varchar binary" is. These should map to the JDBC VARBINARY type, although I have no idea of the corrolary DB type for that on MySQL.

Another option is to map this using a user-type. Then you could store it in the database as a simple VARCHAR using URL.toExternalForm().