Re: How do I Open / Close a db using odbc interface?

m96 wrote: hi, checkout [3]. since i had a crashing and freezing problem with odbc connections from MS Query and Brio i couldn't test it if it also works from ODBC. just check your derby log to see if the db is booted and shutdown. cheers... [3]

Re: How do I Open / Close a db using odbc interface?

Thanks - the shutdown is what I was looking for. Now I have a couple of questions: 1. How do I use it from the odbc interface? do I just perform an SQL statement with the shutdown command? 2. How do I turn the DB back on? Thanks, Yaron m96 wrote: hi, checkout [3]. since i had a crashing

Re: Derby db - need to disable improved performance

I think I found the reseon for the improved performance in derby db: I downloaded the source files of derby db and searched for 'sync' or 'fsync'. Searching for 'sync' brought too many results, but 'fsync' was found in only one file: engine/org/apache/derby/impl/store/raw/log/LogToFile.java

Re: Difference between two timestamp fields

Dmitri Pissarenko wrote: Hello! I need to calculate the difference between two timestamp fields in seconds. I tried this query: SELECT APP.MyTable.startTime, {fn TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND, APP.MyTable.startTime, APP.MyTable.endTime)} FROM APP.MyTable WHERE APP.MyTable IS NOT NULL

security-related incompatibility to be introduced by Derby 10.3

The upcoming release of Derby 10.3 will make networked configurations safer by installing a Java security manager if the user forgets to install one. This will happen only if the user boots the network server without installing a security manager. As a result, it will be harder for hackers to

Number of connections supported by Derby

Hi, What is the limit of concurrent connections that Derby can handle? Thanks, Lorenzo Jimenez Si usted no es el destinatario indicado en este mensaje o responsable como persona de la entrega del mensaje, no debe copiar o reenviar este mensaje, por favor notifique al correo [EMAIL PROTECTED]