Vocabulaire dynamique SQL

user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:9abf2faa3abdd584aaa3a712d6b10a61' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\">Bonjour,\nJe me demande comment faire pour générer un vocabulaire dynamique SQL \nà deux niveaux ?\nPour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml \nfouni (ORI-OAI 1.7).\nLa base SQL d\'origine est en latin1 alors que ORI-OAI est en utf8 et je \nme demande comment il faudra traiter ça ?\nMais pour le moment, le vocabulaire n\'est pas généré et dans les logs :\n1603 mai/15 07:12:52 WARN domain.VocabularyService getVocabulary[49] - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements. \n We continue with others providerManagers. \n Here the exception : \njava.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String \n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63) \n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45) \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46) \n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) \n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) \n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \n at java.lang.reflect.Method.invoke(Method.java:597) \n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) \n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) \n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) \n at $Proxy0.getVocabulary(Unknown Source) \n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55) \n15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory \nINFO: Déploiement du répertoire ROOT de l\'application web \n1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126] - Unable to execute the cached method and no cache found :-( \norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57) \n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) \n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) \n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \n at java.lang.reflect.Method.invoke(Method.java:597) \n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) \n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) \n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) \n at $Proxy0.getVocabulary(Unknown Source) \n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55) \naused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String \n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63) \n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45) \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46) \n ... 12 more \n1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69] - error preloading a vocabulary : auf_etablissements \norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57) \n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) \n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) \n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \n at java.lang.reflect.Method.invoke(Method.java:597) \n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) \n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) \n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) \n at $Proxy0.getVocabulary(Unknown Source) \n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55) \nCaused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String \n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63) \n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45) \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46) \n ... 12 more\nEt quand j\'essaie de consulter ce vocabulaire dans le module vocabulary, \nil y a aussi :\nCaused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:\n** BEGIN NESTED EXCEPTION **\njava.io.EOFException\nSTACKTRACE:\nva.io.EOFException \n at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) \n at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) \n at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) \n at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) \n at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) \n at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) \n at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) \n at com.mysql.jdbc.Statement.executeQuery(Statement.java:824) \n at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) \n at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388) \n at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341) \n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403) \n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411) \n at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442) \n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55) \n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45) \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46) \n at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) \n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) \n at java.lang.reflect.Method.invoke(Method.java:597) \n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) \n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119) \n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) \n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203) \n at $Proxy0.getVocabulary(Unknown Source) \n at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211) \n at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78) \n at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) \n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) \n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) \n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) \n at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) \n at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) \n at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) \n at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) \n at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706) \n at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677) \n at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54) \n at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) \n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) \n at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377) \n at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) \n at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) \n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) \n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) \n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) \n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) \n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) \n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465) \n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) \n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) \n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) \n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) \n at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) \n at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) \n at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) \n at java.lang.Thread.run(Thread.java:662)\n** END NESTED EXCEPTION **\n</div>\n', created = 1507753897, expire = 1507840297, headers = '', serialized = 0 WHERE cid = '4:9abf2faa3abdd584aaa3a712d6b10a61' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:abd4387ab96583155fdaa26eddc2cd79' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\"><html>\n <head>\n <meta content=\"text/html; charset=ISO-8859-1\"\n http-equiv=\"Content-Type\">\n </head>\n <body bgcolor=\"#FFFFFF\" text=\"#000000\">\n Re bonjour, \n \n Avez-vous touché au fichier SqlProvider.java ? \n Pourriez-vous m\'envoyer ce que vous avez modifié exactement ?\n Notamment dans sqlVocabulary.xml svp ? \n \n Merci, \n <div class=\"moz-signature\">\n <div class=\"moz-signature\">\n \n Yohan COLMANT \n Direction des Systèmes d\'Information \n UVHC - Université de Valenciennes et du Hainaut Cambrésis \n Coordinateur Technique du projet ORI-OAI\n \n \n </div>\n </div>\n \n Le 16/05/2012 16:35, Cédric Musso a écrit :\n <div class=\"emailFilter_Toggle\"><div class=\"emailFilter_Author_0\"><blockquote>\n <pre wrap=\"\">Bonjour,\n\n\nJe me demande comment faire pour générer un vocabulaire dynamique SQL\nà deux niveaux ?\n\n\nPour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml\nfouni (ORI-OAI 1.7).\n\nLa base SQL d\'origine est en latin1 alors que ORI-OAI est en utf8 et je\nme demande comment il faudra traiter ça ?\n\nMais pour le moment, le vocabulaire n\'est pas généré et dans les logs :\n\n\n\n1603 mai/15 07:12:52 WARN domain.VocabularyService getVocabulary[49] - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements.\n We continue with others providerManagers. \n Here the exception :\njava.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\n15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory\nINFO: Déploiement du répertoire ROOT de l\'application web\n1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126] - Unable to execute the cached method and no cache found :-(\norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\naused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n ... 12 more\n1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69] - error preloading a vocabulary : auf_etablissements\norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. \n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\nCaused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n ... 12 more\n\n\nEt quand j\'essaie de consulter ce vocabulaire dans le module vocabulary,\nil y a aussi :\n\nCaused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:\n\n** BEGIN NESTED EXCEPTION **\n\njava.io.EOFException\n\nSTACKTRACE:\n\nva.io.EOFException\n at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)\n at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)\n at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)\n at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)\n at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)\n at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)\n at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)\n at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)\n at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)\n at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388)\n at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)\n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403)\n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411)\n at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442)\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211)\n at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)\n at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)\n at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)\n at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)\n at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)\n at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)\n at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54)\n at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)\n at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)\n at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\n at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)\n at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\n at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n at java.lang.Thread.run(Thread.java:662)\n\n\n** END NESTED EXCEPTION **\n\n\n</pre>\n </blockquote></div></div>\n </body>\n</html>\n</div>', created = 1507753898, expire = 1507840298, headers = '', serialized = 0 WHERE cid = '4:abd4387ab96583155fdaa26eddc2cd79' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '4:584839aa3aff249aee52fce98b7235a7' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 27.
user warning: Table './drupal_www_ori_oai_org/cache_filter' is marked as crashed and last (automatic?) repair failed query: UPDATE cache_filter SET data = '<div class=\"emailFilter\"><html>\n <head>\n <meta content=\"text/html; charset=ISO-8859-1\"\n http-equiv=\"Content-Type\">\n </head>\n <body bgcolor=\"#FFFFFF\" text=\"#000000\">\n re bonjour, \n \n Pourriez-vous remplacer le fichier java de vos sources par celui que\n je vous joins et refaire un all-vocabulary ? \n Est-ce que ça fonctionne maintenant ? \n \n Cordialement, \n <div class=\"moz-signature\">\n <div class=\"moz-signature\">\n \n Yohan COLMANT \n Direction des Systèmes d\'Information \n UVHC - Université de Valenciennes et du Hainaut Cambrésis \n Coordinateur Technique du projet ORI-OAI\n \n \n </div>\n </div>\n \n Le 29/05/2012 10:33, Cédric Musso a écrit :\n <div class=\"emailFilter_Toggle\"><div class=\"emailFilter_Author_0\"><blockquote>\n <pre wrap=\"\">Bonjour,\n\nOn Tue, May 29, 2012 at 08:55:18AM +0200, Yohan Colmant wrote:\n</pre>\n <div class=\"emailFilter_Author_1\"><blockquote type=\"cite\">\n <pre wrap=\"\">Re bonjour,\n\nAvez-vous touché au fichier SqlProvider.java ?\n</pre>\n </blockquote></div>\n <pre wrap=\"\">\nNon.\n\n</pre>\n <div class=\"emailFilter_Author_1\"><blockquote type=\"cite\">\n <pre wrap=\"\">Pourriez-vous m\'envoyer ce que vous avez modifié exactement ?\nNotamment dans sqlVocabulary.xml svp ?\n</pre>\n </blockquote></div>\n <pre wrap=\"\">\nJ\'ai copié sqlVocabulary-example.xml dans un fichier\naufEtablissements.xml.\n\nEt dans domain.xml, j\'ai ajouté :\n<import resource=\"aufEtablissements.xml\" />\n\nCi joint ce fichier aufEtablissements.xml\n(Je n\'y ai modifié que le nom de la base, l\'utilisateur et le mot\nde passe, remplacés par database, user et pwd.\nLa requête est correcte, les vrais paramètres database, user et\npwd aussi.)\n\nBien cordialement,\n\nCédric Musso\n\n\n</pre>\n <div class=\"emailFilter_Author_1\"><blockquote type=\"cite\">\n <pre wrap=\"\">Le 16/05/2012 16:35, Cédric Musso a écrit :\n</pre>\n <div class=\"emailFilter_Author_2\"><blockquote type=\"cite\">\n <pre wrap=\"\">Bonjour,\n\n\nJe me demande comment faire pour générer un vocabulaire dynamique SQL\nà deux niveaux ?\n\n\nPour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml\nfouni (ORI-OAI 1.7).\n\nLa base SQL d\'origine est en latin1 alors que ORI-OAI est en utf8 et je\nme demande comment il faudra traiter ça ?\n\nMais pour le moment, le vocabulaire n\'est pas généré et dans les logs :\n\n\n\n1603 mai/15 07:12:52 WARN domain.VocabularyService getVocabulary[49] - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements.\n We continue with others providerManagers.\n Here the exception :\njava.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\n15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory\nINFO: Déploiement du répertoire ROOT de l\'application web\n1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126] - Unable to execute the cached method and no cache found :-(\norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\naused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n ... 12 more\n1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69] - error preloading a vocabulary : auf_etablissements\norg.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)\nCaused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n ... 12 more\n\n\nEt quand j\'essaie de consulter ce vocabulaire dans le module vocabulary,\nil y a aussi :\n\nCaused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:\n\n** BEGIN NESTED EXCEPTION **\n\njava.io.EOFException\n\nSTACKTRACE:\n\nva.io.EOFException\n at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)\n at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)\n at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)\n at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)\n at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)\n at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)\n at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)\n at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)\n at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)\n at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388)\n at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)\n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403)\n at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411)\n at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442)\n at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55)\n at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)\n at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)\n at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\n at java.lang.reflect.Method.invoke(Method.java:597)\n at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)\n at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)\n at $Proxy0.getVocabulary(Unknown Source)\n at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211)\n at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)\n at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)\n at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)\n at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)\n at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)\n at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)\n at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54)\n at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)\n at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)\n at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)\n at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)\n at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)\n at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n at java.lang.Thread.run(Thread.java:662)\n\n\n** END NESTED EXCEPTION **\n\n\n</pre>\n </blockquote></div>\n </blockquote></div>\n </blockquote></div></div>\n </body>\n</html>\n</div>', created = 1507753898, expire = 1507840298, headers = '', serialized = 0 WHERE cid = '4:584839aa3aff249aee52fce98b7235a7' in /home/ori-oai/drupal/drupal-6.34/includes/cache.inc on line 112.

3 messages / 0 nouveaux

Vous devez vous connecter pour poster des commentaires

Dernière contribution

16 mai 2012 - 4:35pm

Anonyme

Vocabulaire dynamique SQL

Bonjour,

Je me demande comment faire pour générer un vocabulaire dynamique SQL
à deux niveaux ?

Pour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml
founi (ORI-OAI 1.7).

La base SQL d'origine est en latin1 alors que ORI-OAI est en utf8 et je
me demande comment il faudra traiter ça ?

Mais pour le moment, le vocabulaire n'est pas généré et dans les logs :

1603 mai/15 07:12:52 WARN domain.VocabularyService getVocabulary[49] - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements.
We continue with others providerManagers.
Here the exception :
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
at $Proxy0.getVocabulary(Unknown Source)
at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Déploiement du répertoire ROOT de l'application web
1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126] - Unable to execute the cached method and no cache found :-(
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
at $Proxy0.getVocabulary(Unknown Source)
at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
aused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
... 12 more
1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69] - error preloading a vocabulary : auf_etablissements
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
at $Proxy0.getVocabulary(Unknown Source)
at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
... 12 more

Et quand j'essaie de consulter ce vocabulaire dans le module vocabulary,
il y a aussi :

Caused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

va.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411)
at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442)
at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55)
at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
at $Proxy0.getVocabulary(Unknown Source)
at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211)
at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)

** END NESTED EXCEPTION **

29 mai 2012 - 9:00am

Yohan Colmant

Re bonjour,

Avez-vous touché au fichier SqlProvider.java ?
Pourriez-vous m'envoyer ce que vous avez modifié exactement ? Notamment dans sqlVocabulary.xml svp ?

Merci,

Yohan COLMANT
Direction des Systèmes d'Information
UVHC - Université de Valenciennes et du Hainaut Cambrésis
Coordinateur Technique du projet ORI-OAI

Le 16/05/2012 16:35, Cédric Musso a écrit :

Bonjour,


Je me demande comment faire pour générer un vocabulaire dynamique SQL
à deux niveaux ?


Pour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml
founi (ORI-OAI 1.7).

La base SQL d'origine est en latin1 alors que ORI-OAI est en utf8 et je
me demande comment il faudra traiter ça ?

Mais pour le moment, le vocabulaire n'est pas généré et dans les logs :



1603 mai/15 07:12:52 WARN  domain.VocabularyService getVocabulary[49]  - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements.
 We continue with others providerManagers. 
 Here the exception :
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Déploiement du répertoire ROOT de l'application web
1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126]  - Unable to execute the cached method and no cache found :-(
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. 
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
aused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        ... 12 more
1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69]  - error preloading a vocabulary : auf_etablissements
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below. 
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        ... 12 more


Et quand j'essaie de consulter ce vocabulaire dans le module vocabulary,
il y a aussi :

Caused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

va.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
    at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411)
    at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442)
    at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55)
    at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
    at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
    at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
    at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
    at $Proxy0.getVocabulary(Unknown Source)
    at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211)
    at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
    at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
    at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)


** END NESTED EXCEPTION **

29 mai 2012 - 1:00pm

(Répondre à #3) #3

Yohan Colmant

re bonjour,

Pourriez-vous remplacer le fichier java de vos sources par celui que je vous joins et refaire un all-vocabulary ?
Est-ce que ça fonctionne maintenant ?

Cordialement,

Yohan COLMANT
Direction des Systèmes d'Information
UVHC - Université de Valenciennes et du Hainaut Cambrésis
Coordinateur Technique du projet ORI-OAI

Le 29/05/2012 10:33, Cédric Musso a écrit :

Bonjour,

On Tue, May 29, 2012 at 08:55:18AM +0200, Yohan Colmant wrote:

Re bonjour,

Avez-vous touché au fichier SqlProvider.java ?

Non.

Pourriez-vous m'envoyer ce que vous avez modifié exactement ?
Notamment dans sqlVocabulary.xml svp ?

J'ai copié sqlVocabulary-example.xml dans un fichier
aufEtablissements.xml.

Et dans domain.xml, j'ai ajouté :
<import resource="aufEtablissements.xml" />

Ci joint ce fichier aufEtablissements.xml
(Je n'y ai modifié que le nom de la base, l'utilisateur et le mot
de passe, remplacés par database, user et pwd.
La requête est correcte, les vrais paramètres database, user et
pwd aussi.)

Bien cordialement,

Cédric Musso

Le 16/05/2012 16:35, Cédric Musso a écrit :

Bonjour,


Je me demande comment faire pour générer un vocabulaire dynamique SQL
à deux niveaux ?


Pour un seul niveau, je suis parti du fichier sqlVocabulary-example.xml
founi (ORI-OAI 1.7).

La base SQL d'origine est en latin1 alors que ORI-OAI est en utf8 et je
me demande comment il faudra traiter ça ?

Mais pour le moment, le vocabulaire n'est pas généré et dans les logs :



1603 mai/15 07:12:52 WARN  domain.VocabularyService getVocabulary[49]  - An exception occured with the providerManager [org.orioai.vocabulary.domain.DynamicVocabularyProviderManager@eabd2f] when retrieving the vocabulary auf_etablissements.
 We continue with others providerManagers.
 Here the exception :
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
15 mai 2012 07:12:52 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Déploiement du répertoire ROOT de l'application web
1740 mai/15 07:12:52 ERROR cache.OriNameMatchCachingInterceptor invoke[126]  - Unable to execute the cached method and no cache found :-(
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
aused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        ... 12 more
1740 mai/15 07:12:52 ERROR cache.CachePreloader run[69]  - error preloading a vocabulary : auf_etablissements
org.orioai.vocabulary.exceptions.OriVocabularyException: A problem occurs while retrieving the vocabulary : auf_etablissements, so please see details below.
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:57)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
        at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
        at $Proxy0.getVocabulary(Unknown Source)
        at org.orioai.vocabulary.domain.utils.cache.CachePreloader$PreloadThread.run(CachePreloader.java:55)
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
        at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:63)
        at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
        at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
        ... 12 more


Et quand j'essaie de consulter ce vocabulaire dans le module vocabulary,
il y a aussi :

Caused by: org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [...requete...]; Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

va.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
    at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
    at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:388)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:403)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:411)
    at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:442)
    at org.orioai.vocabulary.domain.providers.sql.SqlProvider.getXmlStream(SqlProvider.java:55)
    at org.orioai.vocabulary.domain.VocabularyProviderManager.getVocabulary(VocabularyProviderManager.java:45)
    at org.orioai.vocabulary.domain.VocabularyService.getVocabulary(VocabularyService.java:46)
    at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
    at org.orioai.vocabulary.domain.utils.cache.OriNameMatchCachingInterceptor.invoke(OriNameMatchCachingInterceptor.java:119)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:203)
    at $Proxy0.getVocabulary(Unknown Source)
    at org.orioai.vocabulary.web.TestVocabularyServlet.doGetVocab(TestVocabularyServlet.java:211)
    at org.orioai.vocabulary.web.TestVocabularyServlet.doGet(TestVocabularyServlet.java:78)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
    at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
    at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:54)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)


** END NESTED EXCEPTION **

Valoriser le patrimoine numérique scientifique, pédagogique et documentaire des universités et le partager par un réseau de portails communicants en OAI

Traduction auto Google

Aide

Options d'affichage des commentaires