Subject | Re: [Firebird-Java] Re: How2 save javaobject in Firebird ? |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-12-17T14:51:13Z |
> I try to use Firebird as default datastore for JBOSS(tm) AppServer,standardjbosscml-jdbc.xml contains an error in datatype mapping for
> and this server call setObject() method for storing internal
> objects. Probably it is necessary to use default jboss database -
> HSQLDB :(
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