1 Reply Latest reply: Aug 19, 2012 10:55 AM by Tony Field RSS

    Problem in HSQLDB schema, while creating SystemUserAttr table

      Hi All,
      After a long struggle i somehow managed to come up to post installation step. After the installer successfully pinged my DB connection and HelloCS url it again failed after trying to create the CS system tables inside HSQLDB 2.2.8.

      It does create ELEMENTCATALOG, SITECATALAOG and SYSTEMINFO tables, but when it is trying to create SystemUserAttr table it failed due to the below reason
      CREATE TABLE SystemUserAttr (id NUMBER(38) NOT NULL, name VARCHAR(32) NOT NULL, value VARCHAR(255) NOT NULL, urlvalue VARCHAR(255) NULL, PRIMARY KEY (id, name, value))
      java.sql.SQLSyntaxErrorException: type not found or user lacks privilege: NUMBER

      The data type Number is not recognized by HSQLDB, instead Numeric is working. But how do i change it in the installer. The installer failed to locate/execute the corresponding load script for HSQLDB. Is different load script available for different data dialect?

      How can i change this load script? Becuase of this, eventhough the application deployed successfully i was not able to login into the URL http://localhost:8080/cas/login using fwadmin/xceladmin

      The url http://localhost:8080/cs/HelloCS is working fine and it is giving the embedded status when i am seeing the source file as
      *<!--FTCS|||result=It worked!|||reason=Success|||err=0|||command=Test CS jar install|||params=test=true|||-->*

      I am in the last step, if it is working i can start my work.


      Edited by: user652523 on Aug 8, 2012 11:58 AM

      Edited by: user652523 on Aug 8, 2012 11:59 AM
        • 1. Re: Problem in HSQLDB schema, while creating SystemUserAttr table
          Tony Field
          When you choose the database installation type in the installer, the mapping between the Java types and the DB types defaults from the installer based on the db you choose. The HSQLDB defaults are for 1.1.8, not the 2.x version you're using.

          You can override the types. After the first part of the installation, before you get to the pingdb step, you can open up the Property Editor, then open up the futuretense.ini file. Click on the database tab, and change the mapping for cc.numeric to what you want it set to.