Re: [GeoNetwork-users-fr] erreur exception jdbc4 myslq

[Francois P. <fx....@gm...>]

Bonjour,


2013/2/5 Fabien Blanchet <FBl...@fo...>

>
> Bonjour,
> Nous sommes en train de passer à la version de Géosource 2.7.3, avec
> tomcat et mysql.
>
> Suite à la migration, j'ai le message d'erreur ci-dessous sur la page de
> démarrage de géosource.
> Est-ce du à une table ou un champs incompatible avec la version 2.7.3 ?
>

A priori, la migration de la base de données est incomplète. Vérifiez que
le script SQL a été appliqué en totalité
https://geonetwork.svn.sourceforge.net/svnroot/geonetwork/sandbox/GeoSource/trunk/geosource/src/main/added/web/src/main/webapp/WEB-INF/classes/setup/sql-geosource/migrate/273/migrate-default.sql

ALTER TABLE IsoLanguages ADD shortcode varchar(2);

Salutations.

Francois


>
> merci à vous
>
> Raised exception while starting appl handler. Skipped.
> Exception  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Unknown column 'shortcode' in 'field list'
> Message  Unknown column 'shortcode' in 'field list'
> Handler  org.fao.geonet.Geonetwork
> Stack  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
> column 'shortcode' in 'field list' at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at
> com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at
> com.mysql.jdbc.Util.getInstance(Util.java:384) at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2264)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> at jeeves.resources.dbms.Dbms.selectFull(Dbms.java:213) at
> jeeves.resources.dbms.Dbms.select(Dbms.java:176) at
> org.fao.geonet.languages.IsoLanguagesMapper.init(IsoLanguagesMapper.java:81)
> at org.fao.geonet.Geonetwork.start(Geonetwork.java:350) at
> jeeves.server.JeevesEngine.initAppHandler(JeevesEngine.java:541) at
> jeeves.server.JeevesEngine.init(JeevesEngine.java:170) at
> jeeves.server.sources.http.JeevesServlet.init(JeevesServlet.java:78) at
> javax.servlet.GenericServlet.init(GenericServlet.java:160) at
> org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1274)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1186)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1081)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5033)
> at
> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5320)
> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633) at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:657)
> at
> org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1637)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at
> java.util.concurrent.FutureTask.run(FutureTask.java:138) at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
>
> Fabien
>
> ------------------------------------------------------------------------------
> Free Next-Gen Firewall Hardware Offer
> Buy your Sophos next-gen firewall before the end March 2013
> and get the hardware for free! Learn more.
> http://p.sf.net/sfu/sophos-d2d-feb
> _______________________________________________
> GeoNetwork-users-fr mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users-fr
>