Hello!
I am using tomcat 3.0.0 with bundled tomcat 4.0.3. I am using the database Firebird (Firebird-1.0.0.796) with the driver FirebirdSQL-1.0_RC1. I am using the InterBase mapping which is defined "standardjbosscmp-jdbc.xml" file. I am having problems when I use "long" fields within my CMP entity beans. According to "standardjbosscmp-jdbc.xml", the long mapping is:
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMERIC(18,0)</sql-type>
</mapping>
The exception is:
org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable:(org.firebirdsql.jdbc.FBSQLException: GDS Exception: org.firebirdsql.gds.GDSException: Dynamic SQL ErrorSQL error code = -817 Metadata update statement is not allowed by the current database SQL dialect 1 null ....
I have changed "NUMERIC(18,0)" by "DOUBLE PRECISION". I have done this, because I tried to create one table from the "Marathon" client with one column "NUMERIC(18,0)" and on the DB I had the type "Double Precision" for that column.
My new mapping:
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>DOUBLE PRECISION</sql-type>
</mapping>
Can anyone tell me which is the best way to map Longs with Firebird?
Thanks in advance,
Victor Batista