dynamobi/dynamobi — Issue #263: [LDB-58] mondrian segment load query (with complex join) results in error "ResultSet may only be accessed in a forward direction"
Author: dynamobi-build
Created: 2011-12-30 02:25:23+00:00
State: open
Labels: LDB

[reporter="boris", created="Mon, 10 Apr 2006 17:15:18 -0500 (GMT-05:00)"]
0: jdbc:luciddb:> select "time_by_day"."the_year" as "c0", "product_class"."product_department" as "c1", "product_class"."product_family" as "c2", "customer"."education" as "c3", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997", "product_class" as "product_class", "product" as "product", "customer" as "customer" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" group by "time_by_day"."the_year", "product_class"."product_department", "product_class"."product_family", "customer"."education";

Error: ResultSet may only be accessed in a forward direction. (state=24000,code=0)

Trace is here:

Apr 10, 2006 5:12:54 PM net.sf.farrago.db.FarragoDbSession prepare

INFO: select "time_by_day"."the_year" as "c0", "product_class"."product_department" as "c1", "product_class"."product_family" as "c2", "customer"."education" as "c3", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997", "product_class" as "product_class", "product" as "product", "customer" as "customer" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 and "sales_fact_1997"."product_id" = "product"."product_id" and "product"."product_class_id" = "product_class"."product_class_id" and "sales_fact_1997"."customer_id" = "customer"."customer_id" group by "time_by_day"."the_year", "product_class"."product_department", "product_class"."product_family", "customer"."education"

Apr 10, 2006 5:13:40 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException

SEVERE: error while fetching from cursor

Apr 10, 2006 5:13:40 PM FarragoUtil newSqlException

FINER: THROW

java.sql.SQLException: error while fetching from cursor

at org.eigenbase.util14.AbstractResultSet.newFetchError(AbstractResultSet.java:1358)

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:108)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Lsqlline.SqlLine;Ljava.sql.ResultSet;)V(Unknown Source)

at sqlline.SqlLine.print(Ljava.sql.ResultSet;)I(Unknown Source)

at sqlline.SqlLine$Commands.execute(Ljava.lang.String;Z)Z(Unknown Source)

at sqlline.SqlLine$Commands.sql(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.dispatch(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.begin([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.mainWithInputRedirection([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.main([Ljava.lang.String;)V(Unknown Source)

Caused by: java.lang.RuntimeException: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:80)

at net.sf.farrago.runtime.FarragoTransformImpl.restart(FarragoTransformImpl.java:117)

at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(J[B)I(Native Method)

at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:175)

at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:110)

at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)

at net.sf.farrago.dynamic.stmt50579.ExecutableStmt$2.fetchNext()Ljava.lang.Object;(Unknown Source)

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

... 9 more

Caused by: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

at net.sourceforge.jtds.jdbc.JtdsResultSet.checkScrollable(JtdsResultSet.java:316)

at net.sourceforge.jtds.jdbc.JtdsResultSet.first(JtdsResultSet.java:528)at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:73)

... 16 more

Apr 10, 2006 5:13:40 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException

SEVERE: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

Apr 10, 2006 5:13:40 PM FarragoUtil newSqlException

FINER: THROW

java.lang.RuntimeException: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:80)

at net.sf.farrago.runtime.FarragoTransformImpl.restart(FarragoTransformImpl.java:117)

at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(J[B)I(Native Method)

at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:175)

at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:110)

at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)

at net.sf.farrago.dynamic.stmt50579.ExecutableStmt$2.fetchNext()Ljava.lang.Object;(Unknown Source)

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Lsqlline.SqlLine;Ljava.sql.ResultSet;)V(Unknown Source)

at sqlline.SqlLine.print(Ljava.sql.ResultSet;)I(Unknown Source)

at sqlline.SqlLine$Commands.execute(Ljava.lang.String;Z)Z(Unknown Source)

at sqlline.SqlLine$Commands.sql(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.dispatch(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.begin([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.mainWithInputRedirection([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.main([Ljava.lang.String;)V(Unknown Source)

Caused by: java.sql.SQLException: ResultSet may only be accessed in a forward direction.

at net.sourceforge.jtds.jdbc.JtdsResultSet.checkScrollable(JtdsResultSet.java:316)

at net.sourceforge.jtds.jdbc.JtdsResultSet.first(JtdsResultSet.java:528)at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:73)

... 16 more

Apr 10, 2006 5:13:40 PM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException

SEVERE: ResultSet may only be accessed in a forward direction.

Apr 10, 2006 5:13:40 PM FarragoUtil newSqlException

FINER: THROW

java.sql.SQLException: ResultSet may only be accessed in a forward direction.

at net.sourceforge.jtds.jdbc.JtdsResultSet.checkScrollable(JtdsResultSet.java:316)

at net.sourceforge.jtds.jdbc.JtdsResultSet.first(JtdsResultSet.java:528)at org.eigenbase.runtime.ResultSetTupleIter.restart(ResultSetTupleIter.java:73)

at net.sf.farrago.runtime.FarragoTransformImpl.restart(FarragoTransformImpl.java:117)

at net.sf.farrago.fennel.FennelStorage.tupleStreamFetch(J[B)I(Native Method)

at net.sf.farrago.fennel.FennelStreamGraph.fetch(FennelStreamGraph.java:175)

at net.sf.farrago.runtime.FennelTupleIter.populateBuffer(FennelTupleIter.java:110)

at net.sf.farrago.runtime.FennelAbstractTupleIter.fetchNext(FennelAbstractTupleIter.java:99)

at net.sf.farrago.dynamic.stmt50579.ExecutableStmt$2.fetchNext()Ljava.lang.Object;(Unknown Source)

at org.eigenbase.runtime.TupleIterResultSet.next(TupleIterResultSet.java:90)

at net.sf.farrago.runtime.FarragoTupleIterResultSet.next(FarragoTupleIterResultSet.java:97)

at sqlline.SqlLine$BufferedRows.(Lsqlline.SqlLine;Ljava.sql.ResultSet;)V(Unknown Source)

at sqlline.SqlLine.print(Ljava.sql.ResultSet;)I(Unknown Source)

at sqlline.SqlLine$Commands.execute(Ljava.lang.String;Z)Z(Unknown Source)

at sqlline.SqlLine$Commands.sql(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.dispatch(Ljava.lang.String;)Z(Unknown Source)

at sqlline.SqlLine.begin([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.mainWithInputRedirection([Ljava.lang.String;Ljava.io.InputStream;)V(Unknown Source)

at sqlline.SqlLine.main([Ljava.lang.String;)V(Unknown Source)

Apr 10, 2006 5:13:40 PM net.sf.farrago.db.FarragoDbSession commitImpl

INFO: commit