This has been a frustrating subject for a long time.
I worked in DB2 development until I retired last year and never managed
to get a straight answer to this.
It is of concern to me as I developed the DB2 support for Geotools,
Geoserver and uDig. My approach with uDig (not yet delivered) is t
When using the GeoTools tutorial sample to display a map, modified for
DB2, the query generated creates a filter a little greater than the data
bounding box. This is time-consuming to process, checking if each
feature is within the query area where a straight table-scan of all the
data would be
As it has been a while since the DB2 plugin has been updated, there is
some code that is obsolete and there is some code that could be optimized.
Is it better to do this in several small pull requests or to lump them
together?
--
This email has been checked for viruses by Avast antivirus sof
--
Jody Garnett
On Tue, 19 May 2020 at 07:35, Jody Garnett mailto:jody.garn...@gmail.com>> wrote:
I think I have to add you to the geotools team in jira...
done. It is now assigned to you
--
Jody Garnett
On Tue, 19 May 2020 at 05:06,
I have a fix to the DB2 plugin for GEOT-6584.
How do I get this assigned to me?
On 5/18/2020 6:37 PM, Jody Garnett wrote:
As per last meeting I am schedule to make a release this week. If you
are working on a fix, or waiting for something to be back ported,
please speak up!
Looking at outsta
Title: Message Title
David Adler created
Title: Message Title
David Adler created
David Adler created GEOT-4089:
-
Summary: Loose BBOX is not supported for DB2
Key: GEOT-4089
URL: https://jira.codehaus.org/browse/GEOT-4089
Project: GeoTools
Issue Type: Bug
Components
The DB2 internal geometry representation uses integer coordinate values
that are compressed. The ST_AsBinary and ST_AsText functions are
provided as ways for applications to work with the spatial data in an
industry standard (OGC and ISO) format.
The various spatial constructors accept data in
Thank you for cc'ing me. I've been very tied up with other spatial work
and the volume of posts to the GeoTools-related newsgroups has been hard
to keep up with.
What is the timeframe for this work and where is the design documentation?
Regards,
David
Andrea Aime wrote:
> Christian Müller ha
, 2.4.2, 2.3.6, 2.5-M1
Environment: All
Reporter: David Adler
Assignee: David Adler
Fix For: 2.4.2, 2.3.6, 2.5-M1
The DB2DataStore has used the WKTReader to access the geometries but this is
not the most efficient and there have been problems with some
If trace is on at the INFO level, I don't think it is inappropriate to
get the trace message from the DB2DataStore that the DB2 driver (jar
files) is not found. It isn't putting out a stack trace.
David
sfarber wrote:
> I agree. It's annoying. And if I didn't write that code, at the minimum
From the developer guide documentation it isn't completely clear what
the approval process is - it says to "ask" for inclusion in the next
release.
So I'm "asking". :-)
- This has been supported since the GT 2.1 release with updates for each
point release
- It implemented the GeoAPI filter in
The DB2 JDBC Type 4 drivers are now redistributable and it would make
life much simpler if these were used instead of the dummy JDBC jar.
I don't have authority to upload them directly. How can I get them
installed? The zip file containing the driver is 1.8MB.
/software/data/db2/java/
These seem to be for DB2 9 although I think they are pretty generic and
version independent.
I will try them in my local Maven repository and updated pom.xml.
Andrea Aime wrote:
> David Adler ha scritto:
>> Sorry about that.
>>
>> I was testing with
s needed on my plugin's wiki page:
> - http://docs.codehaus.org/display/GEOTOOLS/EPSG-Oracle+Plugin
>
> When you figure it out I will try and follow suite,
> Jody
> David Adler wrote:
>> I'm working on making the DB2 tests consistent with the recommended
>> onli
Sorry about that.
I was testing with the live DB2 drivers and forget to change the
comments back before committing the pom.xml. Hopefully this is fixed now.
Is there a better way to deal with this situation?
A while back, I had found an IBM DB2 web site that indicated the DB2
JDBC drivers coul
nment: All
Reporter: David Adler
Assignee: David Adler
Fix For: 2.5.0
The DB2 testcases should be used to extend the OnlineTestCase class and have
naming that conforms to the 'Online' mechanism.
--
This message is automatically generated by JIRA.
-
I'm having problems getting the existing junit tests to run. I suspect
there may be a problem with the version of 'geoapi-nogenerics' that is
built against vs runtime.
The following is part of the Java stack trace:
java.lang.NoSuchMethodError:
org.opengis.feature.simple.SimpleFeatureType.getA
ajor code change that occurred in the 2.4.x timeframe?
>
> The reason I ask is David Adler has been asking what he needs to do to
> get supported status, and changing implementation of SQL Splitter (and
> changing over to GeoAPI filter) would be the major check points
> associated wit
What is needed to make this change, both procedurally and logistically?
David
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration
I hope it is appropriate to post this information.
There had been some problems with synchronizing the code levels of the
downloads for DB2 9 Express-C and DB2 9 Spatial Extender.
DB2 9 Express-C and DB2 9 Spatial Extender are now available for free
download at:
http://www-306.ibm.com/software/
: 2.4-M4
Environment: all
Reporter: David Adler
Assignee: David Adler
Priority: Minor
Fix For: 2.4-RC0
Somehow the test table creation and the expected results got out of sync.
--
This message is automatically generated by JIRA.
-
If you
Sounds reasonable with a quick read. I'm out of town this week but will
take a more detailed look when I get back.
One of our customers had been asking for data source support a few
months ago.
David
Andrea Aime wrote:
> Hi,
> I've updated the connection pooling
> http://docs.codehaus.org/di
Versions: 2.4.M2
Environment: All
Reporter: David Adler
Assignee: David Adler
Priority: Minor
Fix For: 2.4.M2
Need to support new geoAPI feature model for database queries.
--
This message is automatically generated by JIRA.
-
If you think it
I ran into the same problem when handling a geometry literal. How is a
developer supposed to know that the call to accept needs to include an
extraData parameter of Geometry.class in this case?
Farber, Saul (ENV) wrote:
> Rob,
>
> Yeah, cory's right. The 'extraData' object in the FilterVisitor
It isn't clear to me what the relationship is of the opengis
FilterCapabilities and the geotools FilterCapabilities.
With the switch to the opengis filters, should the geotools
FilterCapabilities still be used?
I've mostly converted SQLEncoderDB2 over to use FilterToSQL.
Andrea Aime wrote:
>
Are there JavaDocs for these?
I'm trying to upgrade to the new filter architecture and it would be
helpful to have more reference than the information at
http://docs.codehaus.org/display/GEOTOOLS/Upgrade+to+2.4#Upgradeto2.4-filter
---
I'm a little confused as to where this stands.
The comments in FilterToSQL states that it has been tested for PostGIS
and MySQL but SQLEncoderPostgis still appears to be based on the old
SQLEncoder which has been deprecated in GT 2.4.
Am I looking in the wrong place?
David
--
: David Adler
Fix For: 2.3.1, 2.4.0
There are some minor syntactic fixes required for spatial support of DB2 on z/OS
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure
nd, jdbc module maintainers like you and myself would be
in a better position to possibly switch over.
-Justin
David Adler wrote:
What is H2?
I'm certainly interested in the JDBC and DataStore topic, although
fixing this may be considerable work.
David
Chris Holmes wrote:
be
useful, but that much of what we try to do is likely better off in some
utility classes. We've had a lot of good lessons, and we should try to
learn from them, make it easier for others to write new jdbc
datastores. Should definitely talk to David Adler as well, he had some
ideas on how to ma
I'm trying to get my GT development environment setup and running on
another system.
With the 2.3.x branch, my JUnit test was getting back coordinate in DMS
format instead of decimal degrees. I added
gt2-epst-wkt-2.3.1-SNAPSHOT.jar to the path and it then gets an exception:
java.lang.NoSuchFie
[EMAIL PROTECTED] should work. Is this what was getting rejected? I have
a bunch of others but prefer to use this with the newsgroup.
Regards,
David
At 02:49 PM 11/7/2006, Jody Garnett wrote:
>I am find a lot of my messages to him "returned"... or perhaps it was
>something I said ;-D
>Jody
>
>
I never quite understood the purpose of TypedFIDMapper but tried to keep
the functionality
consistent with the changes I made to the FIDMapper classes.
If the DefaultFIDMapperFactory is changed, it will break some of the DB2
junit testcases although
this isn't a major problem. Whether it breaks
excerpt}
>being used to show their current "rating".
>David Adler you may wish to review the DB2 Plugin page made yesterday.
>
>Cheers,
>Jody
>
>-
>Using Tomcat but need to do more? Need to suppo
Who controls this domain and where it redirects to?
Currently, this redirects to
http://geotools.codehaus.org/
which is a bit flakey. Some of the links work, others don't.
http://docs.codehaus.org/display/GEOTOOLS/Home
seems to be considerably more robust.
As we update the IBM spatial web site,
I haven't been following the discussion on this.
What does "unsupported" mean and where are the modules going?
Regards,
David (DB2 plug-in supporter)
At 11:11 AM 10/31/2006, Martin Desruisseaux wrote:
>The modules listed in GTSteering document as "unsupported" are:
>
>arcsde
>db2
>directory
>eps
I've updated the Spearfish demo to work with the GeoTools 2.2 and 2.3
MapPane.
It supports both the DB2 data store and the Shapefile data store by
changing a parameter. The shapefile data including .prj and .sld files is
in a subdirectory in the zip file at
http://docs.codehaus.org/display/GEO
I'm getting the following messages from 'mvn install' - this must be an
obvious problem.
I just did an 'svn update'.
[INFO] Scanning for projects...
[INFO]
[ERROR] FATAL ERROR
[INFO]
Is there any script or readme file to run this? Or documentation on what
jar files are pre-requisites at runtime?
It took over an hour to get this going, finding the jar files one by one
after getting "ClassNotFound" errors.
Is there some straightforward way of determining what the pre-requisi
I have a bunch of DB2 fixes on 2.2.x that need to go into 2.3. It
shouldn't be a problem except that mvn install fails on 2.3.x due to syntax
errors in the pom.xml files and I haven't pursued this for the past week.
At 04:51 PM 10/23/2006, Adrian Custer wrote:
>hey all,
>
>I'd suggest doing a f
I'm in favor.
Is this related to GEOT-894?
At 07:14 PM 10/17/2006, Cory Horner wrote:
>Howdy,
>
>We're changing the way uDig uses transactions -- so a transaction is
>AUTO_COMMIT until a modification occurs, and it remains open until the
>user commits the transaction:
>
>http://jira.codehaus.org/
"demo-introduction"? The static main method in
MapViewer.java?
regards,
David
At 07:37 AM 10/17/2006, Adrian Custer wrote:
>Hello,
>
>On Tue, 2006-10-17 at 07:19 -0400, David Adler wrote:
> > Is there any script or readme file to run this? Or documentation on what
>
It isn't clear what the target user audience is for GeoTools.
For the 2.0/2.1 era of GeoTools, there is a considerable set of examples
and snippets and other documentation to help in building GeoTools
applications. We modified the Spearfish demo to work with DB2.
Many of these are no longer v
Is there any script or readme file to run this? Or documentation on what
jar files are pre-requisites at runtime?
It took over an hour to get this going, finding the jar files one by one
after getting "ClassNotFound" errors.
Is there some straightforward way of determining what the pre-requisi
I'm trying to apply the DB2 changes I made to 2.2.x to 2.3.x and trunk.
I tried the command:
svn merge -r 21897:21898 http://svn.geotools.org/branches/2.2.x
in my 2.3.x source tree and got the messages
svn: REPORT request failed on '/!svn/vcc/default'
svn:
Cannot replace a directory from within
I fixed it right after getting Justin's note.
It isn't fixed in trunk yet and 2.3.x is a mess.
At 10:06 AM 10/7/2006, [EMAIL PROTECTED] wrote:
>Justin Deoliveira ha scritto:
> > Hi all,
> >
> > I just went to backport a patch to 2.2.x and found that db2 doesn't
> > compile. Can anyone verify?
> >
Reporter: David Adler
Assigned To: David Adler
Fix For: 2.2.1
Haven't checked anything in for a long time. Tests seem to run ok with this
level so commit it for now. Need to figure out how to fit into 2.3.x and trunk.
--
This message is automatically generated by JIRA.
Affects Versions: 2.3.M0, 2.2.0
Environment: All
Reporter: David Adler
Assigned To: David Adler
Fix For: 2.3
It isn't completely clear why, but the NullFID Filter is now returning a FID
column of "null" instead of indicating that there are ze
I have considerable interest in making sure that this is consistent with
the DB2DataStore.
At 10:30 AM 8/17/2006, Vitali Diatchkov wrote:
>I expected that you will be a person from whom I get a feedback:)
>
>I see you agree that the current JDBC design is worth to be made better. We
>need rich
I've checked in the changes to the 22x branch. It would be very helpful if
someone could check if the PostGIS DataStore still works before I move
these changes into trunk.
-
Using Tomcat but need to do more? Need to supp
There is an snippet at http://geotools.codehaus.org/LiteRendering which
shows rendering to an image buffer.
I'm not sure if this helps if one wants to draw a nice map using the
various styles.
At 03:27 PM 7/11/2006, Adrian Custer wrote:
>On Tue, 2006-07-11 at 14:43 -0400, Natarajan, Senthil wr
n internal
>record of what the next value should be, and it is not always the
>same as the value returned by SELECT MAX(ID). (the internal record
>increases on inserts but doesn't decrease on deletes, if that makes
>sense? I think PostGIS sequence values are the same?)
>
>Mi
ng
> > "SELECT last_insert_id()". I'm not familiar with Oracle, but it looks
> > like it also has sequences, and could be implemented using something
> > like "seq_name.CURVAL".
>
>On Jul 6, 2006, at 3:28 AM, David Adler wrote:
>
> > I woul
Hi Jody, what a job to look through the copyright statements!
I will see what I can find out from the IBM IP dept. At the time this code
was developed, I thought the copyright statement was ok although I'm not
sure I can find the history on this.
In poking around, there seem to be anomalies in
I would like to implement this and would like to check if anyone has any
objections. The interface should not change except for MaxIncFIDMapper
which I believe incorrectly returns hardcoded Types.VARCHAR for the column
type when it should return the type of the actual fid column. (Since it
as
Adler
Assigned to: David Adler
Fix For: 2.3, 2.2-RC4
JDBC type2 and type4 drivers are not being handled correctly. If the port
value is zero, we should use type2. If the port value is not zero, use type4.
--
This message is automatically generated by JIRA.
-
If you think it was sent
It is good to see the geotools.org web site back but the Developers Guide
link to http://geotools.codehaus.org/display/GEOT/Home appears to be broken.
I'm trying to get my 2.2.x environment working again but it is pretty
broken at this point.
svn update updated a bunch of files but got some err
/, I ended up at
http://www.codehaus.org/ instead.
Regards,
David
At 11:17 AM 5/24/2006, Jody Garnett wrote:
David Adler wrote:
Please note that I am not
speaking in any official capacity on behalf of IBM.No fear
David we understand. Indeed we are more interested in making you happy,
you contrib
er.
FWIW - "For what its worth"
David
At 09:21 AM 5/24/2006, Jody Garnett wrote:
David Adler wrote:
I would like to consider GeoTools and GeoServer for some IBM offerings
but it is very difficult to get approval for anything other than the
Apache license.
David this is good informat
y far.
These IP issues tend to be a real pain in the neck.
David
At 03:02 AM 3/31/2006, Jody Garnett wrote:
Introductions:
- David Adler - geotools DB2 module maintainer
- Frank - OSGEO fellow helping us figure out IP issues
- Gabriel Roldan - geotools arcsde module maintainer
- Jody Ga
MaxIncFIDMapper returns wrong column type / size
Key: GEOT-728
URL: http://jira.codehaus.org/browse/GEOT-728
Project: GeoTools
Type: Bug
Components: main
Environment: All
Reporter: David Adler
Assigned to
63 matches
Mail list logo