« Return to Thread: JNDI configuration of datastores in Websphere

Re: JNDI configuration of datastores in Websphere

by mcr :: Rate this Message:

If you can ping the datasource within your websphere admin consoloe, your
config is ok. (Provided that the scope of your DS is not pointing to another
server, I assume you are using a server called "server1").

1)
Try to use "java:comp/env/jdbc/test" instead of jdbc/test in the geoserver
config. I think the logic to add "java:comp/env/" is not in 1.7.5, only on
trunk.

2)
Websphere has a default app called UTC. Within this app you can browse your
JNDI hierarchy. You can also try the full qualified JNDI path

Kris Geusebroek writes:

> 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.jav
> a:555)
>
> Etc.
>
>
>
> What am I doing wrong here?
>
>
>
> Cheers Kris
>
>
>

------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

« Return to Thread: JNDI configuration of datastores in Websphere