[dba-dev] Re: Shared Library registration with regcomp

[Ocke Janssen]

Hi Rohit,

I change and add some lines.

On 05.04.2011 14:40, Rohit Kulkarni wrote:

Hello,
Thank you for your help.

I understand what you are trying to tell me.
I understand why I cant regcomp the lib file from connectivity module.
Now can you please tell me what is wrong in my map file and makefile.

 makefile.mk 


PRJ=..$/..$/..
PRJINC=..$/..
PRJNAME=connectivity
TARGET=DriverSkeleton

ENABLE_EXCEPTIONS=TRUE
VISIBILITY_HIDDEN=TRUE

# --- Settings --
.IF "$(DBGUTIL_OJ)"!=""
ENVCFLAGS+=/FR$(SLO)$/
.ENDIF

.INCLUDE : $(PRJ)$/makefile.pmk
.INCLUDE : $(PRJ)$/version.mk 

# --- Files -
SLOFILES=\
 $(SLO)$/SResultSet.obj  \
 $(SLO)$/SStatement.obj  \
 $(SLO)$/SPreparedStatement.obj  \
 $(SLO)$/SDatabaseMetaData.obj   \
 $(SLO)$/SConnection.obj \
 $(SLO)$/SServices.obj   \
 $(SLO)$/SResultSetMetaData.obj   \
 $(SLO)$/SDriver.obj

SHL1VERSIONMAP= $(TARGET).map

Change to
SHL1VERSIONMAP=$(SOLARENV)/src/component.map


# --- Library ---
SHL1TARGET=$(TARGET)$(DLLPOSTFIX)
SHL1OBJS=$(SLOFILES)
SHL1STDLIBS=\
 $(CPPULIB)  \
 $(CPPUHELPERLIB)\
 $(TOOLSLIB) \
 $(SALLIB)   \
 $(DBTOOLSLIB)   \
 $(COMPHELPERLIB)
SHL1DEPN=
SHL1IMPLIB= i$(TARGET)

SHL1DEF= $(MISC)$/$(SHL1TARGET).def

DEF1NAME= $(SHL1TARGET)
DEF1EXPORTFILE= exports.dxp




# --- Targets --

.INCLUDE : $(PRJ)$/target.pmk


Add these lines
ALLTAR : $(MISC)/skeleton.component

$(MISC)/skeleton.component .ERRREMOVE : 
$(SOLARENV)/bin/createcomponent.xslt \

skeleton.component
$(XSLTPROC) --nonet --stringparam uri \
'$(COMPONENTPREFIX_BASIS_NATIVE)$(SHL1TARGETN:f)' -o $@ \
$(SOLARENV)/bin/createcomponent.xslt skeleton.component

Copy mysql.component to skeleton.component

- oj


==

Also my .map file is,

=DriverSkeleton.map=

DRIVERSKELETON_2_0 {
 global:
 component_getImplementationEnvironment;
 component_writeInfo;
 component_getFactory;
 local:
 *;
};

==

And exports.dxp is,

==exports.dxp==
component_getImplementationEnvironment
component_writeInfo
component_getFactory

==

All above files are under " connectivity/source/drivers/DriverSkeleton "
this path.
Are above files are correct and if so what goes wrong ?
Also, can you tell me what is the use of SServices.cxx file ?
And what should I write below " SHL1STDLIBS=\ " this in makefile.mk
 ?

Regards,
Rohit

2011/4/4 Frank Schönheit mailto:frank.schoenh...@oracle.com>>

Hi Rohit,

 > I am trying to register the library (.so) file for the example
skeleton
 > sdbc driver using "regcomp" tool into the services.rdb file. When
I try
 > to register the shared library in "connection/unxlngi6.pro/lib


I suppose you mean "connectivity/unxlngi6.pro/lib
" here, i.e. the local
output tree of the "connectivity" module?

 > " directory it fails giving
 > "CannotRegisterImplementationException" exception.
 >
 > However during the build process this library is copied into
 > 'solver//330/unxlngi6.pro 
" directory and when I
 > try to register this file it succeeds !
 >
 > Could anyone tell me what changes happen to the library files during
 > build process when they are copied into the solver directory?

I suppose this is a LD_LIBRARY_PATH problem: your library is probably
linked against other libraries from URE (the UNO runtime environment),
which, in a complete build, also reside in
$SOLVER/330/unxlngi6.pro/lib .
So, if your library resides there, too, and your LD_LIBRARY_PATH
contains ".", then loading the lib succeeds. Loading the lib in the
local output tree doesn't succeed, since the loader doesn't find the URE
libs there.

To verify this, try "ldd " to see which libs your actual lib
needs, and whether the loader finds them.

 > My problem is that the my sdbc driver library is supposed t

[dba-dev] Re: Report builder for DEV300m105

[Ocke Janssen]

On 31.03.2011 13:19, Reizinger Zoltán wrote:

Hi Ocke,
Please create report builder for DEV300m105.

Done.

ftp://qa-upload.services.openoffice.org/SRB

- oj


Zoltan
--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hello Rohit,

On 30.03.2011 03:01, Rohit Kulkarni wrote:

Hello Oj,

I an not writing the sdbcx driver, also I can debug everything else but
my driver code. I am guessing I am not registering the driver properly.

I have written the .xml file for the driver and also made changes to
DataAccess.xcu. Should this be sufficient to register the driver? if not
what else do I need to do ?

Do have changed the module scp2 and added lines like
STD_LIB_FILE(gid_File_Lib_Mysql,mysql) in file_library_ooo.scp
and
gid_File_Lib_Mysql, in module_hidden_ooo.scp ?

You have to build OOo instset because your registration is done there.
If the driver should not be an extension than we you could remove your 
dataaccess.xcu changes and adjust the code in dbaccess (look for sdbc: )


Best regards,

oj


Here are excerpts from those files:

== DriverSkeleton.xml 



http://www.w3.org/1999/xlink";>
   skeleton1 

rohit
org.openoffice.comp.connectivity.skeleton.SkeletonDriver
This library implements the database driver for
Skeleton.
com.sun.star.loader.SharedLibrary
c++

com.sun.star.sdbc.Driver
... 

cppuhelper
cppu
sal
vos
cppuhelper
cppu1
sal1 
vos


= DataAccess.xcu =


http://openoffice.org/2001/registry";
xmlns:xs="http://www.w3.org/2001/XMLSchema";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>



Driver Skeleton


Driver Skeleton Page


sdbc:skeleton:







org.openoffice.comp.connectivity.skeleton.SkeletonDriver


false


60




com.sun.star.comp.sdbcx.adabas.ODriver
 ...
   :

--

there is also a DriverSkeleton.xcu as below:

= DriverSkeleton.xcu =
http://openoffice.org/2001/registry";
xmlns:xs="http://www.w3.org/2001/XMLSchema";>



org.openoffice.comp.connectivity.skeleton.SkeletonDriver


Skeleton Driver




true







as for this I have updated the "build.lst and d.lst" files so that it
builds the "libDriverSkeletonli.so" file and copies it into the
installation set.
But when I debug this I can see that my driver is not returned as part
of enumeration by "createContentEnumeration()"

Could you suggest any way I can fix this?
thanks in advance.

-Rohit

On Tue, Mar 29, 2011 at 12:06 AM, Ocke Janssen mailto:ocke.jans...@oracle.com>> wrote:

Hi Rohit,


On 28.03.2011 17:43, Rohit Kulkarni wrote:

Hello,
1) I built whole openoffice and installed it.(normal build
i.e build
--all)
2) I built only dbaccess and connectivity modules with
debug=true
dbglevel=2
3) Copied .so files from ../connectivity/unxlngi6.pro/lib/*
<http://unxlngi6.pro/lib/*>
<http://unxlngi6.pro/lib/*> and ../dbaccess/unxlngi6.pr/lib/*
<http://unxlngi6.pr/lib/*>
<http://unxlngi6.pr/lib/*>  to ../../openoffice3/basis-link/program/

4) Now I set breakpoint to " b
connectivity::flat::ODriver::acceptsURL "
5) Run base through gdb.
6) Execution stopped at breakpoint, whatever I select flat or
skeleton driver or any other from available driver list.
7) When I set breakpoint at " b
connectivity::skeleton::SkeletonDriver::acceptsURL ", it
wont stop
at breakpoint.
8) That means execution of program never goes to SDriver.cxx
(skeleton driver file) file which has acceptsURL function.

The things I have noticed after some more debugging in gdb
are --

1) I saw the function named
OSDBCDriverManager::bootstrapDrivers()
2) I think this is the function where it populates the list
of all
drivers using
" createContentEnumeration " function.
3) And this function is not returning my driver.
4) I saw this after watching the value of " aDriverDescriptor "
variable which is used for pushback in vector " m_aDriverBS
" , I
saw various strings for example , for flat it is
"com.sun.star.comp.sdbc.flat.ODriver" but not my driver name.

What do I need to do so that createContentEnumeration will return my
driver object in the list ?


Do you register the driver as an extension? If so the lib are not
located in basis-link/program they are located in your user folder
3/user/uno_package/cache/uno_package/...
That would also explain why you can't set any breakpoint.
Another reason could be that your driver doesn't support
"com.sun.star.sdbc.Driver" or the driver was not registered.

If that doesn't work I could look at the code if you want to.

Best regards,

Ocke



Regards,
Rohit


On Mon, Mar 28, 2011 at 

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hi Rohit,

On 28.03.2011 17:43, Rohit Kulkarni wrote:

Hello,
1) I built whole openoffice and installed it.(normal build i.e build
--all)
2) I built only dbaccess and connectivity modules with debug=true
dbglevel=2
3) Copied .so files from ../connectivity/unxlngi6.pro/lib/*
<http://unxlngi6.pro/lib/*> and ../dbaccess/unxlngi6.pr/lib/*
<http://unxlngi6.pr/lib/*>  to ../../openoffice3/basis-link/program/
4) Now I set breakpoint to " b
connectivity::flat::ODriver::acceptsURL "
5) Run base through gdb.
6) Execution stopped at breakpoint, whatever I select flat or
skeleton driver or any other from available driver list.
7) When I set breakpoint at " b
connectivity::skeleton::SkeletonDriver::acceptsURL ", it wont stop
at breakpoint.
8) That means execution of program never goes to SDriver.cxx
(skeleton driver file) file which has acceptsURL function.

The things I have noticed after some more debugging in gdb are --

1) I saw the function named OSDBCDriverManager::bootstrapDrivers()
2) I think this is the function where it populates the list of all
drivers using
" createContentEnumeration " function.
3) And this function is not returning my driver.
4) I saw this after watching the value of " aDriverDescriptor "
variable which is used for pushback in vector " m_aDriverBS " , I
saw various strings for example , for flat it is
"com.sun.star.comp.sdbc.flat.ODriver" but not my driver name.

What do I need to do so that createContentEnumeration will return my
driver object in the list ?


Do you register the driver as an extension? If so the lib are not 
located in basis-link/program they are located in your user folder 
3/user/uno_package/cache/uno_package/...

That would also explain why you can't set any breakpoint.
Another reason could be that your driver doesn't support 
"com.sun.star.sdbc.Driver" or the driver was not registered.


If that doesn't work I could look at the code if you want to.

Best regards,

Ocke




Regards,
Rohit


On Mon, Mar 28, 2011 at 1:16 PM, Ocke Janssen mailto:ocke.jans...@oracle.com>> wrote:

Hi,


On 26.03.2011 06:47, Rohit Kulkarni wrote:

Hello,
I have successfully built skeleton driver and I can see it in
available
list.
Now , I tried to debug it using gdb. For this I followed
instructions on
http://wiki.services.openoffice.org/wiki/Debugging
Build using debug=true and copied .so files to installation set.

I added a breakpoint at
connectivity::skeleton::SkeletonDriver::acceptsURL then,
run base -> select Skeleton Driver -> Datasource url window appears
(typed any string in it) -> saved ->finish
In this process debugger wont stop at breakpoint.

Another thing is that I added breakpoint at
connectivity::flat::ODriver::acceptsURL then, all same steps above.
Debugger stopped at breakpoint where I can see flat file EDriver.cxx
code with acceptsURL function.

So, do you have any idea why it wouldn't call
connectivity::skeleton::SkeletonDriver::acceptsURL function?

May be you copied the wrong files or you built them not with debug=t
? When you can set a break point for flat it should also work for
your driver. No guess so far. Or may be set the break point when the
library was loaded. I'm not the gdb expert.

- oj


Regards,
Rohit
On Tue, Mar 15, 2011 at 11:53 AM, Ocke Janssen
mailto:ocke.jans...@oracle.com>
<mailto:ocke.jans...@oracle.com
<mailto:ocke.jans...@oracle.com>>> wrote:

On 14.03.2011 18:45, Rohit Kulkarni wrote:

I could successfully built the skeleton driver and now I
can see
it in
the list of available drivers as well!
Thanks a lot for your help. I really appreciate it.

:-)


I have a quick question.



Any idea on how to solve this?

No, sorry. I think that's a question for the normal
d...@openoffice.org <mailto:d...@openoffice.org>
<mailto:d...@openoffice.org <mailto:d...@openoffice.org>> list.
May be a build

problem or a bug.


Also, Now, if I make any changes to the skeleton driver,
do I
have to
build and install open office every time?

No, just replace your copy of the .so file in your office
installation.

- oj


--


Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 H

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hi,

On 26.03.2011 06:47, Rohit Kulkarni wrote:

Hello,
I have successfully built skeleton driver and I can see it in available
list.
Now , I tried to debug it using gdb. For this I followed instructions on
http://wiki.services.openoffice.org/wiki/Debugging
Build using debug=true and copied .so files to installation set.

I added a breakpoint at
connectivity::skeleton::SkeletonDriver::acceptsURL then,
run base -> select Skeleton Driver -> Datasource url window appears
(typed any string in it) -> saved ->finish
In this process debugger wont stop at breakpoint.

Another thing is that I added breakpoint at
connectivity::flat::ODriver::acceptsURL then, all same steps above.
Debugger stopped at breakpoint where I can see flat file EDriver.cxx
code with acceptsURL function.

So, do you have any idea why it wouldn't call
connectivity::skeleton::SkeletonDriver::acceptsURL function?
May be you copied the wrong files or you built them not with debug=t ? 
When you can set a break point for flat it should also work for your 
driver. No guess so far. Or may be set the break point when the library 
was loaded. I'm not the gdb expert.


- oj



Regards,
Rohit
On Tue, Mar 15, 2011 at 11:53 AM, Ocke Janssen mailto:ocke.jans...@oracle.com>> wrote:

On 14.03.2011 18:45, Rohit Kulkarni wrote:

I could successfully built the skeleton driver and now I can see
it in
the list of available drivers as well!
Thanks a lot for your help. I really appreciate it.

:-)


I have a quick question.



Any idea on how to solve this?

No, sorry. I think that's a question for the normal
d...@openoffice.org <mailto:d...@openoffice.org> list. May be a build
problem or a bug.


Also, Now, if I make any changes to the skeleton driver, do I
have to
build and install open office every time?

No, just replace your copy of the .so file in your office installation.

- oj


--


Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven



Oracle is committed to developing practices and products that help
protect the environment

--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
<mailto:dev-unsubscr...@dba.openoffice.org>
For additional commands send email to sy...@dba.openoffice.org
<mailto:sy...@dba.openoffice.org>
with Subject: help




--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

On 14.03.2011 18:45, Rohit Kulkarni wrote:

I could successfully built the skeleton driver and now I can see it in
the list of available drivers as well!
Thanks a lot for your help. I really appreciate it.

:-)


I have a quick question.



Any idea on how to solve this?
No, sorry. I think that's a question for the normal d...@openoffice.org 
list. May be a build problem or a bug.


Also, Now, if I make any changes to the skeleton driver, do I have to
build and install open office every time?

No, just replace your copy of the .so file in your office installation.

- oj



--


Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven



Oracle is committed to developing practices and products that help 
protect the environment

--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

;http://unxlngi6.pro/lib/libDriverSkeletonli.so>'




I am building the Skeleton Driver and I dont know how to solve this problem.
Could you please help to solve this problem? Am I doing anything wrong ?

Thanks,
Rohit
On Fri, Mar 11, 2011 at 11:35 AM, Ocke Janssen mailto:ocke.jans...@oracle.com>> wrote:

Hi Rohit,


On 10.03.2011 16:58, Rohit Kulkarni wrote:

Hi,

Thanks for your reply. I really appreciate the help.

I could find the skeleton files at the location you have
mentioned. Currently we are planning to develop the SDBC driver
which
will not be an extension. So, we will have to build the skeleton
driver
first, get it in the list of available drivers and then make it
work for
LDAP.

Could you please elaborate the point where you mentioned to search
for macab key on the website?
How does the open office dmake understand that it has to build
this new
driver?

I guess you place your driver in connectivity. So in that module you
find a file named prj/build.lst that is read when call the "build"
command. But for the start you could simply go in your folder and
call dmake. Each driver has a xcu file which must be "deliver"ed.
Which files are needed to copy/deliver is defined in prj/d.lst
So when you have built your driver with dmake you must call deliver.
After that go to the module scp2 and call "build" and deliver again.
Then you have to build the module instsetoo_native and voila your
OOo ist to install.
Below follows a simple list of todo's:
1. Create the driver files (Driver,Connection,Statement,ResultSet,...)
2. Create the xcu and xml file, take a look at the other drivers for
inspiration ;-)
3. dmake
4. Adjust d.lst to fit your new driver
5. deliver
6. Search for the word macab or jdbc in the module scp2 and create
the same for your new driver
7. build
8. deliver
9. go to instsetoo_native and build
10. Install your new OOo and enjoy your new driver.
11. Debug issues ;-)

- oj



Thanks,
Rohit

On Thu, Mar 10, 2011 at 12:38 PM, Ocke Janssen
mailto:ocke.jans...@oracle.com>
<mailto:ocke.jans...@oracle.com
<mailto:ocke.jans...@oracle.com>>> wrote:

Hi Rohit,

First of all you have to decide if the driver should be an
extension
or not. I would first try it as extension because you could
look at
the mysql driver.

Not an extension:
The best and easiest way to start I guess is to simply copy the
skeleton files in a folder beside the other database drivers in
connectivity. Further on you should copy e.g. the macab.xml and
macab.xcu file and rename it to your driver in the same
directory.
Search with opengrok
http://svn.services.openoffice.org/opengrok/
the macab key inside the other projects e.g. scp2 to include the
files into the OOo installation. Build OOo.

As extension:
Here the best way is to look at the mysqlc/source where the
mysql
extension is build and copy the files you need to build the
oxt. But
please be aware to replace all occurrences of mysql with
your name ;-)


Best regards,

Ocke


On 09.03.2011 19:21, Ocke Janssen wrote:

Hi,

The driver can be found here
ooo\odk\examples\DevelopersGuide\Database\DriverSkeleton

- oj

PS: I'll write more tomorrow. ;-)

On 09.03.2011 16:37, Rohit Kulkarni wrote:

Currently I am writing an SDBC driver for LDAP
directories. I am
following the guidelines given at

http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/SDBC_Driver

This includes writing Driver, connection, statement and
resultset
services.

I want to compile the skeleton driver code and have
an entry
in the list
of available drivers. This driver will be a pseudo
driver
and will not
have any functionality. This will help in developing the
actual driver.

I am not able to find skeleton driver related source
files.
I could
locate a folder named skeleton in
"/OOO320_m19/connectivity/workben/skeleton" but could not
find actual
source files.

Could anyone please give me any poi

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hi Rohit,

On 10.03.2011 16:58, Rohit Kulkarni wrote:

Hi,

Thanks for your reply. I really appreciate the help.

I could find the skeleton files at the location you have
mentioned. Currently we are planning to develop the SDBC driver which
will not be an extension. So, we will have to build the skeleton driver
first, get it in the list of available drivers and then make it work for
LDAP.

Could you please elaborate the point where you mentioned to search
for macab key on the website?
How does the open office dmake understand that it has to build this new
driver?
I guess you place your driver in connectivity. So in that module you 
find a file named prj/build.lst that is read when call the "build" 
command. But for the start you could simply go in your folder and call 
dmake. Each driver has a xcu file which must be "deliver"ed. Which files 
are needed to copy/deliver is defined in prj/d.lst

So when you have built your driver with dmake you must call deliver.
After that go to the module scp2 and call "build" and deliver again.
Then you have to build the module instsetoo_native and voila your OOo 
ist to install.

Below follows a simple list of todo's:
1. Create the driver files (Driver,Connection,Statement,ResultSet,...)
2. Create the xcu and xml file, take a look at the other drivers for 
inspiration ;-)

3. dmake
4. Adjust d.lst to fit your new driver
5. deliver
6. Search for the word macab or jdbc in the module scp2 and create the 
same for your new driver

7. build
8. deliver
9. go to instsetoo_native and build
10. Install your new OOo and enjoy your new driver.
11. Debug issues ;-)

- oj




Thanks,
Rohit

On Thu, Mar 10, 2011 at 12:38 PM, Ocke Janssen mailto:ocke.jans...@oracle.com>> wrote:

Hi Rohit,

First of all you have to decide if the driver should be an extension
or not. I would first try it as extension because you could look at
the mysql driver.

Not an extension:
The best and easiest way to start I guess is to simply copy the
skeleton files in a folder beside the other database drivers in
connectivity. Further on you should copy e.g. the macab.xml and
macab.xcu file and rename it to your driver in the same directory.
Search with opengrok http://svn.services.openoffice.org/opengrok/
the macab key inside the other projects e.g. scp2 to include the
files into the OOo installation. Build OOo.

As extension:
Here the best way is to look at the mysqlc/source where the mysql
extension is build and copy the files you need to build the oxt. But
please be aware to replace all occurrences of mysql with your name ;-)


Best regards,

Ocke


On 09.03.2011 19:21, Ocke Janssen wrote:

Hi,

The driver can be found here
ooo\odk\examples\DevelopersGuide\Database\DriverSkeleton

- oj

PS: I'll write more tomorrow. ;-)

On 09.03.2011 16:37, Rohit Kulkarni wrote:

Currently I am writing an SDBC driver for LDAP directories. I am
following the guidelines given at

http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/SDBC_Driver

This includes writing Driver, connection, statement and
resultset
services.

I want to compile the skeleton driver code and have an entry
in the list
of available drivers. This driver will be a pseudo driver
and will not
have any functionality. This will help in developing the
actual driver.

I am not able to find skeleton driver related source files.
I could
locate a folder named skeleton in
"/OOO320_m19/connectivity/workben/skeleton" but could not
find actual
source files.

Could anyone please give me any pointers regarding

1. Where can I find the source files for the skeleton driver?
2. How to build a skeleton driver?
3. How to make an entry in available drivers list?

Thanks for your time. I really appreciate the help.

Regards,
Rohit


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
<mailto:dev-unsubscr...@dba.openoffice.org>
For additional commands send email to sy...@dba.openoffice.org
<mailto:sy...@dba.openoffice.org>
with Subject: help


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
<mailto:dev-unsubscr...@dba.openoffice.org>
For additional commands send email to sy...@dba.openoffice.org
<mailto:sy...@dba.openoffice.org>
with Subject: help




--

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hi Rohit,

First of all you have to decide if the driver should be an extension or 
not. I would first try it as extension because you could look at the 
mysql driver.


Not an extension:
The best and easiest way to start I guess is to simply copy the skeleton 
files in a folder beside the other database drivers in connectivity. 
Further on you should copy e.g. the macab.xml and macab.xcu file and 
rename it to your driver in the same directory.
Search with opengrok http://svn.services.openoffice.org/opengrok/ the 
macab key inside the other projects e.g. scp2 to include the files into 
the OOo installation. Build OOo.


As extension:
Here the best way is to look at the mysqlc/source where the mysql 
extension is build and copy the files you need to build the oxt. But 
please be aware to replace all occurrences of mysql with your name ;-)



Best regards,

Ocke

On 09.03.2011 19:21, Ocke Janssen wrote:

Hi,

The driver can be found here
ooo\odk\examples\DevelopersGuide\Database\DriverSkeleton

- oj

PS: I'll write more tomorrow. ;-)

On 09.03.2011 16:37, Rohit Kulkarni wrote:

Currently I am writing an SDBC driver for LDAP directories. I am
following the guidelines given at
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/SDBC_Driver

This includes writing Driver, connection, statement and resultset
services.

I want to compile the skeleton driver code and have an entry in the list
of available drivers. This driver will be a pseudo driver and will not
have any functionality. This will help in developing the actual driver.

I am not able to find skeleton driver related source files. I could
locate a folder named skeleton in
"/OOO320_m19/connectivity/workben/skeleton" but could not find actual
source files.

Could anyone please give me any pointers regarding

1. Where can I find the source files for the skeleton driver?
2. How to build a skeleton driver?
3. How to make an entry in available drivers list?

Thanks for your time. I really appreciate the help.

Regards,
Rohit


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP

[Ocke Janssen]

Hi,

The driver can be found here
ooo\odk\examples\DevelopersGuide\Database\DriverSkeleton

- oj

PS: I'll write more tomorrow. ;-)

On 09.03.2011 16:37, Rohit Kulkarni wrote:

Currently I am writing an SDBC driver for LDAP directories. I am
following the guidelines given at
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/SDBC_Driver
This includes writing Driver, connection, statement and resultset services.

I want to compile the skeleton driver code and have an entry in the list
of available drivers. This driver will be a pseudo driver and will not
have any functionality. This will help in developing the actual driver.

I am not able to find skeleton driver related source files. I could
locate a folder named skeleton in
"/OOO320_m19/connectivity/workben/skeleton" but could not find actual
source files.

Could anyone please give me any pointers regarding

1. Where can I find the source files for the skeleton driver?
2. How to build a skeleton driver?
3. How to make an entry in available drivers list?

Thanks for your time. I really appreciate the help.

Regards,
Rohit


--
-
To unsubscribe send email to dev-unsubscr...@dba.openoffice.org
For additional commands send email to sy...@dba.openoffice.org
with Subject: help

Re: [dba-dev] hsqldb19 cws will be postponed again?

[Ocke Janssen]

Moin Zoltán,


On 15.02.2011 12:35, Reizinger Zoltán wrote:

Hi Ocke,
Until now the hsqldb19 was not finished and not integrated into DEV300.
The branch off will be in near future for OOo 3.4 this means the
hsqldb19 will not be integrated and consequently the OOo 3.4 will
support hsqldb 1.8.

Yes, that's right.

I know that the hsqldb 2.1 will next stable release and not finished
until now.

Fred (hsqldb) told me that it would be better to switch to the 2.1.

We face same situation when hsqldb 2.0.0 was issued in wrong time for
OOo 3.3 integration.
If we wait allways for nexr stable rellease of hsqldb, the 2.x version
will never integrated :(
Could we do some thing to avoid this?
Yes, as consequence we should first switch to a new release when the 
release is finished. And not make any suggestions in which version that 
will be integrated. When the first GA exists for hsqldb 2.1 I'll 
integrate that into hsqldb19 and push a new build on qa-upload.


Sorry.

Best regards,

Ocke


Thanks,
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

Re: [dba-dev] date axes for charts in report builder

[Ocke Janssen]

Hi Zoltán,

On 02.02.2011 20:32, Reizinger Zoltán wrote:

Hi Ocke,
Now the chart46 cws integrated into DEV300m99, now it needs to inserted
into report builder charts.
Needs separate issue for this?

Would be nice if you write one, I thought that all should work ;-)

Regards,

Ocke

Thanks,
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

[dba-dev] Re: [dev] Re: [dba-dev] OOo Base further development

[Ocke Janssen]

On 17.01.2011 10:07, Andreas Säger wrote:

Am 14.01.2011 10:15, Ocke Janssen wrote:


PS: Somebody (volunteering) interested in developing Java for wizards in
Base (e.g. Form, Query, Table or Report)?


Based on which API? You mean api.openoffice.org?
Only the sdb part of it. May be something from awt but only to access ui 
elements.



No thanks! I'm done with it.
Sad. You could complete refactor it and remove all duplicate code (which 
hopefully is already removed) and give it your own touch. And by the way 
you don't have to cast java.lang.Object(s) anymore to the interface you 
need, a simple


XDialogProvider2 xDialogProvider = 
UnoRuntime.queryInterface(XDialogProvider2.class, obj);


is enough ;-)

A first shot could be to remove String concatenations and replace them 
with StringBuilder. Just an idea.


- oj



-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands, e-mail: dev-h...@openoffice.org




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] OOo Base further development

[Ocke Janssen]

Moin,

On 11.01.2011 14:53, Reizinger Zoltán wrote:

Hi all,

More than year ago Frank collected ideas about Base further development,
he put the list of ideas into wiki page:
http://wiki.services.openoffice.org/wiki/Base/Features/Pool

Not so much happened from that time with this list, for example MySQL
native driver was developed, charts integrated into reports, due to the
limited resources.
The developers time allowed working mostly only on the bugfixes.

On Featues wiki page only new features for OOo 3.4 is the HSQLDB 2.0
integration: http://wiki.services.openoffice.org/wiki/Features

My question is that:
Any other feature could be added to OOo Base in 3.4 or 3.x versions?
Or project will work only on bugfixes, due to resources constraints?


There are many features which come to my mind which should/could be 
implemented. And with limited count of developers (volunteers are always 
welcome) the features which are implemented may be small.

May be Base isn't that attractive for developers as other apps. :-(
On the other side we have many features which need some more polish and 
some pimping before starting new ones. It's difficult to go the fine 
line between feature and polish to get the best for users.


- oj

PS: Somebody (volunteering) interested in developing Java for wizards in 
Base (e.g. Form, Query, Table or Report)?


Thanks,
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

Re: [dba-dev] ORB 1.2.1 on extension site

[Ocke Janssen]

Moin,
On 14.12.2010 15:02, Ocke Janssen wrote:

Hi Zoltán,

On 14.12.2010 13:51, Reizinger Zoltán wrote:

Hi Ocke,
I now find that ORB 1.2.1 version out from 20th September on extension
site.
The report builder betas for OOo 3.3 has same numbering 1.2.1, it will
be misleading if it remains.
Or you plan to use different numbering, or the new version will be
usable in 3.2 and 3.3?
Please clarify the situation.

We'll clarify the situation. Thanks for the pointer.
The newest version now is a 1.2.1 rev2. It can be downloaded from the 
extensions site. For further development (DEV300) I'll raise the version 
number.


- oj



- oj


Thanks,
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] ORB 1.2.1 on extension site

[Ocke Janssen]

Hi Zoltán,

On 14.12.2010 13:51, Reizinger Zoltán wrote:

Hi Ocke,
I now find that ORB 1.2.1 version out from 20th September on extension
site.
The report builder betas for OOo 3.3 has same numbering 1.2.1, it will
be misleading if it remains.
Or you plan to use different numbering, or the new version will be
usable in 3.2 and 3.3?
Please clarify the situation.

We'll clarify the situation. Thanks for the pointer.

- oj


Thanks,
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

Re: [dba-dev] CWS dba33m needs testing CAST() problem

[Ocke Janssen]

Hi Fernand,

On 10.12.2010 13:35, Fernand Vanrie wrote:

Ocke,

after some more testing, i found that things go's far far more speedy
than with the installed m17 ? can you see a reason for this behavior ?
the only differece is that i see the fact that i have less extentions
loaded and less Database registered in your CWS:33dba version.
Did you some major speed aprovements or come i al back to some settings ?
No. I just did a compile job on our side. Nothing different. But less 
extensions could do the job.


- oj



Greetz

Fernand

Ocke,

i manged to install, no more CAST problems :-) for me at least, hopes
others come to the same conclusion

Thank you for this quick fix


Fernand

Ocke,

I am happy to test BUT this stuff is new for me :-)

Have the Zip downloaded, how do i INSTALL this stuff , using my
existing OOO330m17 settings
Greetz
Fernand

Moin,

The cws dba33m needs some testing for the issue 115436 (show
stopper). It would be great if we could verify that the issue is fixed.

I uploaded at to qa-upl...@services.openoffice.org in the folder
dba33m.

Best regards,

Ocke

-
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




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] CWS dba33m needs testing CAST() problem

[Ocke Janssen]

Hi Fernand,

On 10.12.2010 13:07, Fernand Vanrie wrote:

Ocke,

I am happy to test BUT this stuff is new for me :-)

Have the Zip downloaded, how do i INSTALL this stuff , using my existing
OOO330m17 settings
Unzip the file to some temp folder. It includes the whole office and 
should not damage your own settings. Go into the program folder and 
start sbase ;-) That's what I'm doing for Linux.


I hope I forgot nothing.

- oj

PS: We found an issue with select * from table where "id" in ( 'll',OO')



Greetz
Fernand

Moin,

The cws dba33m needs some testing for the issue 115436 (show stopper).
It would be great if we could verify that the issue is fixed.

I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m.

Best regards,

Ocke

-
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

[dba-dev] CWS dba33m needs testing CAST() problem

[Ocke Janssen]

Moin,

The cws dba33m needs some testing for the issue 115436 (show stopper). 
It would be great if we could verify that the issue is fixed.


I uploaded at to qa-upl...@services.openoffice.org in the folder dba33m.

Best regards,

Ocke

-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Hi Fernand,

On 09.12.2010 15:43, Fernand Vanrie wrote:

Ocke,

I was just wondering, my problems with CAST started (i think) after i
instaled the very latest (oracle-report-builder-OOO330-m3.oxt)for
testing . Now i tried to remove this ORB version but i get a error so i
can not test without ORB loaded.

just a hint


PS. how do i remove this unremovable ORB ?:-)
If nothing helps go to your user folder there you have a folder called 
uno_packages. It contains a folder called cache. If ORB is the one and 
only ext delete the cache folder and start again.


- oj



Ocke,

It has certainly nothing to sea with the SQL version or server type. I
work in a company envoriment, everyone uses the same SQL server, same
native OO-connector. Everyone works on OO 3.2 without problems, i test
3.3 and have the CAST problem:
cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where
`mag_news_export`.`DATUM` has a imported data (dd/mm/)
hope it helps




-
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] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Fernand,

On 09.12.2010 18:13, Fernand Vanrie wrote:

Ocke,

sorry in my code no "space" , then i typed "cast in uppercase(CAST), no
difference..
You can't remove the space. It is later on inserted short before it was 
sent to the database.


- oj


cast(`mag_news_export`.`DATUM` as date) AS `DATUM`,



On 09.12.2010 15:28, Fernand Vanrie wrote:

Ocke,

It has certainly nothing to sea with the SQL version or server type. I
work in a company envoriment, everyone uses the same SQL server, same
native OO-connector. Everyone works on OO 3.2 without problems, i test
3.3 and have the CAST problem:
cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where
`mag_news_export`.`DATUM` has a imported data (dd/mm/)
hope it helps

I already fixed the issue and better it looks like it will make it
into 3.3 :-) The problem was the space "CAST (" doesn't work "CAST("
-> works.

- oj

PS: cws is dba33m


Fernand


-
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] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Hi Fernand,

On 09.12.2010 15:28, Fernand Vanrie wrote:

Ocke,

It has certainly nothing to sea with the SQL version or server type. I
work in a company envoriment, everyone uses the same SQL server, same
native OO-connector. Everyone works on OO 3.2 without problems, i test
3.3 and have the CAST problem:
cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where
`mag_news_export`.`DATUM` has a imported data (dd/mm/)
hope it helps
I already fixed the issue and better it looks like it will make it into 
3.3 :-) The problem was the space "CAST (" doesn't work "CAST(" -> works.


- oj

PS: cws is dba33m


Fernand


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Hi Alex,

On 09.12.2010 10:35, Alex Thurgood wrote:

Hi Ocke,


- "Ocke Janssen"  a écrit :


As I mentioned, CAST works for me with OOo 3.2.1. It also works for

me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
is based on).
One more interesting thing
when executing
select CAST('2001-01-01' as DATE)
works, but when executing
select CAST('2001-01-01' as DATE) from ´testdb´.´i115436´
an error is thrown.



You need to create an alias for the CASTed field. If you use this statement 
instead, it should work :

SELECT CAST('2001-01-01' as DATE) as 'MyDate' from 'testdb'.'i115436'
Thanks. I found the issue and it can be fixed. Look at the issue for the 
case.


- oj

PS: A space can make a big difference.




Could you please add some sample data to the issue?



If I get a bit of time today, I'll add some sample data to the issue.


Alex

-
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] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Hi Alex,

First of all if I could I would like to fix it.

On 09.12.2010 09:34, Alex Thurgood wrote:

Hi Ocke,


- "Ocke Janssen"  a écrit :


I just have to set the issue to wontfix. :-(
The problem seems to be the database. Even with odbctest I get the
same
results =>  error and I tested a StarOffice 9.2 which is equal to OOo
3.2, same error as in OOo 3.2.1 and 3.3.



As I mentioned, CAST works for me with OOo 3.2.1. It also works for me in 
LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that is based on).

One more interesting thing
when executing
select CAST('2001-01-01' as DATE)
works, but when executing
select CAST('2001-01-01' as DATE) from ´testdb´.´i115436´
an error is thrown.

Could you please add some sample data to the issue?

- oj





Did anyone did an upgrade to a newer MySQL version before the
statement
stop working?



My actual version of mysql server is :
Server version: 5.1.50 MySQL Community Server (GPL)

My actual version of the mysql connector extension is : 1.0.0


I'm going to test my actual setup with the latest OOoRC, if I can get it to 
install nicely beside my current OOo 3.2.1 on MacOSX.


Alex







-
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] Re: CAST() no longer working with OOO 330m16

[Ocke Janssen]

Moin,

I just have to set the issue to wontfix. :-(
The problem seems to be the database. Even with odbctest I get the same 
results => error and I tested a StarOffice 9.2 which is equal to OOo 
3.2, same error as in OOo 3.2.1 and 3.3.


Did anyone did an upgrade to a newer MySQL version before the statement 
stop working?


- oj

On 08.12.2010 19:04, Fernand Vanrie wrote:

Alex ,

As always, we gave good reasons to use a technique, so let hope the CAST
problem will be fixed soon =-)

Fernand,

Well I also use EXTRACT(), but have found that I still have to CAST
the type. If I just use the DATE/TIME functions on their own, the
results are inconsistent across the months, especially when adding or
subtracting. I haven't kept any of my old queries that did direct
application of date addition / substraction because they were of no
use to me, so I rewrote them all with CAST and EXTRACT.

An example of a current one that works is given below :

SELECT CAST(EXTRACT(YEAR FROM CURDATE()) as SIGNED)-CAST(EXTRACT(YEAR
FROM Date1) as SIGNED)+1 as 'Renewal Num' FROM mybase where
MONTH(Date1) = 12

I do not consider this to be an optimised way of obtaining the result
I wanted, but I found it to be the only way that worked reliably for
each month of the year, independently of the date provided by
CURRENT_DATE. In a more simplified expression, the results were wrong
by +/- 1 dependent on the MONTH given and the date provided by
CURRENT_DATE.

It may be that the underlying cause to this is a problem with date
handling by Mysql, and not OOo at all, but I haven't checked this out.



Alex



- "Fernand Vanrie" a écrit :


Alex ,

its also a fact that there are (better) alternatives for cast Date()

convert() or even left() and right()

Hi Fernand,

Done, but whether it will make any difference ? Its not a blocker

because it doesn't cause a crash, or lose your data, but it is surely
a regression from 3.2.


Alex



- "Fernand Vanrie" a écrit :


Alexander ,

It sould be good to send this message also to

relea...@openoffice.org

there they decide over live and dead :-)

greetz

Fernand

Hi all,

Le 08/12/10 13:38, Reizinger Zoltán a écrit :

Hi Fernand,
It feels to me as I touched in some days ago, and find it, as a

known

issue with cast in MySQL:
http://qa.openoffice.org/issues/show_bug.cgi?id=115436
Zoltan


Hmm, this would not be good for me if this is the case because I

use

a

lot of cast statements with date values in mysql. The reason is

simple,

default typing of the values in date strings used to lead to

funny

behaviour for me on OOo, which meant that calculations I had in

my

queries based on the default types led to incorrect results. I

was

thus

forced into using CAST to ensure correct handling. If that

functionality

has now gone away with the latest dev release, whereas it works

in

3.2,

and connector 1.0.0, I see no incentive to move to 3.3.

Alex




-

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


-
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




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] CWS srb1 status

[Ocke Janssen]

Hi Zoltán,

On 07.12.2010 16:11, Reizinger Zoltán wrote:

Hi Ocke,
Now I see from releases mail, that the cws srb1 integrated into DEV300m95.
The issue http://www.openoffice.org/issues/show_bug.cgi?id=99049 needs
some changes, especially target milestone.
I will wait for ORB form DEV300m95, upload. :)

Here it comes report-builder-DEV300-1.2.2.m95.oxt

- oj


Thanks,
Zoltan

2010.11.08. 12:18 keltezéssel, Ocke Janssen írta:

Hi Zoltán,

On 05.11.2010 13:02, Reizinger Zoltán wrote:

Hi Ocke,
The new pentaho files in CWS srb1 when will be integrated?
It is in Status approved by QA and target is set to 3.4.
It is ready for integration more than a half year, and no real steps
from end of July.

as far as I know we are still waiting for some legal saying "GO" .
But may be we should switch to the next update from pentaho. ;-)

- oj


Thanks,
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




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables

[Ocke Janssen]

Hi Alexander,

On 01.12.2010 21:10, Alexander W. Janssen wrote:


I already thought so; I just helped myself and did the right thing;
aggregating and limiting the data using a query and then calling the
query from OOo Calc. I should've done that in the first place, but I
was in a rush of banging out a few quick diagrams.
To be honest, I was about to abuse Calc for a task it wasn't made for
- I'm currently reverse-engineering a rather bitchy DB-schema and I
just needed a data-viewer which was also able to create some diagrams
rather quickly.
Do you know the Relation designer in Base? You'll find it under 
Tools->Relationships


- oj


Cheers, Alex.





-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0 integration

[Ocke Janssen]

On 23.11.2010 14:10, Reizinger Zoltán wrote:

Hi Ocke,
Changes touched the report builder?

No changes.

-oj

If yes, please upload modified version.
Thanks,
Zoltan

2010.11.23. 13:39 keltezéssel, Ocke Janssen írta:

Moin,

New version of cws hsqldb19 uploaded on qa-upload

Several problems fixed. Give it a try.
BLOB doesn't work like expected when copying about database borders.

Best regards,

Ocke

PS: The version is 2.0.1-rc2 with some fixes out of their svn
repository. ;-)

On 10/26/10 13:33, Reizinger Zoltán wrote:

Hi Ocke,
I see that you fixed cws hsqldb19 issues and 2.0 integration finished.
You will create new installation sets from this cws, or will put into
DEV300 code-line directly?
If the HSQLDB 2.0.1 will be out in near future, this will be integrated,
too, or needs new issue for that?
Thanks,
Zoltan



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0 integration

[Ocke Janssen]

Moin,

New version of cws hsqldb19 uploaded on qa-upload

Several problems fixed. Give it a try.
BLOB doesn't work like expected when copying about database borders.

Best regards,

Ocke

PS: The version is 2.0.1-rc2 with some fixes out of their svn 
repository. ;-)


On 10/26/10 13:33, Reizinger Zoltán wrote:

Hi Ocke,
I see that you fixed cws hsqldb19 issues and 2.0 integration finished.
You will create new installation sets from this cws, or will put into
DEV300 code-line directly?
If the HSQLDB 2.0.1 will be out in near future, this will be integrated,
too, or needs new issue for that?
Thanks,
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] MySQL native driver 1.0.1 for OOo 3.3

[Ocke Janssen]

Moin Zoltán,

On 08.11.2010 13:54, Reizinger Zoltán wrote:

Hi all,
I still using native driver alpha 1.0.1 downloaded from qa-upload site
when test OOo 3.3RCs.
As we approaching the final RC, I raise the question:
Any plan to submit new one on extension site?
http://extensions.services.openoffice.org/en/project/mysql_connector
I guess that the extension will first be available when the final 
release is ready.


- oj

Thanks,
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

Re: [dba-dev] CWS srb1 status

[Ocke Janssen]

Hi Zoltán,

On 05.11.2010 13:02, Reizinger Zoltán wrote:

Hi Ocke,
The new pentaho files in CWS srb1 when will be integrated?
It is in Status approved by QA and target is set to 3.4.
It is ready for integration more than a half year, and no real steps
from end of July.

as far as I know we are still waiting for some legal saying "GO" .
But may be we should switch to the next update from pentaho. ;-)

- oj


Thanks,
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

Re: [dba-dev] HSQLDB 2.0 integration

[Ocke Janssen]

Moin,

New version of cws hsqldb19 uploaded on qa-upload

Several problems fixed. Give it a try.

Best regards,

Ocke

PS: The version is 2.0.1-rc2 with some fixes out of their svn 
repository. ;-)


On 10/26/10 13:33, Reizinger Zoltán wrote:

Hi Ocke,
I see that you fixed cws hsqldb19 issues and 2.0 integration finished.
You will create new installation sets from this cws, or will put into
DEV300 code-line directly?
If the HSQLDB 2.0.1 will be out in near future, this will be integrated,
too, or needs new issue for that?
Thanks,
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

Re: [dba-dev] Fixing the issue 53377 means that all queries editable?

[Ocke Janssen]

Hi,

On 10/28/10 13:42, Reizinger Zoltán wrote:

Hi all,
I found that the issue 53377 was marked as fixed in dba33f, it is means
that all queries including joints, are editable in OOo 3.3?
The issue 53377, I can not find in dba33f tasks list, and in any cws in
eis2. ;)

It seems that I forgot to add it there.


That will be a long waited feature, which not announced in new features.
But in the "What's new guide" it will be included. I got a call from our 
team. ;-)


But the query has to have the primary key from every table included to 
make it work. We still need to re-fetch rows when updated or inserted. 
Nobody knows what the database in the meantime with the data ;-)


Regards,

Ocke


Thanks,
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

Re: [dba-dev] HSQLDB 2.0 integration

[Ocke Janssen]

Ocke Janssen wrote:

Moin Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
I see that you fixed cws hsqldb19 issues and 2.0 integration finished.
You will create new installation sets from this cws, or will put into 
DEV300 code-line directly?


The installation are in the queue and should be built soon. I've upload 
them to qa-upload as soon as possible.

The windows version is ready. Linux needs some time.

- oj

PS: It is a developer build with assertions. ;-)



If the HSQLDB 2.0.1 will be out in near future, this will be 
integrated, too, or needs new issue for that?
We need a new issue for that. But first let 2.0.1 to be released. There 
is a change in the interface we use to communicate with hsqldb, so a 
little  rework is needed on my side.


- oj


Thanks,
Zoltan


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org







--
<http://www.oracle.com/>
Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

<http://www.oracle.com/commitment>



Oracle is committed to developing practices and products that help
protect the environment




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Proposal for other TableFilter

[Ocke Janssen]

Moin Fernand,

Fernand Vanrie wrote:
Our Tablefilter in a OO-Basedoc (who reflect also in the TableList in 
the DatabaseBrowser) is very handy to hide some tables
However there is a important disadvantage, when there are NEW tables 
available in the Database, they  are not visible in the DatabaseBrowser 
and in the OO-base-doc (when using a external data source)


SO: Can the filter been altered by choosing witch tables we NOT want to 
see ? New tables will than automaticly been seen .
 When this is not problematic for other reasons, i will be happy to fill 
a Enhancement Issue  :-)

An Enhancement Issue would be the best. Currently this is a positive list.

- oj



Greetz
Fernand






--
<http://www.oracle.com/>
Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

<http://www.oracle.com/commitment>



Oracle is committed to developing practices and products that help
protect the environment




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0 integration

[Ocke Janssen]

Moin Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
I see that you fixed cws hsqldb19 issues and 2.0 integration finished.
You will create new installation sets from this cws, or will put into 
DEV300 code-line directly?


The installation are in the queue and should be built soon. I've upload 
them to qa-upload as soon as possible.


If the HSQLDB 2.0.1 will be out in near future, this will be integrated, 
too, or needs new issue for that?
We need a new issue for that. But first let 2.0.1 to be released. There 
is a change in the interface we use to communicate with hsqldb, so a 
little  rework is needed on my side.


- oj


Thanks,
Zoltan


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org




--
<http://www.oracle.com/>
Ocke Janssen | Software Developer
Phone: +40 23646500
Oracle Office

ORACLE Deutschland B.V. & Co. KG | Nagelsweg 55 | 20097 Hamburg

ORACLE Deutschland B.V. & Co. KG
Hauptverwaltung: Riesstr. 25, D-80992 München
Registergericht: Amtsgericht München, HRA 95603

Komplementärin: ORACLE Deutschland Verwaltung B.V.
Rijnzathe 6, 3454PV De Meern, Niederlande
Handelsregister der Handelskammer Midden-Niederlande, Nr. 30143697
Geschäftsführer: Jürgen Kunz, Marcel van de Molen, Alexander van der Ven

<http://www.oracle.com/commitment>



Oracle is committed to developing practices and products that help
protect the environment




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] postgres ODBC problem with view

[Ocke Janssen]

Moin,

On 10/11/10 21:06, Frank Schönheit wrote:

Hi Josh/Zoltan,


The data content could not be loaded.
SQL Status: 42703
Error code: 7
ERROR: column "ctid" does not exist;


That's very odd. ctid is a system column; no driver should be accessing
it, for any reason.


Ocke knows more about this, but I suspect the PQ driver might deliver
that column's name as BestRowIdentifier, which might tempt our RowSet to
use it in some kind of "SELECT * FROM  WHERE ctid=?" statement
(for re/fetching rows).

Ocke?
The problem is that Postgres doesn't support updateable cursor for 
views. Already discussed in 2004 :-)


http://archives.postgresql.org/pgsql-odbc/2004-03/msg00045.php

Solution:
http://comments.gmane.org/gmane.comp.openoffice.dba.devel/3037



Best regards,

Ocke



Ciao
Frank



-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] postgres ODBC problem with view

[Ocke Janssen]

Sorry for the duplicates. But it is working again ;-)

-oj

On 10/13/10 08:01, Ocke Janssen wrote:

Moin,
On 10/11/10 21:06, Frank Schönheit wrote:

Hi Josh/Zoltan,


The data content could not be loaded.
SQL Status: 42703
Error code: 7
ERROR: column "ctid" does not exist;

That's very odd. ctid is a system column; no driver should be accessing
it, for any reason.

Ocke knows more about this, but I suspect the PQ driver might deliver
that column's name as BestRowIdentifier, which might tempt our RowSet to
use it in some kind of "SELECT * FROM WHERE ctid=?" statement
(for re/fetching rows).

I just groked for getBestRowIdentifier and it isn't used anywhere. So
the problem is some where else. I'll take a look at it.

- oj

Ocke?

Ciao
Frank




-
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] postgres ODBC problem with view

[Ocke Janssen]

 Moin,
On 10/11/10 21:06, Frank Schönheit wrote:

Hi Josh/Zoltan,


The data content could not be loaded.
SQL Status: 42703
Error code: 7
ERROR: column "ctid" does not exist;

That's very odd. ctid is a system column; no driver should be accessing
it, for any reason.

Ocke knows more about this, but I suspect the PQ driver might deliver
that column's name as BestRowIdentifier, which might tempt our RowSet to
use it in some kind of "SELECT * FROM  WHERE ctid=?" statement
(for re/fetching rows).
I just groked for getBestRowIdentifier and it isn't used anywhere. So 
the problem is some where else. I'll take a look at it.


- oj

Ocke?

Ciao
Frank




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] postgres ODBC problem with view

[Ocke Janssen]

 Moin,
On 10/11/10 21:06, Frank Schönheit wrote:

Hi Josh/Zoltan,


The data content could not be loaded.
SQL Status: 42703
Error code: 7
ERROR: column "ctid" does not exist;

That's very odd. ctid is a system column; no driver should be accessing
it, for any reason.

Ocke knows more about this, but I suspect the PQ driver might deliver
that column's name as BestRowIdentifier, which might tempt our RowSet to
use it in some kind of "SELECT * FROM  WHERE ctid=?" statement
(for re/fetching rows).
I just groked for getBestRowIdentifier and it isn't used anywhere. So 
the problem is some where else. I'll take a look at it.


- oj

Ocke?

Ciao
Frank




-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

Time is rare these days. But I uploaded a new version which I could 
install and run a simple report (one filed only).


So give it a try. :-)

- oj

Ocke Janssen wrote:
It seems that update the sources to newest version doesn't work out of 
the box. I've to invest some more time I guess.

Thanks for the help so far.

- oj

Reizinger Zoltán wrote:

Hi Ocke,
Something wrong remains in new version, too.

I run existing reports, get error "Failed to load style-mapper".
Same error when created new report in design view, and try to run.

Zoltan

2010.06.22. 14:46 keltezéssel, Ocke Janssen írta:

My fault. When things should go fast. ;-(

I uploaded a new version.

- oj

Reizinger Zoltán wrote:

Hi Ocke,
I tried to install it on DEV300_m83 on win7 and failed, with error 
I attached here.
I tried as user and as admin, failed both case, after thet removed 
chache folder, from installation, started with empty extension 
manager, same error.

Zoltan


2010.06.22. 12:53 keltezéssel, Ocke Janssen írta:

Moin,

I've uploaded a new version which uses the newest sources. May 
someone tries to test it. At the moment I've done the build 
without testing it.


oracle-report-builder-cws-srb1.oxt on 
qa-upload.services.openoffice.org/SRB


Best regards,

Ocke

Ocke Janssen wrote:

Hi Zoltan,

On 11/11/09 11:03, Reizinger Zoltán wrote:

Ocke Janssen írta:

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical 
releases from Pentaho. It would be great if you could test this 
new version. Hopefully it should as good/worse as the beta 
version you'll find at the same place.

If I understand well, it needs to test with OOO320_m4, now?

m4 should work. This new SRB is targeted for OOo 3.3 release.

- oj

Zoltan


- oj




- 


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







--
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

It seems that update the sources to newest version doesn't work out of 
the box. I've to invest some more time I guess.

Thanks for the help so far.

- oj

Reizinger Zoltán wrote:

Hi Ocke,
Something wrong remains in new version, too.

I run existing reports, get error "Failed to load style-mapper".
Same error when created new report in design view, and try to run.

Zoltan

2010.06.22. 14:46 keltezéssel, Ocke Janssen írta:

My fault. When things should go fast. ;-(

I uploaded a new version.

- oj

Reizinger Zoltán wrote:

Hi Ocke,
I tried to install it on DEV300_m83 on win7 and failed, with error I 
attached here.
I tried as user and as admin, failed both case, after thet removed 
chache folder, from installation, started with empty extension 
manager, same error.

Zoltan


2010.06.22. 12:53 keltezéssel, Ocke Janssen írta:

Moin,

I've uploaded a new version which uses the newest sources. May 
someone tries to test it. At the moment I've done the build without 
testing it.


oracle-report-builder-cws-srb1.oxt on 
qa-upload.services.openoffice.org/SRB


Best regards,

Ocke

Ocke Janssen wrote:

Hi Zoltan,

On 11/11/09 11:03, Reizinger Zoltán wrote:

Ocke Janssen írta:

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical 
releases from Pentaho. It would be great if you could test this 
new version. Hopefully it should as good/worse as the beta 
version you'll find at the same place.

If I understand well, it needs to test with OOO320_m4, now?

m4 should work. This new SRB is targeted for OOo 3.3 release.

- oj

Zoltan


- oj




- 


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




--
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

My fault. When things should go fast. ;-(

I uploaded a new version.

- oj

Reizinger Zoltán wrote:

Hi Ocke,
I tried to install it on DEV300_m83 on win7 and failed, with error I 
attached here.
I tried as user and as admin, failed both case, after thet removed 
chache folder, from installation, started with empty extension 
manager, same error.

Zoltan


2010.06.22. 12:53 keltezéssel, Ocke Janssen írta:

Moin,

I've uploaded a new version which uses the newest sources. May 
someone tries to test it. At the moment I've done the build without 
testing it.


oracle-report-builder-cws-srb1.oxt on 
qa-upload.services.openoffice.org/SRB


Best regards,

Ocke

Ocke Janssen wrote:

Hi Zoltan,

On 11/11/09 11:03, Reizinger Zoltán wrote:

Ocke Janssen írta:

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical 
releases from Pentaho. It would be great if you could test this 
new version. Hopefully it should as good/worse as the beta version 
you'll find at the same place.

If I understand well, it needs to test with OOO320_m4, now?

m4 should work. This new SRB is targeted for OOo 3.3 release.

- oj

Zoltan


- oj




-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

Moin,

I've uploaded a new version which uses the newest sources. May someone 
tries to test it. At the moment I've done the build without testing it.


oracle-report-builder-cws-srb1.oxt on qa-upload.services.openoffice.org/SRB

Best regards,

Ocke

Ocke Janssen wrote:

Hi Zoltan,

On 11/11/09 11:03, Reizinger Zoltán wrote:

Ocke Janssen írta:

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical 
releases from Pentaho. It would be great if you could test this new 
version. Hopefully it should as good/worse as the beta version 
you'll find at the same place.

If I understand well, it needs to test with OOO320_m4, now?

m4 should work. This new SRB is targeted for OOo 3.3 release.

- oj

Zoltan


- 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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0.0

[Ocke Janssen]

Hi Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
As I seecorrectly from EIS, the cws hsqldb19 postponed to OOo 3.4.
That means to me, that no hope to finish it before OOo 3.3 branching off.
Or I missed something?
No, you missed nothing. The branch of date was Friday and it wasn't 
possible to do all the things like qa in that short time.


Regards,

Ocke

Regards,
Zoltan

2010.06.09. 7:14 keltezéssel, Ocke Janssen írta:

Hi Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
I think this the final version of 2.0.0, issued yesterday 2010.06.07.
See http://hsqldb.org/

Thanks. Yes that is what GA means. ;-) I missed this completely. Sorry.
I'll integrate the newest version in hsqdb19. But that would need 
some time. The cws based on a really old one m67.


Best regards,

Ocke



-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0.0

[Ocke Janssen]

Hi Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
I think this the final version of 2.0.0, issued yesterday 2010.06.07.
See http://hsqldb.org/

Thanks. Yes that is what GA means. ;-) I missed this completely. Sorry.
I'll integrate the newest version in hsqdb19. But that would need some 
time. The cws based on a really old one m67.


Best regards,

Ocke

Zoltan

2010.06.08. 7:28 keltezéssel, Ocke Janssen írta:

Hi Zoltán,

Reizinger Zoltán wrote:

Hi,
The GA version of HSQLDB 2.0.0 is out now.
Can be downloaded from: http://sourceforge.net/projects/hsqldb/files/

It is a time to use this in cws hsqldb19.

Any plan for new cws version of DEV300?
Not in the moment. I would like to wait for the final version. The 
work to put into the build also takes some time. I'll see what I can 
do :-)


Best regards,

Ocke

Thanks,
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




--
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB 2.0.0

[Ocke Janssen]

Hi Zoltán,

Reizinger Zoltán wrote:

Hi,
The GA version of HSQLDB 2.0.0 is out now.
Can be downloaded from: http://sourceforge.net/projects/hsqldb/files/

It is a time to use this in cws hsqldb19.

Any plan for new cws version of DEV300?
Not in the moment. I would like to wait for the final version. The work 
to put into the build also takes some time. I'll see what I can do :-)


Best regards,

Ocke

Thanks,
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] issue 94543, some progress and request for help

[Ocke Janssen]

Moin Terrence,

Terrence Enger wrote:

On Fri, 2010-04-09 at 16:37 -0400, Terrence Enger wrote:
  

Digging around on the web, I found "Technical Standard, Data
Management: SQL Call Level Interafce (CLI)"
<http://www.opengroup.org/pubs/catalog/c451.htm>.



Greetings,

I have pressed on with the notion of retrieving the character
representation of timestamps, and have some results good enough to
keep me interested: a timestamp retrieved via odbc from an AS/400 is
accurate to the centisecond (although the only way I know to see the
result in this precision is to format the result as a floating point
number).

The interesting part of the code, within
connectivity::odbc::OResultSet::getTimestamp
(connectivity/source/drivers/odbcbase/OResultSet.cxx), is

m_bFetchData= false;
::rtl::OUString aString = getString();

This suggests lots of questions.

(*) connectivity::toDateTimeString
(connectivity/source/commontools/CommonTools.cxx) omits the
centiseconds from a DateTime.  I presume that this behaviour must
be maintained, right?
  
To be deleted would be better and to use the version from 
DBTypeConversion :-)

Could you please submit an issue for this. Thanks.

(*) m_bFetchData is defined in
connectivity/source/inc/odbc/OResultSet.cxx with the comment "true
when SQLGetData can be called in any order or when fetching data
for m_aRow".  If I understand what gdb shows me, with the new
assignment to m_bFetchData, the first recursion level of
connectivity::odbc::OResultSet::getTimestamp eventually calls
SQLGetData instead of connectivity::toDateTimeString.  This leaves
me uncomfortable with the assignment to m_bFetchData.
  
No. Do you see the not before it? :-) It is true when it can not be 
called in any order.

(a) Assigning m_bFetchData = false seems to contradict both the
first alternative given in the comment and the meaning of the
variable name itself.  Under what conditions would it be wrong
to call SQLGetData?  Does OO sometimes bind a result column
to a variable, and does this then prevent SQLGetData?  I can
research this one myself, but maybe someone here just knows.

(b) In ann earlier hack of mine, which delivered the same results,
the the first recursion level of
connectivitiy::odbc::OResultSet::getTimestamp deferenced
m_aRow[columnIndex] to get the DateTime built by the second
recursion level.  So the assignment to m_bFetchData is in the
ballpark of the second alternative in the comment.

Anyway, at the end of
connectivity::odbc::OResultSet::getTimestamp, state differs from
the state as left by the almost-original code in that (at least)
  - m_bFetchData is false instead of true.
  - retVal.HundredthSeconds is right instead of a pseudo-random
number.
  - m_bNull is true instead of false.
  - m_aValue is NULL instead of a pionter to a DateTime.
I have not happened to notice bad results, but that is worth
little.

All this leaves me feeling a need for correction or reassurance,
as the case may be.

(*) Speaking of recursion ... The assignment to m_bFetchData avoids
the recursive call to connectivity::odbc:OResultSet::getTimestamp
(and thence to other routines).  I would guess that this is good,
except that it seems too easy.
  

:-)


Possible next steps include the following.  I welcome your guidance.

(*) To look for a situation which will expose a fault in
similar-looking code in ODatabaseMetaDataResultSet::getTimestamp.

(*) To try the same test cases against other databases that I can get
my hands on.  MySql and Postgresql come to mind.  danros66 already
reported that DB2/UDB works like DB2/400.

(*) Search for a condition to expose bad results from similar-looking
code in ODatabaseMetaDataResultSet::getTimestamp.


Thank you all for your patience with a newbie.
  
We still have a problem with the com:.sun;:star::util::DateTime which 
lacks of the capability to hold more than just HundredthSeconds. So 
times less than that can not be queried or updated today.



Best regards,

Ocke


Cheers,
Terry.



-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For a

Re: [dba-dev] SRB missing text FUNTIONS

[Ocke Janssen]

Fernand Vanrie wrote:

Ocke ,

Sorry but I tried this all before and again =-) : also & is not working:

Windows - SRB 1.2 -OO 3.2.0

Sould i fill a issue ?

Yes, please. :-)

- oj



Fernand


Hi Fernand,

Fernand Vanrie wrote:

Ocke Janssen wrote:

Jocke,

Thanks for the Reply, but no i Tried al this stuff before

LEFT([textfieldname] ; 3 ) is working and returns the first 3 
chararters of the field


text must been included in double quotes "text" > works

fields must been include in scuare brackets [Textfiledname]

[Textfieldname] + " "+ [Textfiledname]  not working  results in a 
empty field..
I just had a look at the source code and you are right. The code must 
be with ampersand &


[Textfieldname] & " "& [Textfieldname]


Best regards,

Ocke


Fernand


Fernand Vanrie wrote:

Maybe a stupid  question or  i looked just over it

: but why is a very usefull text Function  as CONCAT or 
CONCATENATE not available in the Sun Report Builder ?

I don't remember exactly but shouldn't it be possible to just write
'column1' + ' '  + 'column2'

- oj


I know, there are Queries to do things like that (supposes we 
build for every Report a new Query...), but Concatenate a part of  
field with some 'text' or other parts  is more handy than some 
other available text Functions.as URLENCODE etc...


Joining  the field parts  as separate  controls  is al so a work 
around  but  by making  URL's  for   pictures  we need to do 
something like


concat('///myserver/mydirectory ; LEFT(TEXT[urlFIELD]);10); 'etc...')

Hope it helps to improve SRB and thanks for all the exellent work 
done to make this tool available!


Fernand




-
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




--
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] SRB missing text FUNTIONS

[Ocke Janssen]

Hi Fernand,

Fernand Vanrie wrote:

Ocke Janssen wrote:

Jocke,

Thanks for the Reply, but no i Tried al this stuff before

LEFT([textfieldname] ; 3 ) is working and returns the first 3 
chararters of the field


text must been included in double quotes "text" > works

fields must been include in scuare brackets [Textfiledname]

[Textfieldname] + " "+ [Textfiledname]  not working  results in a 
empty field..
I just had a look at the source code and you are right. The code must be 
with ampersand &


[Textfieldname] & " "& [Textfieldname]


Best regards,

Ocke


Fernand


Fernand Vanrie wrote:

Maybe a stupid  question or  i looked just over it

: but why is a very usefull text Function  as CONCAT or CONCATENATE 
not available in the Sun Report Builder ?

I don't remember exactly but shouldn't it be possible to just write
'column1' + ' '  + 'column2'

- oj


I know, there are Queries to do things like that (supposes we build 
for every Report a new Query...), but Concatenate a part of  field 
with some 'text' or other parts  is more handy than some other 
available text Functions.as URLENCODE etc...


Joining  the field parts  as separate  controls  is al so a work 
around  but  by making  URL's  for   pictures  we need to do 
something like


concat('///myserver/mydirectory ; LEFT(TEXT[urlFIELD]);10); 'etc...')

Hope it helps to improve SRB and thanks for all the exellent work 
done to make this tool available!


Fernand




-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] SRB missing text FUNTIONS

[Ocke Janssen]

Hi Fernand,

Fernand Vanrie wrote:

Maybe a stupid  question or  i looked just over it

: but why is a very usefull text Function  as CONCAT or CONCATENATE 
not available in the Sun Report Builder ?

I don't remember exactly but shouldn't it be possible to just write
'column1' + ' '  + 'column2'

- oj


I know, there are Queries to do things like that (supposes we build 
for every Report a new Query...), but Concatenate a part of  field 
with some 'text' or other parts  is more handy than some other 
available text Functions.as URLENCODE etc...


Joining  the field parts  as separate  controls  is al so a work 
around  but  by making  URL's  for   pictures  we need to do something 
like


concat('///myserver/mydirectory ; LEFT(TEXT[urlFIELD]);10); 'etc...')

Hope it helps to improve SRB and thanks for all the exellent work done 
to make this tool available!


Fernand




-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] HSQLDB: single-file backend

[Ocke Janssen]

Hi Hendrik Roos,

Hendrik Roos wrote:

Hallo Open Office org development

Currently I have time and I am interested in participating by doing 
the development work on HSQLDB: single-file backend.


My experience: Owner/developer of i01, a Java Memory Optimised ACID 
compliant DB Engine that is cloud expandable.  i01 is also a high 
performance solution.


With experience gained with HSQLDB development I would later (after 
development completion) propose the potential to integrate i01 DB 
Engine into HSQLDB.  Motivations for this: higher performance and ACID 
compliant cloud framework.


Please inform me on how to apply to do the development work on HSQLDB: 
single-file backend.
The best way is to go to the hsqldb project itself. I already get in 
contact with the main developer there and he is awaiting you ;-)


Best regards,

Ocke


Regards
Hendrik Roos, i01 Lab
Bern Switzerland
078 695 89 82








--
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] SRB for DEV300m 76

[Ocke Janssen]

Hi Zoltán,

Reizinger Zoltán wrote:

Hi Ocke,
The DEV300m76 will be out in near future, it consist some bugfix for SRB.
When will be new alpha SRB available, on qa-upload server?

Thanks for the reminder. File uploaded. Now it is named oracle-*

- oj

Thanks,
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Considering the Filter Dialog Project

[Ocke Janssen]

Hi Christopher,

First of all a warm welcome. Developers are rarely spread these days :-)

Christopher C. Mills wrote:

Hi,

I wanted to inquire about the possibility of taking on the filter 
dialog project. I am going to have to think about the level of 
commitment I can contribute. I certainly won't be able to give a month 
block of dedicated time, although I don't suspect you expect this. To 
be honest, I am not even sure I will have the time, but I thought I 
would start a conversation anyway, as I would like to contribute to 
OOo in a meaningful way as a developer, and this particular project is 
near and dear to my heart. I have some clear ideas about this, and 
think I would deliver a rock solid solution that was well structured, 
and poised for future extensions.


What is the process if I were to consider committing to this?
I would first start with some text describing what you want to develop 
and may be you could add some mock-ups to the text. The text could also 
be seen as a pre specification. After that you should send the text to 
this list that all have the opportunity  to add their 2 cents. ;-)
The next step then would be to be able to build OOo. The current dialog 
location is in the module dbaccess in the folder source/ui/dlg

And if you need any assistance feel free to ask, as always.

Best regards,

Ocke

PS: The normal process is to
- define a specification
- ask  User Experience for input
- develop the code
- ask QA to check
- done

But this is the prefect world and as everybody knows a specification may 
change over time ;-)


-
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: Juergen Kunz


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] operator delete mismatch in ODatabaseMetaDataResultSet

[Ocke Janssen]

Hi Terrence,

Great, so you would become a OOo Base developer :-)

I applied your patch in the cws dba33f. Could please add the patch 
directly to the issue and marked as a patch, next time. That would make 
things more easier for me to find the issues. I'm always interested in 
applying patches fast in the source cde.


Best regards,

Ocke

Terrence Enger wrote:

Greetings,

And here is another one, the same except that the source file is
connectivity/source/drivers/odbcbase/OResultSet.cxx, the line number
of new[] is 119, and the line number of scalar delete is 165.

So, how many issues should there be for "operator delete mismatch"?
An awful lot of these come up in my (non-production) build when I work
in Base; I just dug into this one for a change while I wait for advice
on issue 94543.  I have already opened issue 110236
<http://www.openoffice.org/issues/show_bug.cgi?id=110236> for the same
assertion arising from a different place.

I invite your guidance.

Cheers,
Terry.


On Mon, 2010-03-22 at 08:28 -0400, Terrence Enger wrote:

  

summary : operator delete mismatch in ODatabaseMetaDataResultSet



  

And then the patch ...

--- ODatabaseMetaDataResultSet.cxx_m752010-03-21 23:37:01.0 
-0400
+++ ODatabaseMetaDataResultSet.cxx_tje2010-03-21 23:38:03.0 
-0400
@@ -97,7 +97,7 @@
  osl_incrementInterlockedCount( &m_refCount );
  dispose();
  }
- delete m_pRowStatusArray;
+ delete [] m_pRowStatusArray;
 }
 // 
-
 void ODatabaseMetaDataResultSet::disposing(void)






-
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 Schroeder


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] Chart in groups footer of SRB

[Ocke Janssen]

Moin Zoltan,

Reizinger Zoltán wrote:

Hi Ocke,
In OOo Hu forum I met one issue, which I can solve, but may be an 
enhancement for SRB.


The report developer get the task count copies printed out in each 
printer (BW/color) and by persons.


He want to use charts in Grouping footers to show result day by day 
basis, now with SRB we can set chart source separately from whole 
report source, but that is not good for this purpose.
I don't know the report but it isn't it possible to use the same source 
for the chart as used by the report itself extended by the group filters 
as parameter filled by the report?


Greetings,

Ocke


I think this is not solvable now, needs an enhancement.

Thanks,
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 Schroeder


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

[dba-dev] Re: [dba-users] resigning as Base project lead (and as Base team member)

[Ocke Janssen]

THANK YOU

for the great work you've done.

Do I have have anymore to say? No.

- oj

Frank Schoenheit, Sun Microsystems Germany wrote:

Hello fellow Base users and developers,

of the ~2000 mails I sent to d...@dba and us...@dba (wow! 20% of the
mails were from me? My mail client must be lying to me ...), this is one
of the more difficult ones.

Effective immediately, I'll be resigning from the position of Base's
project lead. Along with that, I will probably significantly reduce my
contribution to those lists, and definitely to overall Base.


Background:

Some time ago, I've been asked whether I could imagine working, on a
per-project basis, in another part of Sun's [1] OpenOffice.org team. To
be precise, the talk was about Impress. Well, after some consideration,
I said I could. But - I don't like the idea of doing things only half.
If I were to go to the Impress team, I would want to be an Impress
developer, not half an Impress and half a Base developer.

Consequently, I decided to accept this offering, but only as "full-time
assignment". Hey, this was *the* chance to get rid of the responsibility
for all the crimes I committed in Base! :)


So, here I am: still with Sun/Oracle, still with OpenOffice.org, but not
with Base anymore. Well, of course I'll continue to be available for
consultation (though my bad memory is proverbial, at least for my wife,
I'll probably remember a few things I did to the code). And the next
show stopper fix in some code area of mine will probably also be done by
/me. But I'll stop contributing significant changes to Base.


I certainly see this change with mixed feelings.

I started in the Base team more than 10 years ago, in my first job ever,
immediately after university, still some time before StarDivision was
bought by Sun, and StarOffice was open sourced as OpenOffice.org. Times
were interesting and challenging, we did some things pretty well, and
some things went ... not as good as I would have hoped. Still, Base is
an important part of my (professional, at least) life.

On the other hand, other challenges lie ahead. Impress is pretty new to
me, there'll be a lot to learn.

And who knows - perhaps I'll return to Base when the Impress team
recognizes my inherent inability to understand the basics of their work
- YMCA color models, or however those are called, and such ...


I'm going to send another mail regarding my suggestion for a project
lead successor (it won't surprise you too much).

Also, I still owe some of you an Apfelstrudel - I hope we can still do
that at some point in time :)

See you around, the OpenOffice.org community isn't *that* big that I'll
be completely out of your way ...

Ciao
Frank

[1] I am probably obliged to tell that Sun Microsystems by now is a
wholly owned subsidiary of Oracle Corporation

  



--
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 Schroeder, Wolfgang Engels
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] Please welcome the newest member of the Base QA Team - Zoltan Reizinger

[Ocke Janssen]

Moin Zoltan,

Welcome in the QA team. No more to say, everybody know you already ;-)

Best regards,

Ocke

Drew Jensen wrote:

Good Day all,

First I would thank everyone for their kind remarks to Christoph's 
email regarding the newly minted co-lead position for the Base QA team.


Thanks very much!

It is my pleasure to have as my first opportunity in this capacity the 
chance to announce the teams newest member, Zoltan Reizinger.


Zoltan I doubt needs any more introduction on this list that that.

He has been most active in the mailing lists, the user forums and the 
issue tracking system for a goodly time now and most helpful in each.


Some may not know that Zoltan is also the administrator for the 
Hungarian language forum at user.services and has been since it's 
inception.


Zoltan, let me be the first to say welcome to the team.

It has been my pleasure to work with you on the forums and in all our 
exchanges.


I am looking forward to continuing our joint endeavors.

Thanks

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 Schroeder, Wolfgang Engels
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] new co-lead of OOo database QA team: andrew jensen

[Ocke Janssen]

Moin,

Christoph Lukasiak wrote:
i am proud to introduce andrew jensen (aka drew) as my executing 
co-lead of the OOo database QA team


Congratulations Drew! Goods news for OOo Base, bad news for the issues 
;-) Great to have you on board.


Best regards,

Ocke


--
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 Schroeder, Wolfgang Engels
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] Question 1: Finding the actual column name for an aliased field?

[Ocke Janssen]

Hi Drew,

Drew Jensen wrote:

On 2/9/2010 5:03 PM, Frank Schoenheit, Sun Microsystems Germany wrote:

Hi Drew,


I have a query:

SELECT "COL1" AS "ALIAS" FROM "TABLE"

Now I am handed a dataform in a routine and I need to find the column
names in the table, not the alias.


depending on which column object you have ... there might be a property
RealName, though I do not know, out of my head, at which col objects it
is available. So, try ControlModel.BoundField.RealName.




Nope - realname doesn't show up as a property for anything I can find.

That includes the query composer.

I thought there was a way to get this and realname sounds like it, but 
its gone as far as I can see.
When you use the SingleSelectQueryCompser and ask for the SelectColumns 
each column in that collection has a property RealName as well as a 
TableName property.


- oj


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 Schroeder, Wolfgang Engels
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] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)

[Ocke Janssen]

Hi all,

Reizinger Zoltán wrote:

Hi all,

Ezzel a dátummal: Tuesday 09 February 2010 19.00.32 Drew Jensen ezt írta:
  

On 2/9/2010 11:53 AM, Frank Schoenheit, Sun Microsystems Germany wrote:


Hi Ocke,

  

I thought that I fixed that one in a DEV320 but that doesn't seem to be.
So please submit an issue for it. Thanks.


Wasn't that in one of the dba33? CWS', i.e. for 3.3 only?
  

If so it hasn't integrated yet - tried with dev300_m70 same error.


I think the issue according to issue tracker and eis  is fixed in cws dba33b 
and integrated into m70:
 http://qa.openoffice.org/issues/show_bug.cgi?id=105086 

Then it is a not fully solved issue.  
  
That's the part which I don't understand. I have to check the history of 
some files later on. Hopefully I simply forget it and it isn't no merge 
problem.


- oj

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 Schroeder, Wolfgang Engels
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] Problem: OpenOffice Base and PostgreSQL stored procedures

[Ocke Janssen]

Hello Marc Balmer,

It would be great if you could submit an issue and perhaps could add a 
sample db dump (only with dummy data and one sample procedure) for a 
test case. And assign it to me o...@openoffice.org.


Best regards,

Ocke

Marc Balmer wrote:

Good day

We develop point of sales (POS) applications using PostgreSQL as the
database backend.  We thought it could be interesting for our customers
to access the database directly from OpenOffice Base to create their own
reports etc.  But it turns out that OpenOffice Base and PostgreSQL are
not playing together nicely:

Our database consists of tables (of course..), views, and a substantial
number of stored procedures, especially for the more complex reports and
such.

E.g, to get the balance of all accounts, you would send the following
SQL code to the database:

SELECT * FROM acf_balance_all()

To get the balance from only on account, you would use

SELECT * FROM acf_balance('1000')

('1000' is the account number).

When I enter the SQL code in the query editor in non-native SQL mode, it
outputs a syntax error, i.e. it seems to be unable to handle the
PostgreSQL stored procedure calls.  I can, however, set the query editor
to native SQL mode, then the SQL code is passed as is to the database
backend and no error is output.  But with native SQL mode, I loose the
possibility to have OpenOffice ask the user for parameters.  I can only
use calls without parameters.  But most stored procedurs actually
require paramates.

There is a second (and maybe unrelated) problem:  OpenOffice Base seems
for each query to send a generated query to the database server to check
if that table in the query exists.  It does something like

SELECT COUNT(*) FROM  WHERE 0 = 1

This will of course never return any data, but it will raise an error if
 does not exist, so I assume this is done to check for the
presence of a table.  But again, this does not work when a query instead
of table specifies a stored procedure in a SELECT.

I am using OpenOffice Base on Mac OS X Snow Leopard using the
jdbc.postgresql JDBC driver and PostgreSQL 8.4.2 as the database
backend.  I did not try any native client, since this is a bug that I
want to report (and, if possible, see fixed) regardless if a native
driver would work.

If there are any details I can further provide, or any test I can run,
please me know.



-
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 Schroeder, Wolfgang Engels
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] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)

[Ocke Janssen]

Hi Drew,

I thought that I fixed that one in a DEV320 but that doesn't seem to be. 
So please submit an issue for it. Thanks.


Best regards,

Ocke

Drew Jensen wrote:

and as a BTW

 if CurrentControl.ServiceName = 
"stardiv.one.form.component.ImageControl" then

 dim oStream as object
oStream = CurrentControl.BoundField.getBinaryStream
prepStatement.setBinaryStream( fldcnt, oStream, oStream.Length )
else
 prepStatement.setString( fldcnt, 
CurrentControl.BoundField.getString )

end if

Does work, quite well.

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 Schroeder, Wolfgang Engels
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 2.0 error code translations

[Ocke Janssen]

Hi Zoltán,

First of all a "Happy New Year". :-)

Reizinger Zoltán wrote:

Hi Frank/Ocke,

HSQLDB 2.0 will be integrated into OOo 3.3, and the error messages needs to be 
translated into national languages, for time when OOo 3.3.0 issued.


The HSQLDB 1.8 error messages was translated inside the OOo project.

I found that HSQLDB now plan store translations (and documentation) in their 
own SVN, and spanish translation is in there.


HSQLDB mailing list message:
http://sourceforge.net/mailarchive/forum.php?thread_name=1261680116.28928.1351645883%40webmail.messagingengine.com&forum_name=hsqldb-user

I think it is a time for tstart hinking about this.
What will the dba project do?
  
The best way would be that the localization process will be moved to 
hsqldb. I don't know how the current ones fits to the new error 
messages. I'll point Fred from hsqldb to the sources may be we could 
merge them.

Warn NL teams, through new issue?
  
Yes, that would be the best way I guess. Are you volunteering to write 
them ;-)


- oj
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] hsqldb19 time functions.

[Ocke Janssen]

Hi Zoltán,

Reizinger Zoltán wrote:

Moin oj,

The issue http://qa.openoffice.org/issues/show_bug.cgi?id=106234 
marked as duplicate of 
http://qa.openoffice.org/issues/show_bug.cgi?id=106191, and the second 
status is fixed.
In the main time, if I use CALL CURRENT_TIME and CALL 
CURRENT_TIMESTAMP, in query SQL view, (which works is 1.8)

I get assertions, unsupported type:
---
Debug Output
---
Error: ORowSetValue::fill: unsupported type!
From File 
d:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at 
Line 1960

Abort ? (Yes=abort / No=ignore / Cancel=core dump)
---
Igen   Nem   Mégse  ---
It seems to me the bug not solved, what issue needs to be reopened?
I can not test some new time features in 1.9.
Yes, youŕe right it isnt fixed anymore. Somehow the flag is wrong which 
told the driver to handle interval types differently. Iĺl fix that asap.


Best regards,

Ocke

Thanks,
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

[Ocke Janssen]

Hi Zoltán,

On 03.12.09 10:12, Reizinger Zoltán wrote:

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

Fixed :-) You'll find a new version on qa-upload hsqldb19/hsqldb.jar

- oj

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




--
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

[Ocke Janssen]

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] dba33b

[Ocke Janssen]

Hi Peter,

On 25.11.09 14:18, Peter Eberlein wrote:

Am 25.11.2009 10:45, schrieb Peter Eberlein:

Moin Ocke,
Ocke Janssen schrieb:

Moin Peter,


The windows build is now available too. Sorry for the delay, sometimes
it doesn't work as designed :-)


you are right ;)
Opening an old base doc (vers. 2.2): the macro migration fails [1]
Opening a form (created with 2.2) crash [2]
Creating a new base doc oracle jdbc crash at testConnection[3]

No problems with 320m4 on this computer.
I will try on another computer as admin.


Did it, same result as above.
Do have a bug doc where I can have a look at? I only tested an existing 
odb file but I'll test a new one asap. When the crash appears do you 
sent the crash report and did you get an answer where the crash report 
number is noted? And the last thing is that the build could be damaged, 
may be? I wait for the cws dba33a to be integrated to update dba33b and 
then I'll rebuild it to get the newest and up to date version.


- oj


Peter

-
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] method setBinaryStream not working with Oracle BLOB using jdbc

[Ocke Janssen]

Moin Peter,


The windows build is now available too. Sorry for the delay, sometimes 
it doesn't work as designed :-)


- oj

On 19.11.09 08:22, Ocke Janssen wrote:

Moin Peter,

On 19.11.09 08:11, Peter Eberlein wrote:

Moin Ocke,
Am 13.11.2009 15:02, schrieb Ocke Janssen:


Yes, I'm interested in testing a snapshot, please drop me a mail, when
it's available at qa-upload.

The Linux build is already uploaded. Windows will properly finished on
Monday.


still missing it,

Yes, I know. I'm working on it.

- oj


Regards

Peter

-
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] method setBinaryStream not working with Oracle BLOB using jdbc

[Ocke Janssen]

Moin Peter,

On 19.11.09 08:11, Peter Eberlein wrote:

Moin Ocke,
Am 13.11.2009 15:02, schrieb Ocke Janssen:


Yes, I'm interested in testing a snapshot, please drop me a mail, when
it's available at qa-upload.

The Linux build is already uploaded. Windows will properly finished on
Monday.


still missing it,

Yes, I know. I'm working on it.

- oj


Regards

Peter

-
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] method setBinaryStream not working with Oracle BLOB using jdbc

[Ocke Janssen]

On 16.11.09 09:36, Peter Eberlein wrote:

Moin Ocke,
Am 13.11.2009 15:02, schrieb Ocke Janssen:

Moin Peter,

On 11/13/09 12:55, Peter Eberlein wrote:

Hi Frank,

Am 13.11.2009 11:20, schrieb Frank Schoenheit, Sun Microsystems 
Germany:

Hi Peter,


fine, so I consider this a bug in OpenOffice.


Quite reasonable. Ocke just reworks the [B|C]LOB handling, it seems 
this

code was never confronted with reality before.


How to workaround?


Sorry, don't have to offer anything here. BLOB is highly ...
under-implemented currently :-\

If you're interested in, we could upload a CWS snapshot when Ocke
finished his fixes, so you can test them in your real life 
scenario, and

give us early feedback.


Yes, I'm interested in testing a snapshot, please drop me a mail, when
it's available at qa-upload.

The Linux build is already uploaded. Windows will properly finished on
Monday.

Regarding the subject I have to stand corrected; after updating to a 
newer oracle driver the setBinaryStream method works as expected. 
Sorry for the noise.

Doesn't matter.
Nevertheless I will test the new build, because there are some other 
issues too (graphics in forms e.g.).

That is what I fixed in the uploaded build. :-)

- oj


Regards

Peter

-
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] method setBinaryStream not working with Oracle BLOB using jdbc

[Ocke Janssen]

Moin Peter,

On 11/13/09 12:55, Peter Eberlein wrote:

Hi Frank,

Am 13.11.2009 11:20, schrieb Frank Schoenheit, Sun Microsystems Germany:

Hi Peter,


fine, so I consider this a bug in OpenOffice.


Quite reasonable. Ocke just reworks the [B|C]LOB handling, it seems this
code was never confronted with reality before.


How to workaround?


Sorry, don't have to offer anything here. BLOB is highly ...
under-implemented currently :-\

If you're interested in, we could upload a CWS snapshot when Ocke
finished his fixes, so you can test them in your real life scenario, and
give us early feedback.

Yes, I'm interested in testing a snapshot, please drop me a mail, when 
it's available at qa-upload.
The Linux build is already uploaded. Windows will properly finished on 
Monday.


- oj


Regards

Peter

-
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] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

Hi Zoltan,

On 11/11/09 11:03, Reizinger Zoltán wrote:

Ocke Janssen írta:

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical 
releases from Pentaho. It would be great if you could test this new 
version. Hopefully it should as good/worse as the beta version you'll 
find at the same place.

If I understand well, it needs to test with OOO320_m4, now?

m4 should work. This new SRB is targeted for OOo 3.3 release.

- oj

Zoltan


- 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

[dba-dev] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)

[Ocke Janssen]

Moin,

on qu-upload.services.openoffice.org/SRB you'll find a 
sun-report-builder-cws-srb1.oxt. It contains the newest offical releases 
from Pentaho. It would be great if you could test this new version. 
Hopefully it should as good/worse as the beta version you'll find at the 
same place.


- oj

--
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

[Ocke Janssen]

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

On 10/28/09 07:53, Ocke Janssen 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=8774&logon=true&OpenOnly=false&Section=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

[Ocke Janssen]

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  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 > 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=8774&logon=true&OpenOnly=false&Section=Tasks
   <
http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774&logon=true&OpenOnly=false&Section=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, W

Re: [dba-dev] HSQLDB 1.9 Testing needed

[Ocke Janssen]

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 <mailto: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=8774&logon=true&OpenOnly=false&Section=Tasks

<http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774&logon=true&OpenOnly=false&Section=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
Vorsitzender des Aufsichtsrates: Martin Haering

Re: [dba-dev] HSQLDB 1.9 Testing needed

[Ocke Janssen]

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=8774&logon=true&OpenOnly=false&Section=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

[Ocke Janssen]

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=8774&logon=true&OpenOnly=false&Section=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] triggers

[Ocke Janssen]

On 10/19/09 20:30, Andrew Jensen wrote:

Hi Ocke,

What you think I actually read that SQL statement before executing
itcome on it was late. Yes, the tigger in the sample does work
correctly. Great 2 tick marks..
  

;-)

Ok - the bad trigger.

First - my statement is wrong...but here it is.

Create a new base file.
Open the SQL window
Apply these two statements - separately and without closing the SQL
window in between:

CREATE TABLE category (
  category_id IDENTITY PRIMARY KEY,
  name VARCHAR(25) NOT NULL,
  last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
)

*execute succeeds*

CREATE TRIGGER category_last_upate
BEFORE UPDATE ON category
REFERENCING NEW ROW AS newrow OLD ROW AS oldrow
FOR EACH ROW SET newrow.last_update = CURRENT_TIMESTAMP

*execute succeeds*

Ok now you can close the SQL window, add data to the table, etc. The
trigger doesn't work, but doesn't complain either.

Close the file.

Try to reopen - error in the Create trigger statement - my guess is
because I declared an OLDROW variable and never used it.
  

I fixed the problem and send a patch to hsqldb.
The problem is in the script file. Hsqldb writes a comma between old row 
and new row which is wrong.


A new upload of hsqldb.jar can be found on qa-upload.

-oj

-or-
maybe it is the use of the set keyword..but, if I use this (also
wrong) trigger statement

CREATE TRIGGER category_last_upate
BEFORE UPDATE ON category
REFERENCING NEW ROW AS newrow
FOR EACH ROW SET newrow.last_update = CURRENT_TIMESTAMP

It is accepted, doesn't work, but doesn't stop the HSQLdb engine from
restarting next time it's opened.

Attaching a file created under Win 7, just now with the above steps.

Drew,

ps  Ctrl-C instead of screen shots...lol...like I said it was late..

  



-
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

[Ocke Janssen]

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] triggers

[Ocke Janssen]

Hi Drew,

On 10/18/09 08:40, Drew Jensen wrote:

Drew Jensen wrote:


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).



Ok - so it is my trigger statement.

Tried the supplied trigger definition in the hsql testrun file, it 
works just fine under Base.


[Almost - ]

I added a PK to the test table so that the table can be edited in a 
dataview.
The first 2 times a record is added to the TEST the trigger fails to 
fire.
*note*..for me, if I insert data via the SQL window only the first 
insert fails...LOL..I love software.
It's strange that it works for the first time when inserting it by SQL. 
That the 2 first inserts doesn't trigger inserts into LOG is correct.
When you have a look at the table in script you'll see that the 
increment starts at zero and the trigger is called when id > 1. So id=0 
and id=1 doesn't call the trigger.


then l - there is a problem when I can run a statement, Base says it 
runs successfully and then creates an unusable script file.
Could you send me the sql statement to reproduce it. All I could finger 
out so far is that when the database is read-only it has a problem with 
the trigger statement. I'll notify the developer of hsqldb.


- oj


*smile*...if nothing else an issue BTKATC...

Anyway I'm attaching the Base file with the AFTER INSERT trigger on 
the TEST table, after insert a copy is placed in the log table...least 
that is the idea.


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] memory vs cached tables was( HSQLDB 1.9 Testing needed )

[Ocke Janssen]

On 10/19/09 08:59, Ocke Janssen wrote:


On 10/17/09 23:30, Drew Jensen wrote:
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 
fileI'll let you know on that.

Indeed the CACHED type is missing. I'll have a look at it.
I fixed it in a newer version of the hsqldb.dll. As work around you may 
execute

SET DATABASE DEFAULT TABLE TYPE CACHED

as the first statement when creating a new db or convert an old one.

- oj

PS: I'll upload a new version when more issues are fixed.


- oj


Thanks

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


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Re: [dba-dev] memory vs cached tables was( HSQLDB 1.9 Testing needed )

[Ocke Janssen]

On 10/17/09 23:30, Drew Jensen wrote:
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 
fileI'll let you know on that.

Indeed the CACHED type is missing. I'll have a look at it.

- oj


Thanks

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


-
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

[Ocke Janssen]

Hi Drew,

On 10/17/09 22:34, Drew Jensen wrote:
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?
First of all nobody could hinder you to submit issues. ;-) 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. 2nd in my personal opinion I 
like perfect worlds and I'm developing with the debug build and 
assertions could point to an error which have to be fixed or they have 
to be removed. So it's your choice what to do, I would prefer issues to 
get rid of the nasty assertions. The worst thing what could happen that 
it is a duplicate one. by the way when the assertion pops up you can 
copy the text which CTRL+C :-)


Best regards,

Ocke



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


-
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

[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-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

[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-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

[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-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

[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-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

[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-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

[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-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

[dba-dev] HSQLDB 1.9 Testing needed

[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: +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.8.1 and 1.9

[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-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] SRB for m52 will be uploaded to qa-uploaded?

[Ocke Janssen]

Upload done ;-) Enjoy it.

- oj

On 07/14/09 11:28, Reizinger Zoltán wrote:

Hi all,
Lot of dba cws integrated into m52, some of them touch SRB.
On qa-upload server I can find alpha SRB for m49 version.
SRB for m52 will be uploaded to qa-upload?
I wan to check issues.

Thanks,
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: AW: [dba-dev] [dev-dba] database driver problem with the table creation wizard

[Ocke Janssen]

Hi Micha,

On 02.06.09 01:29, Michael Strobel wrote:

Hi Ocke,

finally I found the reason for the problem with the table wizard. Some 
properties of the ColumnDescriptor objects (IsRowVersion, Description, 
DefaultValue) needed to have value instead of being null. This caused a null 
pointer exception in a method of the wizard, which clones the ColumnDescriptor 
objects. I couldn´t figure out why the wizard does this, but I think it´s okay 
since it works fine with our new driver now and it always worked fine with the 
embeded hsqldb :-)
  

Great. Do you have a patch file that we could apply into our code? :-)

Something that still doesn´t work with our new driver is keeping default values 
and descriptions for columns over sessions. I thought that OOo base stores them 
in the odb file automatically, but looks like the driver needs to do that 
itself. Before I try to dig into the code of the other OOo base drivers to find 
a solution, I just wanted to ask if you know where I could look for a sample of 
that code or if some part OOo API provides the functions to write/read these 
properties in/from odb files ;-)
  

We have two default values
1. "DefaultValue" and
2. "ControlDefault"

The 2nd is stored inside the odb file db:default-value. The 1st is 
stored inside the database. The problem now was to get the default value 
from the database when moving to the insert row. This wasn't possible, 
here ControlDefault was invited. So when you use the table designer to 
create a table you always insert the ControlDefault. To change for 
example the wizard you have to set the DefaultValue at the column 
descriptor. The source code for the table designer can be found in 
dbaccess/source/ui/tabledesign


- oj

Best regards,
Micha

-Ursprüngliche Nachricht-
Von: Ocke Janssen [mailto:ocke.jans...@sun.com]
Gesendet: Do 28.05.2009 01:40
An: dev@dba.openoffice.org
Betreff: Re: [dba-dev] [dev-dba] database driver problem with the table 
creation wizard
 
Hi Mischa,


On 28.05.09 00:58, Michael Strobel wrote:
  

Hi @All,

I have done a complete rewrite of our Ingres driver with the OOo SDK and Java. 
It seems to work pretty well despite two issues. I found a workaround for the 
first issue, but I could not solve the second issue yet. It´s about creating 
tables using the table creation wizard. I will describe the issue below. Maybe 
someone here has an idea what´s causes the problem. It would also be useful to 
know where the sources of the table creation wizard can be found in the 
dbaccess module, as I was not able to figure out where they are. I can log the 
method calls of the driver to a file, so I got at least some information what´s 
going on under the hood of the driver.

When the first page of the wizard is opened a new TableDescriptor object is 
created. When the next button on the first page of the wizard is clicked for 
every column, that was selected beforehand, a ColumnDescriptor object is 
created and the second page of the wizard appears. The the properties of the 
ColumnDescriptor objects are set. For some reason I don´t know these 
ColumnDescriptor objects seem not to be used with the appendByDescriptor method 
of the table object later on, but new ColumnDescriptor object are created for 
this when the next button on the second page is clicked. These new 
ColumnDescriptor object also get their properties set, with exception of the 
Name property. This causes the wizard not to finish. If I do changes to the 
column names on the second page the Name property is set correctly and the 
wizard does finish fine. Another thing that´s strange is that the 
ColumnDescriptor objects created at first seem to get their Type property set 
wrong values. For example columns that should be char columns are set to 
varchar. I am not sure if this is important since I also don´t know what these 
ColumnDescriptor objects are actually used for and as said before the whole 
thing works if I just do some changes to the column names on the second page of 
the wizard.
  

First of all wow. Good tracing. :-) Looks like you found a bug may be 
you want to write an issue and send it to me and I'll take a look at it. 
And/or you have to take look at the wizard itself. It is located in the 
wizards module. When you are familiar with Java you should have no 
problem at  least may be a little bit with the code style. :-) I'm not 
that familiar with the code as well. By the way does this also happen 
with the embedded hsqldb? And which version of OOo do you use?


Best regards,

Ocke
  

Best regards,
Micha

  




  



-
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)   

Re: [dba-dev] [dev-dba] database driver problem with the table creation wizard

[Ocke Janssen]

Hi Mischa,

On 28.05.09 00:58, Michael Strobel wrote:

Hi @All,

I have done a complete rewrite of our Ingres driver with the OOo SDK and Java. 
It seems to work pretty well despite two issues. I found a workaround for the 
first issue, but I could not solve the second issue yet. It´s about creating 
tables using the table creation wizard. I will describe the issue below. Maybe 
someone here has an idea what´s causes the problem. It would also be useful to 
know where the sources of the table creation wizard can be found in the 
dbaccess module, as I was not able to figure out where they are. I can log the 
method calls of the driver to a file, so I got at least some information what´s 
going on under the hood of the driver.

When the first page of the wizard is opened a new TableDescriptor object is 
created. When the next button on the first page of the wizard is clicked for 
every column, that was selected beforehand, a ColumnDescriptor object is 
created and the second page of the wizard appears. The the properties of the 
ColumnDescriptor objects are set. For some reason I don´t know these 
ColumnDescriptor objects seem not to be used with the appendByDescriptor method 
of the table object later on, but new ColumnDescriptor object are created for 
this when the next button on the second page is clicked. These new 
ColumnDescriptor object also get their properties set, with exception of the 
Name property. This causes the wizard not to finish. If I do changes to the 
column names on the second page the Name property is set correctly and the 
wizard does finish fine. Another thing that´s strange is that the 
ColumnDescriptor objects created at first seem to get their Type property set 
wrong values. For example columns that should be char columns are set to 
varchar. I am not sure if this is important since I also don´t know what these 
ColumnDescriptor objects are actually used for and as said before the whole 
thing works if I just do some changes to the column names on the second page of 
the wizard.
  
First of all wow. Good tracing. :-) Looks like you found a bug may be 
you want to write an issue and send it to me and I'll take a look at it. 
And/or you have to take look at the wizard itself. It is located in the 
wizards module. When you are familiar with Java you should have no 
problem at  least may be a little bit with the code style. :-) I'm not 
that familiar with the code as well. By the way does this also happen 
with the embedded hsqldb? And which version of OOo do you use?


Best regards,

Ocke

Best regards,
Micha

  



--
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] SRB for DEV300 - OOo 3.2 versions

[Ocke Janssen]

Hi Zoltan,

On 05.05.09 13:22, Reizinger Zoltán wrote:

Hi Ocke,
Earlier problems seems to me, were caused by installation.
I reinstalled OOo m47 on winXP SP3 and added beta 4 SRB, created new 
file, and I can not create new report first, I closed this new file, 
opened old files with reports I can run them, after running first 
report, I can add new one, with wizard and in design mode. Opened 
earlier created new file, can create new reports, some miracle in my 
system.


On Linux opensuse 10.3 i586, no such problem with m47 version can 
create report and run them.


Find two separate issues:
1. in table wizard, the personal and bussiness categories content 
changed with each other,  you can find for example CD-Collection in 
bussiness category. (in both win/linux)
2. form wizard when you finished creation, with option work with the 
form, window closes and not opens back, and not saves into Form area - 
Form lost. (On linux version caused OOo crash) If you select edit 
mode, the form opens in edit mode and saves into Form area. (On 
linux/rpm version caused OOo crash)

Submit a bug, or it is on my computers only?
Do you guess what my answer looks like ;-) Yes, it works in my OOO310 
m47 build. Do you send the crash reports? May be we get a clue what's 
going on.


Best regards,

Ocke

Thanks,
Zoltan


Reizinger Zoltán írta:
I will try to reinstall OOo and remove all folders first, I 
unistalled m44 and installed m47 into the same directory, this method 
caused lot of trouble earlier, but not with OOo 3.1, and I thinked it 
is not necessary for this dev version.

Zoltan

I had a crash with extensions installation earlier this day:
The ID of the error report is rff8wvc.


Additional info:
I closed "Add field" window and I tried to close file the warning 
message   came up:  The connection to the database has been lost. Do 
you want to reconnect? If I answer yes , new Add field window came 
up, with every click an stays open, if I click 10 times 10 open "Add 
filed" window opens.

Ocke Janssen írta:
Do you have a sample database I could test? I tried the DEv300m47 
and the SRB from OOO310m11 and I could open  an existing and  create 
a new one.


- oj

On 05.05.09 10:32, Ocke Janssen wrote:

Hi Zoltan ,

On 05.05.09 10:12, Reizinger Zoltán wrote:

Hi,
I found OOo- dev m47 version on mirrors, I tried to install 1.1 
beta4 and pavel builds SRB, both installed but failed to open any 
earlier existing reports, and can not create new one.

What SRB will be good to 3.2 dev versions?
Earlier SRB beta worked with m44 version.

I'll investigate it. At the moment I have no idea why not.

- oj

Thanks,
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




--
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] SRB for DEV300 - OOo 3.2 versions

[Ocke Janssen]

Do you have a sample database I could test? I tried the DEv300m47 and 
the SRB from OOO310m11 and I could open  an existing and  create a new one.


- oj

On 05.05.09 10:32, Ocke Janssen wrote:

Hi Zoltan ,

On 05.05.09 10:12, Reizinger Zoltán wrote:

Hi,
I found OOo- dev m47 version on mirrors, I tried to install 1.1 beta4 
and pavel builds SRB, both installed but failed to open any earlier 
existing reports, and can not create new one.

What SRB will be good to 3.2 dev versions?
Earlier SRB beta worked with m44 version.

I'll investigate it. At the moment I have no idea why not.

- oj

Thanks,
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] SRB for DEV300 - OOo 3.2 versions

[Ocke Janssen]

Hi Zoltan ,

On 05.05.09 10:12, Reizinger Zoltán wrote:

Hi,
I found OOo- dev m47 version on mirrors, I tried to install 1.1 beta4 
and pavel builds SRB, both installed but failed to open any earlier 
existing reports, and can not create new one.

What SRB will be good to 3.2 dev versions?
Earlier SRB beta worked with m44 version.

I'll investigate it. At the moment I have no idea why not.

- oj

Thanks,
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

[dba-dev] Volunteer for wiki needed

[Ocke Janssen]

Moin,

The wiki for Java samples how to use databases need some help.

The netbeans project can be found here. I adjusted the code a little bit 
so that MySQL is used instead of the old AdabasD ;-) But may be someone 
already has some code to share which could be integrated (or linked to).

http://api.openoffice.org/source/browse/api/examples/java/netbeans/database/DevGuideDatabaseExamples/

The wiki page is http://wiki.services.openoffice.org/wiki/API/Samples/Java
One page I created so far is 
http://wiki.services.openoffice.org/wiki/API/Samples/Java/Database/TableStructure 
and 
http://wiki.services.openoffice.org/wiki/API/Samples/Java/Database/TableStructure(SDBCX)


Any help is welcome.

Best regards,

Ocke

--
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 Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering


-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org