[Jboss-dev-forums] [Design of JBossCache] - Re: JDBCCacheLoaderTest run

[hmesha <do-...@jb...>]

Hi ALL,

In order to be able to run Derby with JDBCCacheLoaderTest, I need to change the following line JDBCCacheLoader.inserNode method to use blob instead of using longvarbinary. It used to use blob before but was changed for some reason (I suspect when the MarshalledValue object was instroduced to handle de-serialization). 


  |                ps.setNull(2, Types.BLOB);
  | // old       ps.setNull(2, Types.LONGVARBINARY)
  | 

I have tested this change with other DBMS's (MySQL, Oracle, PostgreSQL). It runs fine on  the first 2 but it breaks on PostgreSQL. Anyway, PostgreSQL was never tested with JBossCache until recently when I ran the tests during the work on JBCACHE-320 and I posted a workaround on wiki which is to set the jbosscache table column node data type to bytea. which is suited for LONGVARBINARY but not for BLOB.

So the question is do we support Derby and break PostgreSQL or continue with PostgreSQL and run the test case manually?

Cheers,

-Hany



If no one has objection to the change, I'll go ahead and commit it.

Cheers,

Hany

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3919474#3919474

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3919474