Re: Importing Source code in eclipse ?

2010-10-07 Thread stolyarchukav
Checkout from SVN repositiry http://h2database.googlecode.com/svn/trunk/h2/ Ant script - build.xml located into them On 6 окт, 01:41, Rahul Navinchand rahulnc1...@gmail.com wrote: is there a how to , to import source could of H2 in eclipse ? any help is most appreciated -- You received this

Re: select '12' '-13'

2010-10-07 Thread Dario Fassi
Hi, You are right , in pgsql *select '12' '-13' - false select '1 ' '-' - true * and in H2 and in DB2 *select '12' '-13' - true select '1 ' '-' - true * H2 almost it's consistent in it's results. Where do you notice of this ? I really strange that result from pgsq.

Re: client/server: h2 temp files creation on client's execution direcotry fails

2010-10-07 Thread Patrick Knecht
Hi Kerry Thanks for the answer. I went through the source I made adjustements to ours need. We think this a bug. Client app can run from any program folder which in vista or win7 has no write access, just executionread. So if just blob come from server h2 db which is over 65kb so it will create

Re: select '12' '-13'

2010-10-07 Thread Rami Ojares
If you look at the ASCII character map you'll see that character '-' has code 45 and character '1' has code 49 so clearly '-' '1' = 45 49 What PostgreSQL seems to be doing here is converting string literals to integers and applying the comparison operator to them. I think this type of

Re: select '12' '-13'

2010-10-07 Thread Dario Fassi
Yes , seems something like that (or just a bug). I dig in google and pgsql documentation but can't found any mention to this behavior or special note on char type comparisons. I agree that if this is a decision , is big bad decision that make char comparison almost unpredictable. Dario El

Re: client/server: h2 temp files creation on client's execution direcotry fails

2010-10-07 Thread Sergi Vladykin
Hi, The real problem is not in a place where h2 client stores temp blobs but in the fact that it stores blobs to temp files at all. I think it should not do this. It seems that it does this on each row fetch but this is incorect since even if you have selected some result set conatining blobs you

Re: Importing Source code in eclipse ?

2010-10-07 Thread Kerry Sainsbury
Just FYI I don't think that the ant script gets much use and/or love, so it may not be 100% right. Should be a good start though. 2010/10/8 stolyarchukav stolyarchu...@gmail.com Checkout from SVN repositiry http://h2database.googlecode.com/svn/trunk/h2/ Ant script - build.xml located into

Re: Unequaled timestamps if time zone changed

2010-10-07 Thread Thomas Mueller
Hi, I think in most cases it's better to *not* convert the date/time to UTC (Coordinated Universal Time) before storing, because of following problem: Let's say you store a birthday in the database. After that, you close the database, and move the database file to a different time zone. Then you

Re: Using Binary for compressed text

2010-10-07 Thread Thomas Mueller
Hi, I m using H2 for a project where one of the functions is to store text of a size 100-2000 characters.  This text is highly compressible. Hence I have three questions: 1. Is there a way to compact  a String within H2. COMPRESS does not seem to reach the desired size. Actually it is

Re: Importing Source code in eclipse ?

2010-10-07 Thread Rahul Navinchand
so what would be the best approach for a n00b ?? On Oct 7, 3:55 pm, Kerry Sainsbury ke...@fidelma.com wrote: Just FYI I don't think that the ant script gets much use and/or love, so it may not be 100% right. Should be a good start though. 2010/10/8 stolyarchukav stolyarchu...@gmail.com

Re: Importing Source code in eclipse ?

2010-10-07 Thread Kerry Sainsbury
Use your IDE as an editor, but use the H2 build script to compile and run your tests. Try this to get started: 1. Download various jars and start running the tests: - download the source into a h2 directory - cd h2 - build test ^C once you're bored watching all the tests run. 2. Setup your

Re: Importing Source code in eclipse ?

2010-10-07 Thread Abdul
Thanks for your fast reply, but H2 is not running neither the jar files aren't loaded into the SQL- Workbench! Any Ideas? -Sounds like an operating system problem. Could you be running H2, or have the jar loaded into a DB tool like SQL-Workbench? 2010/10/8 Abdul 3...@bdullah.com Hey guys, Thank

Re: Importing Source code in eclipse ?

2010-10-07 Thread Abdul
Hey guys Thanks for your reply. @Kerry, I had the same doubt, and I followed all the steps that you mentioned. But I had one small error: The project was not built due to Could not delete 'C:\Program Files (x86)\H2\bin\h2-1.2.143.jar'.. Fix the problem, then try refreshing this project and

Re: Importing Source code in eclipse ?

2010-10-07 Thread Abdul
Hey guys, Thank you for your reply, @Kerry I followed the steps that you have mentiond in your post. Everything worked fine but one tiny error : The project was not built due to Could not delete 'C:\Program Files (x86)\H2\bin\h2-1.2.143.jar'.. Fix the problem, then try refreshing this project and

Re: Importing Source code in eclipse ?

2010-10-07 Thread Kerry Sainsbury
I've just Googled Fix the problem, then try refreshing and have discovered that it's an error from Eclipse. Gasp. I hate Eclipse. Whenever I try to use the damned thing it spits out all sorts of nonsense, and breaks in mysterious ways. Sorry, but I can't help you. Correction. I can:

Re: Importing Source code in eclipse ?

2010-10-07 Thread Abdul
LOL tell me about it =p Thank you for your helpful replies, I really appreciated. On Oct 7, 11:38 pm, Kerry Sainsbury ke...@fidelma.com wrote: I've just Googled Fix the problem, then try refreshing and have discovered that it's an error from Eclipse. Gasp. I hate Eclipse. Whenever I try to