Hi, Sorry, I made a mistake, I tested the mysql with the data column as text. Apparently, the mysql as Postgres, provide the text data type to deal with large strings. So, the previously output is for a text data type. Besides, in the Postgres I'm not able to execute rs.getClob(2).
Regards, Fred 2015-03-26 16:37 GMT-03:00 Fred&Dani&Pandora&Aquiles <zepf...@gmail.com>: > Hi, > > The output for mysql 5.5 is: > > jdbc:mysql://localhost:3306/test > while reading: aaa > after next: aaa > after result set close: aaa > after delete: aaa > > Regards, > > Fred > > 2015-03-26 14:00 GMT-03:00 Thomas Mueller <thomas.tom.muel...@gmail.com>: > > 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 <noelgran...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com. >>> To post to this group, send email to h2-database@googlegroups.com. >>> 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 h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
