Re: [dba-dev] Driver to use with Oracle DB

2010-03-18 Thread Pavel Lastovicka
sgautier@free.fr napsal(a): Hi all, Could you advise me what is the best driver to use with an Oracle database (10.2 64bit), is it the JDBC drive provided by Oracle or did an ODBC driver will provide better performances and/or robustness? Thanks in advance Kind regards Sophie Hello

Re: [dba-dev] forms cannot handle Oracles mode of generated values

2009-12-15 Thread Pavel Lastovicka
Hello Peter, the same problem gave me a lot of headaches the last few days. I even thought that one week of work migrating my OO.o database to Oracle will be in vain. Moreover in database's anvanced properties there are some input fields relating to autoincrement column. This setting did not

[dba-dev] OO.o hangs on SQL DELETE execution

2009-12-11 Thread Pavel Lastovicka
Hello, I experience a nasty hang in OpenOffice.org. In my basic macro I call an SQL statement via executeUpdate on XStatement. The command is: DELETE FROM tablename It hangs and OO.o has to be killed. My DB connection is via ODBC to Oracle but I think I hit the same problem with MySQL ODBC