>>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
_______________________________________________
sdx-users mailing list
[email protected]
http://lists.nongnu.org/mailman/listinfo/sdx-users
