Nathan,
Just a wild guess: are using Oracle for your database?
If so this is an issue that was reported a few months ago with a new
version of Oracle and the JDBC driver from Oracle. No one has
submitted a patch to correct it yet though. This may not be too
complicated, like making sure all Strings going to the JDBC driver for
date/time fields are converted to Timestamp objects before being sent
over so that we don't rely on the JDBC driver to pass the correct data
to the database. I heard that this a known/reported bug in the Oracle
JDBC drivers that others have complained about too (ie not just in the
OFBiz world), but I have not had a chance to personally look into this.
BTW, in terms of databases a large or significant number is usually in
the tens or hundreds of thousands before it has a significant impact
on query performance or anything else, and in those cases it's just
slow (because of table scans etc, if indexing is done to improve
things the problems can usually be fixed).
-David
On Mar 30, 2008, at 1:42 PM, Nathan C Hampton wrote:
Hi everyone!
I'm having a little problem in the catalog manager. I have some
feature categories that contain a significant number of features
(read: 100+). When I go to edit those categories in the catalog
manager, the first page comes up fine, but when I click 'Next' to
get items 51-100, I get this error:
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
Exception while getting value : lastUpdatedStamp
[LAST_UPDATED_STAMP] (11) (Cannot convert value '2008-03-11
16:30:00' from column 11 to TIMESTAMP.)
At first I assumed that I had made a mistake when I imported one of
those features into the database, so I ran an SQL query to change
the last updated stamp to a known good value (specifically,
"2008-03-11 16:30:01.001"). Unfortunately, this produces the same
error:
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL
Exception while getting value : lastUpdatedStamp
[LAST_UPDATED_STAMP] (11) (Cannot convert value '2008-03-11
16:30:01' from column 11 to TIMESTAMP.)
I've tried clearing all the caches and restarting OFBiz, but nothing
seems to help. Any advice would be appreciated.
Thanks!
--Nathan C. Hampton
