I move here http://jira.jboss.com/jira/browse/JBPAPP-196 as I thing this stuff is out of my competence.
Aleksandar Kostadinov wrote, On 05/25/2007 04:50 PM (EEST): > Steve Ebersole wrote, On 05/25/2007 04:27 PM (EEST): >> 1) I would guess that this because of temp tables. Hibernate allows the >> Dialect to say whether or not the database supports DDL statements >> within a transaction. Sybase does not override this; the default is to >> query the JDBC metadata to see whether DDL is allowed within >> transactions (see links below). My guess is that Sybase simply does not >> report this accurately based on whether this option you mention is set >> or not set; it probably just blindly says "yeah, we support it...". We >> can look at changing this behavior for Sybase. You can imagine where >> this goes on the priority list ;) > > I would think disabling 'ddl in tran' no matter what sybase reports as > they think it is not good to use it. System tables were locked using > that feature and blah blah... > > Anyway I'm sure you know best what implications will that bring so I > just say what I know and you decide if it makes sense. > >> 2) Believe it or not, as the lead of Hibernate I actually do subscribe >> to the hibernate-dev list ;) >> >> >> http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#dataDefinitionCausesTransactionCommit() >> http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#dataDefinitionIgnoredInTransactions() >> > > I actually think sybase neither ignores neither commits but just fails > the transaction. I actually haven't experienced it myself. It was Shelly > McGowan who reported the error so I might be wrong. As well it is a per > database option in sybase and could be set for the user databse but not > for the temporary database. > > So it would be a good idea to be at least documented as an issue with > sybase. > >> On Fri, 2007-05-25 at 14:39 +0300, Aleksandar Kostadinov wrote: >>> Looking at the latest hibernate cruisecontrol builds I see around 20 >>> sybase tests are passing because I've enabled "ddl in tran" option of >>> tempdb database. >>> It is not recommended by sybase to use DDL in transactions so I think it >>> should be good to avoid it in future hibernate releases if possible. >>> >>> Regadrs, >>> Aleksandar > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
