Subject Re: [Firebird-Java] Re: How2 save javaobject in Firebird ?
Author Roman Rokytskyy
> I try to use Firebird as default datastore for JBOSS(tm) AppServer,
> and this server call setObject() method for storing internal
> objects. Probably it is necessary to use default jboss database -
> HSQLDB :(

standardjbosscml-jdbc.xml contains an error in datatype mapping for
Firebird:

<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>

However, instead it should be:

<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>VARBINARY</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>

or

<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</sql-type>
</mapping>


Either fix your standardjbosscmp-jdbc.xml or add appropriate mapping to your
deployment descriptor.

Roman