Re: Shutting down built-in Derby

Dmitri, you seem to ave truncated the root cause. Can you please provide the entire exception chain? Dmitri Pissarenko wrote: Hello! I'm using Derby database, which is delivered together with Java 1.5/1.6. One of my applications crashed without closing the connection to Derby and I get

Re: Question: How to start Derby from a remote address

Jean, I believe that you can start/stop a service remotely on Windows NT+ if the target macine is running Netsvc.exe (http://support.microsoft.com/kb/166819). One idea would be to logon to the remote machine and register the database startup script as a Windows service. From that point on,

Re: how i can create a datasource in java code when i have connection url?

You can create a new embedded DataSource by virtue of instantiating a new EmbeddedDataSource. For example: EmbeddedDataSource dataSource = new EmbeddedDataSource(); dataSource.setDataSourceName(dsname); dataSource.setUser(APP); dataSource.setPassword(APP);

Re: unique and null

You might have missed my previous post regarding null unique columns: 12/12/2006 2:45 PM : Jose de Castro wrote: I found a way around this issues while converting my application from MySQL to Derby. It appears that Derby will allow nullable columns in unique constraints if defined

Re: Derby in front of Oracle

You might want to check out Sequoia or HA-JDBC . They are both very reliable JDBC clustering engines. You might be able to configure it so the Oracle box only appears to be up every so often. http://sequoia.continuent.org/HomePage http://ha-jdbc.sourceforge.net/ Yekesa Kosuru wrote: Hi All,

Re: Already created, embedded db in Java6

to the database's parent directory. For example, if your database resides in /tmp/databases/salesdb , your derby.system.home property should be set to /tmp/databases/. See the Derby Developer Guide for more information about how Derby establishes a System Environment at runtime. Hope this helps, Jose de

Timestamp Arithmetic

documentation and tried both of the aforementioned solutions with no success. I am running the latest stable Derby build (10.2) on a Windows XP box. What is the correct way of doing this in Derby? Thanks in advance, Jose de Castro Senior Software Engineer Voxeo Corporation [EMAIL PROTECTED]

Re: Timestamp Arithmetic

You learn something new every day. A whole aspect of JDBC of which I was completely unaware. Thanks Rajesh :) Rajesh Kartha wrote: Jose de Castro wrote: I trying to calculate the duration (in seconds) between two timestamps. Historically, I have either used a non-standard function

Re: Query regarding derby

You could use the dblook command. It is well documented in derbytools.pdf in your installation's /docs /directory. Sridharsingh Inder wrote: Hi Derby Team, In Apache Derby, to see the table structure which command can I use? (as in Oracle's desc table name ) Best Regards, Sridhar

NPE in setTimestamp(int,Timestamp,Calendar)

A NullPointerException occurs if you pass in a null Timestamp into org.apache.derby.client.am.PreparedStatement.setTimestamp(int,Timestamp,Calendar) Does anyone know if this is being addressed in 10.3? I have included a suggested fix. Is this something I should add to JIRA? public