0 Replies Latest reply on Sep 26, 2002 12:04 PM by Victor Batista

    Firebird - Long mapping error

    Victor Batista Newbie

      I am using tomcat 3.0.0 with bundled tomcat 4.0.3. I am using the database Firebird (Firebird- 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:


      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:

      <sql-type>DOUBLE PRECISION</sql-type>

      Can anyone tell me which is the best way to map Longs with Firebird?

      Thanks in advance,
      Victor Batista