Hi Thomas,
It occurred to me that not closing the H2 database before exiting my
application, might also be a problem in this regard.
I use Basic Macros and I use the following code to open one of my
applications -
Sub ConnectToTimeLogDatabase() 'Called from openForm()
Dim oContext AS Object 'database context object
Dim oDB AS Object
oContext = CreateUnoService("com.sun.star.sdb.DatabaseContext")
oDB = oContext.getByName("TimeLog") 'get Database
goConn = oDB.getConnection("","") 'establish
connection to database. goConn is a Global variable
End Sub
Ouestions -
1. Should I be calling something like 'goConn(Close)' prior to exiting?
2. Do I need to also close any open Forms?
3. Is there anything else I need to do to close H2 properly?
Thanks,
Noel
On Saturday, 16 August 2014 21:54:28 UTC+10, Thomas Mueller wrote:
>
> Hi,
>
> Some more detail: numbers are only skipped if the process is killed.
>
> Regards
> Thomas
>
> On Saturday, August 16, 2014, Noel Grandin <[email protected]
> <javascript:>> wrote:
>
>> You can't is the short answer.
>> IDENTITY columns and their underling SEQUENCEs are not guaranteed to
>> always increase by one.
>> For optimisation reasons, it may sometimes skip some numbers.
>> If you really numbers increasing by one all the time you will have to
>> implement it by hand.
>>
>> --
>> 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 [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at http://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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
