oracle.sql.TIMESTAMP returned instead of java.sql.Timestamp
-----------------------------------------------------------
Key: GEOS-4256
URL: http://jira.codehaus.org/browse/GEOS-4256
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 2.0.2
Environment: Windows
Reporter: steve gorman
Assignee: Andrea Aime
When I try to publish an Oracle View that has a table of type TIMESTAMP to GeoServer the table is ignored.
CREATE TABLE "CHAT"."MESSAGE"
( "ID" NUMBER(10,0) NOT NULL ENABLE,
"TIME_OVER_TARGET" TIMESTAMP (6) WITH TIME ZONE NOT NULL ENABLE,
"MESSAGE" CLOB NOT NULL ENABLE,
"FRAME_CENTER" "MDSYS"."SDO_GEOMETRY"....... ,
During Publish in Geoserver
10 Dec 11:53:23 WARN [geotools.jdbc] - Could not find mapping for 'TIMEOVERTARGET', ignoring the column and setting the feature type read only
According to oracle if the J2EE13Compliant flag is not set before obtaining a connection than the time will be returned as oracle.sql and not java.sql.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira