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
------------------------------------------------------------------------------
Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL,
new data types, scalar functions, improved concurrency, built-in packages,
OCI, SQL*Plus, data movement tools, best practices and more.
http://p.sf.net/sfu/oracle-sfdev2dev
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
