JBoss Database

[adin_mamr]

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.

[theute]

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)

[adin_mamr]

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?

[adin_mamr]

Got it!

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