Re: [dba-dev] HSQLDB 1.9 Testing needed
Hi Zoltán, On 02.12.09 14:07, Reizinger Zoltán wrote: Moin Ocke, I tested some new features of 1.9 in cws One question regarding BACKUP command it could create backup files on file system, it will be supported? This is not planned at the moment. But I'll have a look at it, may be we have an issue. - oj When I run this command: BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING Get error, in SQL command window: 5: file input/output error: Required file is missing: C:\Downloads\OOotest\hsqldb19\Alkalmazottak31_.odb.properties in statement [BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING] Zoltan Ocke Janssen írta: The upload of the newest sources from hsqldb is ready to test. It includes clob and blob handling. I also adjusted the wizards and did also some refactoring. So it would be good idea to test this very well ;-) (all wizards) - oj - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
Hi Ocke, Ocke Janssen írta: Hi Zoltán, On 02.12.09 14:07, Reizinger Zoltán wrote: Moin Ocke, I tested some new features of 1.9 in cws One question regarding BACKUP command it could create backup files on file system, it will be supported? This is not planned at the moment. But I'll have a look at it, may be we have an issue. http://qa.openoffice.org/issues/show_bug.cgi?id=107402 Zoltan - oj When I run this command: BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING Get error, in SQL command window: 5: file input/output error: Required file is missing: C:\Downloads\OOotest\hsqldb19\Alkalmazottak31_.odb.properties in statement [BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING] Zoltan Ocke Janssen írta: The upload of the newest sources from hsqldb is ready to test. It includes clob and blob handling. I also adjusted the wizards and did also some refactoring. So it would be good idea to test this very well ;-) (all wizards) - oj - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
Moin Ocke, I tested some new features of 1.9 in cws One question regarding BACKUP command it could create backup files on file system, it will be supported? When I run this command: BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING Get error, in SQL command window: 5: file input/output error: Required file is missing: C:\Downloads\OOotest\hsqldb19\Alkalmazottak31_.odb.properties in statement [BACKUP DATABASE TO 'C:\backup.tgz' BLOCKING] Zoltan Ocke Janssen írta: The upload of the newest sources from hsqldb is ready to test. It includes clob and blob handling. I also adjusted the wizards and did also some refactoring. So it would be good idea to test this very well ;-) (all wizards) - oj - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
On Thu, Oct 29, 2009 at 2:08 PM, Andrew Jensen drewjensen.in...@gmail.comwrote: Data! Here is what I was thinking. Option 1 - Just push the data into the odb file(s) and be done with it. Pros - Doesn't get any easier then downloading one file. Cons - The download is big. Option 2 - refer users to the existing sakila data file at sourceforge and add a macro in the odb file that reads the file (which is a bunch of insert statements), perform any string replacements needed per line and execute each against the curent connection. The user would only need to download the Sakila data zip file, decompress it to their local drives and run the macro - One dialog to get the location of the file and that should be it. Pros - The odb files are nice and small Cons - Exrra download, Slow (then again that is a whole other question with the embedded files) Option 3 - ?? Anyhow - I was going to leave data for last, but perhaps it makes most sense to it next and then the views and such afterwards. Any thoughts - data next? Who - hooo... Option 1 - currently I have everything but payments rentals in the embedded file. I added the data to tables with no extra indexes, fk's or triggers then added these...it jumps to 776K during the creation of the indexes. After a SHUTDOWN COMPACT the file comes in at ~285 K. Later, Drew
Re: [dba-dev] HSQLDB 1.9 Testing needed
Hi, On 10/29/09 19:08, Andrew Jensen wrote: Data! Here is what I was thinking. Option 1 - Just push the data into the odb file(s) and be done with it. Pros - Doesn't get any easier then downloading one file. Cons - The download is big. Option 2 - refer users to the existing sakila data file at sourceforge and add a macro in the odb file that reads the file (which is a bunch of insert statements), perform any string replacements needed per line and execute each against the curent connection. The user would only need to download the Sakila data zip file, decompress it to their local drives and run the macro - One dialog to get the location of the file and that should be it. Pros - The odb files are nice and small Cons - Exrra download, Slow (then again that is a whole other question with the embedded files) Option 3 - ?? Anyhow - I was going to leave data for last, but perhaps it makes most sense to it next and then the views and such afterwards. Any thoughts - data next? I would choose option 2, that wouldn't need any legal work on our side ;-) And such a sql script importer could be a nice extension for OOo. - oj Drew On Thu, Oct 29, 2009 at 7:42 AM, Ocke Janssen ocke.jans...@sun.com wrote: Hi Drew, Thanks. Looks great. I just missing the data ;-) In my test I used also the sakila schema with data and I figured out that CLOBs are making trouble and the zip package (storing inside OOo) as well. When inserting a clob value where a trigger is waiting for data inserting like it is for the table film and film_text we have a dead lock. Fred from hsqldb already as a look at it. Off site: We need to support triggers at the UI ;-) - oj On 10/29/09 09:25, Drew Jensen wrote: Then it must be time for frist test files Attached are two files, both derived from the Sakila 0.8 data schema. sakila-ooo-32-1028.odb - Created w/ DEV320m_2 - tables, indexes and table constraints sakila-hsqldb-1028-03a.odb - Created w/ CWS build uploaded 10/28/2009 - tables, indexes, table constraints and triggers (minus 1) - domains (one with CHECK constraint) 3 forms in each file: Schema-MySQL-5 (original Sakila 0.8 schema) Schema-OOo-hsql-2-3.2 (the HSQLdb 1.8 schema) -- All PK fields as integer identity -- MySQL ENUM and SET data type replaced w/ CHAR and VARCHAR types -- All FK relations from original schema --- The database can be recreated by copy/paste of this file into the SQL window in an empty Base 2.x file. Schema-OOo-hsql-3.3 (the HSQLdb 1.9 schema) -- PK fields defined with same data types as original schema -- MySQL ENUM and SET data type replaced w custom domains -- All but one upate / insert triggers -- Stored procedure as first setp in supporting missing update trigger upd_film from original schema -- The database can not be recreated by a simple copy/paste of this file into the SQL window of a Base file. (yet) Views to follow. By the way - forms are rather broken in that last build, it seems. Later, Drew On Wed, Oct 28, 2009 at 2:53 AM, Ocke Janssen ocke.jans...@sun.commailto: ocke.jans...@sun.com wrote: Moin again, It's time for a new version. - oj On 10/21/09 15:08, Ocke Janssen wrote: Moin, I uploaded a new version. Please have a look at the cws hsqldb19 for fixed issues. http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks If you file new issues please add them to the cws. Thanks. - oj On 10/14/09 15:12, Ocke Janssen wrote: 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 http://qa-upload.services.openoffice.org in the folder hsqldb19. -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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
Re: [dba-dev] HSQLDB 1.9 Testing needed
Well, I was thinking simple.
Place a Base file with the sakila table definitions (sans indexes, triggers)
in a directory.
Place the file sakila-data.sql in the same directory.
In the Base database create a TEXT table, with a single column per record
for each line in the file.
CREATE TEXT TABLE SAKILA_DATA (INPUT_LINE LONGVARCHAR(10));
Source the text table to the data file and set the field separator to a
semi-colon.
SET TABLE SAKILA_DATA SOURCE sakila-data.sql;fs=\semi;
Now in the data file there are 17 insert statements - which can be had with
a simple query.
SELECT INPUT_LINE
FROM SAKILA_DATA
WHERE LEFT( INPUT_LINE, LENGTH('INSERT INTO')) = 'INSERT_INTO');
Create a basic procedure:
Create a ResultSet by executing the above query in a statement.
FOR EACH ROW in the result set
STATEMENT.EXECUTE( resultset.getstring(1) )
DROP TABLE SAKILA_DATA
Everything up to the create basic procedure works
- off to try the macro.
OOPS - I switched from OpenSUSE to Win 7 for that last step.
Open new issue, seems one can not SOURCE a text table under Win
7...arrrghback to Linux for the moment.
Re: [dba-dev] HSQLDB 1.9 Testing needed
Moin, I uploaded a new version. Please have a look at the cws hsqldb19 for fixed issues. http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks If you file new issues please add them to the cws. Thanks. - oj On 10/14/09 15:12, Ocke Janssen wrote: 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: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
On 10/20/09 00:34, Andrew Jensen wrote: First of all nobody could hinder you to submit issues. ;-) hmm - you mean that in a totally generic way I hope... :-) Yes. The difference between a debug (non-product) build and product build is that you see much more assertions as you would normally see. In a perfect world that wouldn't be the case but it is. Well, I am surely in the mind that I should open issues now - today I went ahead and setup OpenSUSE 11.1 / installed the CWSHSQLdb19 build, most (it seems) of the assertions/errors flying around under Win 7 are absent under OpenSUSE. That's because hsqldb19 for windows is a debug version and for Linux I created a product version (it's a policy to create a least one product version, sometimes the compiler is more intelligent as is good for him ;-) BTW found a easy and consistent way to crash OO.o w/Base due to a heap corruption under Win 7 that doesn't happen under OSUSE ...oops Your not supposed write past the end of the heap (actually this one is a block before the heap IIRC) - 'least that's how I remember it, so that's one issue I'll open for sure. Logging! - it wasn't till I was launching from a terminal under Linux that I realized the logging being generated to stdout...I'll start paying attention - although I planned to turned on logging to a file under Windows ..now I'm anxious to try launching OO.o uing the PowerShell under Win 7, will I get the default logging you have turned on there also? That's one thing I also encounter in newer builds. Seems that I over read a feature mail. (insider) ;-) We use cygwin on our side which runs good and looks more like a Unix. See you, oj Till later, Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
