See http://hudson.opengeo.org/hudson/job/geotools-trunk/1219/changes
Changes:
[aaime] Added empty table tests
[aaime] Added JDBCFeatureReaderTest
[aaime] Notes on creating a new JDBC backed datastore
[aaime] Initial write support
[aaime] Avance sequence to 2 so that it won't generate an already manually
inserted value
------------------------------------------
[...truncated 13805 lines...]
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore createConnection
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore getPrimaryKey
FINE: Grabbing table pk metadata: SELECT "id" FROM "geotools"."fk" WHERE 0=1
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore createConnection
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore
ensureAssociationTablesExist
FINE: Creating geometry table: CREATE TABLE "geotools"."geometry" ( "id"
VARCHAR(255), "name" VARCHAR(255), "description" VARCHAR(255), "type"
VARCHAR(255), "geometry" BLOB )
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore
ensureAssociationTablesExist
FINE: Creating multi-geometry table: CREATE TABLE "geotools"."multi_geometry" (
"id" VARCHAR(255), "mgid" VARCHAR(255), "ref" BOOLEAN )
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore
ensureAssociationTablesExist
FINE: Creating geometry association table: CREATE TABLE
"geotools"."geometry_associations" ( "fid" VARCHAR(255), "gname" VARCHAR(255),
"gid" VARCHAR(255), "ref" BOOLEAN )
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'fk' AND "col" = 'geometry'
Dec 27, 2008 12:16:42 PM org.geotools.data.h2.H2Dialect getGeometrySRID
FINE: SELECT getSRID("geometry") FROM "geotools"."fk" WHERE "geometry" is not
null LIMIT 1
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'fk' AND "col" = 'intProperty'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'fk' AND "col" = 'ft1'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore createConnection
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore getReaderInternal
FINE: SELECT "id","geometry" as "geometry","intProperty","ft1" FROM
"geotools"."fk"
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureReader next
FINE: SELECT "fid","rtable","rcol", "rfid" FROM
"geotools"."feature_associations" WHERE "fid" = 'fk.0'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore createConnection
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore getPrimaryKey
FINE: Grabbing table pk metadata: SELECT "id" FROM "geotools"."ft1" WHERE 0=1
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore createConnection
FINE: CREATE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'ft1' AND "col" = 'geometry'
Dec 27, 2008 12:16:42 PM org.geotools.data.h2.H2Dialect getGeometrySRID
FINE: SELECT getSRID("geometry") FROM "geotools"."ft1" WHERE "geometry" is not
null LIMIT 1
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'ft1' AND "col" = 'intProperty'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'ft1' AND "col" = 'doubleProperty'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCFeatureStore buildFeatureType
FINE: SELECT "table","col" FROM "geotools"."feature_relationships" WHERE
"table" = 'ft1' AND "col" = 'stringProperty'
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCDataStore closeSafe
FINE: CLOSE CONNECTION
Dec 27, 2008 12:16:42 PM org.geotools.jdbc.JDBCTestSetup run
FINE: DROP TABLE "geotools"."fk"; COMMIT;
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.126 sec
Results :
Tests run: 118, Failures: 0, Errors: 0, Skipped: 0
[INFO] [jar:jar]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-h2/target/gt-jdbc-h2-2.6-SNAPSHOT.jar
[INFO] Preparing source:jar
[WARNING] Removing: jar from forked lifecycle, to prevent recursive invocation.
[INFO] No goals needed for project - skipping
[INFO] [source:jar {execution: attach-sources}]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-h2/target/gt-jdbc-h2-2.6-SNAPSHOT-sources.jar
[INFO] [jar-collector:collect {execution: default}]
[INFO] [install:install]
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-h2/target/gt-jdbc-h2-2.6-SNAPSHOT.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-h2/2.6-SNAPSHOT/gt-jdbc-h2-2.6-SNAPSHOT.jar
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-h2/target/gt-jdbc-h2-2.6-SNAPSHOT-sources.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-h2/2.6-SNAPSHOT/gt-jdbc-h2-2.6-SNAPSHOT-sources.jar
[INFO] ------------------------------------------------------------------------
[INFO] Building MySQL DataStore
[INFO] task-segment: [clean, install]
[INFO] ------------------------------------------------------------------------
[INFO] [clean:clean]
[INFO] Deleting directory
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:compile]
[INFO] Compiling 4 source files to
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/classes
[INFO] [resources:testResources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:testCompile]
[INFO] Compiling 18 source files to
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/test-classes
[INFO] [surefire:test]
[INFO] Surefire report directory:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/surefire-reports
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.geotools.data.mysql.MySQLDataStoreTest
Skipping tests org.geotools.data.mysql.MySQLDataStoreTest since data souce is
not available: Cannot create PoolableConnectionFactory (Communications link
failure
Last packet sent to the server was 0 ms ago.)
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.774 sec
Running org.geotools.data.mysql.MySQLFeatureReaderTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.mysql.MySQLFeatureStoreTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.mysql.MySQLEmptyTest
Skipping tests org.geotools.data.mysql.MySQLEmptyTest since data souce is not
available: Cannot create PoolableConnectionFactory (Communications link failure
Last packet sent to the server was 0 ms ago.)
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.018 sec
Running org.geotools.data.mysql.MySQLDataStoreAPITest
Skipping tests org.geotools.data.mysql.MySQLDataStoreAPITest since data souce
is not available: Cannot create PoolableConnectionFactory (Communications link
failure
Last packet sent to the server was 0 ms ago.)
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
Running org.geotools.data.mysql.MySQLFeatureCollectionTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec
Running org.geotools.data.mysql.MySQLFeatureLockingTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.mysql.MySQLFeatureSourceTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.geotools.data.mysql.MySQLSpatialFiltersTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.geotools.data.mysql.MySQLDataStoreFactoryTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.033 sec
Running org.geotools.data.mysql.MySQLGeometrylessTest
Skipping tests org.geotools.data.mysql.MySQLGeometrylessTest since data souce
is not available: Cannot create PoolableConnectionFactory (Communications link
failure
Last packet sent to the server was 0 ms ago.)
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.geotools.data.mysql.MySQLTransactionTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.mysql.MySQLPrimaryKeyTest
Skipping tests org.geotools.data.mysql.MySQLPrimaryKeyTest since data souce is
not available: Cannot create PoolableConnectionFactory (Communications link
failure
Last packet sent to the server was 0 ms ago.)
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec
Results :
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0
[INFO] [jar:jar]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/gt-jdbc-mysql-2.6-SNAPSHOT.jar
[INFO] Preparing source:jar
[WARNING] Removing: jar from forked lifecycle, to prevent recursive invocation.
[INFO] No goals needed for project - skipping
[INFO] [source:jar {execution: attach-sources}]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/gt-jdbc-mysql-2.6-SNAPSHOT-sources.jar
[INFO] [jar-collector:collect {execution: default}]
[INFO] [install:install]
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/gt-jdbc-mysql-2.6-SNAPSHOT.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-mysql/2.6-SNAPSHOT/gt-jdbc-mysql-2.6-SNAPSHOT.jar
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-mysql/target/gt-jdbc-mysql-2.6-SNAPSHOT-sources.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-mysql/2.6-SNAPSHOT/gt-jdbc-mysql-2.6-SNAPSHOT-sources.jar
[INFO] ------------------------------------------------------------------------
[INFO] Building Oracle DataStore
[INFO] task-segment: [clean, install]
[INFO] ------------------------------------------------------------------------
[INFO] [clean:clean]
[INFO] Deleting directory
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:compile]
[INFO] Compiling 16 source files to
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/classes
[INFO] [resources:testResources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:testCompile]
[INFO] Compiling 20 source files to
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/test-classes
[INFO] [surefire:test]
[INFO] Surefire report directory:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/surefire-reports
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.geotools.data.oracle.OracleSpatialFiltersTest
Skipping tests org.geotools.data.oracle.OracleSpatialFiltersTest since data
souce is not available: Cannot load JDBC driver class
'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.033 sec
Running org.geotools.data.oracle.OracleEmptyTest
Skipping tests org.geotools.data.oracle.OracleEmptyTest since data souce is not
available: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running org.geotools.data.oracle.Oracle3DTest
Skipping tests org.geotools.data.oracle.Oracle3DTest since data souce is not
available: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.geotools.data.oracle.OraclePrimaryKeyTest
Skipping tests org.geotools.data.oracle.OraclePrimaryKeyTest since data souce
is not available: Cannot load JDBC driver class
'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running org.geotools.data.oracle.OracleFeatureSourceTest
Skipping tests org.geotools.data.oracle.OracleFeatureSourceTest since data
souce is not available: Cannot load JDBC driver class
'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.geotools.data.oracle.OracleDataStoreTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.oracle.OracleGeometrylessTest
Skipping tests org.geotools.data.oracle.OracleGeometrylessTest since data souce
is not available: Cannot load JDBC driver class
'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.geotools.data.oracle.OracleGeometryTest
Skipping tests org.geotools.data.oracle.OracleGeometryTest since data souce is
not available: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running org.geotools.data.oracle.OracleFeatureCollectionTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.geotools.data.oracle.OracleDataStoreAPITest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.geotools.data.oracle.OracleFeatureLockingTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.geotools.data.oracle.OracleFeatureStoreTest
Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.geotools.data.oracle.OracleFilterToSqlTest
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.072 sec
Results :
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0
[INFO] [jar:jar]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/gt-jdbc-oracle-2.6-SNAPSHOT.jar
[INFO] Preparing source:jar
[WARNING] Removing: jar from forked lifecycle, to prevent recursive invocation.
[INFO] No goals needed for project - skipping
[INFO] [source:jar {execution: attach-sources}]
[INFO] Building jar:
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/gt-jdbc-oracle-2.6-SNAPSHOT-sources.jar
[INFO] [jar-collector:collect {execution: default}]
[INFO] [install:install]
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/gt-jdbc-oracle-2.6-SNAPSHOT.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-oracle/2.6-SNAPSHOT/gt-jdbc-oracle-2.6-SNAPSHOT.jar
[INFO] Installing
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-oracle/target/gt-jdbc-oracle-2.6-SNAPSHOT-sources.jar
to
/home/tomcat/.m2/repository/org/geotools/gt-jdbc-oracle/2.6-SNAPSHOT/gt-jdbc-oracle-2.6-SNAPSHOT-sources.jar
[INFO] ------------------------------------------------------------------------
[INFO] Building PostGIS DataStore
[INFO] task-segment: [clean, install]
[INFO] ------------------------------------------------------------------------
[INFO] [clean:clean]
[INFO] Deleting directory
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-postgis/target
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:compile]
[INFO] Compiling 4 source files to
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-postgis/target/classes
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Compilation failure
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-postgis/src/main/java/org/geotools/data/postgis/PostGISDialect.java
:[31,18] package org.hsqldb does not exist
http://hudson.opengeo.org/hudson/job/geotools-trunk/ws/gt_trunk/modules/unsupported/jdbc-ng/jdbc-postgis/src/main/java/org/geotools/data/postgis/PostGISDialect.java
:[278,31] cannot find symbol
symbol : variable Types
location: class org.geotools.data.postgis.PostGISDialect
[INFO] ------------------------------------------------------------------------
[INFO] For more information, run Maven with the -e switch
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 9 minutes 49 seconds
[INFO] Finished at: Sat Dec 27 12:16:49 EST 2008
[INFO] Final Memory: 48M/63M
[INFO] ------------------------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
