Re: Query regarding derby

"A lock could not be obtained within the time requested " this exception. My queries are as follows 1. Why I am getting this exception? 2. What I should do to avoid this error? 3. How the locking mechanism working in Derby Database? This is a completely normal exception, and indicates that you

Query regarding derby

Hi Derby User Team, Do you have any updates on this issue? Since it been a long time we submitted this problem. Most of our clients are struck because of this problem. Respond as soon as possible so that we can proceed further. Suggest us how can we avoid this exception. So that we can impleme

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

Suraj Batuwana wrote: createDB.sql in the attached zip file has all the sqls for database tables, indexes and views Error comes when run SELECT * FROM vwDerbyBasePackage_derbygen_DerbyRepositoryObject67ceb178 Can use the CreateDatabase.bat to create the derby database and TestIssue.bat can use t

In response to Oracle white paper

Thanks, Kasper, for forwarding that link. Very interesting. I think it's a good sign that Oracle is spending the time and effort to produce this white paper -- it means they're getting asked about Derby in their various conversations with customers. That's a good thing. Anyway, I responded

Re: WHERE clause

From: John Embretsen <[EMAIL PROTECTED]> Subject: Re: WHERE clause Newsgroups: gmane.comp.apache.db.derby.user Date: 2006-11-29 10:53:52 GMT (11 hours and 31 minutes ago) Alan M. Feldstein wrote: > the SQL that Derby sees > > selectSql = "SELECT * FROM "ADDTestCasesResults" WHERE "chipR

RE: Help! Can't connect to DBase

Hmm, I downloaded the 10.2 version and signed it. I replaced the one I was using with the new one. Now it works again. The scary thing is that it just up and quit working. I didn't replace the jar or alter it in any way. I sure hope that doesn't happen again. Well, thanks for your help:o) -

Re: XAResource setTransactionTimeout()

Hi Prashant, Transaction timeout is not supported by Derby. setTransactionTimeout method always returns false which means setting a transaction timeout is not supported. I do not know if there is any other way to achieve the equivalent in Derby. Thanks, Deepa On 11/28/06, Prashant Bhagat <[EMA

Re: SQL for inserting BLOB data?

In the meantime, you should be able to use the String function "getByte()" (with the appropriate character coding if necessary) and then use a SerialBlob - new SerialBlob(byte[]). Donald -- Original message -- From: "Andrew McIntyre" <[EMAIL PROTECTED]> > On 1

Re: Using Derby as a binary store

Kristian Waagan wrote: Kasper Nielsen wrote: Kasper Nielsen wrote: Hi, I'm evaluating Derby for a project of mine. I really would like to avoid using SQL and just use Derby as a binary store. Is this possible? My data consists of key -> value pairs where the keys are uniformly distributed

Re: WHERE clause

Alan M. Feldstein wrote: jdb shows me the SQL that Derby sees Thread-1[1] print selectSql selectSql = "SELECT * FROM "ADDTestCasesResults" WHERE "chipRelease" = 'Sputnik001' AND "testCaseID" = 1" Thread-1[1] This Java statement resultSet = statement.executeQuery( selectSql

Re: Using Derby as a binary store

Kasper Nielsen wrote: Kasper Nielsen wrote: Hi, I'm evaluating Derby for a project of mine. I really would like to avoid using SQL and just use Derby as a binary store. Is this possible? My data consists of key -> value pairs where the keys are uniformly distributed 160 bit numbers and the

R: Use SQL parsing

Hi Bernt, I tried this way but it seems to me that the parsing is really light ... I'd like to get a deeper parse. Thanks Flavio > -Messaggio originale- > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Inviato: mercoledì 29 novembre 2006 9.41 > A: Derby Discussion > Oggetto: Re: Use

Re: Use SQL parsing

Flavio Palumbo wrote (2006-11-29 09:11:10): > Hi all, > > maybe a bit OT ... but I'd like to use the SQL parsing engine of Derby ; my > goal is to validate a string to say it's a correct SQL statement, before to > execute it. > > Is it possible with no headache ?? The easiest way is

Use SQL parsing

Hi all, maybe a bit OT ... but I'd like to use the SQL parsing engine of Derby ; my goal is to validate a string to say it's a correct SQL statement, before to execute it. Is it possible with no headache ?? Thank a lot. Flavio --- Il pre

Re: SQL for inserting BLOB data?

On 11/28/06, Ray Kiddy <[EMAIL PROTECTED]> wrote: If one is writing SQL to create tables and insert data and one has a BLOB column, how can one do this? There is not currently a way to do this with just SQL. However, there is an open JIRA for similar functionality and there has been some discu