Re: Should getTableTypes() return GLOBAL TEMPORARY as a tab;e type?

2007-08-13 Thread Ravinder Reddy Pandiri
On Mon, 13 Aug 2007, Daniel John Debrunner wrote: Daniel John Debrunner wrote: Kathey Marsden wrote: In looking at DERBY-3000 it occurred to me that perhaps we should return GLOBAL TEMPORARY in getTableTypes() or is there a reason that we do not? Why would we? getTableTypes(): Retrieves

Creating an Open cursor..

2007-08-07 Thread Ravinder Reddy Pandiri
hi , In one of the JUnit testcases I need to have an OpenCursor. what's wrong with the following code.? Statement s = createStatement(ResultSet.TYPE_FORWARD_ONLY , ResultSet.CONCUR_UPDATABLE); assertUpdateCount(s , 0 , create table t2(c21 int not null

Re: Creating an Open cursor..

2007-08-07 Thread Ravinder Reddy Pandiri
On Tue, 7 Aug 2007, Daniel John Debrunner wrote: Ravinder Reddy Pandiri wrote: assertUpdateCount(s , 0 , create table t2(c21 int not null primary key)); assertUpdateCount(s , 1 , insert into t2 values(21)); assertUpdateCount(s , 1 , insert into t2 values(22

help requires regarding get cursor..!!

2007-08-02 Thread Ravinder Reddy Pandiri
hi, I am getting the following error while executing the the line s.executeUpdate(get cursor c1 as 'select * from t2'); in one of the testcases of DERBY-2968. The Error is:

reg: DatabaseMetaData.getTables()

2007-08-01 Thread Ravinder Reddy Pandiri
hi, In one of the JUnit test cases I have the following code. Statement s = createStatement(); DatabaseMetaData databaseMetaData; databaseMetaData = getConnection().getMetaData(); ResultSet rs1 = databaseMetaData.getTables(, null, %,

Re: regarding unique keys in derby..

2007-07-23 Thread Ravinder Reddy Pandiri
On Fri, 20 Jul 2007, Kathey Marsden wrote: Ravinder Reddy wrote: hi all, w.r.t DERBY-2945(convert lang/primarykey.sql to junit) I have a small doubt. There is a test for verifying a unique key can not contain nulls. 1)-- verify that a unique key can not contain nulls create