HSQLDB 1.8.1 and 1.9

[Reizinger Zoltán]

Hi all,
Any plan for inserting 1.8.1 HSQLDB instead of 1.8.0.10 into OOo 3.2,
and 1.9 into OOo 3.3?
Thanks,
Zoltan


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

Hi Zoltan,

On 10/13/09 13:47, Reizinger Zoltán wrote:
> Hi all,
> Any plan for inserting 1.8.1 HSQLDB instead of 1.8.0.10 into OOo 3.2,
> and 1.9 into OOo 3.3?
Do you have cameras somewhere near me? :-) I currently working on the
upgrade from 1.8 to 1.9 for OOo 3.3. The OOo 3.2 train has gone. The
whole thing looks very promising I'll put the installation sets online
when I'm ready with building.

Best regards,

Ocke
> Thanks,
> Zoltan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>


--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

Moin,

I've uploaded a new version based on DEV300m61 with the new hsqldb
version 1.9rc6 + patches.
This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-)

For the people who want to start testing please work on copied data
because the file format isn't backward compatible. Once converted can't
be ported back. So test only.

As I'm waiting for the first bug reports, I put a hsqldb.jar in the root
of hsqldb19 every time a fix is available which has to be copied in the
classes folder.

So happy testing.

Best regards,

Ocke

PS: The files can be found qa-upload.services.openoffice.org in the
folder hsqldb19.

--

Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Reizinger Zoltán]

Hi Ocke,
Ocke Janssen írta:
> Moin,
>
> I've uploaded a new version based on DEV300m61 with the new hsqldb
> version 1.9rc6 + patches.
> This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-)
I installed win version, and soffice.exe/sbase/ and other executables,
not start - it is a really not working release ;--))
Next I downloaded linux version and this is starting, good :-).

Started tests, and simple file transformation, working. :)
>
> For the people who want to start testing please work on copied data
> because the file format isn't backward compatible. Once converted
> can't be ported back. So test only.
>
> As I'm waiting for the first bug reports, I put a hsqldb.jar in the
> root of hsqldb19 every time a fix is available which has to be copied
> in the classes folder.
Now I find hsqldb.jar in root folder. I need to copy it now, or it is a
same as in installation packages.

>
> So happy testing.
>
> Best regards,
>
> Ocke
>
> PS: The files can be found qa-upload.services.openoffice.org in the
> folder hsqldb19.
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

On 10/14/09 16:33, Reizinger Zoltán wrote:

> Hi Ocke,
> Ocke Janssen írta:
>> Moin,
>>
>> I've uploaded a new version based on DEV300m61 with the new hsqldb
>> version 1.9rc6 + patches.
>> This is NO WORKING RELEASE, if your data is import then DON'T USE IT.
>> ;-)
> I installed win version, and soffice.exe/sbase/ and other executables,
> not start - it is a really not working release ;--))

Yes ;-) Attention check. You won ;-)
No, I will recheck the win version and updated as soon as I found the error.

> Next I downloaded linux version and this is starting, good :-).
>
> Started tests, and simple file transformation, working. :)
>>
>> For the people who want to start testing please work on copied data
>> because the file format isn't backward compatible. Once converted
>> can't be ported back. So test only.
>>
>> As I'm waiting for the first bug reports, I put a hsqldb.jar in the
>> root of hsqldb19 every time a fix is available which has to be copied
>> in the classes folder.
> Now I find hsqldb.jar in root folder. I need to copy it now, or it is
> a same as in installation packages.

Yes, it contains some performance fixes. Later today I'll upload a newer
version as I got email from Fred (the main developer of hsqldb).

- oj

>>
>> So happy testing.
>>
>> Best regards,
>>
>> Ocke
>>
>> PS: The files can be found qa-upload.services.openoffice.org in the
>> folder hsqldb19.
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>

--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

Win upload now completed and tested.

- oj
On 10/15/09 06:37, Ocke Janssen wrote:

> On 10/14/09 16:33, Reizinger Zoltán wrote:
>> Hi Ocke,
>> Ocke Janssen írta:
>>> Moin,
>>>
>>> I've uploaded a new version based on DEV300m61 with the new hsqldb
>>> version 1.9rc6 + patches.
>>> This is NO WORKING RELEASE, if your data is import then DON'T USE
>>> IT. ;-)
>> I installed win version, and soffice.exe/sbase/ and other
>> executables, not start - it is a really not working release ;--))
> Yes ;-) Attention check. You won ;-)
> No, I will recheck the win version and updated as soon as I found the
> error.
>> Next I downloaded linux version and this is starting, good :-).
>>
>> Started tests, and simple file transformation, working. :)
>>>
>>> For the people who want to start testing please work on copied data
>>> because the file format isn't backward compatible. Once converted
>>> can't be ported back. So test only.
>>>
>>> As I'm waiting for the first bug reports, I put a hsqldb.jar in the
>>> root of hsqldb19 every time a fix is available which has to be
>>> copied in the classes folder.
>> Now I find hsqldb.jar in root folder. I need to copy it now, or it is
>> a same as in installation packages.
> Yes, it contains some performance fixes. Later today I'll upload a
> newer version as I got email from Fred (the main developer of hsqldb).
>
> - oj
>>>
>>> So happy testing.
>>>
>>> Best regards,
>>>
>>> Ocke
>>>
>>> PS: The files can be found qa-upload.services.openoffice.org in the
>>> folder hsqldb19.
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@...
>> For additional commands, e-mail: dev-help@...
>>
>
>

--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Reizinger Zoltán]

Ocke Janssen írta:
> Win upload now completed and tested.
I down loaded the new installation set, installed  on winXP Home
Hungarian version, from cmd window:
msiexec/a openofficeorg32.msi
into C:\Program Files\OOo_hsqldb19\ folder, installs without any problem.
I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
soffice not starts from file manager, error mesage: (fast translation)
The application can not be started, becuse configuration not correct.
The reinstallation can be solve this problem.
What can I do?
Regards:
Zoltan


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

On 10/15/09 11:32, Reizinger Zoltán wrote:
> Ocke Janssen írta:
>> Win upload now completed and tested.
> I down loaded the new installation set, installed  on winXP Home
> Hungarian version, from cmd window:
> msiexec/a openofficeorg32.msi
> into C:\Program Files\OOo_hsqldb19\ folder, installs without any problem.
> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
> soffice not starts from file manager, error mesage: (fast translation)
I just do the same.
- install OOo but not in Program Files, flat on d:
- change bootstrap to ORIGIN
- start soffice.exe from explorer
OOo starts.


> The application can not be started, becuse configuration not correct.
> The reinstallation can be solve this problem.
> What can I do?
hmm. I'm sorry I don't know.

- oj
> Regards:
> Zoltan
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>


--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Fernand Vanrie]

Zoltan,

"The application can not be started" do not has to be the stuff you are
installing.  "Windows"  :-) forgot to mention the "application who is
missing it can been any application who is not on your machine or is not
in the right path !

Hope it helps

Fernand

> On 10/15/09 11:32, Reizinger Zoltán wrote:
>> Ocke Janssen írta:
>>> Win upload now completed and tested.
>> I down loaded the new installation set, installed  on winXP Home
>> Hungarian version, from cmd window:
>> msiexec/a openofficeorg32.msi
>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>> problem.
>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>> soffice not starts from file manager, error mesage: (fast translation)
> I just do the same.
> - install OOo but not in Program Files, flat on d:
> - change bootstrap to ORIGIN
> - start soffice.exe from explorer
> OOo starts.
>
>
>> The application can not be started, becuse configuration not correct.
>> The reinstallation can be solve this problem.
>> What can I do?
> hmm. I'm sorry I don't know.
>
> - oj
>> Regards:
>> Zoltan
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@...
>> For additional commands, e-mail: dev-help@...
>>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Drew Jensen]

Ocke Janssen wrote:

> On 10/15/09 11:32, Reizinger Zoltán wrote:
>> Ocke Janssen írta:
>>> Win upload now completed and tested.
>> I down loaded the new installation set, installed  on winXP Home
>> Hungarian version, from cmd window:
>> msiexec/a openofficeorg32.msi
>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>> problem.
>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>> soffice not starts from file manager, error mesage: (fast translation)

Hi Zoltan,

Just a thought - if a reinstall did not help then I would look
immediately to the user configuration data.
Befrore starting OO.o again be sure to double check the entry in the
bootstrap.ini file
Ensure that it is going to point to a non-existent (or verified empty)
directory.


@Ocke, @QA-Database team

Ocke on qa-upload there is both a hsqldb.jar and a full windows install
- If I followed the conversation correctly:
The newer build does not need the stand-alone hsqldb.jar?


Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Reizinger Zoltán]

Drew Jensen írta:

> Ocke Janssen wrote:
>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>> Ocke Janssen írta:
>>>> Win upload now completed and tested.
>>> I down loaded the new installation set, installed  on winXP Home
>>> Hungarian version, from cmd window:
>>> msiexec/a openofficeorg32.msi
>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>> problem.
>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>> soffice not starts from file manager, error mesage: (fast translation)
> Hi Zoltan,
>
> Just a thought - if a reinstall did not help then I would look
> immediately to the user configuration data.
> Befrore starting OO.o again be sure to double check the entry in the
> bootstrap.ini file
> Ensure that it is going to point to a non-existent (or verified empty)
> directory.

I did it no change the problem, changed installation directory,
installed into other drive, same error.
I stopped installations, something other problem can cause this. I
installed similar way the OOO320_m1, and DEV300_m61. Only change was
from that time, windows update in this Tuesday. I give up on win version.
>
>
> @Ocke, @QA-Database team
>
> Ocke on qa-upload there is both a hsqldb.jar and a full windows install
> - If I followed the conversation correctly:
> The newer build does not need the stand-alone hsqldb.jar?
>
As I understand, this stand alone hsqldb.jar is newer than hsqdldb.jar
in installation set.
Not need to create a new installation set for testing new one, only
deleting old and copying this newer hsqldb.jar into classes directory.
Zoltan
>
> Drew
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Reizinger Zoltán]

Fernand,

Fernand Vanrie írta:
> Zoltan,
>
> "The application can not be started" do not has to be the stuff you
> are installing.  "Windows"  :-) forgot to mention the "application who
> is missing it can been any application who is not on your machine or
> is not in the right path !
You can be right, I found this, with the same error message:
http://blogs.msdn.com/jreddy/archive/2005/12/23/troubleshooting-c-c-isolated-applications-and-side-by-side-assemblies-scenario-based-with-solutions.aspx
*Scenario 2:
This application has failed to start because the application
configuration is incorrect. Reinstalling application may fix this problem.
The system cannot execute the specified program.*


If a manifest is present in your application but a required Visual C++
library is not installed in the WinSxS folder, you may get one of the
above error messages depending on the version of Windows on which you
try to run your application:

Solution
Event viewer will have more details that will help us in finding a solution.

Source SideBySide
Event number: 59
Generate Activation Context - unsuccesful on: c:\Program
Files\OOo_hsqldb19\OpenOffice.org 3\program\soffice.exe. Reference-error
message: The operation finished successfully.
Part of them translated.

I Found on other blogs to install  VC++ runtimes.
I installed VC++ 2005 and 2008 runtime versions, not help.
I think when Ocke build this version, something was missing. He can
install it and works for him, because he has a VC++ build system on his
computer. I only guess it.
Anybody other can install and run win version of cwshsqldb19?
Zoltan

>
> Hope it helps
>
> Fernand
>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>> Ocke Janssen írta:
>>>> Win upload now completed and tested.
>>> I down loaded the new installation set, installed  on winXP Home
>>> Hungarian version, from cmd window:
>>> msiexec/a openofficeorg32.msi
>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>> problem.
>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>> soffice not starts from file manager, error mesage: (fast translation)
>> I just do the same.
>> - install OOo but not in Program Files, flat on d:
>> - change bootstrap to ORIGIN
>> - start soffice.exe from explorer
>> OOo starts.
>>
>>
>>> The application can not be started, becuse configuration not
>>> correct. The reinstallation can be solve this problem.
>>> What can I do?
>> hmm. I'm sorry I don't know.
>>
>> - oj
>>> Regards:
>>> Zoltan
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@...
>>> For additional commands, e-mail: dev-help@...
>>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

Moin,

On 10/15/09 19:49, Reizinger Zoltán wrote:

> Drew Jensen írta:
>> Ocke Janssen wrote:
>>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>>> Ocke Janssen írta:
>>>>> Win upload now completed and tested.
>>>> I down loaded the new installation set, installed  on winXP Home
>>>> Hungarian version, from cmd window:
>>>> msiexec/a openofficeorg32.msi
>>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>>> problem.
>>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>>> soffice not starts from file manager, error mesage: (fast translation)
>> Hi Zoltan,
>>
>> Just a thought - if a reinstall did not help then I would look
>> immediately to the user configuration data.
>> Befrore starting OO.o again be sure to double check the entry in the
>> bootstrap.ini file
>> Ensure that it is going to point to a non-existent (or verified
>> empty) directory.
> I did it no change the problem, changed installation directory,
> installed into other drive, same error.
> I stopped installations, something other problem can cause this. I
> installed similar way the OOO320_m1, and DEV300_m61. Only change was
> from that time, windows update in this Tuesday. I give up on win version.

The Windows version is non-product build where more assertions are
visible as you would see in other cases.
http://wiki.services.openoffice.org/wiki/Non_Product_Build
For the Windows build you need debug dll which aren't on your system by
default. The link
http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements 
might help you to find the pieces which are missing.

I hope that is a little help. I'm currently build a product version but
for testing the non-product would be better. That's my personal opinion.

- oj

>>
>>
>> @Ocke, @QA-Database team
>>
>> Ocke on qa-upload there is both a hsqldb.jar and a full windows install
>> - If I followed the conversation correctly:
>> The newer build does not need the stand-alone hsqldb.jar?
>>
> As I understand, this stand alone hsqldb.jar is newer than hsqdldb.jar
> in installation set.
> Not need to create a new installation set for testing new one, only
> deleting old and copying this newer hsqldb.jar into classes directory.
> Zoltan
>>
>> Drew
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@...
>> For additional commands, e-mail: dev-help@...
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@...
> For additional commands, e-mail: dev-help@...
>

--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

I've uploaded new versions.

- forms and report can be opened now
- no assertion from HStorageMap
- script which contains a view with select a from "b" "c" can be read a
2nd time

- oj

On 10/16/09 09:42, Ocke Janssen wrote:

> Moin,
>
> On 10/15/09 19:49, Reizinger Zoltán wrote:
>> Drew Jensen írta:
>>> Ocke Janssen wrote:
>>>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>>>> Ocke Janssen írta:
>>>>>> Win upload now completed and tested.
>>>>> I down loaded the new installation set, installed  on winXP Home
>>>>> Hungarian version, from cmd window:
>>>>> msiexec/a openofficeorg32.msi
>>>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>>>> problem.
>>>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>>>> soffice not starts from file manager, error mesage: (fast
>>>>> translation)
>>> Hi Zoltan,
>>>
>>> Just a thought - if a reinstall did not help then I would look
>>> immediately to the user configuration data.
>>> Befrore starting OO.o again be sure to double check the entry in the
>>> bootstrap.ini file
>>> Ensure that it is going to point to a non-existent (or verified
>>> empty) directory.
>> I did it no change the problem, changed installation directory,
>> installed into other drive, same error.
>> I stopped installations, something other problem can cause this. I
>> installed similar way the OOO320_m1, and DEV300_m61. Only change was
>> from that time, windows update in this Tuesday. I give up on win
>> version.
> The Windows version is non-product build where more assertions are
> visible as you would see in other cases.
> http://wiki.services.openoffice.org/wiki/Non_Product_Build
> For the Windows build you need debug dll which aren't on your system
> by default. The link
> http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements 
> might help you to find the pieces which are missing.
>
> I hope that is a little help. I'm currently build a product version
> but for testing the non-product would be better. That's my personal
> opinion.
>
> - oj
>
>
>>>
>>>
>>> @Ocke, @QA-Database team
>>>
>>> Ocke on qa-upload there is both a hsqldb.jar and a full windows install
>>> - If I followed the conversation correctly:
>>> The newer build does not need the stand-alone hsqldb.jar?
>>>
>> As I understand, this stand alone hsqldb.jar is newer than
>> hsqdldb.jar in installation set.
>> Not need to create a new installation set for testing new one, only
>> deleting old and copying this newer hsqldb.jar into classes directory.
>> Zoltan
>>>
>>> Drew
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@...
>>> For additional commands, e-mail: dev-help@...
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@...
>> For additional commands, e-mail: dev-help@...
>>
>
>

--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Ocke Janssen]

new hsqldb.jar with fixed issue 105916

- oj

On 10/16/09 11:53, Ocke Janssen wrote:

> I've uploaded new versions.
>
> - forms and report can be opened now
> - no assertion from HStorageMap
> - script which contains a view with select a from "b" "c" can be read
> a 2nd time
>
> - oj
>
> On 10/16/09 09:42, Ocke Janssen wrote:
>> Moin,
>>
>> On 10/15/09 19:49, Reizinger Zoltán wrote:
>>> Drew Jensen írta:
>>>> Ocke Janssen wrote:
>>>>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>>>>> Ocke Janssen írta:
>>>>>>> Win upload now completed and tested.
>>>>>> I down loaded the new installation set, installed  on winXP Home
>>>>>> Hungarian version, from cmd window:
>>>>>> msiexec/a openofficeorg32.msi
>>>>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>>>>> problem.
>>>>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>>>>> soffice not starts from file manager, error mesage: (fast
>>>>>> translation)
>>>> Hi Zoltan,
>>>>
>>>> Just a thought - if a reinstall did not help then I would look
>>>> immediately to the user configuration data.
>>>> Befrore starting OO.o again be sure to double check the entry in
>>>> the bootstrap.ini file
>>>> Ensure that it is going to point to a non-existent (or verified
>>>> empty) directory.
>>> I did it no change the problem, changed installation directory,
>>> installed into other drive, same error.
>>> I stopped installations, something other problem can cause this. I
>>> installed similar way the OOO320_m1, and DEV300_m61. Only change was
>>> from that time, windows update in this Tuesday. I give up on win
>>> version.
>> The Windows version is non-product build where more assertions are
>> visible as you would see in other cases.
>> http://wiki.services.openoffice.org/wiki/Non_Product_Build
>> For the Windows build you need debug dll which aren't on your system
>> by default. The link
>> http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements 
>> might help you to find the pieces which are missing.
>>
>> I hope that is a little help. I'm currently build a product version
>> but for testing the non-product would be better. That's my personal
>> opinion.
>>
>> - oj
>>
>>
>>>>
>>>>
>>>> @Ocke, @QA-Database team
>>>>
>>>> Ocke on qa-upload there is both a hsqldb.jar and a full windows
>>>> install
>>>> - If I followed the conversation correctly:
>>>> The newer build does not need the stand-alone hsqldb.jar?
>>>>
>>> As I understand, this stand alone hsqldb.jar is newer than
>>> hsqdldb.jar in installation set.
>>> Not need to create a new installation set for testing new one, only
>>> deleting old and copying this newer hsqldb.jar into classes directory.
>>> Zoltan
>>>>
>>>> Drew
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: dev-unsubscribe@...
>>>> For additional commands, e-mail: dev-help@...
>>>>
>>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@...
>>> For additional commands, e-mail: dev-help@...
>>>
>>
>>
>
>

--
Ocke Janssen                      Tel: [phone], x66661
Dipl. Inf(FH)                     Fax: [phone]
Sun Microsystems Inc.
Nagelsweg 55                      mailto:Ocke.Janssen@...
D-20097 Hamburg                   http://www.sun.com/staroffice

Sitz der Gesellschaft:
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Reizinger Zoltán]

Hi Ocke,

Ocke Janssen írta:

> Moin,
>
> On 10/15/09 19:49, Reizinger Zoltán wrote:
>> Drew Jensen írta:
>>> Ocke Janssen wrote:
>>>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>>>> Ocke Janssen írta:
>>>>>> Win upload now completed and tested.
>>>>> I down loaded the new installation set, installed  on winXP Home
>>>>> Hungarian version, from cmd window:
>>>>> msiexec/a openofficeorg32.msi
>>>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>>>> problem.
>>>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>>>> soffice not starts from file manager, error mesage: (fast
>>>>> translation)
>>> Hi Zoltan,
>>>
>>> Just a thought - if a reinstall did not help then I would look
>>> immediately to the user configuration data.
>>> Befrore starting OO.o again be sure to double check the entry in the
>>> bootstrap.ini file
>>> Ensure that it is going to point to a non-existent (or verified
>>> empty) directory.
>> I did it no change the problem, changed installation directory,
>> installed into other drive, same error.
>> I stopped installations, something other problem can cause this. I
>> installed similar way the OOO320_m1, and DEV300_m61. Only change was
>> from that time, windows update in this Tuesday. I give up on win
>> version.
> The Windows version is non-product build where more assertions are
> visible as you would see in other cases.
> http://wiki.services.openoffice.org/wiki/Non_Product_Build

It says that all debug messages should be submitted as issue, with
ASSERT: in summary.

What to do if I found one or more such assertions, in  CWS hsqldb19.
Create screenshot and put it to wiki page as Drew did, or submit issue?
> For the Windows build you need debug dll which aren't on your system
> by default. The link
> http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements 
> might help you to find the pieces which are missing.
>
> I hope that is a little help. I'm currently build a product version
> but for testing the non-product would be better. That's my personal
> opinion.
>
After I installed Visual C++2008 Express Edition, I can start OOo, and
start tests on winXP,

Zoltan
> - oj
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Drew Jensen]

Reizinger Zoltán wrote:

> Hi Ocke,
>
> Ocke Janssen írta:
>> Moin,
>>
>> On 10/15/09 19:49, Reizinger Zoltán wrote:
>>> Drew Jensen írta:
>>>> Ocke Janssen wrote:
>>>>> On 10/15/09 11:32, Reizinger Zoltán wrote:
>>>>>> Ocke Janssen írta:
>>>>>>> Win upload now completed and tested.
>>>>>> I down loaded the new installation set, installed  on winXP Home
>>>>>> Hungarian version, from cmd window:
>>>>>> msiexec/a openofficeorg32.msi
>>>>>> into C:\Program Files\OOo_hsqldb19\ folder, installs without any
>>>>>> problem.
>>>>>> I changed bootstrap.ini,  UserInstallation=$ORIGIN/..
>>>>>> soffice not starts from file manager, error mesage: (fast
>>>>>> translation)
>>>> Hi Zoltan,
>>>>
>>>> Just a thought - if a reinstall did not help then I would look
>>>> immediately to the user configuration data.
>>>> Befrore starting OO.o again be sure to double check the entry in
>>>> the bootstrap.ini file
>>>> Ensure that it is going to point to a non-existent (or verified
>>>> empty) directory.
>>> I did it no change the problem, changed installation directory,
>>> installed into other drive, same error.
>>> I stopped installations, something other problem can cause this. I
>>> installed similar way the OOO320_m1, and DEV300_m61. Only change was
>>> from that time, windows update in this Tuesday. I give up on win
>>> version.
>> The Windows version is non-product build where more assertions are
>> visible as you would see in other cases.
>> http://wiki.services.openoffice.org/wiki/Non_Product_Build
> It says that all debug messages should be submitted as issue, with
> ASSERT: in summary.
>
> What to do if I found one or more such assertions, in  CWS hsqldb19.
> Create screenshot and put it to wiki page as Drew did, or submit issue?

Hi Zoltan,

Actually I'll be, most likely, opening issues also - not just updating
the wiki page.
The wiki page, I'm hoping will serve a different purpose - to be able to
go back through the page and generate one or more test scenarios.
I'm trying to document each interaction (create something, alter
something) and as I do assign it to the functional section it is testing.

With the number of assertions/errors/warings being displayed to screen
however I need to 1) start some issues 2) break the wiki page down into
sub-pages for the different functional areas..else, I'm going to be lost
pretty quick.

ALSO
@Ocke, or ?: Using the 10/16/09 CWSHsql19 build  I get lots of errors in
things that are not directly related to Base/HSQL or even Base. For
instance trying to install the XRay macro via the distribution writer
file found at OOoMacros.org. Under this build opening the pre-2.0 writer
file generates a flurry of errors - but does open - trying to run the
macro that installs XRay generates even more errors, then hangs the
system and the XRay basic library is NOT copied into the system. Do I
chaulk this up to the odd build, or report this in the issue tracker
under framework?


Drew


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Drew Jensen]

Using the CWSHsqldb19 build, 10/16/09 the default has changed in the
HSQLdb engine for table creation from CACHED to MEMORY.

Creating tables via the GUI or via SQL statement, w/out explicit CACHED
type, produces a memory based table - on purpose change?
-hmm, I didn't go back and check the SCRIPT file for a converted Base
file....I'll let you know on that.

Thanks

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Drew Jensen]

Ok - how much of the new features in 1.9 should be usable in Base.

I don't mean via the GUI, rather
- Is there anything in the engine that is being suppressed in the
embedded implementation?
- Triggers , Procedures/Functions, etc

How about the other way - Anything that under 3.2 was not available that
will be in 3.3 (HSQL1.9)?

For instance - I've created a couple of tables and added indexes, FKs
via SQL window, works fine. Tried to add a trigger and...well, not quite
working.

1) Create the table, indexes and trigger directly one after the other in
the SQL window:
-- Base accepts each command
-- Can add/delete/edit data
-- Trigger does not function/but doesn't generate an error either (ok,
probably me and the trigger def. being wrong at this point...)
-- Close file
-- HSQLdb engine will not start on next open, the CREATE TRIGGER
statement generated in the script file is the rejected command

2) Create the table, indexe in the SQL window:
-- Base accepts
-- Can add/edit/delete data
-- Close file
-- Open and there is no problem
-- Run save CREATE TRIGGER statement as used in (1) above and it is
rejected due to a RIGHTS violation in the engine.

Right now then I'll go check the trigger statement against a stand alone
HSQLdb engine...and then maybe use the HSQLdb supplied sample for
triggers in the Base file (Table and Trigger def).

But - before I get to far into these newer features just wanted to be
sure that they are actually expected to work - meaning that they aren't
be turned off in the implementation here.

Thanks

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...

[Drew Jensen]

Just a quick note:

Updated these pages on the wiki
http://wiki.services.openoffice.org/wiki/User:DrewJensen/HSQLdb/TestDB
http://wiki.services.openoffice.org/wiki/User:DrewJensen/HSQLdb/1.9QATest/Wizard
(errr, misnamed that page...I sometimes don't like MediaWiki very much
)

Cached table for default
- does seem that the new build simply is not adding the 'set database
default table type cached' line in the script on NEW.

Adding it via the SQL window as the first thing you do after creating
a new Base file then creates cached tables via the GUI.

Triggers
- actually this whole new access privilege model, with roles, is
rather interesting...
anyway, does look like just needing to explicitly grant a role as a
separate statement in the SQl window first...


Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...