Customize connection used by LinkedTable

2008-12-03 Thread Toshiaki Takashima
Hi, Now I'm using LinkedTable objects under following conditions : ACCESS_MODE=R OPEN_NEW=TRUE SHARE_LINKED_CONNECTIONS=TRUE When I issue SELECT statement which use JOIN clause, SQLException is thrown because ResultSet is closed under the condition. the JDBC I use seems to close all

Thank you

2008-12-03 Thread [EMAIL PROTECTED]
I just wanted to say you that H2 is the best Java DataBase I know. It's a prodigious piece of code, like Rhino in an other domain, that I discovered by chance. Why does Sun propose Derby in stead of H2 ? It's quite stupid. Derby is almost not usable.

Re: FULL OUTER JOIN in H2

2008-12-03 Thread Thomas Mueller
Hi, I have seen that is in priority 2 - can you give some wild guess about availability of this feature ? The wild guess is middle of next year (unless somebody else implements this feature of course). Regards, Thomas --~--~-~--~~~---~--~~ You received this

Re: Thank you

2008-12-03 Thread julianbui
I like it too On Dec 3, 3:01 am, [EMAIL PROTECTED] [EMAIL PROTECTED] srh.com wrote: I just wanted to say you that H2 is the best Java DataBase I know. It's a prodigious piece of code, like Rhino in an other domain, that I discovered by chance. Why does Sun propose Derby in stead of H2 ? It's

Re: Error Information

2008-12-03 Thread Thomas Mueller
Hi, I am sorry to say that, but it looks like a corruption problem. I am very interested in analyzing and solving this problem. Corruption problems have top priority for me. I have a few question: - What is your database URL? - Did you use multiple connections? - The first workarounds is: