In org.postgresql.jdbc2.ResultSet, both getDate() and getTime() fail on
columns of type 'timestamp', which is against the jdbc spec, patch below
fixes it.
Michael Stephenson mstephenson@openworld.co.uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738
--- ResultSet.java.old Wed May 30 16:32:48 2001
+++ ResultSet.java Wed May 30 16:41:33 2001
@@ -423,6 +423,8 @@
String s = getString(columnIndex);
if(s==null)
return null;
+ if (s.length() > 10)
+ return new java.sql.Date(getTimeStamp(columnIndex).getTime())
return java.sql.Date.valueOf(s);
}
@@ -441,6 +443,8 @@
if(s==null)
return null; // SQL NULL
+ if (s.length() > 8)
+ return new java.sql.Time(getTimeStamp(columnIndex).getTime());
return java.sql.Time.valueOf(s);
}