Looks like Oracle resultset implementation doesn't like isLast()
public boolean TableTool::hasNext()
{
try
{
return !(rs.isLast() || this.isEmpty);
}
catch (SQLException se)
{
System.err.println("SQLException :");
se.printStackTrace();
}
return false;
}
Ilia
-----Original Message-----
From: Jason van Zyl [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 11:27 AM
To: Turbine Users List
Subject: Re: TorqueDataDumpTask problem
On 11/1/01 2:22 PM, "Ilia Iourovitski" <[EMAIL PROTECTED]> wrote:
> I'm trying to dump data from database and I got the following
exception.
>
> java org.apache.tools.ant.Main -emacs -emacs -buildfile build.xml
> project-datadump
> Buildfile: build.xml
>
> init-tasks:
>
> project-datadump:
> +-----------------------------------------------+
> | |
> | Dumping the data from database into XML |
> | Woo hoo! |
> | |
> +-----------------------------------------------+
> taking build.properties from: build.properties
> report.apc.datadump.generation
> Resolver: used database.dtd from
> org.apache.torque.engine.database.transform package
> Your DB settings are:
> driver : oracle.jdbc.driver.OracleDriver
> URL :
> user :
> password :
> DB driver sucessfuly instantiated
> DB connection established
Some of your properties don't seem to be filled in?
This task will be added to the testbed by Monday. I don't know what the
problem is off the top of my head.
j k
> fetching table FOO_TBLSQLException :
> java.sql.SQLException: Invalid operation for forward only resultset :
> isLast
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> at
>
oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:2
> 88)
> at
>
org.apache.torque.task.TorqueDataDumpTask$TableTool.hasNext(TorqueDataDu
> mpTask.java:381)
> at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java)
> at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
> .java)
> at
> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java)
> at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java)
> at
>
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective
> .java)
> at
>
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.jav
> a)
> at org.apache.velocity.Template.merge(Template.java)
> at org.apache.velocity.texen.Generator.parse(Generator.java)
> at
> org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java)
> at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:164)
> at org.apache.tools.ant.Target.performTasks(Target.java:182)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.Project.executeTargets(Project.java:560)
> at org.apache.tools.ant.Main.runBuild(Main.java:454)
> at org.apache.tools.ant.Main.start(Main.java:153)
> at org.apache.tools.ant.Main.main(Main.java:176)
>
> Ilia
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
