when the data base is new created " Test Connection" will work and red 'Test Successfull' appear below. here is what printed for an emtp data base : ------------------------------------------------------ Test successful Profiler: top stack trace(s) [build-126] ------------------------------------------------------ unfortunately when data base is about 28MB (2 table with one record and 1 table with 200,000 record) ,Test Connection Doesnt work and the red 'Test Successfull' will Not appear. and when I press 'Connect' through consol , connection spent too long time and finally no-connection , here is some printed info : ------------------------------------------------------- Opening Database URL: jdbc:h2:file:E:/Temp/H2DB/PhoenixDB User: sa Version: 1.2.126 (2009-12-18)
11:06:32.223: Start... 11:06:32.270: Creating index SYS:SYS_ID 0% 11:06:32.270: Creating index SYS:SYS_ID 4% 11:06:33.270: Creating index RECORD:PRIMARY_KEY_8 28% 11:06:34.442: Creating index RECORD:PRIMARY_KEY_8 44% 11:06:35.598: Creating index RECORD:PRIMARY_KEY_8 46% 11:06:36.614: Creating index RECORD:PRIMARY_KEY_8 46% 11:06:37.802: Creating index RECORD:PRIMARY_KEY_8 46% 11:06:38.880: Creating index RECORD:PRIMARY_KEY_8 46% 11:06:40.411: Creating index RECORD:PRIMARY_KEY_8 46% ?? -------------------------------------------------------------------------------------------- my URL is "jdbc:h2:file:E:/Temp/H2DB/PhoenixDB" and file size is about 28 MB (I can connect to database through application with 2-3 second and this time grows up with database grows) On Jan 15, 5:41 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > Could you start the H2 Console, then run "Test Connection", click on > the red 'Test successful' and post the profiling stack traces listed > there? I would like to have the results for both cases, plus the total > time it took to connection (version 1.2.126 doesn't show that yet). > Also, could you post the database URL and the file sizes before and > after connecting? > > Regards, > Thomas
-- 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.
