[h2] Re: Honest Opion

[Adam McMahon]

You may want to clarify what you mean by reliable.

But here is my 2 cents:

I have several small h2 databases that have run continuously for several 
years as part of a web app. No problems at all.

As with any database, you will want to perform regular backups, and 
understand well how to manage the particular database.

I find H2 just as reliable as other opensource databases.

-Adam


 

On Wednesday, November 23, 2016 at 3:53:57 PM UTC-5, Warren Basterfield 
wrote:
>
> How reliable is H2 ?
>

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] Honest Opion

[Warren Basterfield]

How reliable is H2 ?

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] Serious bug : Urgent solution : Wrong records show when date filter in where query.

[Mayur Bhatt]

Problem solve this is the problem of open office. thanks for your great 
support.

On Wednesday, November 23, 2016 at 4:01:38 AM UTC-8, Mayur Bhatt wrote:
>
> Yes sir you are right console show the above result. but I post here the 
> insert query when above record inserted in database. there is right date 
> but when save it will auto convert to another date. please check it. here 
> is the insert query for above records. Please check it.
>
> insert into 
> paymentList(voucherNumber,date1,shiftNoC,billTypeNo,companySubNo,veihHeadNo,tripEntryNoC,veihNumberNoC,ledgerGroupNoC,clBalanceLedgerGroupNoC,ledgerGroupNo1C,clBalanceLedgerGroupNo1C,amountMain,discountPer,discountFigure,ledgerGroupNo2C,ledgerGroupNo3C,amount1,roundOff,amount,totalAmount,paymentModeNo,chequeNumber,neftNumber,bankName,bankNoC,narrationA,userName,dateTimeDT,moduleRecordNo,nameNo)
>  
> values('177','2016-09-30',0,0,0,2,0,19,664,'1392000.00 Dr.',607,'1666400.00 
> Cr.',0,0,0,664,0,0,0,71000,0,1,'','','',0,'Hafta No. 5','123','2016-10-04 
> 17:00:00.00',0,'177');
>
>
> On Wednesday, November 23, 2016 at 3:45:19 AM UTC-8, Thomas Mueller Graf 
> wrote:
>>
>> Hi,
>>
>> Did you run this with the H2 Console tool?
>>
>> select "date1" from "paymentList" where "date1">='2017-01-01'
>>
>> date1  
>> 8016-08-31 00:00:00.0
>> 9016-09-30 00:00:00.0
>>
>> So the result seems to be correct. Openoffice trucates the century.
>>
>> Regards,
>> Thomas
>>
>>
>>
>> On Wed, Nov 23, 2016 at 12:20 PM, Mayur Bhatt  
>> wrote:
>>
>>> When I Execute following query it's out is below 
>>>
>>> Query : select * from paymentList where date1>='2017-01-01'
>>>
>>> Below screen shoots prove that the result is completely wrong. the all 
>>> records are < '2017-01-01' but query will show the result. I think this is 
>>> very serious bug in h2 database. I am using latest h2 database version. 
>>> 1.4.193  
>>> (latest) 
>>>
>>> I attached the database file with this. mail. Please check it and give 
>>> me reply as soon as possible thanks in advance.
>>>
>>> Note that the if rewrite the date value then problem solved 
>>> automatically. Please refer that.
>>>
>>> User Name : Admin
>>> Password : qs
>>>
>>>
>>>
>>>
>>> 
>>>
>>> Av
>>>
>>> -- 
>>> 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...@googlegroups.com.
>>> To post to this group, send email to h2-da...@googlegroups.com.
>>> Visit this group at https://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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] Serious bug : Urgent solution : Wrong records show when date filter in where query.

[Mayur Bhatt]

Yes sir you are right console show the above result. but I post here the 
insert query when above record inserted in database. there is right date 
but when save it will auto convert to another date. please check it. here 
is the insert query for above records. Please check it.

insert into 
paymentList(voucherNumber,date1,shiftNoC,billTypeNo,companySubNo,veihHeadNo,tripEntryNoC,veihNumberNoC,ledgerGroupNoC,clBalanceLedgerGroupNoC,ledgerGroupNo1C,clBalanceLedgerGroupNo1C,amountMain,discountPer,discountFigure,ledgerGroupNo2C,ledgerGroupNo3C,amount1,roundOff,amount,totalAmount,paymentModeNo,chequeNumber,neftNumber,bankName,bankNoC,narrationA,userName,dateTimeDT,moduleRecordNo,nameNo)
 
values('177','2016-09-30',0,0,0,2,0,19,664,'1392000.00 Dr.',607,'1666400.00 
Cr.',0,0,0,664,0,0,0,71000,0,1,'','','',0,'Hafta No. 5','123','2016-10-04 
17:00:00.00',0,'177');


On Wednesday, November 23, 2016 at 3:45:19 AM UTC-8, Thomas Mueller Graf 
wrote:
>
> Hi,
>
> Did you run this with the H2 Console tool?
>
> select "date1" from "paymentList" where "date1">='2017-01-01'
>
> date1  
> 8016-08-31 00:00:00.0
> 9016-09-30 00:00:00.0
>
> So the result seems to be correct. Openoffice trucates the century.
>
> Regards,
> Thomas
>
>
>
> On Wed, Nov 23, 2016 at 12:20 PM, Mayur Bhatt  > wrote:
>
>> When I Execute following query it's out is below 
>>
>> Query : select * from paymentList where date1>='2017-01-01'
>>
>> Below screen shoots prove that the result is completely wrong. the all 
>> records are < '2017-01-01' but query will show the result. I think this is 
>> very serious bug in h2 database. I am using latest h2 database version. 
>> 1.4.193  
>> (latest) 
>>
>> I attached the database file with this. mail. Please check it and give me 
>> reply as soon as possible thanks in advance.
>>
>> Note that the if rewrite the date value then problem solved 
>> automatically. Please refer that.
>>
>> User Name : Admin
>> Password : qs
>>
>>
>>
>>
>> 
>>
>> Av
>>
>> -- 
>> 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...@googlegroups.com .
>> To post to this group, send email to h2-da...@googlegroups.com 
>> .
>> Visit this group at https://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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

[Ziming Zhao]

Hello,

we are now doing some research on h2-1.4.192. However, during code reading, 
I'm confused about the difference between org.h2.mvstore.type.DataType and 
org.h2.value.DataType.

Is there anyone who is familiar with why there are two classes representing 
Type of data in h2? What's the main difference between these two kind of 
classes?

Thanks a lot!


-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Re: [h2] Serious bug : Urgent solution : Wrong records show when date filter in where query.

[Thomas Mueller Graf]

Hi,

Did you run this with the H2 Console tool?

select "date1" from "paymentList" where "date1">='2017-01-01'

date1
8016-08-31 00:00:00.0
9016-09-30 00:00:00.0

So the result seems to be correct. Openoffice trucates the century.

Regards,
Thomas



On Wed, Nov 23, 2016 at 12:20 PM, Mayur Bhatt 
wrote:

> When I Execute following query it's out is below
>
> Query : select * from paymentList where date1>='2017-01-01'
>
> Below screen shoots prove that the result is completely wrong. the all
> records are < '2017-01-01' but query will show the result. I think this is
> very serious bug in h2 database. I am using latest h2 database version. 
> 1.4.193
> (latest)
>
> I attached the database file with this. mail. Please check it and give me
> reply as soon as possible thanks in advance.
>
> Note that the if rewrite the date value then problem solved automatically.
> Please refer that.
>
> User Name : Admin
> Password : qs
>
>
>
>
> 
>
> Av
>
> --
> 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 https://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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.