3 Replies Latest reply on Jan 24, 2011 5:10 AM by Adin MR

    JBoss Database

    Adin MR Newbie

      Hi,

       

      I am using the GateIn portal, which runs on JBoss.

       

      I understood that JBoss has created it's memory database, which means the server can still be run even without external database installed. In order to get my GateIn running, there is a table from that database I need to delete, which is the JCR_CONFIG table.

       

      My problem right now is how do we connect to that HSQL database? i.e, what is the default port? what is the dba username and password? and what is the name of the database? I did not recall any steps that I configure all of these.

       

      Need your help and advice. Thanks a lot in advance.

        • 1. JBoss Database
          Thomas Heute Master

          The configuration for database can be found in:

          GateIn-3.1.0-GA/server/default/conf/gatein/configuration.properties

           

          # JCR

          gatein.jcr.datasource.name=java:jdbcjcr

          gatein.jcr.datasource.dialect=auto

          gatein.jcr.datasource.driver=org.hsqldb.jdbcDriver

          gatein.jcr.datasource.url=jdbc:hsqldb:file:${gatein.db.data.dir}/data/jdbcjcr_${name}

          gatein.jcr.datasource.username=sa

          gatein.jcr.datasource.password=

           

          ${gatein.db.data.dir} translates into $GATEIN_HOME/server/default/data/gatein/db (By default)

           

          Note that It's not configured to be in-memory but file based. Which means that if you want to delete all data stored by the portal and start fresh you can delete $GATEIN_HOME/server/default/data (You will also lose all portals you may have defined)

          • 2. JBoss Database
            Adin MR Newbie

            Hi Thomas,

             

            Here you are again, and I really appreciate it. Anyways, speaking of that JCR_CONFIG table, I can't find it anyware in that database. How can I delete it, as per you recommendation?

            • 3. JBoss Database
              Adin MR Newbie

              Got it!

               

              Thank you very much Thomas, for your assistance. I appreciate it. Have a good day!