JNDIDatabaseFileSystem DefaultDS on JBoss

[Richard Huddleston]

I'm trying to get jackrabbit migrated over on JBoss to MySQL (it's currently
using the default config).  I'm having an issue doing the JNDI lookups.  No
matter what I put for the dataSourceLocation I can't get the JNDI lookup to
succeed.  I have the DefaultDS working for other things (ex. JBoss
messaging).  I'm running on JBoss version 4.2.2.GA.  Has anyone had success
with this?

I've tried "java:/DefaultDS", "DefaultDS", "java:comp/env/jdbc/DefaultDS",
and "jndi/DefaultDS" ... no luck.

<Repository>
  <FileSystem
class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
    <param name="dataSourceLocation" value="java:/DefaultDS" />
    <param name="schema" value="mysql" />
    <param name="schemaObjectPrefix" value="jcr_fs_" />
  </FileSystem>
  <Security appName="Jackrabbit">
    <AccessManager
      class="org.apache.jackrabbit.core.security.SimpleAccessManager">
    </AccessManager>
    <LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
      <param name="anonymousId" value="anonymous" />
    </LoginModule>
  </Security>
  <Workspaces rootPath="${rep.home}/workspaces"
    defaultWorkspace="default" />
  <Workspace name="${wsp.name}">
    <FileSystem
      class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
      <param name="dataSourceLocation" value="java:/DefaultDS" />
      <param name="schema" value="mysql" />
      <param name="schemaObjectPrefix" value="jcr_fs_${wsp.name}_" />
    </FileSystem>
    <PersistenceManager

class="org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager">
      <param name="dataSourceLocation" value="java:/DefaultDS" />
      <param name="schema" value="mysql" />
      <param name="schemaObjectPrefix" value="jcr_pm_${wsp.name}_" />
    </PersistenceManager>
  </Workspace>
  <Versioning rootPath="${rep.home}/version">
    <FileSystem
      class="org.apache.jackrabbit.core.fs.db.JNDIDatabaseFileSystem">
      <param name="dataSourceLocation" value="java:/DefaultDS" />
      <param name="schema" value="mysql" />
      <param name="schemaObjectPrefix" value="jcr_fs_version_" />
    </FileSystem>
    <PersistenceManager

class="org.apache.jackrabbit.core.persistence.db.JNDIDatabasePersistenceManager">
      <param name="dataSourceLocation" value="java:/DefaultDS" />
      <param name="schema" value="mysql" />
      <param name="schemaObjectPrefix" value="jcr_pm_version_" />
    </PersistenceManager>
  </Versioning>
</Repository>

<datasources>
  <local-tx-datasource>

    <jndi-name>DefaultDS</jndi-name>

    <connection-url>jdbc:mysql://localhost:3306/jboss</connection-url>

    <driver-class>com.mysql.jdbc.Driver</driver-class>

    <user-name>jboss</user-name>

    <password>password</password>

    <exception-sorter-class-name>
        org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
    </exception-sorter-class-name>

    <valid-connection-checker-class-name>
        org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker
    </valid-connection-checker-class-name>

    <transaction-isolation>
        TRANSACTION_READ_COMMITTED
    </transaction-isolation>

    <metadata>
       <type-mapping>mySQL</type-mapping>
    </metadata>

  </local-tx-datasource>
</datasources>