#601 Error message when it returns a blob field from hypersonicDB

[Emidio Stani]

Hi all,

I installed SQuirreL SQL 2.6.3 on Ubuntu 7.04 and I'm working with an Hibernate database with Jonas.

If I choose to see the content of a table from the Object Panel I can see the effective content of the Blob field that is inside the table.

If I query the table (in SQL or in HQL language) I see the ascii code of the "<Error>" string in the Blob field.

I tried also to enable Blob for the Global Preference but it doesn't work.

Bye

Emidio Stani

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Hibernate provides Object/Relational Mapping. It supports many databases, but it isn't a database. What is the database that you are using? (The default for JOnAS appears to be HyperSonic DB, is that correct?) What is the version of the database and the driver that you are using? (You can get this in the metadata tab which is shown by default when you click on the top node of the object tree)

Rob

[Emidio Stani]

Logged In: YES
user_id=1942430
Originator: YES

Sorry if I wasn't precise,

I use Hypersonic DB (HSQLDB 1.8.0) using the driver hsqldb.jar (org.hsqldb.jdbcDriver classname) that is provided by JOnAS (4.8.5).

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Yes; I just noticed that in the subject - somehow I read right past it :)

Rob

[Rob Manning]

Logged In: YES
user_id=1287991
Originator: NO

Emidio,

Do you have an exception in the log. Can you check and post it here if you find it?

Rob