SQLServer 2005 if your interested... jdbc:sqlserver://xxx.xxx.xxx.xxx:1433 while reading: aaa after next: aaa after result set close: aaa after delete: aaa
Uses VARCHAR(MAX) instead of CLOB. But don't let this result sway you... I vote for the change. The Java docs only say that > "Blob, Clob, and NClob Java objects remain valid for at least the > duration of the transaction in which they are created." > No guarantees after that. -Kent On Thursday, March 26, 2015 at 1:00:20 PM UTC-4, Thomas Mueller wrote: > > Hi, > > Hm, interesting, Oracle does it the "easy way" then... I didn't know that. > That was similar to the original H2 behavior, and them somebody told me > this is wrong (I think it was somebody from the Hibernate team, but I don't > remember). > > I don't have MySQL installed right now, could anybody test it? If not, I > will install the latest version and test later on. > > Regards, > Thomas > > > On Thursday, March 26, 2015, Noel Grandin <[email protected] > <javascript:>> wrote: > >> >> >> On 2015-03-26 08:48 AM, Thomas Mueller wrote: >> >>> >>> >>> I didn't know that. I made some tests (see below), and at least Apache >>> Derby seems to do that. I'm not sure about other >>> >> >> In Oracle, you may only read a BLOB column in the same order as the >> SELECT statement, and the BLOB ceases to be valid as soon as you read the >> next column: >> http://docs.oracle.com/cd/B28359_01/java.111/b31224/ >> jstreams.htm#BHCDJAGI >> >> Despite a lot of searching, I could not find any information on how this >> works in Sybase or MS-SQL-Server. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
