[Geoserver-users] Couple of queries on 1.4

Chris_Tweedie1 · October 18, 2006, 11:13am

1. The ArcSDE jar under "GeoServer Extras 1.4.x" seems to be incomplete. The package only contains a .pom file?? The others all seem fine though.

2. I have seen a few other people post this, but is there any reason why Geoserver does not output the SQL query it sends to the db even when loglevel is set to all? I could have sworn this info was available in the logs on earlier builds (maybe 1.2.x series). Its very difficult trying to debug WFS performance issues when you can not accurately see what Geoserver is requesting from the db. All i can see on 1.3.x and now 1.4 is the standard filter formulation ... show me the sql!

Thanks guys,

Chris

Brent_Owens1 · October 18, 2006, 3:33pm

Oops, that ArcSDE problem would be my fault. I will correct he file and upload a new version.

I agree that the SQL in the query would be nice to see.
If you make a Jira task for it we can get it out for a later release.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

1. The ArcSDE jar under "GeoServer Extras 1.4.x" seems to be incomplete. The package only contains a .pom file?? The others all seem fine though.

2. I have seen a few other people post this, but is there any reason why Geoserver does not output the SQL query it sends to the db even when loglevel is set to all? I could have sworn this info was available in the logs on earlier builds (maybe 1.2.x series). Its very difficult trying to debug WFS performance issues when you can not accurately see what Geoserver is requesting from the db. All i can see on 1.3.x and now 1.4 is the standard filter formulation ... show me the sql!

Thanks guys,

Chris

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Chris_Holmes1 · October 18, 2006, 4:36pm

Chris, is it not setting the output SQL for any datastores? Or just for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries with that'd be great. I do think this should be a blocker before 1.4.0, since it's like flying blind without knowing that, but it's done on a per datastore basis.

best regards,

Chris

Brent Owens wrote:

Oops, that ArcSDE problem would be my fault. I will correct he file and upload a new version.

I agree that the SQL in the query would be nice to see.
If you make a Jira task for it we can get it out for a later release.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

1. The ArcSDE jar under "GeoServer Extras 1.4.x" seems to be incomplete. The package only contains a .pom file?? The others all seem fine though.

2. I have seen a few other people post this, but is there any reason why Geoserver does not output the SQL query it sends to the db even when loglevel is set to all? I could have sworn this info was available in the logs on earlier builds (maybe 1.2.x series). Its very difficult trying to debug WFS performance issues when you can not accurately see what Geoserver is requesting from the db. All i can see on 1.3.x and now 1.4 is the standard filter formulation ... show me the sql!

Thanks guys,

Chris

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,45364982209734750375898!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

Chris_Tweedie1 · October 19, 2006, 12:51am

Thanks for the fixing the plugin Brent, but this new version doesn't want to work.

Previously i was using the 1.3.x plugin which worked fine, but now when trying to add the datastore (using same connections params) ...

form connection params { password="xxxxx", pool.minConnections=2, user="sde", instance="", pool.maxConnections=2, pool.timeOut=1000, server="test", port=60170, dbtype="arcsde"}
182422 [WARNING] org.geotools.data.arcsde.ConnectionConfig - No database name specified
182422 [WARNING] org.geotools.data.arcsde.ConnectionConfig - No database name specified
182422 [WARNING] org.geotools.data.arcsde.ConnectionConfig - No database name specified
java.lang.NoClassDefFoundError: org/apache/commons/pool/PoolableObjectFactory
  at org.geotools.data.arcsde.ConnectionPoolFactory.createPool(ConnectionPoolFactory.java:79)
  at org.geotools.data.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:143)
  at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:131)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
       ............

Any ideas?

I guess my next query would be the difference between the versions. I can see this vers is from the newer geotools build ... but what exactly is the differences or improvements?

@Chris: I dont have access to postgis/oracle at the moment so i couldnt confirm whether SQL output is there or not. I realise SDE isnt "SQL", but i'd still like to see what Geoserver is requesting in order to narrow things down. Judging from some other similar posts to the mailinglist, maybe it is across the other datastores. I just logged http://jira.codehaus.org/browse/GEOS-747 on this for your reference.

Cheers lads,

On Wed, 18 Oct 2006 12:36:22 -0400, Chris Holmes <cholmes@anonymised.com> wrote:

Chris, is it not setting the output SQL for any datastores? Or just for
ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send
some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries
with that'd be great. I do think this should be a blocker before 1.4.0,
since it's like flying blind without knowing that, but it's done on a
per datastore basis.

best regards,

Chris

Brent Owens wrote:

Oops, that ArcSDE problem would be my fault. I will correct he file and
upload a new version.

I agree that the SQL in the query would be nice to see.
If you make a Jira task for it we can get it out for a later release.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

1. The ArcSDE jar under "GeoServer Extras 1.4.x" seems to be

incomplete. The package only contains a .pom file?? The others all seem
fine though.

2. I have seen a few other people post this, but is there any reason

why Geoserver does not output the SQL query it sends to the db even when
loglevel is set to all? I could have sworn this info was available in the
logs on earlier builds (maybe 1.2.x series). Its very difficult trying to
debug WFS performance issues when you can not accurately see what
Geoserver is requesting from the db. All i can see on 1.3.x and now 1.4 is
the standard filter formulation ... show me the sql!

Thanks guys,

Chris

-------------------------------------------------------------------------

Using Tomcat but need to do more? Need to support web services,

security?

Get stuff done quickly with pre-integrated technology to make your job

easier

Download IBM WebSphere Application Server v.1.0.1 based on Apache

Geronimo

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------

Using Tomcat but need to do more? Need to support web services,

security?

Get stuff done quickly with pre-integrated technology to make your job

easier

Download IBM WebSphere Application Server v.1.0.1 based on Apache

Geronimo

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,45364982209734750375898!

--
Chris Tweedie

Chris_Holmes1 · October 19, 2006, 3:10pm

Sounds like you just need to stick the commons pool jar in it. You can download it from: http://jakarta.apache.org/site/downloads/downloads_commons-pool.cgi

The 1.4.x is actually very similar to 1.3.x - both are built off of geotools 2.2.x. Try the 1.3.x with the 1.4.0-RC1, and see if that works. If you get the same error it's likely that we were including the pool jar in 1.3.x. If you don't then I guess ArcSDE switched pool implementations. But it sounds like downloading that jar should work fine.

Gabriel, is there any way to see the ArcSDE query going to the backend? Looking at the code I see a few logs in ArcSDEQuery. Like: if (LOGGER.isLoggable(Level.FINE)) {
             LOGGER.fine("constructing new sql query with connection: "
                 + connection + ", propnames: "
                 + java.util.Arrays.asList(propertyNames) + " sqlConstruct: "
                 + this.filters.getSeSqlConstruct());
         }

Chris, try setting to fine and grepping for the 'constructing new sql query with connection: ' And Gabriel, can you confirm that the logging is still working?

Chris

Chris Tweedie wrote:

Thanks for the fixing the plugin Brent, but this new version doesn't want to work.

Previously i was using the 1.3.x plugin which worked fine, but now when trying to add the datastore (using same connections params) ...

form connection params { password="xxxxx", pool.minConnections=2, user="sde", instance="", pool.maxConnections=2, pool.timeOut=1000, server="test", port=60170, dbtype="arcsde"}
182422 [WARNING] org.geotools.data.arcsde.ConnectionConfig - No database name specified
java.lang.NoClassDefFoundError: org/apache/commons/pool/PoolableObjectFactory
  at org.geotools.data.arcsde.ConnectionPoolFactory.createPool(ConnectionPoolFactory.java:79)
  at org.geotools.data.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:143)
  at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:131)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
       ............

Any ideas?

I guess my next query would be the difference between the versions. I can see this vers is from the newer geotools build ... but what exactly is the differences or improvements?

@Chris: I dont have access to postgis/oracle at the moment so i couldnt confirm whether SQL output is there or not. I realise SDE isnt "SQL", but i'd still like to see what Geoserver is requesting in order to narrow things down. Judging from some other similar posts to the mailinglist, maybe it is across the other datastores. I just logged http://jira.codehaus.org/browse/GEOS-747 on this for your reference.

Cheers lads,

On Wed, 18 Oct 2006 12:36:22 -0400, Chris Holmes <cholmes@anonymised.com> wrote:

Chris, is it not setting the output SQL for any datastores? Or just for
ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send
some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries
with that'd be great. I do think this should be a blocker before 1.4.0,
since it's like flying blind without knowing that, but it's done on a
per datastore basis.

best regards,

Chris

Brent Owens wrote:

Oops, that ArcSDE problem would be my fault. I will correct he file and
upload a new version.

I agree that the SQL in the query would be nice to see.
If you make a Jira task for it we can get it out for a later release.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

1. The ArcSDE jar under "GeoServer Extras 1.4.x" seems to be

incomplete. The package only contains a .pom file?? The others all seem
fine though.

2. I have seen a few other people post this, but is there any reason

why Geoserver does not output the SQL query it sends to the db even when
loglevel is set to all? I could have sworn this info was available in the
logs on earlier builds (maybe 1.2.x series). Its very difficult trying to
debug WFS performance issues when you can not accurately see what
Geoserver is requesting from the db. All i can see on 1.3.x and now 1.4 is
the standard filter formulation ... show me the sql!

Thanks guys,

Chris

-------------------------------------------------------------------------

Using Tomcat but need to do more? Need to support web services,

security?

Get stuff done quickly with pre-integrated technology to make your job

easier

Download IBM WebSphere Application Server v.1.0.1 based on Apache

Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------

Using Tomcat but need to do more? Need to support web services,

security?

Get stuff done quickly with pre-integrated technology to make your job

easier

Download IBM WebSphere Application Server v.1.0.1 based on Apache

Geronimo

http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Chris Tweedie

!DSPAM:1003,4536cc0d301836309890654!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

Andrea_Aime3 · October 19, 2006, 4:07pm

Chris Tweedie ha scritto:

Thanks for the fixing the plugin Brent, but this new version doesn't want to work.

Previously i was using the 1.3.x plugin which worked fine, but now when trying to add the datastore (using same connections params) ...

form connection params { password="xxxxx", pool.minConnections=2, user="sde", instance="", pool.maxConnections=2, pool.timeOut=1000, server="test", port=60170, dbtype="arcsde"}
182422 [WARNING] org.geotools.data.arcsde.ConnectionConfig - No database name specified
java.lang.NoClassDefFoundError: org/apache/commons/pool/PoolableObjectFactory
  at org.geotools.data.arcsde.ConnectionPoolFactory.createPool(ConnectionPoolFactory.java:79)
  at org.geotools.data.arcsde.ArcSDEDataStoreFactory.createDataStore(ArcSDEDataStoreFactory.java:143)
  at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:131)
  at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)
       ............

Any ideas?

Well, it seems to me we do have arcsde.jar around, but not its dependencies. We should
carry them as well. (which is just commons-pool in this case, the pom lists also the dummy-api
file but it's a mistake, opened an issue about it, http://jira.codehaus.org/browse/GEOT-985).

Cheers
Andrea

Andrea_Aime3 · October 19, 2006, 4:55pm

Chris Holmes ha scritto:

Chris, is it not setting the output SQL for any datastores? Or just for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries with that'd be great. I do think this should be a blocker before 1.4.0, since it's like flying blind without knowing that, but it's done on a per datastore basis.

Ok, I checked the code and I can confirm there's a logging statement in the common
jdbc datastores superclass that does log the sql statement. There's a catch thought:
when you configure the logging level from the user interface, it's not changed on the
fly, you need to restart geoserver instead. (after restart I can see the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

Brent_Owens1 · October 19, 2006, 5:02pm

I have noticed that too, where I have to restart to see the logging level change.

Brent Owens
(The Open Planning Project)

Andrea Aime wrote:

Chris Holmes ha scritto:

Chris, is it not setting the output SQL for any datastores? Or just for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries with that'd be great. I do think this should be a blocker before 1.4.0, since it's like flying blind without knowing that, but it's done on a per datastore basis.

Ok, I checked the code and I can confirm there's a logging statement in the common
jdbc datastores superclass that does log the sql statement. There's a catch thought:
when you configure the logging level from the user interface, it's not changed on the
fly, you need to restart geoserver instead. (after restart I can see the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

Chris_Holmes1 · October 19, 2006, 6:18pm

I'm pretty positive it has _not_ always been like that. Sounds like perhaps may be a bug on 1.4? I just confirmed that on 1.3.x it works. This is pretty important, to be able to see changes on the fly.

Also, Andrea, note that ArcSDE is not an extension of JDBCDataStore, so it won't pick up that logging statement.

Chris, could you try a restart and see if that gets you more arcsde logging?

Chris

Brent Owens wrote:

I have noticed that too, where I have to restart to see the logging level change.

Brent Owens
(The Open Planning Project)

Andrea Aime wrote:

Chris Holmes ha scritto:

Chris, is it not setting the output SQL for any datastores? Or just for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if we send some text command or if it's just modifying stuff in their api.

If you could report on which datastores you're not getting SQL queries with that'd be great. I do think this should be a blocker before 1.4.0, since it's like flying blind without knowing that, but it's done on a per datastore basis.

Ok, I checked the code and I can confirm there's a logging statement in the common
jdbc datastores superclass that does log the sql statement. There's a catch thought:
when you configure the logging level from the user interface, it's not changed on the
fly, you need to restart geoserver instead. (after restart I can see the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

!DSPAM:1003,4537af9371687731818748!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

Chris_Tweedie1 · October 19, 2006, 10:14pm

Will let you know when i get into work, thanks.

Brent: any news on the 1.4 arcsde plugin not working? (see previous mail)

On Thu, 19 Oct 2006 14:18:19 -0400, Chris Holmes <cholmes@anonymised.com> wrote:

I'm pretty positive it has _not_ always been like that. Sounds like
perhaps may be a bug on 1.4? I just confirmed that on 1.3.x it works.
This is pretty important, to be able to see changes on the fly.

Also, Andrea, note that ArcSDE is not an extension of JDBCDataStore, so
it won't pick up that logging statement.

Chris, could you try a restart and see if that gets you more arcsde
logging?

Chris

Brent Owens wrote:

I have noticed that too, where I have to restart to see the logging
level change.

Brent Owens
(The Open Planning Project)

Andrea Aime wrote:

Chris Holmes ha scritto:

Chris, is it not setting the output SQL for any datastores? Or just
for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if
we send some text command or if it's just modifying stuff in their

api.

If you could report on which datastores you're not getting SQL
queries with that'd be great. I do think this should be a blocker
before 1.4.0, since it's like flying blind without knowing that, but
it's done on a per datastore basis.

Ok, I checked the code and I can confirm there's a logging statement
in the common
jdbc datastores superclass that does log the sql statement. There's a
catch thought:
when you configure the logging level from the user interface, it's not
changed on the
fly, you need to restart geoserver instead. (after restart I can see
the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

!DSPAM:1003,4537af9371687731818748!

--
Chris Tweedie

Brent_Owens1 · October 19, 2006, 10:23pm

Hi Chris
I haven't played with the ArcSDE module so I'm not sure what has changed, maybe someone else has made some changes and can shed some light on the problem. The NoClassDefFoundError looks like a jar might be missing somewhere or could have been moved.
Lets see if the GeoTools list has an idea.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

Will let you know when i get into work, thanks.

Brent: any news on the 1.4 arcsde plugin not working? (see previous mail)

On Thu, 19 Oct 2006 14:18:19 -0400, Chris Holmes <cholmes@anonymised.com> wrote:


I'm pretty positive it has _not_ always been like that. Sounds like
perhaps may be a bug on 1.4? I just confirmed that on 1.3.x it works.
This is pretty important, to be able to see changes on the fly.

Also, Andrea, note that ArcSDE is not an extension of JDBCDataStore, so
it won't pick up that logging statement.

Chris, could you try a restart and see if that gets you more arcsde
logging?

Chris

Brent Owens wrote:


I have noticed that too, where I have to restart to see the logging
level change.

Brent Owens
(The Open Planning Project)

Andrea Aime wrote:


Chris Holmes ha scritto:


Chris, is it not setting the output SQL for any datastores? Or just
for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if
we send some text command or if it's just modifying stuff in their


api.


If you could report on which datastores you're not getting SQL
queries with that'd be great. I do think this should be a blocker
before 1.4.0, since it's like flying blind without knowing that, but
it's done on a per datastore basis.


Ok, I checked the code and I can confirm there's a logging statement
in the common
jdbc datastores superclass that does log the sql statement. There's a
catch thought:
when you configure the logging level from the user interface, it's not
changed on the
fly, you need to restart geoserver instead. (after restart I can see
the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

!DSPAM:1003,4537af9371687731818748!

--
Chris Tweedie

Chris_Holmes1 · October 19, 2006, 10:27pm

Hrm, I thought I sent an email out about it. Chris, try the binary download from: http://jakarta.apache.org/site/downloads/downloads_commons-pool.cgi

Put the jar in your classpath and see if that works. That's the classdef that appears to be missing.

If that fixes the problem we'll start shipping the plug-in with that jar.

Chris

Brent Owens wrote:

Hi Chris
I haven't played with the ArcSDE module so I'm not sure what has changed, maybe someone else has made some changes and can shed some light on the problem. The NoClassDefFoundError looks like a jar might be missing somewhere or could have been moved.
Lets see if the GeoTools list has an idea.

Brent Owens
(The Open Planning Project)

Chris Tweedie wrote:

Will let you know when i get into work, thanks.

Brent: any news on the 1.4 arcsde plugin not working? (see previous mail)

On Thu, 19 Oct 2006 14:18:19 -0400, Chris Holmes <cholmes@anonymised.com> wrote:


I'm pretty positive it has _not_ always been like that. Sounds like
perhaps may be a bug on 1.4? I just confirmed that on 1.3.x it works.
This is pretty important, to be able to see changes on the fly.

Also, Andrea, note that ArcSDE is not an extension of JDBCDataStore, so
it won't pick up that logging statement.

Chris, could you try a restart and see if that gets you more arcsde
logging?

Chris

Brent Owens wrote:


I have noticed that too, where I have to restart to see the logging
level change.

Brent Owens
(The Open Planning Project)

Andrea Aime wrote:


Chris Holmes ha scritto:


Chris, is it not setting the output SQL for any datastores? Or just
for ArcSDE? ArcSDE doesn't really support sql, and I'm not sure if
we send some text command or if it's just modifying stuff in their


api.


If you could report on which datastores you're not getting SQL
queries with that'd be great. I do think this should be a blocker
before 1.4.0, since it's like flying blind without knowing that, but
it's done on a per datastore basis.


Ok, I checked the code and I can confirm there's a logging statement
in the common
jdbc datastores superclass that does log the sql statement. There's a
catch thought:
when you configure the logging level from the user interface, it's not
changed on the
fly, you need to restart geoserver instead. (after restart I can see
the queries performed
against my local postgis datastore). Has it always been like this?

Cheers
Andrea

--
Chris Tweedie

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

!DSPAM:1003,4537faca121682223018498!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

Tyler_Erickson1 · December 5, 2006, 3:04pm

I am running into a seemingly related problem when attempting to create an
ArcSDE data store. After reading the message on the commons pool jar, I
downloaded the commons-pool-1.3.jar file from the Jakarta website and placed
it in the Geoserver lib folder \webapps\geoserver\WEB-INF\lib along with the
ArcSDE jar files ( jpe91_sdk.jar, jsde91_sdk.jar,
gt2-arcsde-2.2.2-SNAPSHOT.jar).

On the Config->Data->Stores->Edit screen for the ArcSDE datastore, after I
enter the required fields (server, port, user, password) and click Submit, I
receive a message '*
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;' on
the left side of the screen. The wrapper log file seems to indicate that it
is unable to find the PooledConnection.getLayers() method.

Is this the correct commons-pool-1.3.jar file to be using?
Or am I missing another jar file that contains the getLayers() method?

Here is an excerpt from wrapper.log:
INFO | jvm 1 | 2006/12/05 09:48:43 | form connection params {
password="secret", pool.minConnections=2, user="test_user", instance="",
pool.maxConnections=2, pool.timeOut=1000, server="test", port=5153,
dbtype="arcsde"}
INFO | jvm 1 | 2006/12/05 09:48:44 | java.lang.NoSuchMethodError:
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEConnectionPool.getAvailableLayerNames(ArcSDEConnectionPool.java:373)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEDataStore.getTypeNames(ArcSDEDataStore.java:142)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:144)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)

Chris Holmes wrote:

Sounds like you just need to stick the commons pool jar in it. You can
download it from:
http://jakarta.apache.org/site/downloads/downloads_commons-pool.cgi

The 1.4.x is actually very similar to 1.3.x - both are built off of
geotools 2.2.x. Try the 1.3.x with the 1.4.0-RC1, and see if that
works. If you get the same error it's likely that we were including the
pool jar in 1.3.x. If you don't then I guess ArcSDE switched pool
implementations. But it sounds like downloading that jar should work
fine.

--
View this message in context: http://www.nabble.com/Couple-of-queries-on-1.4-tf2465891.html#a7700925
Sent from the GeoServer - User mailing list archive at Nabble.com.

Farber_Saul_EEA · December 5, 2006, 5:22pm

Which version of geoserver are you using Tyler?

I have an SDE instance available, so I can double-check if there's an error in the build-process for the latest 1.4 geoserver or something.

--saul

Tyler Erickson wrote:

I am running into a seemingly related problem when attempting to create an
ArcSDE data store. After reading the message on the commons pool jar, I
downloaded the commons-pool-1.3.jar file from the Jakarta website and placed
it in the Geoserver lib folder \webapps\geoserver\WEB-INF\lib along with the
ArcSDE jar files ( jpe91_sdk.jar, jsde91_sdk.jar,
gt2-arcsde-2.2.2-SNAPSHOT.jar).

On the Config->Data->Stores->Edit screen for the ArcSDE datastore, after I
enter the required fields (server, port, user, password) and click Submit, I
receive a message '*
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;' on
the left side of the screen. The wrapper log file seems to indicate that it
is unable to find the PooledConnection.getLayers() method.

Is this the correct commons-pool-1.3.jar file to be using?
Or am I missing another jar file that contains the getLayers() method?

Here is an excerpt from wrapper.log:
INFO | jvm 1 | 2006/12/05 09:48:43 | form connection params {
password="secret", pool.minConnections=2, user="test_user", instance="",
pool.maxConnections=2, pool.timeOut=1000, server="test", port=5153,
dbtype="arcsde"}
INFO | jvm 1 | 2006/12/05 09:48:44 | java.lang.NoSuchMethodError:
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEConnectionPool.getAvailableLayerNames(ArcSDEConnectionPool.java:373)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEDataStore.getTypeNames(ArcSDEDataStore.java:142)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:144)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)

Chris Holmes wrote:

Sounds like you just need to stick the commons pool jar in it. You can download it from: http://jakarta.apache.org/site/downloads/downloads_commons-pool.cgi

The 1.4.x is actually very similar to 1.3.x - both are built off of geotools 2.2.x. Try the 1.3.x with the 1.4.0-RC1, and see if that works. If you get the same error it's likely that we were including the pool jar in 1.3.x. If you don't then I guess ArcSDE switched pool implementations. But it sounds like downloading that jar should work
fine.

Chris_Holmes1 · December 5, 2006, 5:26pm

Saul, do you remember the conclusion of the whole commons pool jar? Could you try downloading the latest arcsde plugin and seeing if you can get it to work?

http://sourceforge.net/project/downloading.php?group_id=25086&use_mirror=umn&filename=arcsde-plugin.zip&68650487

Brent can work on a bit of testing and updating the jars for that download as well.

Chris

Saul Farber wrote:

Which version of geoserver are you using Tyler?

I have an SDE instance available, so I can double-check if there's an error in the build-process for the latest 1.4 geoserver or something.

--saul

Tyler Erickson wrote:

I am running into a seemingly related problem when attempting to create an
ArcSDE data store. After reading the message on the commons pool jar, I
downloaded the commons-pool-1.3.jar file from the Jakarta website and placed
it in the Geoserver lib folder \webapps\geoserver\WEB-INF\lib along with the
ArcSDE jar files ( jpe91_sdk.jar, jsde91_sdk.jar,
gt2-arcsde-2.2.2-SNAPSHOT.jar).

On the Config->Data->Stores->Edit screen for the ArcSDE datastore, after I
enter the required fields (server, port, user, password) and click Submit, I
receive a message '*
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;' on
the left side of the screen. The wrapper log file seems to indicate that it
is unable to find the PooledConnection.getLayers() method.

Is this the correct commons-pool-1.3.jar file to be using?
Or am I missing another jar file that contains the getLayers() method?

Here is an excerpt from wrapper.log:
INFO | jvm 1 | 2006/12/05 09:48:43 | form connection params {
password="secret", pool.minConnections=2, user="test_user", instance="",
pool.maxConnections=2, pool.timeOut=1000, server="test", port=5153,
dbtype="arcsde"}
INFO | jvm 1 | 2006/12/05 09:48:44 | java.lang.NoSuchMethodError:
org.geotools.data.arcsde.PooledConnection.getLayers()Ljava/util/List;
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEConnectionPool.getAvailableLayerNames(ArcSDEConnectionPool.java:373)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.geotools.data.arcsde.ArcSDEDataStore.getTypeNames(ArcSDEDataStore.java:142)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:144)
INFO | jvm 1 | 2006/12/05 09:48:44 | at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:98)

Chris Holmes wrote:

Sounds like you just need to stick the commons pool jar in it. You can download it from: http://jakarta.apache.org/site/downloads/downloads_commons-pool.cgi

The 1.4.x is actually very similar to 1.3.x - both are built off of geotools 2.2.x. Try the 1.3.x with the 1.4.0-RC1, and see if that works. If you get the same error it's likely that we were including the pool jar in 1.3.x. If you don't then I guess ArcSDE switched pool implementations. But it sounds like downloading that jar should work
fine.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:1003,4575ab64280971971556521!

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

Tyler_Erickson1 · December 5, 2006, 5:33pm

I am using geoserver-1.4.0-RC3c

Which version of geoserver are you using Tyler?

I have an SDE instance available, so I can double-check if there's an
error in the build-process for the latest 1.4 geoserver or something.

--saul

--
View this message in context: http://www.nabble.com/Couple-of-queries-on-1.4-tf2465891.html#a7703978
Sent from the GeoServer - User mailing list archive at Nabble.com.

Farber_Saul_EEA · December 5, 2006, 10:23pm

Tyler,

It seems that the gt2-arcsde-2.2.2-SNAPSHOT.jar posted on the sourceforge site is indeed broken. I tried your exact steps with the latest posted jars on sourceforge and got your exact problem.

I then re-built the gt2-arcsde-2.2.2-SNAPSHOT.jar from the latest 2.2.x sources, and re-tested simply replacing that one jarfile. It worked.

So here's a fixed gt2-arcsde-2.2.2-SNAPSHOT.jar:

http://maps.massgis.state.ma.us/~sfarber/gt2-arcsde-2.2.2-SNAPSHOT.jar

Give that one a shot, and if it works then we'll work to get this version posted on sourceforge.

--saul

Brent_Owens1 · December 5, 2006, 10:28pm

If it works I can update the files tomorrow morning along with the RC5 release.

Thanks Saul,

Brent Owens
(The Open Planning Project)

Saul Farber wrote:

Tyler,

It seems that the gt2-arcsde-2.2.2-SNAPSHOT.jar posted on the sourceforge site is indeed broken. I tried your exact steps with the latest posted jars on sourceforge and got your exact problem.

I then re-built the gt2-arcsde-2.2.2-SNAPSHOT.jar from the latest 2.2.x sources, and re-tested simply replacing that one jarfile. It worked.

So here's a fixed gt2-arcsde-2.2.2-SNAPSHOT.jar:

http://maps.massgis.state.ma.us/~sfarber/gt2-arcsde-2.2.2-SNAPSHOT.jar

Give that one a shot, and if it works then we'll work to get this version posted on sourceforge.

--saul

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Tyler_Erickson1 · December 6, 2006, 2:00pm

I replaced the gt2-arcsde-2.2.2-SNAPSHOT.jar file in
\webapps\geoserver\WEB-INF\lib\ with the one provided by Saul. That seems
to have fixed the issue. I am now able to create an ArcSDE data store, a
feature type, and get it to display with the MapPreview Demo.

- Tyler

Brent Owens wrote:

If it works I can update the files tomorrow morning along with the RC5
release.

Thanks Saul,

Brent Owens
(The Open Planning Project)

--
View this message in context: http://www.nabble.com/Couple-of-queries-on-1.4-tf2465891.html#a7719801
Sent from the GeoServer - User mailing list archive at Nabble.com.

Blaz · January 11, 2007, 8:03am

Great fix man. Just one question. Did you try running the WFS-T with ArcSDE
and this plugin?

Saul Farber-2 wrote:

Tyler,

It seems that the gt2-arcsde-2.2.2-SNAPSHOT.jar posted on the
sourceforge site is indeed broken. I tried your exact steps with the
latest posted jars on sourceforge and got your exact problem.

I then re-built the gt2-arcsde-2.2.2-SNAPSHOT.jar from the latest 2.2.x
sources, and re-tested simply replacing that one jarfile. It worked.

So here's a fixed gt2-arcsde-2.2.2-SNAPSHOT.jar:

http://maps.massgis.state.ma.us/~sfarber/gt2-arcsde-2.2.2-SNAPSHOT.jar

Give that one a shot, and if it works then we'll work to get this
version posted on sourceforge.

--saul

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/Couple-of-queries-on-1.4-tf2465891.html#a8273204
Sent from the GeoServer - User mailing list archive at Nabble.com.