Webflow: SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'set'.

SEVERE: Servlet.service() for servlet apr threw exception
org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'set'. One of '{"http://www.springframework.org/schema/webflow":attribute}' is expected.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:195)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:131)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:384)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:318)

Dapat agak error ni sebab salah letak attribut, tapi jenuh jugak la nak cari. Hilang setengah hari.
Rupa2nya sebab ini:


<evaluate expression="studyPlanFrmService.saveStudyPlan(flowScope.studyPlanForm)" result="flowScope.studyPlanform">
<set name="flowScope.msj" value="flowScope.studyPlanForm.formMessage" ></set>
</evaluate>

<set></set> tak boleh diletak dalam <evaluate></evaluate> ???
Tak kisahlah, asal jalan kod aku.

Assert: The expression string to parse is required and must not empty

Buang masa juga DEBUG ERROR ni, hanya kerana TRY & ERROR.

 Punca: 

 <display:column>  
      <form:checkbox path="studyPlanDetailList[${spd_rowNum-1}].selected" value="Y" />  
 </display:column>  

 Sepatutnya:

 <display:column>  
      <form:checkbox path="studyPlanDetailList[${spd_rowNum-1}].selected" value="Y">  
 </form:checkbox></display:column>  

WebFlow: Error semasa transition utk hasil evaluate Boolean

ERROR:

org.springframework.webflow.engine.NoMatchingTransitionException: No transition was matched on the event(s) signaled by the [1] action(s) that executed in this action state 'checkAuthorization' of flow 'marking/apr'; transitions must be defined to handle action result outcomes -- possible flow configuration error? Note: the eventIds signaled were: 'array<String>['no']', while the supported set of transitional criteria for this action state is 'array<TransitionCriteria>[true, false]'

Punca:

Silap nilai transition semasa evaluate function yang memulangkan nilai Boolean

 <action-state id="checkAuthorization">
     <evaluate expression="aprService.isAuthorized(requestScope.viewerId, requestScope.aprId)" />
     <transition on="true" to="markingEntry" />
     <transition on="false" to="summary" />
</action-state>

Sepatutnya true dan false itu ditukarkan kepada yes dan no.

Ibatis: Invalid column name

java.sql.SQLException: Invalid column name

1. Semak dan pastikan semua colum dalam sql ada pada result-mapping.

at com.ibatis.sqlmap.engine.type.StringTypeHandler.getResult(StringTypeHandler.java:35)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getPrimitiveResultMappingValue(ResultMap.java:619)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getResults(ResultMap.java:345)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:384)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:300)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:189)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)

FRM-41214 : Unable to run report

Recently I found FRM-41214 error while try to run report from Form. All of them work well on Report Builder.

So, I assume there are sumtin wrong with my LOC on forms.

I found source of the problem, which r I send date parameter as string with conversion/cast. [to_char(:date_from,'dd-mm-rrrr')]

So, u may send date as string but never ever try to cast it to string/char.

Well, thats sure means we cant send wrong parameter type.