I am trying to replace my Oracle database by an equivalent (embedded)
Apache Derby database. Everything works fine until I specify an integer
value in the maxRows attribute (as opposed to using the value *).
Specifying a value of 1 generates the following error...
<db:dbform tableName="client"
whereClause="<%= whereClause.toString() %>"
maxRows="1"
formValidatorName="client"
javascriptValidation="true"
displayFieldsOnError="true"
followUp="<%= followUp.toString() %>">
ERROR 54738 [http-8080-Processor24] (DataSource.java:109) ERROR
org.dbforms.event.datalist.dao.DataSource - getCurrent
SQL Exception: The 'getRow()' method is only allowed on scroll cursors.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.checkScrollCursor(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.getRow(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingResultSet.getRow(DelegatingResultSet.j
ava:253)
at
org.dbforms.event.datalist.dao.DataSourceJDBC.checkResultSetEnd(DataSour
ceJDBC.java:590)
at
org.dbforms.event.datalist.dao.DataSourceJDBC.getRow(DataSourceJDBC.java
:341)
at
org.dbforms.event.datalist.dao.DataSource.getResultSetVector(DataSource.
java:562)
at
org.dbforms.event.datalist.dao.DataSource.getCurrent(DataSource.java:107
)
at
org.dbforms.event.datalist.dao.DataSourceFactory.getCurrent(DataSourceFa
ctory.java:95)
at
org.dbforms.event.datalist.GotoEvent.processEvent(GotoEvent.java:261)
at org.dbforms.taglib.DbFormTag.doStartTag(DbFormTag.java:1829)
at org.apache.jsp.client_jsp._jspService(client_jsp.java:204)
Any ideas on how to fix this problem?
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
