Re: JNDI configuration of datastores in Websphere

Hi all,

Cheered too soon i think.
After removing the schema definition form the catalog.xml completely
(emptying the value was not enough)

It seems websphere is able to get the tables form the db but when
creating a feature type I get the error:

Could not obtain native oracle connection for class
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection
Andrea mentioned the unwrappers that were needed.
Is this the case in my configuration?

I found someone reporting the use of

ds = (DataSource) ctx.lookup("java:comp/env/" + dataSource);

WSJdbcConnection conn = (WSJdbcConnection) ds.getConnection();
con = (OracleConnection)
WSJdbcUtil.getNativ-eConnection((WSJdbcC-onnection) conn);

to fix this but I don't know if that is used in geoserver code

Is there a configuration change I can make to fix this or do I need java
code?

Cheers Kris
-----Original Message-----
From: Kris Geusebroek [mailto:kgeusebroek@...]
Sent: Wednesday, July 08, 2009 4:23 PM
To: Andrea Aime
Cc: geoserver-users@...
Subject: Re: [Geoserver-users] JNDI configuration of datastores in
Websphere

Found the solution!!

After trying to configure tomcat with the same oracle connection (which
didn't work also) I found out that removing the schema from the
datastore configuration did the trick.

Apparently giving the username is sufficient enough.

Cheers Kris

-----Original Message-----
From: Kris Geusebroek [mailto:kgeusebroek@...]
Sent: Wednesday, July 08, 2009 3:12 PM
To: Andrea Aime
Cc: geoserver-users@...
Subject: Re: [Geoserver-users] JNDI configuration of datastores in
Websphere

Hi,

Yes i saw the tutorial for oracle, so I have to get some oracle db
running on my laptop to investigate further I guess.

Thanks

Kris

-----Original Message-----
From: Andrea Aime [mailto:aaime@...]
Sent: Wednesday, July 08, 2009 3:03 PM
To: Kris Geusebroek
Cc: geoserver-users@...
Subject: Re: [Geoserver-users] JNDI configuration of datastores in
Websphere

Kris Geusebroek ha scritto:
> Hi Andrea,
>
> No nothing else to see in the logs.
> I'm now trying to make it work on my tomcat installation with postgis
db
> but I don't believe there is a jndi version of the postgis jdbc plugin
> right?

Not for 1.7.x, there is only one for GeoServer trunk (aka 2.0 series).
The JDNI tutorial (which you already saw, right?) was written for
Oracle:
http://gridlock.openplans.org/geoserver/1.7.x/doc/user/tutorials/tomcat-
jndi/tomcat-jndi.html


Cheers
Andrea



--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------
------
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/Challenge
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------
------
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/Challenge
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------------
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/Challenge
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users