Re: [dba-dev] FYI: postgresql-sdbc-0.7.6a released

2010-02-07 Thread Joerg Budischewski
n. Thanks, Zoltan Ezzel a dátummal: Sunday 07 February 2010 13.48.15 Joerg Budischewski ezt írta: Hi, the former driver versions (0.7.6 and below) do not work anymore with upcoming OOo 3.2 (see issue http://www.openoffice.org/issues/show_bug.cgi?id=108028). You can download it

[dba-dev] FYI: postgresql-sdbc-0.7.6a released

2010-02-07 Thread Joerg Budischewski
Hi, the former driver versions (0.7.6 and below) do not work anymore with upcoming OOo 3.2 (see issue http://www.openoffice.org/issues/show_bug.cgi?id=108028). You can download it from http://dba.openoffice.org/drivers/postgresql/index.html Bye, Joerg @oj: thx a lot for your hints.

[dba-dev] postgresql-sdbc-0.7.6

2008-07-23 Thread Joerg Budischewski
Hi, I'd like to announce the availability of the version 0.7.6 of the native postgresql driver for OpenOffice.org for windows and linux x86. The driver's homepage can be found here: http://dba.openoffice.org/drivers/postgresql/index.html Compared to Version 0.7.5, the following things have cha

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 li

[dba-dev] postgresql-sdbc-0.7.5

2007-08-28 Thread Joerg Budischewski
Hi, I'd like to announce the availability of the version 0.7.5 of the native postgresql driver for OpenOffice.org database API for windows and linux x86. The driver's homepage can be found here: http://dba.openoffice.org/drivers/postgresql/index.html Compared to Version 0.7.4, the following th

Re: [dba-dev] postgresql-sdbc driver installation fails

2007-05-27 Thread Joerg Budischewski
Hi, in case you are still interested, have a look at http://www.openoffice.org/issues/show_bug.cgi?id=77188 In case it works for you, let me know. (Andrew Zinn probably had dot (.) in his LD_LIBRARY_PATH). Bye, Joerg ovaldez wrote: I've followed all installation alternatives for OOo 2.0 found

Re: [dba-dev] Linkage of drivers with libraries

2006-07-10 Thread Joerg Budischewski
Hi, My suggestion is just to merge all "primary" libs into one single lib. Not sharing, merging. Not a factorization, rather an addition. Ah, okay, now I see. Yes, this would be possible. The original idea for the drivers is to be as independent as possible, but as lot of them already share

Re: [dba-dev] OOo Form Auto Fields not working correctly through PostgreSQL SDBC driver

2006-07-08 Thread Joerg Budischewski
>> hmm, don't understand why this query fails, it looks fine to me. Do >> you have an idea ? >> > The quotes are missing around the column identifier ID, so Postgres > down-cases it to "id", which does not exist. "ID" does exist in my > table however. It looks like a simple omission in this one

Re: [dba-dev] OOo Form Auto Fields not working correctly through PostgreSQL SDBC driver

2006-07-07 Thread Joerg Budischewski
Hi, "SELECT MAX(columnid)" is only a workaround, which of course isn't multi-user-safe at all. This workaround is used for databases where no other way to retrieve generated values is known - unfortunately there's no (wide-spread enough) standard to retrieve the server-side generated values afte

[dba-dev] Announcing postgresql-sdbc-0.7.2 driver for OpenOffice.org

2006-05-27 Thread Joerg Budischewski
Hi, I'd like to announce the availability of the version 0.7.2 of the native postgresql driver for OpenOffice.org database API for windows and linux x86. The driver's homepage can be found here: http://dba.openoffice.org/drivers/postgresql/index.html Compared to Version 0.7.1, the following th

Re: [dba-dev] posgresql-sdbc-0.7.1 syntax error filtering by a date column

2006-05-26 Thread Joerg Budischewski
Hi, Frank Schönheit - Sun Microsystems Germany wrote: Hi Jörg, Ocke, @Frank, Ocke: Can I influence somehow, how date literals are added to queries created in the design view ? I'm sorry to say but it is at the moment not possible to turn this feature off. There the parse nodes for th

Re: [dba-dev] posgresql-sdbc-0.7.1 syntax error filtering by a date column

2006-05-22 Thread Joerg Budischewski
Hi, @Frank, Ocke: Can I influence somehow, how date literals are added to queries created in the design view ? @Moritz: You can deselect the "View/Switch on Design View On/Off" in the query designer and modify the query by hand (remove the '{D' and the '}'. Bye, Joerg Moritz Rempel wrote:

[dba-dev] Announcing postgresql-sdbc-0.7.1 driver for OpenOffice.org

2006-05-01 Thread Joerg Budischewski
I'd like to announce the availability of the version 0.7.1 of the native postgresql driver for OpenOffice.org database API for windows and linux x86. The driver's homepage can be found here: http://dba.openoffice.org/drivers/postgresql/index.html Compared to Version 0.7.0, the following thin

Re: [dba-dev] SDBC (PostgreSQL) and domains

2006-04-02 Thread Joerg Budischewski
Hi, Two somewhat related queries: 1. In my database, I defined a number of domains. Those domains are basically all constrained versions of one of: int2, bpchar(1) or bpchar(2). Unfortunately, it seems that, through OOoBase's SDBC driver, I cannot access (neither read nor write) the corre

[dba-dev] Announcing postgresql-sdbc-0.7.0 driver for OpenOffice.org

2006-01-22 Thread Joerg Budischewski
Hi, I'd like to announce the availability of the version 0.7.0 of the native postgresql driver for OpenOffice.org database API for windows and linux x86. The driver's homepage can be found here: http://dba.openoffice.org/drivers/postgresql/index.html Compared to Version 0.6.2, the following

Re: [dba-dev] postgresql sdbc driver

2006-01-08 Thread Joerg Budischewski
Hi, I currently don't have time to update it. Use the program/unopkg add instead of pkgchk. In case this raises errors (or you don't get a postgresql option in the database dialog), note, that it may not work, when you use the debian built OOo. You'll then need someone to rebuilt the drive

Re: [dba-dev] vacation notice

2005-09-06 Thread Joerg Budischewski
Hi, > Depending on how much sleep my new-born daughter Congratulations for your new 'lifetime-task' :-). > will allow me in the near future, I might be able to return to normal > work in about two weeks or so :) we will see ... Bye, Joerg -

Re: [dba-dev] Current status of PG driver?

2005-08-09 Thread Joerg Budischewski
Hi, the driver is working with OOo1.1 und preOOo2.0 and is still maintained by me (though I haven't done anything on it for some months now). Josh Berkus wrote: Joerg, I've been offered some corporate help on the PostgreSQL SDBC. What needs to be done on it? there are several issues,

Re: [dba-dev] Location Of JDBC Code In OpenOffice

2005-07-01 Thread Joerg Budischewski
Hi, you can find the jdbc driver implementation here http://dba.openoffice.org/source/browse/dba/connectivity/source/drivers/jdbc/ , but this is c++ code calling jdbc code via jni, don't know, if you can read this. When this happens on linux, you can try to get a sensible native stacktrace

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-20 Thread Joerg Budischewski
Hi, >>hat does a> >>netstat -a | grep PGSQL >> > > This yealds nothing ;( I think, this points to the source of the problem. You use the postgresql shipping with debian, can it be possible, that they patched the default connection path to something else ? Try a netstat -a | grep 5432 and when this

[dba-dev] [Fwd: Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]]

2005-03-19 Thread Joerg Budischewski
there has been a typo in the address --- Begin Message --- Hi Joerg, * Joerg Budischewski <[EMAIL PROTECTED]> [180305, 22:21]: > > is your server configured to serve tcp/ip requests (-i option) ? If not, > try leaving away the "host=local" phrase, the driver wil

[dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-19 Thread Joerg Budischewski
Hi, is your server configured to serve tcp/ip requests (-i option) ? If not, try leaving away the "host=local" phrase, the driver will then use unix domain sockets. OK, I commented out the tcp/ip option in hba.conf, left away all that follows the "sdbc:postgres:" string but the result is always

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-19 Thread Joerg Budischewski
Hi, After having solved this, you are going to have a problem with the user authentication. Leave the "user=" phrase away, and hit the 'unnamed' tab within the data source dialog between General and Table, fill in your user name and check the "password required" flag. Can you explain why this i

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-18 Thread Joerg Budischewski
ot; phrase away, and hit the 'unnamed' tab within the data source dialog between General and Table, fill in your user name and check the "password required" flag. Bye, Joerg Ennio-Sr wrote: Hi Joerg, thank you for answering my post. * Joerg Budischewski <[EMAIL PRO

Re: [dba-dev] Re: [For Josh Berkus]_[OT]OOo, ODBC and PostgreSQL database]

2005-03-17 Thread Joerg Budischewski
Hi, I tried SDBC connection also and I'm getting the same error: complaining about user and password (that, of course, are correct). How do you pass user and password currently with the sdbc driver ? Did you have a look at the postgres server log about the concrete error message of your authentica

Re: [dba-dev] Speaking of the PostgreSQL driver ...

2005-03-14 Thread Joerg Budischewski
Josh Berkus wrote: ... is it going to ship with OOo 2.0?Even if it's beta, it's fairly functional, and would make life easier for a lot of users. The license shouldn't be a problem, the PostgreSQL libraries are BSD. Hi, it's one of my next tasks, but I temporarily can't spend time on OOo

Re: [dba-dev] New user of postgresql drivers

2005-01-25 Thread Joerg Budischewski
Hi, in case you engage problems with the postgresql-openoffice interaction, you should switch to version 0.6.2, it has some major improvements over over 0.5.0. Yes, I'll do that soon. I assume the 0.6.2 version is simply 'further along the development road' and isn't likely to be any *less* re

Re: [dba-dev] New user of postgresql drivers

2005-01-24 Thread Joerg Budischewski
Hi, Chris Green wrote: I've just installed the postgresql SDBC drivers (version 0.5 at the moment) in case you engage problems with the postgresql-openoffice interaction, you should switch to version 0.6.2, it has some major improvements over over 0.5.0. Bye, Joerg