dynamobi/dynamobi — Issue #270: [LDB-51] select query on foreign table for oracle and sqlserver fail
Author: dynamobi-build
Created: 2011-12-30 02:25:53+00:00
State: closed
Labels: LDB

[reporter="elin", created="Fri, 24 Mar 2006 17:20:52 -0500 (GMT-05:00)"]
To reproduce:

---------------------

create schema s;

set schema 's';

create foreign data wrapper orcl_jdbc

library '/home/elin/open/luciddb/plugin/FarragoMedJdbc3p.jar'

language java;

create server orcl_server

foreign data wrapper orcl_jdbc

options(

url 'jdbc:oracle:thin:@akela.lucidera.com:1521:XE',

user_name 'schoi',

password 'schoi',

driver_class 'oracle.jdbc.driver.OracleDriver'

);

create foreign table BENCH_SOURCE_100 (

C1 INTEGER,

C2 INTEGER,

C4 INTEGER,

C5 INTEGER,

C10 INTEGER,

C25 INTEGER,

C100 INTEGER,

C1K INTEGER,

C10K INTEGER,

C40K INTEGER,

C100K INTEGER,

C250K INTEGER,

C500K INTEGER)server orcl_server

options (

SCHEMA_NAME 'SCHOI',

TABLE_NAME 'bench100'

);

select * from BENCH_SOURCE_100;

Here's the stack trace:

-------------------------------

0: jdbc:luciddb:> select count(*) from BENCH_SOURCE_100;

Error: java.lang.NoSuchFieldError: ENABLE_NEW_ITER (state=,code=0)

net.sf.farrago.jdbc.FarragoJdbcUtil$FarragoSqlException: java.lang.NoSuchFieldError: ENABLE_NEW_ITER

at net.sf.farrago.namespace.jdbc.ResultSetToFarragoIteratorConverter.getResultSetIteratorClass(ResultSetToFarragoIteratorConverter.java:203)

at net.sf.farrago.namespace.jdbc.ResultSetToFarragoIteratorConverter.implement(ResultSetToFarragoIteratorConverter.java:192)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChildInternal(JavaRelImplementor.java:387)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:180)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at org.eigenbase.oj.rel.JavaRelImplementor.visitJavaChild(JavaRelImplementor.java:343)

at org.eigenbase.oj.rel.IterCalcRel.implement(IterCalcRel.java:282)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChildInternal(JavaRelImplementor.java:387)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:180)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at org.eigenbase.oj.rel.JavaRelImplementor.visitJavaChild(JavaRelImplementor.java:343)

at net.sf.farrago.query.IteratorToFennelConverter.implementFennelChild(IteratorToFennelConverter.java:402)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:178)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at net.sf.farrago.query.FennelAggRel.implementFennelChild(FennelAggRel.java:72)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:178)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at net.sf.farrago.query.FennelSingleRel.implementFennelChild(FennelSingleRel.java:102)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:178)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at net.sf.farrago.query.FennelToIteratorConverter.implement(FennelToIteratorConverter.java:157)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChildInternal(JavaRelImplementor.java:387)

at net.sf.farrago.query.FarragoRelImplementor.visitChildInternal(FarragoRelImplementor.java:180)

at org.eigenbase.oj.rel.JavaRelImplementor.visitChild(JavaRelImplementor.java:355)

at org.eigenbase.oj.rel.JavaRelImplementor.visitJavaChild(JavaRelImplementor.java:343)

at org.eigenbase.oj.rel.JavaRelImplementor.implementRoot(JavaRelImplementor.java:404)

at net.sf.farrago.query.FarragoRelImplementor.implementRoot(FarragoRelImplementor.java:323)

at org.eigenbase.oj.stmt.OJPreparingStmt.implement(OJPreparingStmt.java:301)

at org.eigenbase.oj.stmt.OJPreparingStmt.prepareSql(OJPreparingStmt.java:256)

at net.sf.farrago.query.FarragoPreparingStmt.prepare(FarragoPreparingStmt.java:237)

at net.sf.farrago.db.FarragoDatabase$2.initializeEntry(FarragoDatabase.java:664)

at net.sf.farrago.util.FarragoObjectCache.pin(FarragoObjectCache.java:157)

at net.sf.farrago.db.FarragoDatabase.prepareStmtImpl(FarragoDatabase.java:674)

at net.sf.farrago.db.FarragoDatabase.prepareStmt(FarragoDatabase.java:554)

at net.sf.farrago.db.FarragoDbSession.prepareImpl(FarragoDbSession.java:838)

at net.sf.farrago.db.FarragoDbSession.prepare(FarragoDbSession.java:780)

at net.sf.farrago.db.FarragoDbStmtContext.prepare(FarragoDbStmtContext.java:158)

at net.sf.farrago.jdbc.engine.FarragoJdbcEngineStatement.execute(FarragoJdbcEngineStatement.java:104)

at sqlline.SqlLine$Commands.execute(Unknown Source)

at sqlline.SqlLine$Commands.sql(Unknown Source)

at sqlline.SqlLine.dispatch(Unknown Source)

at sqlline.SqlLine.begin(Unknown Source)

at sqlline.SqlLine.mainWithInputRedirection(Unknown Source)

at sqlline.SqlLine.main(Unknown Source)

0: jdbc:luciddb:>