Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Is there a bug in the ojFormLayout / user-assistance-density?

User_QH8O4Aug 9 2022

We have a form set-up with the form layout user-assistance-density = 'compact' and the hover over question marks work everywhere except select-many and combobox-many. This can be duplicated in the cookbook ( Form Layout | Overview | JET Developer Cookbook (oracle.com) ) with the following set-up:
User Assistance Density = 'compact'
help-hints.definition = checked
After setting the form up, the hover feature works on everything except the 'many' boxes. Am I missing something or is this a bug?
2022-08-09_15-00-13.png2022-08-09_14-57-41.png

Comments

843859
I modified the xml like this: 
	<parameterMap id="parameterErroriMap" class="errori">
		<parameter property="cod_err"         jdbcType="INT" 		javaType="Integer"/>
                <parameter property="lang"            jdbcType="VARCHAR" 	javaType="String"/>		
                <!-- misses text - dt_ins is datetime in the db table-->
		<parameter property="dt_ins"          jdbcType="VARCHAR" 	javaType="String"/>
		<!-- misses text-->
	</parameterMap>

  <update id="updateErrori" parameterMap="parameterErroriMap">
  	update Errori SET dt_ins = ?
  	where cod_err = ? AND lang = ?
  </update>
But now I get the following error:

org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/domain/dao/sqlmap/Errori.xml.
--- The error occurred while applying a parameter map.
--- Check the Errori.parameterErroriMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String data truncated
at java.lang.Throwable.<init>(Throwable.java:59)
at java.lang.Throwable.<init>(Throwable.java:89)
at org.springframework.core.NestedRuntimeException.<init>(NestedRuntimeException.java:58)
at org.springframework.dao.DataAccessException.<init>(DataAccessException.java:55)
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.update(SqlMapClientTemplate.java:411)
at com.persistence.sqlmapdao.ErroriSqlMapDao.updateErrori(ErroriSqlMapDao.java)
at com.service.impl.SisErroriServiceImpl.updateErrori(SisErroriServiceImpl.java:41)
at com.sysdat.servlet.SysdatHttpServlet.doPost(SysdatHttpServlet.java:77)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
843859
I found out the solution!

In the file xml I modified the code like this:
<typeAlias alias="errori" type="com.domain.Errori"/>

 <update id="updateErrori" parameterClass="errori" >
  	update Errori SET des_err = #des_err:VARCHAR#, tp_err = #tp_err:VARCHAR#, fg_consmod = #fg_consmod:VARCHAR#, fg_reg = #fg_reg:VARCHAR#, help = #help:VARCHAR#, orig_err = #orig_err:VARCHAR#, dt_ins = #dt_ins:TIMESTAMP#, id_help = #id_help:NUMERIC#, modulo = #modulo:VARCHAR#, livelo = #livelo:NUMERIC#, cod_ute = #cod_ute:VARCHAR#, flag_ins = #flag_ins:VARCHAR#
  	where cod_err = #cod_err# AND lang = #lang#
  </update>
Thanks and regards
1 - 2

Post Details

Added on Aug 9 2022
#form, #html, #oracle-jet
1 comment
185 views