Re: [OT] Two suggestions on list management...

2006-11-14 Thread Bernt M. Johnsen
Bernt M. Johnsen wrote (2006-11-13 23:12:04): The rest of this mail should be directed to [EMAIL PROTECTED] [FYI] Since only comitters are allowed to mail on [EMAIL PROTECTED], I forwarded your mail there. Reply from infrastructure: For example, the Dovecot mailing list will include

Query regarding derby

2006-11-14 Thread Sridharsingh Inder
Hi Derby User Team, Do you have any updates on this issue? Best Regards, Sridhar - Forwarded by Sridharsingh Inder/LNTINFOTECH on 11/14/2006 05:50 PM - Sridharsingh Inder/LNTINFOTECH 11/10/2006 11:17 AM To derby-user@db.apache.org cc derby-user@db.apache.org, [EMAIL

Re: Query regarding derby

2006-11-14 Thread Julius.Stroffek
Hi Sridharsingh, I asked some more questions about this, the code you send looks alright but does not explain anything related to the problem you are having. --- Is it possible for you to upgrade to a newer version of Derby? I think the version 10.0 is not supported by the community any more.

Timestamp Arithmetic

2006-11-14 Thread Jose de Castro
I trying to calculate the duration (in seconds) between two timestamps. Historically, I have either used a non-standard function such as DateDiff in SQL Server and MySQL or performed a direct arithmetic calculation (i.e. timestamp1-timestamp2) in PostgreSQL. I have searched the reference

Re: Timestamp Arithmetic

2006-11-14 Thread Rajesh Kartha
Jose de Castro wrote: I trying to calculate the duration (in seconds) between two timestamps. Historically, I have either used a non-standard function such as DateDiff in SQL Server and MySQL or performed a direct arithmetic calculation (i.e. timestamp1-timestamp2) in PostgreSQL. I have

RE: Large IN clause produces server error

2006-11-14 Thread Michael Segel
Can you provide the query? 1800 items in an IN clause? That doesn't sound right or efficient. Why not use a subselect? -Original Message- From: Robert Enyedi [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 14, 2006 9:51 AM To: Derby Discussion Subject: Large IN clause produces

Re: Timestamp Arithmetic

2006-11-14 Thread Jose de Castro
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 such as

Re: A new derby tutorial

2006-11-14 Thread Laura Stewart
When tutorials like this come out, is a link added from the Derby web pages to these tutorials or just announced on the lists? On 11/8/06, Jean T. Anderson [EMAIL PROTECTED] wrote: This came out today: http://www.regdeveloper.co.uk/2006/11/08/java_database_derby/ -jean -- Laura Stewart

Re: A new derby tutorial

2006-11-14 Thread Jean T. Anderson
Laura Stewart wrote: When tutorials like this come out, is a link added from the Derby web pages to these tutorials or just announced on the lists? I added a link to it on this wiki page: http://wiki.apache.org/db-derby/WorkingWithDerby -jean On 11/8/06, Jean T. Anderson [EMAIL PROTECTED]

drop table cascade?

2006-11-14 Thread Bryan Pendleton
I think that Derby currently does not support a CASCADE option on the DROP TABLE statement. I searched Jira and found DERBY-1631, which discusses the desire for a CASCADE option on DROP VIEW, but I could not find a Jira issue logged to request a CASCADE option on DROP TABLE. Is there such a

Error when executing query:com.ibm.websphere.ce.cm.StaleConnectionException: Meta-data for Container [EMAIL PROTECTED] could not be accessed

2006-11-14 Thread Suraj Batuwana
I'm getting the following fun stack trace (in attached derby.log) when using embedded network server derby 10.2.1.6 and was would like to know if anyone knows what might cause this to error. I am using IBM JDK 1.4.2 with the Websphere 6.0.2.5 as the application server on Windows XP with service