Hi, I can't see anything wrong or problematic with what your describe, only I don't know how you store, retrieve, and display the data. Could you post a simple, standalone test case that reproduces the problem? It would be great if the test case does not have any dependencies except the H2 jar file (that is, a simple SQL script that can be run in the H2 Console, or a Java class uses the JDBC API and is run using a static main method). Please include any initialization code (CREATE TABLE, INSERT and so on) in the Java class or in a .sql script file.
Regards, Thomas On Mon, Aug 3, 2009 at 1:28 PM, nanisamaga<[email protected]> wrote: > > Hello, > it's not like an error message, but still i can say this might be a > bug. > I tried to store text data in a clob field, but somewhat, when i > retrieve the data i get a part of my document, not all the text. > I dont have the same problem with HSQLDB. > I chose tu use h2 instead of hsqldb cause of the way the data are > stored on the disk (plenty of file, hsqldb usually store the data in > the script file, so it isn't convinient for big file). > > Data table : > create table test > ( > INDEX int not null primary key, > test1_INDEX int, > test2 CLOB > ) > > INSERT INTO test (Index, test1, test2) VALUES > (1, 1, the file) > > the text file i tried to store is about 100 Ko of size > > Any help is really appreciated > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
