Oracle NG OCI connection on Geoserver 2.0

[Kasper Thuno]

Hey list,

This bug has been discovered already (http://jira.codehaus.org/browse/GEOS-3579)
and I asked Andrea if there are any ways to work around this problem, but he has
yet to reply, so now I'm asking the rest of you.

I have upgraded from a 1.5 installation and the data directory restructoring
went fine, but I get a whole lot of these:

java.io.IOException
        at
org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:294)
        at
org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java
:37)
        at
org.geoserver.catalog.util.LegacyCatalogImporter.importDataStores(LegacyCatalogI
mporter.java:352)
        at
org.geoserver.catalog.util.LegacyCatalogImporter.importCatalog(LegacyCatalogImpo
rter.java:297)
        at
org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCatalogImporter.jav
a:146)
        at
org.geoserver.config.GeoServerLoader.readLegacyCatalog(GeoServerLoader.java:665)
        at
org.geoserver.config.GeoServerLoader.loadCatalog(GeoServerLoader.java:159)
        at
org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLo
ader.java:125)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java
:350)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini
tializeBean(AbstractAutowireCapableBeanFactory.java:1330)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
reateBean(AbstractAutowireCapableBeanFactory.java:473)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
un(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
ateBean(AbstractAutowireCapableBeanFactory.java:380)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
ctBeanFactory.java:264)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
ton(DefaultSingletonBeanRegistry.java:221)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
BeanFactory.java:261)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:185)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:164)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
erence(BeanDefinitionValueResolver.java:269)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
ueIfNecessary(BeanDefinitionValueResolver.java:104)
        at
org.springframework.beans.factory.support.ConstructorResolver.resolveConstructor
Arguments(ConstructorResolver.java:495)
        at
org.springframework.beans.factory.support.ConstructorResolver.autowireConstructo
r(ConstructorResolver.java:162)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.aut
owireConstructor(AbstractAutowireCapableBeanFactory.java:925)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
ateBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
reateBean(AbstractAutowireCapableBeanFactory.java:440)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
un(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
ateBean(AbstractAutowireCapableBeanFactory.java:380)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
ctBeanFactory.java:264)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
ton(DefaultSingletonBeanRegistry.java:221)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
BeanFactory.java:261)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:185)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:164)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
erence(BeanDefinitionValueResolver.java:269)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
ueIfNecessary(BeanDefinitionValueResolver.java:104)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveMan
agedList(BeanDefinitionValueResolver.java:287)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
ueIfNecessary(BeanDefinitionValueResolver.java:126)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
lyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.pop
ulateBean(AbstractAutowireCapableBeanFactory.java:1010)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
reateBean(AbstractAutowireCapableBeanFactory.java:472)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
un(AbstractAutowireCapableBeanFactory.java:409)
        at java.security.AccessController.doPrivileged(Native Method)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
ateBean(AbstractAutowireCapableBeanFactory.java:380)
        at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
ctBeanFactory.java:264)
        at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
ton(DefaultSingletonBeanRegistry.java:221)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
BeanFactory.java:261)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:185)
        at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
anFactory.java:164)
        at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstanti
ateSingletons(DefaultListableBeanFactory.java:429)
        at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactory
Initialization(AbstractApplicationContext.java:729)
...

In the WEB UI all stores are not enabled, and when clicking on one, it says that
the plugin for this store type could not be found.


Datastore example:

<dataStore>
  <id>DataStoreInfoImpl-2d2dd346:12495f0b664:-7ff1</id>
  <name>kms</name>
  <enabled>true</enabled>
  <workspace>
    <id>WorkspaceInfoImpl-2d2dd346:12495f0b664:-7fff</id>
  </workspace>
  <connectionParameters>
    <entry key="schema"></entry>
    <entry key="passwd">xxx</entry>
    <entry key="dbtype">oracle</entry>
    <entry key="alias">areal</entry>
    <entry key="user">xxx</entry>
    <entry key="namespace">http://www.xxx.dk/</entry>
  </connectionParameters>
</dataStore>


Anyone able to find a solution?

/Kasper



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Justin Deoliveira-6]

Hi Kasper,

You might be running into this issue:

http://jira.codehaus.org/browse/GEOS-3602

Ensure that you are running GeoServer 2.0.0a which is 2.0 with a minor
patch.

Also be sure to read the upgrade notes:

http://geoserver.org/display/GEOS/Upgrading+To+2.0

So if you could do teh following:

1) upgrade to 2.0.0a if you have not already
2) upgrade the oracle extension if you have not already
3) restore the data directory to the 1.7 style by following instructions
from the upgrade notes
4) start geoServer again and let us know if the problem persists

-Justin

Kasper Thuno wrote:

> Hey list,
>
> This bug has been discovered already (http://jira.codehaus.org/browse/GEOS-3579)
> and I asked Andrea if there are any ways to work around this problem, but he has
> yet to reply, so now I'm asking the rest of you.
>
> I have upgraded from a 1.5 installation and the data directory restructoring
> went fine, but I get a whole lot of these:
>
> java.io.IOException
>         at
> org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:294)
>         at
> org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java
> :37)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.importDataStores(LegacyCatalogI
> mporter.java:352)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.importCatalog(LegacyCatalogImpo
> rter.java:297)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCatalogImporter.jav
> a:146)
>         at
> org.geoserver.config.GeoServerLoader.readLegacyCatalog(GeoServerLoader.java:665)
>         at
> org.geoserver.config.GeoServerLoader.loadCatalog(GeoServerLoader.java:159)
>         at
> org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLo
> ader.java:125)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
> lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java
> :350)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini
> tializeBean(AbstractAutowireCapableBeanFactory.java:1330)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:473)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
> erence(BeanDefinitionValueResolver.java:269)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructor
> Arguments(ConstructorResolver.java:495)
>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructo
> r(ConstructorResolver.java:162)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.aut
> owireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
> erence(BeanDefinitionValueResolver.java:269)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveMan
> agedList(BeanDefinitionValueResolver.java:287)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:126)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
> lyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.pop
> ulateBean(AbstractAutowireCapableBeanFactory.java:1010)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:472)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstanti
> ateSingletons(DefaultListableBeanFactory.java:429)
>         at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactory
> Initialization(AbstractApplicationContext.java:729)
> ...
>
> In the WEB UI all stores are not enabled, and when clicking on one, it says that
> the plugin for this store type could not be found.
>
>
> Datastore example:
>
> <dataStore>
>   <id>DataStoreInfoImpl-2d2dd346:12495f0b664:-7ff1</id>
>   <name>kms</name>
>   <enabled>true</enabled>
>   <workspace>
>     <id>WorkspaceInfoImpl-2d2dd346:12495f0b664:-7fff</id>
>   </workspace>
>   <connectionParameters>
>     <entry key="schema"></entry>
>     <entry key="passwd">xxx</entry>
>     <entry key="dbtype">oracle</entry>
>     <entry key="alias">areal</entry>
>     <entry key="user">xxx</entry>
>     <entry key="namespace">http://www.xxx.dk/</entry>
>   </connectionParameters>
> </dataStore>
>
>
> Anyone able to find a solution?
>
> /Kasper
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Kasper Thunø (KAT)]

Hey Justin

The problem is very much still there, even with the patched install. All I did was to extract the war (2.0.0a), copy the content of the oracle.jar (again 2.0.0a) into WEB-INF/lib, replace the data dir with my own old style data dir and start up the Tomcat. And for each datastore I get an exception thrown as shown below.

Anyone got 2.0.0a successfully working with OCI datastores?

Regards Kasper

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@...]
Sent: 28. oktober 2009 02:30
To: Kasper Thuno
Cc: geoserver-users@...
Subject: Re: [Geoserver-users] Oracle NG OCI connection on Geoserver 2.0

Hi Kasper,

You might be running into this issue:

http://jira.codehaus.org/browse/GEOS-3602

Ensure that you are running GeoServer 2.0.0a which is 2.0 with a minor
patch.

Also be sure to read the upgrade notes:

http://geoserver.org/display/GEOS/Upgrading+To+2.0

So if you could do teh following:

1) upgrade to 2.0.0a if you have not already
2) upgrade the oracle extension if you have not already
3) restore the data directory to the 1.7 style by following instructions
from the upgrade notes
4) start geoServer again and let us know if the problem persists

-Justin

Kasper Thuno wrote:

> Hey list,
>
> This bug has been discovered already (http://jira.codehaus.org/browse/GEOS-3579)
> and I asked Andrea if there are any ways to work around this problem, but he has
> yet to reply, so now I'm asking the rest of you.
>
> I have upgraded from a 1.5 installation and the data directory restructoring
> went fine, but I get a whole lot of these:
>
> java.io.IOException
>         at
> org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:294)
>         at
> org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java
> :37)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.importDataStores(LegacyCatalogI
> mporter.java:352)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.importCatalog(LegacyCatalogImpo
> rter.java:297)
>         at
> org.geoserver.catalog.util.LegacyCatalogImporter.imprt(LegacyCatalogImporter.jav
> a:146)
>         at
> org.geoserver.config.GeoServerLoader.readLegacyCatalog(GeoServerLoader.java:665)
>         at
> org.geoserver.config.GeoServerLoader.loadCatalog(GeoServerLoader.java:159)
>         at
> org.geoserver.config.GeoServerLoader.postProcessBeforeInitialization(GeoServerLo
> ader.java:125)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
> lyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java
> :350)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.ini
> tializeBean(AbstractAutowireCapableBeanFactory.java:1330)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:473)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
> erence(BeanDefinitionValueResolver.java:269)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at
> org.springframework.beans.factory.support.ConstructorResolver.resolveConstructor
> Arguments(ConstructorResolver.java:495)
>         at
> org.springframework.beans.factory.support.ConstructorResolver.autowireConstructo
> r(ConstructorResolver.java:162)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.aut
> owireConstructor(AbstractAutowireCapableBeanFactory.java:925)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:440)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveRef
> erence(BeanDefinitionValueResolver.java:269)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:104)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveMan
> agedList(BeanDefinitionValueResolver.java:287)
>         at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveVal
> ueIfNecessary(BeanDefinitionValueResolver.java:126)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.app
> lyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.pop
> ulateBean(AbstractAutowireCapableBeanFactory.java:1010)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doC
> reateBean(AbstractAutowireCapableBeanFactory.java:472)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.r
> un(AbstractAutowireCapableBeanFactory.java:409)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.cre
> ateBean(AbstractAutowireCapableBeanFactory.java:380)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Abstra
> ctBeanFactory.java:264)
>         at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingle
> ton(DefaultSingletonBeanRegistry.java:221)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abstract
> BeanFactory.java:261)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:185)
>         at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBe
> anFactory.java:164)
>         at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstanti
> ateSingletons(DefaultListableBeanFactory.java:429)
>         at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFactory
> Initialization(AbstractApplicationContext.java:729)
> ...
>
> In the WEB UI all stores are not enabled, and when clicking on one, it says that
> the plugin for this store type could not be found.
>
>
> Datastore example:
>
> <dataStore>
>   <id>DataStoreInfoImpl-2d2dd346:12495f0b664:-7ff1</id>
>   <name>kms</name>
>   <enabled>true</enabled>
>   <workspace>
>     <id>WorkspaceInfoImpl-2d2dd346:12495f0b664:-7fff</id>
>   </workspace>
>   <connectionParameters>
>     <entry key="schema"></entry>
>     <entry key="passwd">xxx</entry>
>     <entry key="dbtype">oracle</entry>
>     <entry key="alias">areal</entry>
>     <entry key="user">xxx</entry>
>     <entry key="namespace">http://www.xxx.dk/</entry>
>   </connectionParameters>
> </dataStore>
>
>
> Anyone able to find a solution?
>
> /Kasper
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Andrea Aime-4]

Kasper Thunø (KAT) ha scritto:
> Hey Justin
>
> The problem is very much still there, even with the patched install. All I did was to extract the war (2.0.0a), copy the content of the oracle.jar (again 2.0.0a) into WEB-INF/lib, replace the data dir with my own old style data dir and start up the Tomcat. And for each datastore I get an exception thrown as shown below.
>
> Anyone got 2.0.0a successfully working with OCI datastores?

Did you try the solutions I've proposed in the associated jira?
http://jira.codehaus.org/browse/GEOS-3579

Cheers
Andrea

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Kasper Thunø (KAT)]

Nope, must have overseen your post in jira. But from what I can tell it's not that simple to make a JNDI resource based on OCI. I'm locked at using OCI as it's a customer installation.

I've tried searching the list for anything related to OCI without luck... Do you have a link to the related post by any chance?

Regards Kasper

-----Original Message-----
From: Andrea Aime [mailto:aaime@...]
Sent: 5. november 2009 15:07
To: Kasper Thunø (KAT)
Cc: Justin Deoliveira; geoserver-users@...
Subject: Re: [Geoserver-users] Oracle NG OCI connection on Geoserver 2.0

Kasper Thunø (KAT) ha scritto:
> Hey Justin
>
> The problem is very much still there, even with the patched install. All I did was to extract the war (2.0.0a), copy the content of the oracle.jar (again 2.0.0a) into WEB-INF/lib, replace the data dir with my own old style data dir and start up the Tomcat. And for each datastore I get an exception thrown as shown below.
>
> Anyone got 2.0.0a successfully working with OCI datastores?

Did you try the solutions I've proposed in the associated jira?
http://jira.codehaus.org/browse/GEOS-3579

Cheers
Andrea

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



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Andrea Aime-4]

Kasper Thunø (KAT) ha scritto:
> Nope, must have overseen your post in jira. But from what I can tell
> it's not that simple to make a JNDI resource based on OCI. I'm locked
> at using OCI as it's a customer installation.
>
> I've tried searching the list for anything related to OCI without
> luck... Do you have a link to the related post by any chance?

Mumble... I probably was wrong, the workaround suggested was about
connecting to a cluster, not to use OCI.

Atm the only solution I see is to build a JNDI source following
the lines of this tutorial:
http://docs.geoserver.org/1.7.x/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
(which needs to be adapted to use OCI, it's using thin atm)

Alternatively you can provide a patch to solve GEOS-3579
or have someone develop a patch for you (see the commercial support page
at geoserver.org)

Cheers
Andrea

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

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geoserver-users mailing list
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users