PortalDS and HSQLDB Schema - HELP!

[wowowonder]

Installation:
JBOSS 4.0.3SP1
JBOSS Portal 2-2
OS: Mac OSX 10.3.9
IDE: NetBeans 5.0 Beta

My objective is to use HSQLDB and at a later date use HSQLDB Extreme as the database for my future web site. Also, I plan to use a Macintosh server.

What I'd like to do is to be able to see the table structure of the JBOSS Portal and connect to the HSQLDB even when JBOSS is not running.

I changed the portal-hsqldb-ds.xml to use the HSQLDB TCP connection as defined in hsqldb-ds.xml:

<connection-url>jdbc:hsqldb:hsql://localhost:1704</connection-url>

Below is how portal-hsqldb-ds.xml is configured:

<?xml version="1.0" encoding="UTF-8"?>



<local-tx-datasource>

<jndi-name>PortalDS</jndi-name>
<!-- ***** 01-12-05 - Changed URL location
<connection-url>jdbc:hsqldb:${jboss.server.data.dir}\portal\hypersonic\database</connection-url>
to
-->
<connection-url>jdbc:hsqldb:hsql://localhost:1704</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<!-- ***** 01-12-05 - Change password
<![CDATA[]]>
-->

somepassword

</local-tx-datasource>



Also, I defined the csm repository.xml to use RDBMS and deleted the data/portal and data/hypersonic folders. I then booted JBOSS and the error below was generated:

--- MBeans waiting for other MBeans ---
ObjectName: portal:service=TreeCache,type=persistent
State: FAILED
Reason: java.lang.IllegalArgumentException: not a Hibernate iterator
I Depend On:
jboss.jca:name=PortalDS,service=DataSourceBinding
Depends On Me:
portal:service=TreeCacheProvider,type=persistent

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: portal:service=TreeCache,type=persistent
State: FAILED
Reason: java.lang.IllegalArgumentException: not a Hibernate iterator
I Depend On:
jboss.jca:name=PortalDS,service=DataSourceBinding
Depends On Me:
portal:service=TreeCacheProvider,type=persistent


There were other errors such as:

13:26:34,174 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
13:26:34,178 ERROR [SchemaExport] schema export unsuccessful

Any idea what is causing the error?

Also, can someone tell me how I can boot up the HSQLDB independent of JBOSS? Somehow, JBOSS starts the database and shuts it down afterwards.

Thanks in advance for the help,
wowowonder

"Whoa! You must have been bookin'!"

[peter3]

I would appreciate to hear the answer to this one as well. My setup is comparable, except that I want to use MySQL 4.1 as database. After editing the repository.xml file I get the exact same error as mentioned above...since this posting isn't very recent I hope someone came up with a solution?

[roy.russo]

This doesn't look related to Portal, but is related to hypersonic.