2 Replies Latest reply on Mar 21, 2006 5:27 PM by Roy Russo

    PortalDS and HSQLDB Schema - HELP!

    Alex Fajardo Newbie

      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'!"