Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5?
Hi, yes - there is alot more weird limitations, but Derby is not alone in that aspect (db2 comes to mind ;) But the turnaorund performance is disappointing. /max AFAIR, the DDL generation fails on my test suite for this DB. They are too strict in some are. So unless they've relaxed some restriction, it's a nope for me. Max Rydahl Andersen wrote: Hi, A small FYI crosspost here since both communities has talked about it. Tonight I tried out Derby and followed the advise about running Derby with the JVM wide system property derby.system.durability to the value test. It certainly has an effect, but Derby is still sluggish with this setting compared to all other dbs on my box (mysql, oracle and hsql) - maybe the dialect can be tuned more; but as a development db HSQL still has a *much* better turnaround time. /max Sacha Labourey wrote: I think that Alexey had evaluated it (right?) and mentionned it was nowhere close from the original closed source product. Maybe I am mistaken... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: mardi, 20. septembre 2005 19:31 To: jboss-development@lists.sourceforge.net Subject: Re: [JBoss-dev] switch to derby in JB5? Its been very slow compared to using hsqldb with hibernate test suite - at least the two times i tried to use it. It seems like it is not very well optimized for DDL and queries when running in embedded mode. That might have changed, but it should at least be tested/considered before changing away from the test/developer friendly hsqld. When Derby were named Cloudscape it actually had more sql features and were faster...but apparently they did their best to make it DB2 compliant ;) /max Its been asked in the past. Someone needs to validate that it works as the default db and update the service to start it. Alexey has a prototype in varia: org.jboss.jdbc.DerbyDatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Burke Sent: Tuesday, September 20, 2005 9:29 AM To: jboss-development@lists.sourceforge.net Subject: [JBoss-dev] switch to derby in JB5? Should we switch to derby for JB5? Seems it is a fully featured DB unlike Hypersonic which supports XA and everything. -- Bill Burke Chief Architect JBoss Inc. --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list
Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5?
AFAIR, the DDL generation fails on my test suite for this DB. They are too strict in some are. So unless they've relaxed some restriction, it's a nope for me. Max Rydahl Andersen wrote: Hi, A small FYI crosspost here since both communities has talked about it. Tonight I tried out Derby and followed the advise about running Derby with the JVM wide system property derby.system.durability to the value test. It certainly has an effect, but Derby is still sluggish with this setting compared to all other dbs on my box (mysql, oracle and hsql) - maybe the dialect can be tuned more; but as a development db HSQL still has a *much* better turnaround time. /max Sacha Labourey wrote: I think that Alexey had evaluated it (right?) and mentionned it was nowhere close from the original closed source product. Maybe I am mistaken... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: mardi, 20. septembre 2005 19:31 To: jboss-development@lists.sourceforge.net Subject: Re: [JBoss-dev] switch to derby in JB5? Its been very slow compared to using hsqldb with hibernate test suite - at least the two times i tried to use it. It seems like it is not very well optimized for DDL and queries when running in embedded mode. That might have changed, but it should at least be tested/considered before changing away from the test/developer friendly hsqld. When Derby were named Cloudscape it actually had more sql features and were faster...but apparently they did their best to make it DB2 compliant ;) /max Its been asked in the past. Someone needs to validate that it works as the default db and update the service to start it. Alexey has a prototype in varia: org.jboss.jdbc.DerbyDatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Burke Sent: Tuesday, September 20, 2005 9:29 AM To: jboss-development@lists.sourceforge.net Subject: [JBoss-dev] switch to derby in JB5? Should we switch to derby for JB5? Seems it is a fully featured DB unlike Hypersonic which supports XA and everything. -- Bill Burke Chief Architect JBoss Inc. --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- This SF.Net email is sponsored by:
RE: [Hibernate] Re: [JBoss-dev] switch to derby in JB5?
There maybe some setting we are just missing for test purposes. For example, I don't know about you, but on my Oracle setup I disable recovery logging on the datafiles backing my test schema. Without disabling this option, it is painfully slow to run the testsuite against Oracle; and obviously I don't care about recovery of my test data ;). Wasn't one of the Derby guys interested in helping us with any issues we encountered in Derby usage/adoption? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: Saturday, October 15, 2005 5:18 AM To: Emmanuel Bernard Cc: jboss-development@lists.sourceforge.net; Hibernate development Subject: Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5? Hi, yes - there is alot more weird limitations, but Derby is not alone in that aspect (db2 comes to mind ;) But the turnaorund performance is disappointing. /max AFAIR, the DDL generation fails on my test suite for this DB. They are too strict in some are. So unless they've relaxed some restriction, it's a nope for me. Max Rydahl Andersen wrote: Hi, A small FYI crosspost here since both communities has talked about it. Tonight I tried out Derby and followed the advise about running Derby with the JVM wide system property derby.system.durability to the value test. It certainly has an effect, but Derby is still sluggish with this setting compared to all other dbs on my box (mysql, oracle and hsql) - maybe the dialect can be tuned more; but as a development db HSQL still has a *much* better turnaround time. /max Sacha Labourey wrote: I think that Alexey had evaluated it (right?) and mentionned it was nowhere close from the original closed source product. Maybe I am mistaken... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: mardi, 20. septembre 2005 19:31 To: jboss-development@lists.sourceforge.net Subject: Re: [JBoss-dev] switch to derby in JB5? Its been very slow compared to using hsqldb with hibernate test suite - at least the two times i tried to use it. It seems like it is not very well optimized for DDL and queries when running in embedded mode. That might have changed, but it should at least be tested/considered before changing away from the test/developer friendly hsqld. When Derby were named Cloudscape it actually had more sql features and were faster...but apparently they did their best to make it DB2 compliant ;) /max Its been asked in the past. Someone needs to validate that it works as the default db and update the service to start it. Alexey has a prototype in varia: org.jboss.jdbc.DerbyDatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Burke Sent: Tuesday, September 20, 2005 9:29 AM To: jboss-development@lists.sourceforge.net Subject: [JBoss-dev] switch to derby in JB5? Should we switch to derby for JB5? Seems it is a fully featured DB unlike Hypersonic which supports XA and everything. -- Bill Burke Chief Architect JBoss Inc. --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email
Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5?
Hi, The JVM wide system property derby.system.durability to the value true does just that (recommended by the Derby crowd). And it has an effect, but surely not enough; my oracle installation runs faster. /max There maybe some setting we are just missing for test purposes. For example, I don't know about you, but on my Oracle setup I disable recovery logging on the datafiles backing my test schema. Without disabling this option, it is painfully slow to run the testsuite against Oracle; and obviously I don't care about recovery of my test data ;). Wasn't one of the Derby guys interested in helping us with any issues we encountered in Derby usage/adoption? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: Saturday, October 15, 2005 5:18 AM To: Emmanuel Bernard Cc: jboss-development@lists.sourceforge.net; Hibernate development Subject: Re: [Hibernate] Re: [JBoss-dev] switch to derby in JB5? Hi, yes - there is alot more weird limitations, but Derby is not alone in that aspect (db2 comes to mind ;) But the turnaorund performance is disappointing. /max AFAIR, the DDL generation fails on my test suite for this DB. They are too strict in some are. So unless they've relaxed some restriction, it's a nope for me. Max Rydahl Andersen wrote: Hi, A small FYI crosspost here since both communities has talked about it. Tonight I tried out Derby and followed the advise about running Derby with the JVM wide system property derby.system.durability to the value test. It certainly has an effect, but Derby is still sluggish with this setting compared to all other dbs on my box (mysql, oracle and hsql) - maybe the dialect can be tuned more; but as a development db HSQL still has a *much* better turnaround time. /max Sacha Labourey wrote: I think that Alexey had evaluated it (right?) and mentionned it was nowhere close from the original closed source product. Maybe I am mistaken... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: mardi, 20. septembre 2005 19:31 To: jboss-development@lists.sourceforge.net Subject: Re: [JBoss-dev] switch to derby in JB5? Its been very slow compared to using hsqldb with hibernate test suite - at least the two times i tried to use it. It seems like it is not very well optimized for DDL and queries when running in embedded mode. That might have changed, but it should at least be tested/considered before changing away from the test/developer friendly hsqld. When Derby were named Cloudscape it actually had more sql features and were faster...but apparently they did their best to make it DB2 compliant ;) /max Its been asked in the past. Someone needs to validate that it works as the default db and update the service to start it. Alexey has a prototype in varia: org.jboss.jdbc.DerbyDatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Burke Sent: Tuesday, September 20, 2005 9:29 AM To: jboss-development@lists.sourceforge.net Subject: [JBoss-dev] switch to derby in JB5? Should we switch to derby for JB5? Seems it is a fully featured DB unlike Hypersonic which supports XA and everything. -- Bill Burke Chief Architect JBoss Inc. --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net
[Hibernate] Re: [JBoss-dev] switch to derby in JB5?
Hi, A small FYI crosspost here since both communities has talked about it. Tonight I tried out Derby and followed the advise about running Derby with the JVM wide system property derby.system.durability to the value test. It certainly has an effect, but Derby is still sluggish with this setting compared to all other dbs on my box (mysql, oracle and hsql) - maybe the dialect can be tuned more; but as a development db HSQL still has a *much* better turnaround time. /max Sacha Labourey wrote: I think that Alexey had evaluated it (right?) and mentionned it was nowhere close from the original closed source product. Maybe I am mistaken... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max Rydahl Andersen Sent: mardi, 20. septembre 2005 19:31 To: jboss-development@lists.sourceforge.net Subject: Re: [JBoss-dev] switch to derby in JB5? Its been very slow compared to using hsqldb with hibernate test suite - at least the two times i tried to use it. It seems like it is not very well optimized for DDL and queries when running in embedded mode. That might have changed, but it should at least be tested/considered before changing away from the test/developer friendly hsqld. When Derby were named Cloudscape it actually had more sql features and were faster...but apparently they did their best to make it DB2 compliant ;) /max Its been asked in the past. Someone needs to validate that it works as the default db and update the service to start it. Alexey has a prototype in varia: org.jboss.jdbc.DerbyDatabase -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Burke Sent: Tuesday, September 20, 2005 9:29 AM To: jboss-development@lists.sourceforge.net Subject: [JBoss-dev] switch to derby in JB5? Should we switch to derby for JB5? Seems it is a fully featured DB unlike Hypersonic which supports XA and everything. -- Bill Burke Chief Architect JBoss Inc. --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42 plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development -- -- Max Rydahl Andersen callto://max.rydahl.andersen Hibernate [EMAIL PROTECTED] http://hibernate.org JBoss Inc [EMAIL PROTECTED] http://www.jboss.com/events/jbossworld JBoss World Barcelona 10-12 October --- This SF.Net email is sponsored by: