<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style>.EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; }</style>
</head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Hi list,</div>
<div> </div>
<div>I want to use wfs and gui-digitize to digitize some geometry and put some attributes to the geometry. Nearly all things do the correct thing.</div>
<div> </div>
<div>But I also want to store data of data-type "date" in the database. And so I have some difficulties. </div>
<div> </div>
<div>First of all:</div>
<div>========</div>
<div>Database is Oracle 9i (german settings like the date-format). In this database i have defined an attribute "DATUM" with data-type "date".</div>
<div>For creating a WFS-T i use geoserver 1.6.0. The server does what he should do. But I recognized, that in the "FeatureType Editor" the "DATUM"-attribute is shown as a "string"-type.</div>
<div>After loading and configuring this WFS in Mapbender 2.4.4, this attribute is known in mapbender as a "date"-type (I really don't know, how mapbender knows this, because geo serversays, this is a "string"-type !!!)</div>
<div> </div>
<div>I use postgres as mapbender database.</div>
<div> </div>
<div>The problem in detail:</div>
<div>================</div>
<div>Entering a date in the format YYYY-MM-DD in the html-template generated by gui-digitize , this date is accepted by geoserver. But the Oracle database is not accepting this format !</div>
<div> </div>
<div>Entering the date in the german format DD-MM-YYYY, geoserver recognizes a "Illegal argument exception" and the oracle DB never gets this argument.</div>
<div> </div>
<div>I have done some trials with escape-characters (like \), but this had never an effect !</div>
<div> </div>
<div>My Questions:</div>
<div>===========</div>
<div>Does anybody know, how mapbender recognizes the correct format "date" for the DATUM attribute ? (Geoserver says, this is a string attribute).</div>
<div> </div>
<div>Does mapbender it's own interpretation of an attribute of type "date" ? (So, the solution could be in altering the date-interpretation of the postgres - db or in the source-code of mapbender ??)</div>
<div> </div>
<div>I didn't find any possibility to configure the format of "date"-types in geoserver ? If it is possible to configure this item in geoserver, please let me know where !</div>
<div> </div>
<div>Or has anybody a solution for this problem ( I think the problem will also occure, if postgres or mysql is used instead of oracle).</div>
<div> </div>
<div> </div>
<div>Thanks and greetings</div>
<div>from Herbert</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
</font>
</body>
</html>