Re: Odd SQL Exception

[Nathan C Hampton <of...@nhampton.net>]

I'm using MySQL.  (I can't afford Oracle!)  What confuses me most is  
that this is happening with the second page, but not the first.

--NCH

On 30 Mar 2008, at 6:00 PM, David E Jones wrote:
>
> 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
>
>