<HTML dir=ltr><HEAD><TITLE>Re: [hibernate-dev] HSQLDialect - sequences - problems with white space</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2800.1597" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText25285 dir=ltr>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> Steve Ebersole on behalf of Steve Ebersole<BR></FONT><FONT size=2><BR>> So certainly we could have SequenceGenerator account for trimming the sequence<BR>> name. I obviously have no objections to that.<BR>> <BR>> As for not not creating the dual_* tables:<BR>> 1) I do not like (and will not code for) a "MY_COMMON_DUAL" approach; this is<BR>> a simple oversight in HSQLDB (at least "back then", #2 alleviates that<BR>> shortcoming)<BR>> 2) since when was the "call NEXT VALUE FOR [sequence_name]" syntax available? <BR>> Depending on the answer to that, I have no issues with going this route;<BR>> create a patch and attach to a JIRA request.</FONT></DIV><FONT size=2></FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>2) not sure, it works with hsqldb 1.8.0.1. I will check with hsqldb guys.</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>Regards,</FONT></DIV>
<DIV dir=ltr><FONT size=2>David</DIV>
<DIV dir=ltr><BR></DIV></FONT></BODY></HTML>