JNDI configuration of datastores in Websphere

Hi,

I have successfully deployed geoserver with the oracle-ng plugin into websphere and managed to create a jdbc datasource which can be successfully pinged in Websphere also.

I’m struggling though to get it to work with my geoserver config.

Here’s what I have now:

-          A resource-ref section in the web.xml (following the example on the geoserver website)

<resource-ref>

  <description>Oracle datastore test</description>

         <res-ref-name>jdbc/test</res-ref-name>

         <res-type>javax.sql.DataSource</res-type>

         <res-auth>Container</res-auth>

       </resource-ref>

-          A configured JDBC Provider with a classpath set to ojdbc14.jar of my oracle client installation directory with an implementation classname: oracle.jdbc.pool.OracleConnectionPoolDataSource

-          A datasource configuration

o   Name: testJNDI

o   JNDI Name: jdbc/testJNDI

o   Use this datasource in CMP checked

o   Oracle 10g data store helper

o   Component-managed authentication alias selected

o   And an url like: jdbc:oracle:thin:@(DESCRIPTION= etc)

-          Bound the resource ref to the concrete datasource definition on installing the geoserver war file with the default method for authentication (many-to-one) with the samemanaged authentication as above selected.

-          And in geoserver catalog.xml

<datastore namespace=”testJNDI” enabled=”true” id=”jndi_test_ds”>

       <connectionParams>

                       <parameter value=”http://www.test.nl/JNDI” name=”namespace”/>

                       <parameter value=”jdbc/test” name=”jndiReferenceName”/>

                       <parameter value=”Oracle” name=”dbtype”/>

                       <parameter value=”USERNAME” name=”schema”/>

       </connectionParams>

</datastore>

After deploying this I cannot see my datastore in the list when I choose to add a new featureType so I configured a featureType manually but when accessing this featureType I get the following error:

Java.io.IOException: Schema ‘http://www.test.nl/JNDITABLENAME’ does not exist.

At org.geotools.data.store.ContentDataStoe.ensureEntry(ContentDataStore.java:555)

Etc.

What am I doing wrong here?

Cheers Kris