Re: [sdx-users] problèmes pour supprimer une notice

[Vincent LECONTE]

>>Il "suffit" de paramétrer votre application SDX actuelle pour utiliser MySQL, 
>>PostgreSQL à la place. 
>>Pour cela, il faut modifier l'application.xconf pour avoir :
>><sdx:application [...]>
>><sdx:database type="{MYSQL|POSTGRESQL}" 
>>dsi="{WEB-INF/cocoon.xconf/cocoon/datasources/jdbc/@name}"/>
>></sdx:application>
>Ah mais j'ignorais...
>Et en plus ça marche! C'est génial! :-)

Il semble que j'ai parlé un peu trop vite...
La création d'une application HSQL-free se passe sans soucis mais si je relance 
Tomcat mon application a disparue :-(

Comme message d'erreur dans sdx.log j'ai :

ERROR   (2008-03-14) 14:46.11:353   [sdx.framework] (Unknown-URI) 
Unknown-thread/LoggingUtils: Unable to create the table, "SansHSQL_users" : 
Unable to execute the query, "{0}" : Unable to read the search index of {1} : 
{2}
fr.gouv.culture.sdx.exception.SDXException: Unable to execute the query, "{0}" 
: Unable to read the search index of {1} : {2}
        at fr.gouv.culture.sdx.exception.SDXException.log(SDXException.java:125)
        at 
fr.gouv.culture.sdx.exception.SDXException.<init>(SDXException.java:105)
        at fr.gouv.culture.sdx.utils.rdbms.JDBC.createTable(JDBC.java:88)
        at 
fr.gouv.culture.sdx.utils.database.AbstractJDBCDatabase.init(AbstractJDBCDatabase.java:584)
        at 
fr.gouv.culture.sdx.utils.database.DatabaseBacked.init(DatabaseBacked.java:125)
        at 
fr.gouv.culture.sdx.repository.FSRepository.init(FSRepository.java:226)
        at 
fr.gouv.culture.sdx.utils.configuration.ConfigurationUtils.createRepository(ConfigurationUtils.java:196)
        at 
fr.gouv.culture.sdx.documentbase.SDXDocumentBase.configureRepositories(SDXDocumentBase.java:335)
        at 
fr.gouv.culture.sdx.documentbase.SDXDocumentBase.configure(SDXDocumentBase.java:156)
        at 
fr.gouv.culture.sdx.documentbase.LuceneDocumentBase.configure(LuceneDocumentBase.java:234)
        at 
fr.gouv.culture.sdx.application.Application.configureUserDocumentBase(Application.java:473)
        at 
fr.gouv.culture.sdx.application.Application.configure(Application.java:327)
        at 
fr.gouv.culture.sdx.framework.FrameworkImpl.configureApplication(FrameworkImpl.java:407)
        at 
fr.gouv.culture.sdx.framework.FrameworkImpl.configureApplications(FrameworkImpl.java:307)
        at 
fr.gouv.culture.sdx.framework.FrameworkImpl.init(FrameworkImpl.java:791)
        at 
fr.gouv.culture.sdx.framework.FrameworkImpl.initialize(FrameworkImpl.java:708)
        at 
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283)
        at 
org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:277)
        at 
org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108)
        at 
org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:522)
        at 
org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:527)
        at 
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283)
        at org.apache.cocoon.Cocoon.initialize(Cocoon.java:306)
        at 
org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:283)
        at 
org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java:1360)
        at org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:481)
        at 
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1068)
        at 
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:900)
        at 
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3823)
        at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4087)
        at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:800)
        at 
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:695)
        at 
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1106)
        at 
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at 
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1019)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
        at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440)
        at 
org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
        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:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
Caused by: java.sql.SQLException: General error: Table 'sanshsql_users' already 
exists
        at fr.gouv.culture.sdx.exception.SDXException.log(SDXException.java:125)
        at 
fr.gouv.culture.sdx.exception.SDXException.<init>(SDXException.java:105)
        at fr.gouv.culture.sdx.utils.rdbms.JDBC$Template.execute(JDBC.java:147)
        at fr.gouv.culture.sdx.utils.rdbms.JDBC.createTable(JDBC.java:82)
        ... 49 more

Et d'autres du même genre par la suite...

Je pige vraiment pas d'où vient le problème dons si jamais vous aviez une 
petite idée... 

Merci d'avance,

Vincent Leconte