Hello everyone,

I am attempting to install XWiki 1.2rc2 on a freshly installed Glassfish Application server. (GlassFish V2 Update Release 1 (UR1))

I would like to use the Application Server controlled JDBC Connection pool to connect to a JavaDB/Derby Database that is currently located on the same machine.

I have created an XWiki specific connection pool on the app server, with a "JDBC Resource" created to match, named "JNDI Name: '
jdbc/XWiki'".

My Hibernate configuration script looks like this:
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Template for hibernate configuration. processing by maven using profiles.
     Replace original src/main/webapp/WEB-INF/hibernate.cfg.xml -->
<hibernate-configuration>
  <session-factory>

    <property name="show_sql">true</property>
    <property name="use_outer_join">true</property>

    <property name="connection.datasource">jdbc/XWiki</property>
    <property name="current_session_context_class">jta</property>
    <property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>

    <property name="dialect">org.hibernate.dialect.DerbyDialect</property>
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

    <mapping resource="xwiki.derby.hbm.xml"/>
    <mapping resource="feeds.hbm.xml"/>

  </session-factory>
</hibernate-configuration>

Upon launch of the XWiki application (attempt to load the XWiki main page), I am getting an
"HTTP Status 500" error.  Inspecting the log files of the application server, I see the following Exception that appears to be the Root Cause:

ERROR store.XWikiHibernateBaseStore   - Failed creating schema update script
java.lang.ArrayIndexOutOfBoundsException: 2
        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.isTable(DatabaseMetadata.java:147)
        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:935)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiHibernateBaseStore.java:361)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:249)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
        at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
        at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
        at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
        ...<application server stack>...
|#]


I have found http://www.nabble.com/Upgrading-to-new-1.2rc1-td14257861.html to be a similar error message, but there is no suitable resolution to the issue in that thread.  Also, I'm not upgrading anything, I'm starting new.

I'm pretty sure that I have some configuration to work through, but I am just not able to get the details worked out for my next move.

Thanks!

--
Michael J Hess