db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravinder Reddy Pandiri <pand...@students.iiit.ac.in>
Subject help requires regarding get cursor..!!
Date Thu, 02 Aug 2007 19:11:48 GMT

 	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:

testRenameOpenCursoredTable(org.apache.derbyTesting.functionTests.tests.lang.RenameTableTest)java.sql.SQLException:

Syntax error: Encountered "get" at line 1, column 1.
         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
         at org.apache.derbyTesting.functionTests.tests.lang.RenameTableTest.testRenameOpenCursoredTable(RenameTableTest.java:66)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:83)
Caused by: ERROR 42X01: Syntax error: Encountered "get" at line 1, column 
1.      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
         at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source)
         at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
         at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
         at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
         ... 19 more


Thanks in Advance.

Ravinder
-- 
******************************************************************************

    Every problem that has been solved can be solved again in a better way

                                                   - Ravinder Reddy

*******************************************************************************


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


Mime
View raw message