Need to convert CURRENT_TIMESTAMP value to BIGINT

2008-01-07 Thread Suraj Batuwana
My Application is using Apache Derby 10.1.3.2 and it needs to insert current time stamp value to a column which is a BIGINT ( it can also be SMALLINT, INTEGER or DECIMAL) datatype. According to http://db.apache.org/derby/docs/10.2/ref/rrefsqlj33562.html time stamp value can't directly converted t

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

2006-12-04 Thread Suraj Batuwana
I have file a JIRA issue at https://issues.apache.org/jira/browse/DERBY-2144 Army-4 wrote: > > Suresh Thalamati wrote: >> By doing quick scan of the code, I think during the query optimization >> Derby opens all the tables and all the indexes on each table to estimate >> the costs and those

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

2006-11-30 Thread Suraj Batuwana
Hi Suresh, Many thanks for the reply. Yes, as you said jdk15 does not have the above issue. But now the big problem is my application does not support jdk15. Is there a way we can have a fix for the above issue with using the jdk14 ? -Suraj Suresh Thalamati wrote: > > Suraj Batuwana

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

2006-11-16 Thread Suraj Batuwana
From: Suraj Batuwana Sent: Wednesday, November 15, 2006 12:53 PM To: 'derby-user@db.apache.org' Subject: Error when executing query:com.ibm.websphere.ce.cm.StaleConnectionException: Meta-data for Container [EMAIL PROTECTED] could not be accessed I'm getting the following fun

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 pac

Re: Failed to start database with Derby/Websphere

2006-11-06 Thread Suraj Batuwana
application requirement I can't used the Network Server. According to some mailing groups this issue is not a bug but known problem which can be improved. If it is so it will be much help full for my application. -Suraj Suraj Batuwana wrote: > >

Failed to start database with Derby/Websphere

2006-11-05 Thread Suraj Batuwana
Hi , I have received following server side and client side(inside junit test classes) when I am running my application's nightly build for Websphere 6.0.2.5 with derby10.2.1.6. I have used IBM JDK 1.4.2 which comes with my Websphere I have used the org.apache.derby.jdbc.EmbeddedDriver as the jd

Re: Issue with Derby when using with IBM WebSphere Application Server Community Edition

2006-11-03 Thread Suraj Batuwana
s on derby.log Thanks, Suraj Suresh Thalamati wrote: > > Suraj Batuwana wrote: >> Hi Suresh, >> > >> 3.I do not see any files with zero length in the >> seg0 directory of the database. > > That's good news. zero-length files are the real scary on

Re: Issue with Derby when using with IBM WebSphere Application Server Community Edition

2006-10-30 Thread Suraj Batuwana
and boot up the derby instance. I also found that error is commong from error message coming from the derby.org.apache.derby.client.net.NetConnectionReply a class which is in the derbyclient.jar -Suraj Suresh Thalamati wrote: > > Stanley Bradbury wrote: >> Suraj Batuwana wrote: &g

RE: Issue with Derby when using with IBM WebSphere Application Server Community Edition

2006-10-27 Thread Suraj Batuwana
=testuser;bootPassword=testpass;   According to my application it is not possible to use the Network Server instance that WAS CE starts.   Thanks, Suraj From: Suraj Batuwana Sent: Thursday, October 26, 2006 10:46 AM To: 'derby-user@db.apache.org' Subject: Issue with Derby

Issue with Derby when using with IBM WebSphere Application Server Community Edition

2006-10-26 Thread Suraj Batuwana
Hi, I have received a server side error as   Error when executing query:org.apache.derby.client.am.DisconnectException: Execution failed due to a distribution protocol error that caused deallocation of the conversation.  The requested command encountered an unarchitected and implementati