[dba-dev] Re: Shared Library registration with regcomp
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 http://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 http://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
http://makefile.mk ?
Regards,
Rohit
2011/4/4 Frank Schönheit frank.schoenh...@oracle.com
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
http://unxlngi6.pro/lib
I suppose you mean connectivity/unxlngi6.pro/lib
http://unxlngi6.pro/lib here, i.e. the local
output tree of the connectivity module?
http://unxlngi6.pro/lib directory it fails giving
CannotRegisterImplementationException exception.
However during the build process this library is copied into
'solver//330/unxlngi6.pro http://unxlngi6.pro
http://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 http://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 lib_name 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 to
implement
[dba-dev] Re: Report builder for DEV300m105
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
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 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 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
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 ocke.jans...@oracle.com 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 ocke.jans...@oracle.com 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 Hamburg ORACLE Deutschland B.V. Co. KG Hauptverwaltung: Riesstr. 25, D-80992 München Registergericht: Amtsgericht München
[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP
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
[dba-dev] Re: Help Required In Writing a New SDBC Driver For LDAP
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
Re: [dba-dev] date axes for charts in report builder
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
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] CWS dba33m needs testing CAST() problem
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
Re: [dba-dev] CWS dba33m needs testing CAST() problem
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] Re: CAST() no longer working with OOO 330m16
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 Vanries...@pmgroup.be 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 Vanries...@pmgroup.be 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] Re: CAST() no longer working with OOO 330m16
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 Janssenocke.jans...@oracle.com 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
Hi Alex,
On 09.12.2010 10:35, Alex Thurgood wrote:
Hi Ocke,
- Ocke Janssenocke.jans...@oracle.com 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
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] CWS srb1 status
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] CWS srb1 status
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] MySQL native driver 1.0.1 for OOo 3.3
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] HSQLDB 2.0 integration
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?
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] Proposal for other TableFilter
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 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] postgres ODBC problem with view
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 * FROMtable 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] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)
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)
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] Tester needed: New SRB with vanilla sources available (new version 1.1.2 from Pentaho)
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)
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] HSQLDB 2.0.0
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] issue 94543, some progress and request for help
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 additional commands, e-mail: dev-h
Re: [dba-dev] SRB for DEV300m 76
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
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
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
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)
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] SetBlob.... ( was Re: setBlog not implemented for preparedStatement in HSQLdb SDBC driver)
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] Question 1: Finding the actual column name for an aliased field?
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] Problem: OpenOffice Base and PostgreSQL stored procedures
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 tablename WHERE 0 = 1
This will of course never return any data, but it will raise an error if
tablename 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)
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
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.comforum_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.
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
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
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
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
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
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)
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
Re: [dba-dev] HSQLDB 1.9 Testing needed
Hi, On 10/29/09 19:08, Andrew Jensen wrote: Data! Here is what I was thinking. Option 1 - Just push the data into the odb file(s) and be done with it. Pros - Doesn't get any easier then downloading one file. Cons - The download is big. Option 2 - refer users to the existing sakila data file at sourceforge and add a macro in the odb file that reads the file (which is a bunch of insert statements), perform any string replacements needed per line and execute each against the curent connection. The user would only need to download the Sakila data zip file, decompress it to their local drives and run the macro - One dialog to get the location of the file and that should be it. Pros - The odb files are nice and small Cons - Exrra download, Slow (then again that is a whole other question with the embedded files) Option 3 - ?? Anyhow - I was going to leave data for last, but perhaps it makes most sense to it next and then the views and such afterwards. Any thoughts - data next? I would choose option 2, that wouldn't need any legal work on our side ;-) And such a sql script importer could be a nice extension for OOo. - oj Drew On Thu, Oct 29, 2009 at 7:42 AM, Ocke Janssen ocke.jans...@sun.com wrote: Hi Drew, Thanks. Looks great. I just missing the data ;-) In my test I used also the sakila schema with data and I figured out that CLOBs are making trouble and the zip package (storing inside OOo) as well. When inserting a clob value where a trigger is waiting for data inserting like it is for the table film and film_text we have a dead lock. Fred from hsqldb already as a look at it. Off site: We need to support triggers at the UI ;-) - oj On 10/29/09 09:25, Drew Jensen wrote: Then it must be time for frist test files Attached are two files, both derived from the Sakila 0.8 data schema. sakila-ooo-32-1028.odb - Created w/ DEV320m_2 - tables, indexes and table constraints sakila-hsqldb-1028-03a.odb - Created w/ CWS build uploaded 10/28/2009 - tables, indexes, table constraints and triggers (minus 1) - domains (one with CHECK constraint) 3 forms in each file: Schema-MySQL-5 (original Sakila 0.8 schema) Schema-OOo-hsql-2-3.2 (the HSQLdb 1.8 schema) -- All PK fields as integer identity -- MySQL ENUM and SET data type replaced w/ CHAR and VARCHAR types -- All FK relations from original schema --- The database can be recreated by copy/paste of this file into the SQL window in an empty Base 2.x file. Schema-OOo-hsql-3.3 (the HSQLdb 1.9 schema) -- PK fields defined with same data types as original schema -- MySQL ENUM and SET data type replaced w custom domains -- All but one upate / insert triggers -- Stored procedure as first setp in supporting missing update trigger upd_film from original schema -- The database can not be recreated by a simple copy/paste of this file into the SQL window of a Base file. (yet) Views to follow. By the way - forms are rather broken in that last build, it seems. Later, Drew On Wed, Oct 28, 2009 at 2:53 AM, Ocke Janssen ocke.jans...@sun.commailto: ocke.jans...@sun.com wrote: Moin again, It's time for a new version. - oj On 10/21/09 15:08, Ocke Janssen wrote: Moin, I uploaded a new version. Please have a look at the cws hsqldb19 for fixed issues. http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks If you file new issues please add them to the cws. Thanks. - oj On 10/14/09 15:12, Ocke Janssen wrote: Moin, I've uploaded a new version based on DEV300m61 with the new hsqldb version 1.9rc6 + patches. This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-) For the people who want to start testing please work on copied data because the file format isn't backward compatible. Once converted can't be ported back. So test only. As I'm waiting for the first bug reports, I put a hsqldb.jar in the root of hsqldb19 every time a fix is available which has to be copied in the classes folder. So happy testing. Best regards, Ocke PS: The files can be found qa-upload.services.openoffice.org http://qa-upload.services.openoffice.org in the folder hsqldb19. -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel
Re: [dba-dev] HSQLDB 1.9 Testing needed
Moin, I uploaded a new version. Please have a look at the cws hsqldb19 for fixed issues. http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=8774logon=trueOpenOnly=falseSection=Tasks If you file new issues please add them to the cws. Thanks. - oj On 10/14/09 15:12, Ocke Janssen wrote: Moin, I've uploaded a new version based on DEV300m61 with the new hsqldb version 1.9rc6 + patches. This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-) For the people who want to start testing please work on copied data because the file format isn't backward compatible. Once converted can't be ported back. So test only. As I'm waiting for the first bug reports, I put a hsqldb.jar in the root of hsqldb19 every time a fix is available which has to be copied in the classes folder. So happy testing. Best regards, Ocke PS: The files can be found qa-upload.services.openoffice.org in the folder hsqldb19. -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
On 10/20/09 00:34, Andrew Jensen wrote: First of all nobody could hinder you to submit issues. ;-) hmm - you mean that in a totally generic way I hope... :-) Yes. The difference between a debug (non-product) build and product build is that you see much more assertions as you would normally see. In a perfect world that wouldn't be the case but it is. Well, I am surely in the mind that I should open issues now - today I went ahead and setup OpenSUSE 11.1 / installed the CWSHSQLdb19 build, most (it seems) of the assertions/errors flying around under Win 7 are absent under OpenSUSE. That's because hsqldb19 for windows is a debug version and for Linux I created a product version (it's a policy to create a least one product version, sometimes the compiler is more intelligent as is good for him ;-) BTW found a easy and consistent way to crash OO.o w/Base due to a heap corruption under Win 7 that doesn't happen under OSUSE ...oops Your not supposed write past the end of the heap (actually this one is a block before the heap IIRC) - 'least that's how I remember it, so that's one issue I'll open for sure. Logging! - it wasn't till I was launching from a terminal under Linux that I realized the logging being generated to stdout...I'll start paying attention - although I planned to turned on logging to a file under Windows ..now I'm anxious to try launching OO.o uing the PowerShell under Win 7, will I get the default logging you have turned on there also? That's one thing I also encounter in newer builds. Seems that I over read a feature mail. (insider) ;-) We use cygwin on our side which runs good and looks more like a Unix. See you, oj Till later, Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering
Re: [dba-dev] memory vs cached tables was( HSQLDB 1.9 Testing needed )
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] triggers
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] HSQLDB 1.9 Testing needed
Moin, On 10/15/09 19:49, Reizinger Zoltán wrote: Drew Jensen írta: Ocke Janssen wrote: On 10/15/09 11:32, Reizinger Zoltán wrote: Ocke Janssen írta: Win upload now completed and tested. I down loaded the new installation set, installed on winXP Home Hungarian version, from cmd window: msiexec/a openofficeorg32.msi into C:\Program Files\OOo_hsqldb19\ folder, installs without any problem. I changed bootstrap.ini, UserInstallation=$ORIGIN/.. soffice not starts from file manager, error mesage: (fast translation) Hi Zoltan, Just a thought - if a reinstall did not help then I would look immediately to the user configuration data. Befrore starting OO.o again be sure to double check the entry in the bootstrap.ini file Ensure that it is going to point to a non-existent (or verified empty) directory. I did it no change the problem, changed installation directory, installed into other drive, same error. I stopped installations, something other problem can cause this. I installed similar way the OOO320_m1, and DEV300_m61. Only change was from that time, windows update in this Tuesday. I give up on win version. The Windows version is non-product build where more assertions are visible as you would see in other cases. http://wiki.services.openoffice.org/wiki/Non_Product_Build For the Windows build you need debug dll which aren't on your system by default. The link http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements might help you to find the pieces which are missing. I hope that is a little help. I'm currently build a product version but for testing the non-product would be better. That's my personal opinion. - oj @Ocke, @QA-Database team Ocke on qa-upload there is both a hsqldb.jar and a full windows install - If I followed the conversation correctly: The newer build does not need the stand-alone hsqldb.jar? As I understand, this stand alone hsqldb.jar is newer than hsqdldb.jar in installation set. Not need to create a new installation set for testing new one, only deleting old and copying this newer hsqldb.jar into classes directory. Zoltan Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
new hsqldb.jar with fixed issue 105916 - oj On 10/16/09 11:53, Ocke Janssen wrote: I've uploaded new versions. - forms and report can be opened now - no assertion from HStorageMap - script which contains a view with select a from b c can be read a 2nd time - oj On 10/16/09 09:42, Ocke Janssen wrote: Moin, On 10/15/09 19:49, Reizinger Zoltán wrote: Drew Jensen írta: Ocke Janssen wrote: On 10/15/09 11:32, Reizinger Zoltán wrote: Ocke Janssen írta: Win upload now completed and tested. I down loaded the new installation set, installed on winXP Home Hungarian version, from cmd window: msiexec/a openofficeorg32.msi into C:\Program Files\OOo_hsqldb19\ folder, installs without any problem. I changed bootstrap.ini, UserInstallation=$ORIGIN/.. soffice not starts from file manager, error mesage: (fast translation) Hi Zoltan, Just a thought - if a reinstall did not help then I would look immediately to the user configuration data. Befrore starting OO.o again be sure to double check the entry in the bootstrap.ini file Ensure that it is going to point to a non-existent (or verified empty) directory. I did it no change the problem, changed installation directory, installed into other drive, same error. I stopped installations, something other problem can cause this. I installed similar way the OOO320_m1, and DEV300_m61. Only change was from that time, windows update in this Tuesday. I give up on win version. The Windows version is non-product build where more assertions are visible as you would see in other cases. http://wiki.services.openoffice.org/wiki/Non_Product_Build For the Windows build you need debug dll which aren't on your system by default. The link http://wiki.services.openoffice.org/wiki/Documentation/Building_Guide/Building_on_Windows#software_requirements might help you to find the pieces which are missing. I hope that is a little help. I'm currently build a product version but for testing the non-product would be better. That's my personal opinion. - oj @Ocke, @QA-Database team Ocke on qa-upload there is both a hsqldb.jar and a full windows install - If I followed the conversation correctly: The newer build does not need the stand-alone hsqldb.jar? As I understand, this stand alone hsqldb.jar is newer than hsqdldb.jar in installation set. Not need to create a new installation set for testing new one, only deleting old and copying this newer hsqldb.jar into classes directory. Zoltan Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
Win upload now completed and tested. - oj On 10/15/09 06:37, Ocke Janssen wrote: On 10/14/09 16:33, Reizinger Zoltán wrote: Hi Ocke, Ocke Janssen írta: Moin, I've uploaded a new version based on DEV300m61 with the new hsqldb version 1.9rc6 + patches. This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-) I installed win version, and soffice.exe/sbase/ and other executables, not start - it is a really not working release ;--)) Yes ;-) Attention check. You won ;-) No, I will recheck the win version and updated as soon as I found the error. Next I downloaded linux version and this is starting, good :-). Started tests, and simple file transformation, working. :) For the people who want to start testing please work on copied data because the file format isn't backward compatible. Once converted can't be ported back. So test only. As I'm waiting for the first bug reports, I put a hsqldb.jar in the root of hsqldb19 every time a fix is available which has to be copied in the classes folder. Now I find hsqldb.jar in root folder. I need to copy it now, or it is a same as in installation packages. Yes, it contains some performance fixes. Later today I'll upload a newer version as I got email from Fred (the main developer of hsqldb). - oj So happy testing. Best regards, Ocke PS: The files can be found qa-upload.services.openoffice.org in the folder hsqldb19. - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
On 10/15/09 11:32, Reizinger Zoltán wrote: Ocke Janssen írta: Win upload now completed and tested. I down loaded the new installation set, installed on winXP Home Hungarian version, from cmd window: msiexec/a openofficeorg32.msi into C:\Program Files\OOo_hsqldb19\ folder, installs without any problem. I changed bootstrap.ini, UserInstallation=$ORIGIN/.. soffice not starts from file manager, error mesage: (fast translation) I just do the same. - install OOo but not in Program Files, flat on d: - change bootstrap to ORIGIN - start soffice.exe from explorer OOo starts. The application can not be started, becuse configuration not correct. The reinstallation can be solve this problem. What can I do? hmm. I'm sorry I don't know. - oj Regards: Zoltan - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] HSQLDB 1.9 Testing needed
Moin, I've uploaded a new version based on DEV300m61 with the new hsqldb version 1.9rc6 + patches. This is NO WORKING RELEASE, if your data is import then DON'T USE IT. ;-) For the people who want to start testing please work on copied data because the file format isn't backward compatible. Once converted can't be ported back. So test only. As I'm waiting for the first bug reports, I put a hsqldb.jar in the root of hsqldb19 every time a fix is available which has to be copied in the classes folder. So happy testing. Best regards, Ocke PS: The files can be found qa-upload.services.openoffice.org in the folder hsqldb19. -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com D-20097 Hamburg http://www.sun.com/staroffice Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schr?der, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] HSQLDB 1.9 Testing needed
On 10/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.8.1 and 1.9
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?
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: [dba-dev] SRB for DEV300 - OOo 3.2 versions
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
[dba-dev] Volunteer for wiki needed
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
Re: [dba-dev] New Filter Dialog
affinity, else you wouldn't offer to write a spec) is always a good thing. Again, asking is what gives you answers/volunteers. disc...@ux is a good place. I of course could recommend Chris Lukasiak to you, who happened to take the UX role in the Base team after our previous UX expert left for other tasks. Personally, I am immodest enough to offer my help in the Dev as well as UX area, though I fear I haven't as much time to spend for the project as I would like to have. --Q4 [i-Team Agreement]: --Do all i-Team members agree on Q1 - Q3? Well, first I need these three people... --What happens if I can't answer all questions mentioned above, with Yes? --The consequence could be that your valuable work won't be integrated --into OpenOffice.org. So, at the moment I should better not start or should I? You should. I consider a specification a very good means to plan a feature, to stay in contact with the stakeholders (which is very important, see above), to ensure that all the time all of them see the same big picture ... I do *not* consider a specification and end in itself, as I do not consider the Qs an end in themselves - if you can reach what they (the Qs, and on a higher level the spec itself) want to ensure by other means, then Just Do It (TM). Although it might not be necessary to meet all these requirements as long as only the spec is going to be written, it would be a good idea to involve at least a User Experience member. Yes. Ciao Frank -- 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
Re: [dba-dev] New Filter Dialog
Moin Karl, On 26.02.09 22:25, Karl Weber wrote: Hi, I noticed that the OOo community is interested in a new filter dialog -- according to [1]. I would like to contribute a specification. Note, however, that I do not plan to do any coding. Someone else would have to implement the specification. May be someone on this list just want to do the coding but is afraid of the specification. ;-) I think, there should only be _one_ filter dialog that is used during design time, i.e. to add a filter to a query or table, and that is also used by the end user in a form. I agree with what is said in [1]: The design is an important part of the project. I think it is not an easy task to create a filter dialog that can represend any filter condition that is logically possible and that is intuitive for the designer and the end user. Is there still any interest, in particular in getting just a specification? Sure. That would bring us one step further. - oj -Karl [1] http://dba.openoffice.org/development/projects.html#new_filter - 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, 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
Re: [dba-dev] Which version of SRB use with DEV300m2?
Moin Zoltán, On 23.02.09 07:40, Ocke Janssen wrote: On 21.02.09 10:13, Reizinger Zoltán wrote: Hi, Which version of SRB use with DEV300m2? I try to use rptfix04 and it fails to start any report. I would guess the one from the extensions download page. The one from rptfix04 only works with a version = DEV300m40 Seems that more have to vote http://www.openoffice.org/issues/show_bug.cgi?id=99143 to get rid of this. Do you mean OOO310m2? I was confused by the DEv300m2? I interpreted the ? as placehodler for 1,2,3,4,5 Stupid developer thinking :=) The problem here is that the lib with *rpt* in name are not registered at the services.rdb and even bad they aren't in the installation set. I'll build a new m2 and will upload it as soon as it ready. Best regards, Ocke 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 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
Re: [dba-dev] Which version of SRB use with DEV300m2?
The up-load will be finished in about 5 min. Linux only at the moment. - oj On 23.02.09 10:32, Frank Schönheit wrote: Hi Zoltán, It's normal, my question was non clear. I tried to usa all my SRB's and downloaded m1 version from Pavel's build, and no working version. cannot start any report from m2 as were in earlier last 5 developer version. I searched and I found that issue 98549 fixed and fix cws integrated and found that this was not fully real, reports not working from m2. The fix for issue 98549 did not make it into m2, and I still have to find out whether this is SubVersion's fault, or a mistake of release engineering. Just to know who to shoot ... Ciao Frank PS: Technically, the fix was part of a file which meanwhile had been renamed in the main trunk, and SVN and file renamings aren't really good friends ... -- 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
Re: [dba-dev] Which version of SRB use with DEV300m2?
Windows is uploaded as well. - oj On 23.02.09 10:56, Ocke Janssen wrote: The up-load will be finished in about 5 min. Linux only at the moment. - oj On 23.02.09 10:32, Frank Schönheit wrote: Hi Zoltán, It's normal, my question was non clear. I tried to usa all my SRB's and downloaded m1 version from Pavel's build, and no working version. cannot start any report from m2 as were in earlier last 5 developer version. I searched and I found that issue 98549 fixed and fix cws integrated and found that this was not fully real, reports not working from m2. The fix for issue 98549 did not make it into m2, and I still have to find out whether this is SubVersion's fault, or a mistake of release engineering. Just to know who to shoot ... Ciao Frank PS: Technically, the fix was part of a file which meanwhile had been renamed in the main trunk, and SVN and file renamings aren't really good friends ... -- 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
Re: [dba-dev] Reportbuilder: Configure Page Break
Moin Mechtilde, On 20.02.09 20:18, Mechtilde wrote: Hello, There is a discussion at us...@de.openoffice.org. We have problems to create a report about more than one pages. We need a logo on the first page. and the group header on each page. Details are displaed as a table. In the properties of the headers I find a filed where I can input expressions, but I don't know how to define them They are defined in the same way you define Calc expressions. Column names are enclosed with [column name] Please also have a look at the wiki. Search for Sun report Builder. I can't copy a link here, server seems to be down. :-( - oj Regards Mechtilde -- 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
[dba-dev] Searched: Performance Tester
Moin, I currently doing some performance test and fixed some code in that area. But I need some volunteer whom want to test my cws dbaperf1. It is based on a DEV300 m41. What I'm interested in is the comparison against a OOo 3.0? So if you would like to help me just create some test case like I copied 1k rows inside a MySQL db and it took 2 min in OOo 3.0 and in the cws dbaperf1 1s. that would be great. :-) You'll find the cws here qa-upload.services.openoffice.org/dbaperf1 Ccurrently I only build Linux but Windows will follow as soon it is built. Best regrads, Ocek -- 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
Re: [dba-dev] MWS builds and SRB development
Moin, On 12.02.09 09:18, Frank Schönheit - Sun Microsystems Germany wrote: Hi Zoltán, It is a possible to attach to any MWS, versions of SRB which allows new features supported in main code, same way as dictionaries installed with OOo? bundling extensions with the OOo distribution is technically easily possible, but a political issue. People need to decide and *agree* to which extension is/not bundled, and this seems to be a difficult process. Reporting is, in my opinion, an integral part of a database application, so you ask me, SRB should be an integral part of Base (not even in the form of an extension). I took the opportunity to start, again, a discussion about integrating SRB into Base - something I'd really like to see happening, as it would significantly lower the efforts around SRB (e.g. testing different SRB versions for compatibility with different OOo versions). Someone could think to submit an issue integrating the SRB into OOo with a high vote would do the job. It's some kind of community binding. Let's see. Yes. best regards, Ocke Ciao Frank -- 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
[dba-dev] SRB documentation
Moin, Do you know the SRB Guidebook? http://www.lulu.com/content/6021296 Thanks to Dimitri Popov who wrotes this Guidebook for the SRB. Please have a look at it. 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
Re: [dba-dev] New Linux version of OOo from cws rptfix04
Moin, On 30.01.09 11:58, Reizinger Zoltán wrote: Hi, Ocke Janssen írta: Moin, I uploaded a new version from cws rptfix04 to ftp://qa-upload.services.openoffice.org/rptfix04 Good Hunting ;-) Best regards, oj PS: If wanted I could also upload Windows. I need one. Needs longer than I expected. Upload done. - 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, 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
[dba-dev] New Linux version of OOo from cws rptfix04
Moin, I uploaded a new version from cws rptfix04 to ftp://qa-upload.services.openoffice.org/rptfix04 Good Hunting ;-) Best regards, oj PS: If wanted I could also upload Windows. -- 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
Re: [dba-dev] OOo Base 3.1 New Features wiki page
Moin Zoltan, On 29.01.09 15:21, Reizinger Zoltán wrote: Hi, I compiled a wikipage from features mailing list mails, and some cases from requirement documents. My intention was that, to spread information, make some noise, about changing or new features, what we have, now in Base. You can find it: http://wiki.services.openoffice.org/wiki/Base/New_features_in_3_1 Please review it. Great work. Thanks. - 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 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
Re: [dba-dev] DEV300m40 and SRB 1.1.0
Moin, On 28.01.09 08:55, Reizinger Zoltán wrote: Hi, I installed DEV300m40 on winXP, and SRB 1.1.0.9371 and SRB not working for me. Opening existing document, error msg: The document cannot be opened New reports cannot be created in design mode and with wizard, they not starts when clicking on them. Any help? The SRB doesn't work in a m40. This problem is that the lib for SRB (named rpt*) aren't packed. This will be fixed in the cws rptfix04. Regards, Ocke 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 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
Re: [dba-dev] Shapes have no editable text in SRB
Moin Fernand, On 23.01.09 13:55, Fernand Vanrie wrote: Ocke, First of all here you can find a list for the next planned features in base http://wiki.services.openoffice.org/wiki/Base/Features/Pool Now some details :-) In the 1.05 SRB, shapes have not the same text-edit functionality as is a normal Writter Doc.Its simply not possible to enter a text in a shape. As I see it shapes are a way to have some text-design features in SRB. Yes, this is a know issue 77094 When used on Company level (Text having some standards) then the use of Styles becomes also a issue . Issue 88683 Are there plans to implement more text functionality in SBR and where can i find a specification off where we go with SBR, to avoid to ask for things who are already planned :-) Most issues which are assigned to the SRB are prefixed with RPT: So you could search for it. Best regards, Ocke Hope it helps 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: 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
Re: [dba-dev] SRB not working with Queries
On 19.01.09 10:07, Fernand Vanrie wrote: Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) And a sample with hsqldb is not possible? - oj Best regards, Ocke Greezt 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: 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
Re: [dba-dev] Re: [dba-users] New version of the SRB for testing
Moin Drew, On 18.12.08 18:39, Drew Jensen wrote: Ocke Janssen wrote: As far as I know this version should be 4 times faster in report generating as before. You still need to start Writer or Calc which cost most of the time. And the formula which can be used have been reworked as the wiki page for it. Hi Ocke, Just wondering if the new functions will flow backwards into SRB 1.0.x ? The functions should be there but in an older version has bugs. One also may be that the description is faulty. if not then someone should, I suppose, make note on the wiki page which functions are available with which release. I guess that it would generate some workload. Best regards, Ocke 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, 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
[dba-dev] New version of the SRB for testing
Moin, I uploaded a new version of the SRB to qa-upload.services.openoffice.org. This version uses the newest sources from Pentaho. Please be aware that this version doesn't work with frmdlg cws OOo version, which will be the case next year ;-) Different cwses. As far as I know this version should be 4 times faster in report generating as before. You still need to start Writer or Calc which cost most of the time. And the formula which can be used have been reworked as the wiki page for it. As always feel free to submit issues when you encounter them. Perhaps you could attach a sample with the formula inside, makes things a lot easier for to handle it. Thanks to Drew, for his samples so far. 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
Re: [dba-dev] How to create a report?
Moin Mechtilde, On 06.12.08 13:34, Mechtilde wrote: Hello, Drew Jensen schrieb: Mechtilde wrote: Yes I use the latest official build of SRB which doesn't work with a version of DEV300_m35 and higher. Kind of slow but - just sent you a copy of 1.0.9.9345 that works with OO.o m35 direct. I get an error message. a screenshot is here: www.mechtilde.de/temp/SRB-Installation.png That looks like the problem with license text which doesn't had a default. I've uploaded a slightly changed version of the SRB oxt from a DEV300_m37. Could you please test this version? Thanks. Best regards, Ocke Regards Mechtilde -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] Open Report from Macro does not insert data
Hi Thomas, On 28.11.08 23:28, Thomas Friese wrote: Hi, I'm trying to open a Report on a button-click from a Form (and save that report afterwards). Frank Schönheit suggests in this message: http://dba.openoffice.org/servlets/ReadMsg?list=devmsgNo=3334 that something like this: documentDefinition = reports.getByName( sReportName ) Dim aCommand as new com.sun.star.ucb.Command aCommand.Name = open aCommand.Handle = -1 oReport=documentDefinition.execute(aCommand,n,null) should open the Report (which it does - yet, no data is inserted into the report). When I open the Report from the UI or use the following call, passing a connection in the properties, the data is filled in: oReport=reports.loadComponentFromURL(sReportName,_blank,0,aProp()) Am I missing something in the execute open-Method above? aCommand.Argument is a sequence where you set the same arguments as aProp. Best regards, Ocke Thanks for any hint Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Typos in connectivity/source/resource.po
Moin Sophie, On 26.11.08 17:53, sophie wrote: Hi all, On my way on translating the new connectivity strings, I think I find a typo. Should I fill an issue for this project or is it for Uwe ? [ OO.o PO UI ] connectivity / source / resource.po #:conn_shared_res.src#STR_QUERY_MORE_TABLES.string.text msgid: The query can not be executed. It is contains more then one table. I think it should be : It contains more than one table. Thanks for finding this. An issue would be great, please assign it to me. Thanks. Best regards, Ocke Kind regards Sophie - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] OOo 3.0 is released and do you use charts in reports? Comments are welcome.
Moin, When you use charts in reports I would like to get any kind of feedback, comments or even rants :-) What work and what doesn't work? What should be better or is the feature itself useless. (I don't hope so ;-) So your opinion is asked for. Best regards, Ocke PS: You need a OOo 3.0 and the newest SRB 1.0.5 (http://extensions.services.openoffice.org/project/reportdesign) -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Formula in Sun-Report-builder (DateDiff360)
Moin Mechtilde, sorry for the long delay. Mechtilde wrote: Hello, *I try it again* I want to create a report for a calculation with data from database. there I need a funktion which calculate the different between the actual datum and the datum from the entry before (you know it as date diff). The special Problem is that I need it with the 360 day method (so call in Germany) for interest calculation. Can anyone give me a hint to find more information about such things? Currently the days360 function is not supported by the report engine. The formula engine is developed outside from Pentaho. So best would be to submit an issue and assign it to me. I'll contact the owner and may be create a patch for it. Best regards, Ocke The informations in the wiki doesn't help me futher. In Calc there is such a funktion. But it is not an effective way to do it there. It is not pacticable to print 18 colums on a page also in landscape. In the sun-Report-Builder allows me to put a record in more than one row. Regards Mechtilde -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: AW: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi Micha, Michael Strobel wrote: Hi Ocke, I'm back :-) That's great news, at least me ;-) Hope you had a good vacation. Yes, Indeed I became a father. So less sleep. :-) First of all I have to clarify that default values which you enter in the table design window are never propagated to the driver. These default values are only UI values which will be shown when you open the table to add data. What may me confuse is the fact that your alter command is called. Normally I would argue that some props of the column type has changed. May be the problem is databasemetadata::getColumns for that table (type nfo of the column), but that is only a guess. What could be the problem with properties of the column type exactly? If it is because of a difference between the result of getTypeInfo() and getColumns() this is likely a fault in our JDBC driver, which explains why the problem does not appear with MySQL and the SDBC-JDBC bridge, but as far as I could see the problem is independent of the column type. I'll check that and the results of the both methods. I only thought that this could be the problem of the alter statement. The table design checks if any changes happen. The best place to look at is :DoSave in TableController.cxx in dbacces or alterColumns. - oj Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi Micha, Michael Strobel wrote: Hi Ocke, - how about just call dropObject at the views Calling dropObject at the views results in a SQL exception since the view is already dropped in the database. I just tried to catch the exception and ignore it to see what happens, but calling that didn't solve the actual problem. Another try to get the right object could be to query *this for XDrop and then call dropObject I don't know if it works but give it a try. :-) - or forbid that a table which is referenced in a vew can not be deleted :-) This is possible, but unfortunately my project lead isn't happy with this solution as it doesn't reflect the standard behavior of the database. Working on that ;) I have still one more question ;) I began the development using Windows and now tried to compile the driver for Linux, which gave me some linker problems. As said before the driver is derived from your MySQL driver, but there are also some classes in the driver inherited from the OO JDBC driver, which for the implementation of autoincrement columns. (I know it's nasty, but I don't see a chance to change it.) Which classes you are talking about? The best way is to get rid of the dependency of JDBC. To get the symbols for the linker under Windows I just added the jdbc.lib to the SHL1STDLIBS in the makefile, which works fine for linking, but under Linux putting -ljdbc2 doesn't work. The linker generates a lot of undefined symbol errors for the symbols from the libjdbc2.so. I have also tried to add it to SHL1LIBS instead, but this gives results in multiple definitions of component_getFactory and component_getImplementationEnvironement. Any ideas? You can't link against JDBC that simple. I would prefer that you isolate the classes you need and move them into dbtools (that's the commontools folder). In that way both can share it and we don't have duplicate (bad) code ;-) Best regards, Ocke Best reagards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Moin Micha,
Michael Strobel wrote:
Hi Ocke,
I have created issues for the stuff, which we discussed last time I
posted here. It seems like it will still take a while until they are
treated. There are still a few more problems with the driver and hope
you have an idea how to solve this one:
A view that references a table is dropped silently by our DBMS, when the
referenced table is dropped, yet Base still displayes the view, until
View-Refresh Tables in the Bases menubar is clicked.
Calling refreshTables() and refreshViews() from the IngCatalog class
doesn't solve this, as it only refreshes the structures in the driver,
but Base has no clue that they have changed.
I guess I should do something like the following for every silently
dropped view in the implementation of XDrop for the IngTables class to
tell Base about the change, but it doesn't seem to work either.
IngViews* pViews = static_castIngViews*
(static_castOIngresCatalog(m_rParent).getPrivateViews());
if (pViews pViews-hasByName(_ViewName_))
{
pViews-dropByNameImpl(_ViewName_);
ContainerEvent aEvent(static_castXContainer*(this),
makeAny(_ViewName_), Any(), Any());
OInterfaceIteratorHelper aListenerLoop(m_aContainerListeners);
while (aListenerLoop.hasMoreElements())
{
static_castXContainerListener*
(aListenerLoop.next())-elementRemoved(aEvent);
}
}
I think now it's time for debugger :-)
Some brainstorming:
- set breakpoints in dbaccess/source/core/api/viewcontainer.cxx
::elementremoved and tablecontainer.cxx
- can it be that the view name is still in the tablecontainer
- debug who receives the elementRemoved message
- how about just call dropObject at the views
- or forbid that a table which is referenced in a vew can not be deleted :-)
Best regards,
Ocke
Best Regards,
Micha
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x1
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Moin Micha, Michael Strobel wrote: Hi Ocke, You also have to check getColums, getPrimaryKey, getExportedKeys and all occurrences where a table or column name can be asked for. The best way is to look at the databasemetedata where a resultset is returned. Works. Only the table name that is displayed the tree view in the OO Base main window is still in upper case. Do you know where it is stored? Column 3 from getTables ResultSet from XDatabaseMetaData is used. What do you think about that OO base might delete a long varchar value under the circumstances which I described in my last mail? Sorry I missed that in my answer. I never created such long text before, could you please submit an issue for this. May be someone in between has still use USHORT_MAX as limitation. Thanks. Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] Re: Sun Report Builder with EuroOffice Map Chart extension
Moin Dániel, Darabos Dániel wrote: Dear Ocke, I have checked out rptchart02, and have compiled it to work with OOo 2.4 (I needed to change a file, I have attached the diff in case you are interested). Thanks. I'll put it in a new cws when rptchart02 is integrated. Could you please submit an issue where you attach the patch file. Thanks. I would like to ask for a bit of help though. Our extension is a UNO component and its output is a vector drawing. Do you think that with rptchart02 Sun Report Builder would now be able to accomodate such an extension? I got my hopes high, because charts are similar to some extent, but from looking at the source code I find that it is very specific to charts and not easily extended to other UNO components. Yes it should work. When you create a new function like for example Author-function.java and you put the component context in the same list as the AUTHOR keyword, you can access it in your function. Your function has to do the same what it does in the ImageProducer. The functions gets evaluated and the result will be send to the image producer. So I guess 100 lines of code :-) But may be one or more things have to be done which we currently don't see. I would start by search for Author and Title in Java and in properties files. In fact I do not understand why Sun Report Builder writes the XML directly when generating the report instead of using UNO to build and save a document. I think that the current approach is rather rigid and at the same time requires lots of extra effort on your part (writing more and more complex XML generators). What was the reason for this approach? It should be possible to generate many reports at a time. Where the resulting documents don't need to be loaded. Another reason is speed ;-) Best regards, Ocke Cheers, Daniel On Thu, Jun 12, 2008 at 6:50 AM, Ocke Janssen [EMAIL PROTECTED] wrote: Moin Daniel, Darabos Dániel wrote: Thanks for the answer! I will look into rptchart02, it sounds like a Promised Land :). Is it only going to be integrated in OOo 3.0, or will its features come earlier as an update to the extension? The feature to insert charts into the report will be available in a DEv300m20 or m21. But to extend the function set is already possible. At the moment I don't know exactly but it looks good the engine will be released earlier as OOo3.0. It still works with earlier versions and the new feature se t is simply unused in that versions. Best regards, Ocke Best regards, Daniel On Wed, Jun 11, 2008 at 4:15 PM, Ocke Janssen [EMAIL PROTECTED] wrote: Hi Daniel Darabos, Please note I answer the mail in dev@dba.openoffice.org, which really is the more appropriate for this kind of discussion. Please also stick to this list - doing all this in private communication sounds like a waste of knowledge to me. Thanks. Darabos Dániel wrote: Dear Ocke, I am a developer from MultiRacio Ltd., responsible for the EuroOffice brand of extensions. Seeing how useful and popular Sun Report Builder is, we had the idea of bringing the functionality of EuroOffice Map Chart to it. It would allow adding automatically generated map charts to your reports. To read about EuroOffice Map Chart here is its page in the Extension Repository: http://extensions.services.openoffice.org/project/eurooffice-mapchart We now have a prototype of this integration working. That sounds really cool. :-) Unfortunately for this to work, I had to modify two files in the Java source of Sun Report Builder. In SOReportJobFactory.java I made m_cmpCtx public static so I could get a UNO ServiceManager in ImageProducer.java. In ImageProducer.java if the image data is a string and starts with map: I instanciate com.multiracio.MapChartProfessional, give it the image data and use the image returned by EuroOffice Map Chart in the document. If you would like to open up Sun Report Builder to extensions, I think this could be a very effortless approach. There would just need to be a registry for Sun Report Builder plugins, and they could register for handling different protocols (such as com.multiracio.MapChartProfessional for map:). The prototype of EuroOffice Map Chart Professional now works by adding a new menu item to the Insert menu of com.sun.star.report.ReportDefinition (through the UIConfigurationManager), which opens a dialog, and creates an image object with a data field that is a formula expression that will evaluate to a string starting with map: and containing possibly different data for different instances (such as in the example). I don't know if it is a good idea to introduce a new URL for map:. A better approach for me would be to use a function like rpt:MapChartProfessional(args). In cws rptchart02 I introduced two new functions Author and Title which can be used as template. all what need to be done is add the service factory to the configuration like
Re: [dba-dev] Re: Sun Report Builder with EuroOffice Map Chart extension
Moin Daniel, Darabos Dániel wrote: Thanks for the answer! I will look into rptchart02, it sounds like a Promised Land :). Is it only going to be integrated in OOo 3.0, or will its features come earlier as an update to the extension? The feature to insert charts into the report will be available in a DEv300m20 or m21. But to extend the function set is already possible. At the moment I don't know exactly but it looks good the engine will be released earlier as OOo3.0. It still works with earlier versions and the new feature se t is simply unused in that versions. Best regards, Ocke Best regards, Daniel On Wed, Jun 11, 2008 at 4:15 PM, Ocke Janssen [EMAIL PROTECTED] wrote: Hi Daniel Darabos, Please note I answer the mail in dev@dba.openoffice.org, which really is the more appropriate for this kind of discussion. Please also stick to this list - doing all this in private communication sounds like a waste of knowledge to me. Thanks. Darabos Dániel wrote: Dear Ocke, I am a developer from MultiRacio Ltd., responsible for the EuroOffice brand of extensions. Seeing how useful and popular Sun Report Builder is, we had the idea of bringing the functionality of EuroOffice Map Chart to it. It would allow adding automatically generated map charts to your reports. To read about EuroOffice Map Chart here is its page in the Extension Repository: http://extensions.services.openoffice.org/project/eurooffice-mapchart We now have a prototype of this integration working. That sounds really cool. :-) Unfortunately for this to work, I had to modify two files in the Java source of Sun Report Builder. In SOReportJobFactory.java I made m_cmpCtx public static so I could get a UNO ServiceManager in ImageProducer.java. In ImageProducer.java if the image data is a string and starts with map: I instanciate com.multiracio.MapChartProfessional, give it the image data and use the image returned by EuroOffice Map Chart in the document. If you would like to open up Sun Report Builder to extensions, I think this could be a very effortless approach. There would just need to be a registry for Sun Report Builder plugins, and they could register for handling different protocols (such as com.multiracio.MapChartProfessional for map:). The prototype of EuroOffice Map Chart Professional now works by adding a new menu item to the Insert menu of com.sun.star.report.ReportDefinition (through the UIConfigurationManager), which opens a dialog, and creates an image object with a data field that is a formula expression that will evaluate to a string starting with map: and containing possibly different data for different instances (such as in the example). I don't know if it is a good idea to introduce a new URL for map:. A better approach for me would be to use a function like rpt:MapChartProfessional(args). In cws rptchart02 I introduced two new functions Author and Title which can be used as template. all what need to be done is add the service factory to the configuration like it was done for Author. If you have any questions about using it, let me know. It is supposed to be installed after the modified Sun Report Builder is installed, so that the menu is correctly extended. Now we are sure all this would be a nice feature for users. But we are not sure about how to go ahead with providing this solution. The easiest way for me is that you submit a patch file. I'll verify and check before I integrate it into the source code. ;-) The ideal scenario for us would be if a cleaned up version of this extensibility feature could be integrated into future versions of Sun Report Builder. This would also open up the way for other Sun Report Builder extensions, a very useful example of which would be an integration of regular charts. That is done in cws rptchart02. You can use charts as you can in for example in OOoCalc. I would be more than glad to cooperate with you on making this happen. (Of course my understanding of the Sun Report Builder sources is a bit limited, but with your guidance I could probably write most of the code.) Feel free to ask any question which come to your mind. I'll try my best to answer them ;-) We could also possibly provide a patched variant of the newest Sun Report Builder versions for download for users of EuroOffice Map Chart, but this would be quite an awkward solution, and I am not even sure about its legal circumstances, so I would like to avoid this approach. +1 Please let me know what you think about all this! I am looking forward to your answer. Really great. Best regards, Ocke Best regards, Daniel Darabos -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] D-20097 Hamburg http://www.sun.com/staroffice Sitz der
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi Micha, Michael Strobel wrote: Hi Ocke, After save the table we ask the db metadata with getTabes and the parameter filled for the table we saved. May be that doesn't return no information. When you do a refresh it is mostly like creating a new connection. Thanks, that helped, at least a bit. The problem results from the Ingres behavior with identifier case sensitivity. While Ingres treats quoted identifiers per default as case insensitive, ANSI/ISO Entry SQL-92 specifies quoted identifiers as case sensitive. Open Office uses quoted identifiers and always expects them to be ANSI/ISO Entry SQL-92 compliant. Open Office builds a create table statement with quoted identifiers in mixed case, so the table name is mixed case in Open Office and in lower case in Ingres. Afterwards Open Office tries to fetch a description of the table for updating it's list of available tables using DatabaseMetaData.getTables() and passes the tableNamePattern in mixed case. DatabaseMetaData.getTables() builds a query against the catalogs that hence includes the table name in mixed case in a like comparison. As the table name is stored in the catalogs as lower case the like comparison fails and an empty result is returned, so the newly created table doesn't appear in Open Office list of available tables. I tried to perform a toAsciiLowerCase() on the table name string before getTables() is called. This results in an update of the tree view in the OO Base main window, but the table name appears in the tree view as mixed case, opening the table shows no editable columns and reopening the table design shows no columns at all. An extra call of Catalog.refreshTables() after creating the table also didn't do a correct refresh. Could I do anything else in the driver to repair this? You also have to check getColums, getPrimaryKey, getExportedKeys and all occurrences where a table or column name can be asked for. The best way is to look at the databasemetedata where a resultset is returned. Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Moin Micha, Michael Strobel wrote: Hi Ocke, That would be great. But an issue where you attach the bugdoc would even be better :-) I got the following mail from our JDBC driver developer, which makes me think it's not an issue. What do you think? --- snip --- Working with LOB columns is extremely difficult due to many restrictions on when the data can or must be accessed. Autocommit makes it very difficult to handle LOB locators. I do not recommend enabling locators during autocommit, especially with a cursor mode of 'multi'. Simulating autocommit to support multiple open cursors (which Ingres does not support) results in full transaction commits being issued by the driver. A full commit invalidates a LOB locator, which is probably the cause of your problems. With locators disabled, the application must process the streamed LOB data. This restricts what actions may be taken on the connection. The application is attempting to issue a new query when there is LOB data still to be processed. The driver protects the data stream with locks, which is causing a dead-lock in the application. Most generic applications are not disciplined enough to follow JDBC portability guidelines of reading all columns in order and only once when processing result-sets. My suggestion is that you do not enable lob locators (use default settings), but that you enable the caching of LOB data. This will avoid the transaction conflicts with locators and restrictions on processing LOB data streams. The downside is that LOB data will need to fit in memory. Please review the BLOB Column Handling section of the JDBC chapter in the 2006r3 Connectivity Guide. --- snip --- The suggestion to enable the caching of LOB data works for me. Maybe this is what databases which run out of the box with OO do by default. While doing more tests of the driver unfortunately I discovered the following two problems: When I click the save button in the table design view for a new table without having set a primary key beforehand a dialog appears which allows me to let OO create a additional column 'ID' as primary key. That's fine so far. When I click the 'Yes' Button in the dialog the create table statement is executed correctly, but OO doesn't recognize the new table until the tables are refreshed manually by clicking 'View - Refresh Tables'. In table design view you may again click the save button as OO doesn't recognize that the table is created successfully. Clicking the button again produces an SQL error as the table already exists. Similar thing happens when I use the table wizard to create a table. Clicking finish executes the create table statement correctly, but the table isn't displayed in the list of tables and the wizard doesn't close itself. Clicking the finish button again produces an SQL error as the table already exists. Any ideas what might be the root cause? I did a bit code reviewing but found nothing suspicious so far. Do you know what queries are usually executed after saving a table? Possibly there is one that doesn't work with Ingres in these situations. After save the table we ask the db metadata with getTabes and the parameter filled for the table we saved. May be that doesn't return no information. When you do a refresh it is mostly like creating a new connection. Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Hi MIcha, Michael Strobel wrote: Hi Ocke, You may have a look at connectivity/source/commontools/FValue.cxx. This class is used to fetch the values from the result set and dbtools.cxx as well. How does your table structure look like? Could you create another db (may be hsqldb) for a testing purpose with some sample data so that I may have a look at it? Creating another db is no problem, if you think it's useful. I'm using a very simple test case, one table t1 with columns c1 int, primary key, c2 varchar(5), c3 long varchar containing one row (1, 'test', 'test') and the trace output from the JDBC driver. I can send you the trace output, just didn't attach it here because of it's size. That would be great. But an issue where you attach the bugdoc would even be better :-) Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Moin Micha, Michael Strobel wrote: Hi Ocke, Your patch work's fine with the test programs, but I'm still unable to read and write long varchar columns in OO Base. I guess OO Base may be mislead by our JDBC driver, which unfortunately returns always 0 for the length and precision of long varchar columns. Methods that return always 0 for the length and precision of long varchar columns: - XConnection.getMetaData().getTypeInfo() in PRECISION (column 3) - XConnection.getMetaData().getColumns(...) in COLUMN_SIZE (column 7) - XResultSetMetaData.getPrecision(...) It's possible to switch our JDBC driver in two different modes. First mode disables use of clobs, long varchar columnss are described as type -1 in ResultSetMetaData. This mode causes OO Base to freeze, when it tries to read long varchar column using getString(). Second mode enables use of clobs, long varchar columnss are described as type 2005 in ResultSetMetaData. In this mode Base displays the long varchar columns always empty, values may be entered, but disappear as you leave the input field with the cursor and don't go to the database. Could the length and precision values cause such a behavior in Base? No, the length and precision are only used when you try to change the table layout or to create a new table. The problem here seems to be that the data could not be read. The method getString should always return something. So may be calling getString for a long var char column doesn't work for your jdbc driver. Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] CJK fonts with Sun Report Builder
Hi Tora, tora - Takamichi Akiyama wrote: Hello Ocke, Ocke Janssen wrote: Looks like an issue for me ;-) Could please submit one and attach a sample database with report. Thanks. Issue 90298 has been filed. Could you please have a look? Perfectly. Thanks. Best regards, Ocke Best Regards, Tora - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] SRB 1.0.5_alpha query strange behavior
Hi Zoltan, Reizinger Zoltán wrote: Hi Ocke, I try to do some strange (not usual, trial and error) sort of tests, on rptcart02 OOo and 1.0.5_alpha SRB. I makes some times strange things, because I'm self and half or third trained database user, not developer. Now I try to create some report with charts, and for this I created some query, and found some strange behavior in query designer, or in OOo3. First I created query and saved, opened again, and some thing changed, see: http://www.flickr.com/photos/[EMAIL PROTECTED]/2536326260/ I occassionally switched off design view and switched back, and the query changed, the query results hopfully not. After this I switched o-off several times and get this: http://www.flickr.com/photos/[EMAIL PROTECTED]/2536326264/ results not changed Tried with all newly created queries, same result. I quit from OOo, restarted it open as first picture, and after several off-on same results as second picture. Zoltan Strange. Does this only occur on the SRB1.0.5_alpha or e.g. in a DEV300m13 version? Nothing at all we need an issue for this ;-) Would you be so kind to submit one? Thank you. If this only occurs in this snapshot we have to fix it in that cws. Best regards, Ocke - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] SRB 1.0.5_alpha query strange behavior
Hi Zoltan, Reizinger Zoltán wrote: Ezzel a dátummal: Monday 02 June 2008 09.52.27 Ocke Janssen ezt írta: Hi Zoltan, Strange. Does this only occur on the SRB1.0.5_alpha or e.g. in a DEV300m13 version? Nothing at all we need an issue for this ;-) You are not so lucky, I find it in 2.4.1RC2, and 3.0 beta and DEV300m14 as you can see in issue. The other way around. ;-) I can fix this issue in another cws and don't have to reopen rptchart02. Would you be so kind to submit one? Thank you. http://www.openoffice.org/issues/show_bug.cgi?id=90244 Thank you. If this only occurs in this snapshot we have to fix it in that cws. You could do more, than fix this cws :( ? Regards, Zoltan Best regards, Ocke - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] CJK fonts with Sun Report Builder
Moin tora, tora - Takamichi Akiyama wrote: Hi, A question about CJK fonts with Sun Report Builder. With SRB 1.0.0, the size of CJK font was surprisingly too big. Thanks to the efforts of development, with SRB 1.0.4, the default size of CJK fonts seems to have been changed to normal size. It, however, seems to be forcedly set to 12pt and seems not to be able to be specified. Additionally, its font family seems to be unchangeable. The size and family of CJK font of labels become able to be changed in the design window, but its font family in a processed output is forcedly set to the default font family when Execute Report is executed. Is there any information on supporting CJK fonts with SRB? I have just started to locally build CWS rptchart02 to confirm them with the latest, under-development one. Looks like an issue for me ;-) Could please submit one and attach a sample database with report. Thanks. Best regards, Ocke Thanks in advance, Tora - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] rptchart2 issue?
Moin Zoltan, I'll take a look at asap. I tested this only on a windows version. May be Linux is also import. Best regards, Ocke PS: I changed the version number from 1.0.3 to 1.0.5_alpha. My mistake. Reizinger Zoltán wrote: I downloaded new version marked as 080528 (ftp://qa-upload.services.openoffice.org/rptchart02/) of rptchart2, and SRB with upload date 080528, installs as 1.0.3, from the same place installed on openSuSE 10.3 x86_64, java 1.6_05. My first question, this is the version which need to be tested? if yes I found that, file in issue 89365 (OOo30RPT_1_0_3_first.odb) cause crash when I tried to edit or open existing reports. After that I deleted all reports, closed file and OOo, opened again, tried to create report on More3 table, I put three filed into main area, and tried to insert chart into report footer, and this caused crash. Best regards, Zoltan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] rptchart2 issue?
Hi Zoltán, Reizinger Zoltán wrote: Hi Ocke, Moin Zoltan, I'll take a look at asap. I tested this only on a windows version. May be Linux is also import. But we have only linux build on download site :). :-) Windows is easier to debug but still needs longer to build :-) I tried with newly created file, too. Results same, crash after I draw rectangle for chart into any part of report, detail, Group footer, report footer. When I release mouse button, crash. I found the problem. It was a build problem with one file. After rebuilding it, it works. I currently load new download sets up. They should be finished in about 15 min. - oj Zoltan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver
Moin Micha, Michael Strobel wrote: Moin Ocke, When you call at the metadata the getTypeInfo method which results do you get? You could for example use the code in the qa folder as template. I wrote a small test program that calls getTypeInfo and shows the result. Used NetBeans for this, very cool :) The value is actually set to the string supplied with the Properties, but as before there is no change in Open Office. Unexpected values as the string null don't produce any errors? What do you want to achieve with the TypeDescriptionInfo? May be your Double type doesn't need any parameters, just a guess. Currently null is not recognized as keyword, you have to adjust the RowFunctionParser.cxx when you don't want to appear the word null as the column value. So this is necessary to set a value in the result to null, because so far only substitution of values is possible? When null is really needed, may be should could change the RowFunctionParser to accept null as well. It's not that complicated ;-) Freeze is not good. Does this happen also with other dbs? Sometimes we are calling getObject(xx) and some methods are not handled well. It depends on the column which method is called, may a look in ORowSetValue might help or dbtools.cxx No, it doesn't happen with MySQL at least. As far as I could see OOo uses LOB locators to retrieve LOB values from the DBMs. What happens if LOB locators are not supported? I think Ingres supports them in the version I'm using. Maybe our JDBC driver developer can give more hints. You have an own JDBC driver? Then change the getTypeInfo there :-) Best regards, Ocke Best regards, Micha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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
Re: [dba-dev] New cws rptchart02 for testing purpose
Ariel Constenla-Haile wrote: Hi Ocke, Ocke Janssen escribió: Moin all, now it's time for 2nd release. I fixed all reported issues but may be there are more unknown inside. So please test this version also :-) It is build on a DEV300.m13 where can we download it? Moin Ariel, sorry I missed that :-) Same location as before. ftp://qa-upload.services.openoffice.org/ - oj Regards Ariel. -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
