packaging of h2 distribution

Hi, I would like to propose a different packaging style for the zip- download. This zip file currently contains the h2-database jar as /h2/ bin/h2-1.1.115.jar. I would rather prefer this way: /h2-1.1.115/bin/ h2.jar Advantage: You can define a H2_HOME classpath variable in the eclipse ide.

Re: packaging of h2 distribution

Agreed. I was already thinking about such kind of proposal. Best, Manfred Frank Schwarz wrote: Hi, I would like to propose a different packaging style for the zip- download. This zip file currently contains the h2-database jar as /h2/ bin/h2-1.1.115.jar. I would rather prefer this way:

Best way to import large data file.

Hi, i have a little problem. I have a data file around 120MB, which contains around 7 milions of lines, and i need to import it to database as fast as it gets. This situation will occure like once a week, so it is not a one time thing... I used embeded mysql server and used their LOAD DATA IN

Wrong string to integer conversion ?

Hi can someone explain me why these two statement returns different values ? select convert('023',integer) return 19 select convert('023',double) return 23 I'm running version 1.1.115 on java 1.6.0_13 Thanks in advance E.

Re: Unable to delete a sequence ? (SEQUENCE_BELONGS_TO_A_TABLE_1)

Hi, - Created a table with an identity field (which strangely creates a primary key by default) The documentation is unclear. What about if I extend the CREATE TABLE documentation: Identity and auto-increment columns are columns with a sequence as the default. The column declared as the

Re: Wrong string to integer conversion ?

In the first case, the leading '0' indicates an octal representation of the number. On Tue, Jul 14, 2009 at 9:21 AM, tuxshadow tuxshadow1...@gmail.com wrote: Hi can someone explain me why these two statement returns different values ? select convert('023',integer) return 19

Re: Prevent JVM freeze when using H2

Hi, You need to ensure the processing is really happening in the background. You could reduce the thread priority (Thread.setPriority). Additionally, you can slow down H2 using SET THROTTLE - see also http://www.h2database.com/html/grammar.html#setthrottle - this should solve most such problems.

Re: packaging of h2 distribution

putting the version in the name of the jar file itself is actually the maven convention. i have approximately 75 deps on my eclipse classpath for the project i work on, and every single one of them is versioned in that manner. they are easily resolved and downloaded during build time because

Re: packaging of h2 distribution

they are easily resolved and downloaded during build time I second this! I *like* having the version in the jar name rather than the folder. This way users can put multiple versions in the bin folder, when migrating between versions. Switch the JAR you use (in your IDE or the shell

ResultSet not showing updates, with CONCUR_UPDATABLE, TYPE_SCROLL_SENSITIVE ?

Right off, I should say that I'm not sure if this is H2 at fault, some part of the JDBC spec I am misinterpreting, or a setting that needs to be changed. The problem: an H2 ResultSet is not showing changes I make to the underlying data. The database is using more or less default settings

Re: packaging of h2 distribution

they are easily resolved and downloaded during build time This way users can put multiple versions in the bin folder, when migrating between versions. In addition to the above, versioning file names also makes debugging easier. A look at the classpath tells you exactly which version is in

Re: Query to determine size of table

Hi, I have a in memory database which has couple of tables in it , is there a way for me to determine the size of each table? You mean the size used in memory? No, at the moment not. H2 uses a value cache where common values are shared among rows and possibly tables (values objects are

Re: Console tables not expandable inside schema

Thanks. Is that 116? When is it expected released? - Thomas Muellerthomas.tom.muel...@gmail.com wrote: Hi, Hi. In the Quick Start at the end it shows a screenshot of the web console. I followed the instructions to create the test table, and you can