Thanks to Tim, we now have SQL Server on the new Windows box which is great for testing. The next step for proper automated testing of Cayenne (and some other database centric projects who have also expressed interest), is to be able to test on these common dbs:
* mysql * postgres * oracle 10 (I'm pretty sure the free dev license is quite sufficient) * sqlite Maybe more later, but those would be a great start. Now infrastructure have a new database server on the way sometime soon which will host the big databases behind Jira, Confluence, etc. However I'm wondering whether it would be more suitable to host these databases on one of the Hudson test machines. I had previously attempted to do that within the Cayenne Solaris zone, but it was just too hard to install software within the locked down zone. Something that would be trivial in Ubuntu or FreeBSD. I don't think I have access rights to allow me to install an rpm, so a Hudson admin would have to do it. Would this be an appropriate use of these resources? Could we proceed to set this up? If so, I'll go create Jira tasks. As for system resources: * disk size: tiny (possibly measured in kilobytes for the data) * databases: one per database engine for the Cayenne project (possible a couple more say if we want myisam and innodb as two separate tests) * CPU: tiny load once per test run, not more than once an hour * memory: they will all sit there using up RAM just idling, but they could all be tuned for a low RAM usage configuration since performance is not being measured as part of the testing. Regards Ari -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
