Can't get XWiki 1.0 beta 4 and embedded Apache Derby to play nice - xwiki-users@xwiki.org

22 Feb 2007

I once had an older version of XWiki running with embedded Derby under 
Tomcat 5 on Windows XP.  I blew that away to start fresh with XWiki 1.0 
beta 4 (still with embedded Derby under Tomcat 5 on Windows XP); 
however, I've run into a variety of difficulties.

In my last run with XWiki, someone had converted the script to create 
the DB into a Derby-compatible syntax which I ran through SQuirreL SQL 
Client to prime the DB.  With the latest version of XWiki, though, it 
seems there is no need to explicitly create the schema ahead of time.  
My understanding is that Hibernate will do this automatically when 
directed to do so through the XWiki configuration:

    xwiki.store.hibernate.updateschema=1

Thus, I have Tomcat 5 set up with a datasource for the XWiki context:

    <Context docBase="C:/Program Files/XWiki/xwiki-1.0"
        useNaming="true"
        swallowOutput="true"
        privileged="true"
        antiResourceLocking="false"
        antiJARLocking="false"
        reloadable="true" >

        <Resource
            name="jdbc/xwiki"
            description="XWiki DataSource"
            auth="Container"
            username="xwiki"
            password="xwiki"
            type="javax.sql.DataSource"
            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
            url="jdbc:derby:C:/Documents and Settings/Administrator/My
    Documents/Xwiki;create=true"
            maxActive="8"
            maxIdle="4" />

      <!-- Link to the user database we will get roles from -->
      <ResourceLink name="users" global="UserDatabase"
                    type="org.apache.catalina.UserDatabase"/>

    </Context>

In the hibernate.cfg.xml file, I've commented out the direct connections 
in favor of using a datasource:

        <!-- DataSource Connection -->
        <property
    name="connection.datasource">java:/comp/env/jdbc/xwiki</property>
        <property
    name="dialect">org.hibernate.dialect.DerbyDialect</property>

Trying this, though, I get problems when I hit my XWiki saying the 
schema XWIKI is not found.  I connected again using SQuirreL SQL Client 
and indeed, there was no XWIKI schema (but the default, APP, was 
there).  So I created one using SQL:

    CREATE SCHEMA XWIKI

Now the schema exists, so I start Tomcat with XWiki and try to access 
it.  Now it doesn't complain about the schema not existing.  Instead it 
says it can't find the tables it wants:

    ERROR 42X05: Table 'XWIKI.XWIKIDOC' does not exist.

I cannot understand what it takes to have the schema created.  Any ideas?