Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: None
-
Component/s: jdbc-db2 plugin
-
Labels:None
-
Environment:linux
Description
1)
The README.TXT contains old direcory infos
2)
import_places.db2 and import_roads.db2 use the Windows directory seperator
in data\roads.shp and data\places.shp. I know no easy solution so I would
recommend to move the shape files up one level and ommit the dir sep problem.
Next problem is the lower uppercase issue. The import statement uses
data\Places.shp, the file is data\places.shp. No problem on Windows, big
problem on other platforms
3)
With db2 9.5 import_plases.shp produces the following eror
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0798N A value cannot be specified for column "Id" which is defined as
GENERATED ALWAYS. SQLSTATE=428C9
------------
Failed tests:
4)
testGetBounds(org.geotools.data.db2.DB2FeatureSourceOnlineTest)
the following code fails
assertEquals("all places bounds",
"ReferencedEnvelope[-74.160507 : -74.067637, 41.993695 : 42.05990399999999]",
env.toString());
on my box,
assertEquals("all places bounds",
"Env[-74.160507 : -74.067637, 41.993695 : 42.059904]", coordString);
would work. There is a rounding problem.
---------------------
5)
testSchema(org.geotools.data.db2.DB2FeatureSourceOnlineTest)
does not work, dont know why
--------------
6)
testCreateDataStore(org.geotools.data.db2.DB2DataStoreFactoryOnlineTest)
The follwong code
assertEquals("DB2ADMIN", schema);
makes problems with non standard windows installations. DB2ADMIN ist
the standard user for windows. (On unix systems mostly DB2INST1). I would resolve this with a lookup in the fixture.
----------------