portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Sean Taylor <da...@bluesunrise.com>
Subject Re: Jetspeed 2 + MySql 4.1
Date Fri, 03 Dec 2004 19:57:14 GMT
David Sean Taylor wrote:

> LOMBART Christophe wrote:
> 
>> Hi All,
>>
>> I'm wondering if someone is using Jetspeed 2 with MySql 4.1 ?
>> I cannot build with this Mysql version. I'm not the MySql expert but I 
>> expect the issues comes from the differencies between MySql 3.x & 4.1. 
>> Mainly InnoDb support is not by default in 3.x. 
> 
> 
> I work with 4.1 here.
> Seems to build fine, but I suspect you may have InnoDB as your default 
> table type?
> 
> I think InnoDB should be the default for Jetspeed
> Im trying to change my default table type so I can reproduce it but i 
> can't get the setting to work :(
> 
> 
>>
>> The build failed because the Torque generated script are not correct 
>> for MySql 4.1. I have a patch but I want to verify if others solved 
>> the problem by using another way.
>>
>>
> Could you send the patch and I'll try it out here
> 

ok, Im now building against all InnoDB tables.
I had to modify the schema files,
-- change the table creation order
-- add a drop.sql task into the build for MySQL only
-- add CASCADE DELETE on all FKs

Ran all tests -- PASSED
Deployed to Tomcat5.0.30

Now testing on Oracle, Hypersonic, MySQL (ISAM)
Will report back if I see any errors


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message