Silverpeas » Silverpeas Components » MyDB

Bonjour,

J'essai désespérément d'utiliser un champ booléen pour une table myDB mais sans succès.

J'ai essayé les syntaxes suivantes :
't' OU 'f'
'true' OU 'false' (impossible le champ n'a qu'une taille de 1 !!!)
'0' ou '1'

J'ai aussi essayé avec des doubles cotes.

Mais rien ne fonctionne.
Lorsque je valide ma création d'enregistrement j'ai le message suivant :

Erreur lors de la modification de la ligne :
ERREUR: la colonne « augmentedvalley » est de type boolean mais l'expression est de type character varying Indice : Vous devez réécrire l'expression ou lui appliquer une transformation de type. Position : 129

Et côté trace c'est pas mieux :

14:30:09,112 INFO [STDOUT] ERROR : util.MSG_EXCEPTION_NOT_EMBEDED | MODULE : util.HomePageUtil.traceException() | Exception non encapsul´┐¢e dans une Silverpeas...Exception (EXCEPTION : java.lang.Num
berFormatException: For input string: "f"
14:30:09,112 INFO [STDOUT] at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
14:30:09,112 INFO [STDOUT] at java.lang.Integer.parseInt(Integer.java:449)
14:30:09,112 INFO [STDOUT] at java.lang.Integer.parseInt(Integer.java:499)
14:30:09,112 INFO [STDOUT] at com.silverpeas.mydb.control.MyDBSessionController.setValueByType(MyDBSessionController.java:1295)
14:30:09,112 INFO [STDOUT] at com.silverpeas.mydb.control.MyDBSessionController.createDbLine(MyDBSessionController.java:861)
14:30:09,112 INFO [STDOUT] at com.silverpeas.mydb.servlets.MyDBRequestRouter.getUpdateLineDestination(MyDBRequestRouter.java:254)
14:30:09,112 INFO [STDOUT] at com.silverpeas.mydb.servlets.MyDBRequestRouter.getDestination(MyDBRequestRouter.java:114)
14:30:09,112 INFO [STDOUT] at com.silverpeas.mydb.servlets.MyDBRequestRouter.getDestination(MyDBRequestRouter.java:53)
14:30:09,127 INFO [STDOUT] at com.stratelia.silverpeas.peasCore.servlets.ComponentRequestRouter.computeDestination(ComponentRequestRouter.java:247)
14:30:09,127 INFO [STDOUT] at com.stratelia.silverpeas.peasCore.servlets.ComponentRequestRouter.doPost(ComponentRequestRouter.java:133)
14:30:09,127 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
14:30:09,127 INFO [STDOUT] at com.stratelia.silverpeas.peasCore.servlets.SilverpeasHttpServlet.service(SilverpeasHttpServlet.java:49)
14:30:09,127 INFO [STDOUT] at com.stratelia.silverpeas.peasCore.servlets.SilverpeasAuthenticatedHttpServlet.service(SilverpeasAuthenticatedHttpServlet.java:81)
14:30:09,127 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:324)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,127 INFO [STDOUT] at com.silverpeas.whitePages.filters.ComponentRequestRouterFilter.doFilter(ComponentRequestRouterFilter.java:74)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,127 INFO [STDOUT] at org.silverpeas.web.filter.MassiveWebSecurityFilter.doFilter(MassiveWebSecurityFilter.java:193)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,127 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,143 INFO [STDOUT] at org.silverpeas.web.filter.InternetExplorerAntiCompatibilityFilter.doFilter(InternetExplorerAntiCompatibilityFilter.java:48)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,143 INFO [STDOUT] at org.silverpeas.web.token.SessionSynchronizerTokenValidator.doFilter(SessionSynchronizerTokenValidator.java:103)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,143 INFO [STDOUT] at org.silverpeas.web.filter.MessageFilter.doFilter(MessageFilter.java:74)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,143 INFO [STDOUT] at org.silverpeas.web.filter.HttpServletRequestDecoration.doFilter(HttpServletRequestDecoration.java:60)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,143 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,143 INFO [STDOUT] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
14:30:09,143 INFO [STDOUT] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:274)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:242)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
14:30:09,158 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:181)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
14:30:09,158 INFO [STDOUT] at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.event(CatalinaContext.java:285)
14:30:09,158 INFO [STDOUT] at org.jboss.modcluster.catalina.CatalinaContext$RequestListenerValve.invoke(CatalinaContext.java:261)
14:30:09,158 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:88)
14:30:09,158 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:100)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:159)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
14:30:09,158 INFO [STDOUT] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
14:30:09,158 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
14:30:09,174 INFO [STDOUT] at org.jboss.web.tomcat.service.request.ActiveRequestResponseCacheValve.invoke(ActiveRequestResponseCacheValve.java:53)
14:30:09,174 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
14:30:09,174 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
14:30:09,174 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654)
14:30:09,174 INFO [STDOUT] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:951)
14:30:09,174 INFO [STDOUT] at java.lang.Thread.run(Thread.java:662)
14:30:09,174 INFO [STDOUT] )

Une idée ?