RE: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-10-01 Thread Michael Strobel
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Dienstag, 30. September 2008 13:29 To: dev@dba.openoffice.org Hi Frank, If you want, we can create a CWS based on this milestone, and commit your changes (or you can do yourself, if you want, after we

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-10-01 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, Okay, I went through some documents introducing to the CWS concept. In case using a CWS to apply my changes, I'll need to checkout the most recent milestone via cwsquery, create the CWS via cwscreate, apply my changes locally to the CWS and commit them to the CWS via a CVS commit,

RE: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-09-30 Thread Michael Strobel
Hello Frank and Ocke, It's been a while since I wrote to the mailing list last time, because I was on vacation. You may remember that we were working on a driver. We are finished with the driver so far and would like to integrate it into the core code base. Probably we need to do some small

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-09-30 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, It's been a while since I wrote to the mailing list last time, because I was on vacation. You may remember that we were working on a driver. We are finished with the driver so far and would like to integrate it into the core code base. Probably we need to do some small changes to

AW: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-17 Thread Michael Strobel
Hi Ocke, I'm back :-) That's great news, at least me ;-) Hope you had a good vacation. 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

Re: AW: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-17 Thread Ocke Janssen
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

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-07 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael Strobel wrote: There is no issue for this, because I wanted to get sure that this is problem is not related to our driver. Since I couldn't reproduce the behavior with MySQL today, but only with Ingres I'm not quite sure about that. On the one hand the default values are not saved

RE: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-07 Thread Michael Strobel
Hi Frank, Hmm - you couldn't reproduce the default values vanishing, or you couldn't reproduce the default values not being passed to the driver? I couldn't reproduce the vanishing. The defaults were saved correctly when connecting via the SDBC-JDBC bridge to MySQL or via OOo's MySQL driver.

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-06 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, I'm still confused what is happening to the default values in Base. You mentioned before that they never appear in the database and are stored in the base document instead. Seems to be correct, they do never appear in the database, but how is that done? IIRC (it's a while since I

RE: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-08-05 Thread Michael Strobel
Hi Frank, small misunderstanding - supplying the default from within the driver is exactly the item which we don't have an infrastructure for. We can easily add a setting to database documents, default it so that the current behavior is unchanged - but then everybody creating an .odb for

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-31 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, A flag saved at the data source / database document and supplying it's default from within the driver is absolutely sufficient for our needs. :-) small misunderstanding - supplying the default from within the driver is exactly the item which we don't have an infrastructure for. We

RE: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-30 Thread Michael Strobel
Hi Frank, Nearly forgot that: If the problem would only be the missing warning, I'd vote for adding it to the dialog which asks the user (which would be a Good Thing (TM), anyway) .. There's no mechanism in place to disable the feature. We can introduce one, though I fear you have no time

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-29 Thread Frank Schönheit - Sun Microsystems Germany
Hello Michael, I would like to prevent that OOo Base asks if it should delete a column and append a new one, when the column definition can't be modified. Is it possible to do this from within the driver or switch it of in one of Base's option dialogs (I didn't see anything like this, but

Re: AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-21 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, first of all thanks for your response. I think I forgot to tell this, as I'm usuallyworking from Monday to Wednesday or Thursday only, it may take some time till I respond to the mails here. As you might have noticed, my answers are delayed, too - I do not work on Fridays, and

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-16 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, Ocke's on vacation for a while, so let me jump in here. Which classes you are talking about? The best way is to get rid of the dependency of JDBC. I need a specialized ResultSetMetaData class for the driver, but to integrate this class I also need to inherit the Driver,

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-16 Thread Frank Schönheit - Sun Microsystems Germany
Hi Michael, me again ;) Probably there is bug regarding the save process in Base when changing a default value or a description text. It appears with MySQL and Ingres, but not with HSQLDB. I reviewed the driver method OTable::alterColumnByName, but I didn't find the root cause for this. To

AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-16 Thread Michael Strobel
Hi Frank, first of all thanks for your response. I think I forgot to tell this, as I'm usuallyworking from Monday to Wednesday or Thursday only, it may take some time till I respond to the mails here. Now towards the weird driver architecture. You are right, my driver does not inherit from the

AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-16 Thread Michael Strobel
Hi Frank, One thing to mention is that the description text and the default value, as you see them in the UI, might not be what you expect them to be. That is, those values are completely client-side at the moment, even if the underlying database would support them, to. So, whatever you

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-14 Thread Michael Strobel
Hi Ocke, Which classes you are talking about? The best way is to get rid of the dependency of JDBC. I need a specialized ResultSetMetaData class for the driver, but to integrate this class I also need to inherit the Driver, Connection, PreparedStatement and ResulSet classes to make sure that

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-14 Thread Michael Strobel
Hi Ocke, me again ;) Probably there is bug regarding the save process in Base when changing a default value or a description text. It appears with MySQL and Ingres, but not with HSQLDB. I reviewed the driver method OTable::alterColumnByName, but I didn't find the root cause for this. To

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-11 Thread Ocke Janssen
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-03 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-07-02 Thread Michael Strobel
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-19 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-18 Thread Michael Strobel
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

AW: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-15 Thread Michael Strobel
Hi Ocke, I didn't get the chance to finish the case sensitivity problem with Ingres yet, but meanwhile I have discovered other things and probably at least one of them is worth an issue. For some reason Base can't handle values in long varchar columns that exceed a length of 65535 characters,

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-10 Thread Michael Strobel
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-10 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-09 Thread Michael Strobel
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-09 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-05 Thread Michael Strobel
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-05 Thread Ocke Janssen
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

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-04 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-04 Thread Michael Strobel
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-06-03 Thread Michael Strobel
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-05-29 Thread Michael Strobel
Moin Ocke, XClob is not well tested in OOo. Which type does your column have? May be getCharacterStream works as well. Please submit an issue for the XClob. Thank you. The column type is long varchar. Using the the test programs - a JavaApp and a OOoClientApp - mentioned in the last mail for

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-05-29 Thread Michael Strobel
XClob is not well tested in OOo. Which type does your column have? May be getCharacterStream works as well. Please submit an issue for the XClob. Thank you. Ahh, sorry, I didn't notice getCharacterStream. That explains how OOo Base could retrieve the data from a MySQL database. Hmm, no

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-05-28 Thread Ocke Janssen
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

RE: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-05-28 Thread Michael Strobel
Moin Ocke, What do you want to achieve with the TypeDescriptionInfo? May be your Double type doesn't need any parameters, just a guess. You have an own JDBC driver? Then change the getTypeInfo there :-) Right, the Ingres double type doesn't expect any parameters. It's definitely a bug in

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-05-09 Thread Michael Strobel
The rename entry is already there. I would take the sources from the mysql driver and change the sql statement in such way that ingres understand it :-) It has been quite a while and there is still more refinement needed, but finally the driver compiles and the basic stuff works :-)

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-04-25 Thread Ocke Janssen
Moin Michael, Michael Strobel wrote: Moin Ocke, thanks for your fast reply :-) Normally I attach the debugger to the process or start soffice.bin directly. But it depends on your operating system ;-) Okay, make debug seems to be sufficient to create the symbols for the debugger :-)

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-04-16 Thread Ariel Constenla-Haile
Hi Michael, Michael Strobel escribió: Hi, I try to develop a SDBC driver for Ingres and OOo Could you give me some advice how to manage this problem, please? Do I need to compile the whole OOo source code, besides using the OOo SDK or should I try something totally different? sure Frank

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-04-16 Thread Joerg Budischewski
Hi, The only C++ external UNO driver component I know is the PostgreSQL SDBC driver, but this component is not a true independent extension, as it is (AFAIK) build linking against the connectivity module libraries. the postgresql driver is an implementation, that just links to ODK

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-04-16 Thread Ariel Constenla-Haile
Hi Joerg, Joerg Budischewski escribió: Hi, The only C++ external UNO driver component I know is the PostgreSQL SDBC driver, but this component is not a true independent extension, as it is (AFAIK) build linking against the connectivity module libraries. the postgresql driver is an

Re: [dba-dev] writing a new SDBC(X) driver, similar to the MySQL driver

2008-04-16 Thread Frank Schönheit - Sun Microsystems Germany
Hi Ariel, (answering the easy questions first, sorry Michael, your questions are more time-consuming to answer) * do you have any idea if external drivers linking against connectivity libs. will break in the 3-layer OOo? Joerg already pointed out that the PostgreSQL driver in fact is what