Partage
  • Partager sur Facebook
  • Partager sur Twitter

OpenGTS java

    19 octobre 2018 à 13:22:51

    salut a vous.

    lorsque j'essaie d'initialiser la base de données d'openGTS sur mysql, j'ai l'erreur suivante :

    Microsoft Windows [version 6.3.9600]
    (c) 2013 Microsoft Corporation. Tous droits réservés.
    
    C:\eclipse\workspace\OpenGTS>bin\initdb.bat "-rootUser:root"
    "C:\Program Files\Java\jdk1.8.0_77\\bin\java" "-Dfile.encoding=UTF-8" -classpath
     "C:\eclipse\workspace\OpenGTS\\build\lib"\gtsdb.jar;"C:\eclipse\workspace\OpenG
    TS\\build\lib"\gtsutils.jar;"C:\eclipse\workspace\OpenGTS\\build\lib"\optdb.jar;
    "C:\eclipse\workspace\OpenGTS\\build\lib"\ruledb.jar;"C:\eclipse\workspace\OpenG
    TS\\build\lib"\bcrossdb.jar;"C:\eclipse\workspace\OpenGTS\\build\lib"\custom.jar
    ;"C:\eclipse\workspace\OpenGTS\\build\lib"\dmtpserv.jar;"C:\eclipse\workspace\Op
    enGTS\\build\lib"\gtsdmtp.jar; org.opengts.db.DBConfig -conf:"C:\eclipse\workspa
    ce\OpenGTS\\default.conf" -log.file.enable:false -initTables  "-rootUser:root"
    
    Version: 2.6.5
    Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class
    is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SP
    I and manual loading of the driver class is generally unnecessary.
    Fri Oct 19 12:15:13 WAT 2018 WARN: Establishing SSL connection without server's
    identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ an
    d 5.7.6+ requirements SSL connection must be established by default if explicit
    option isn't set. For compliance with existing applications not using SSL the ve
    rifyServerCertificate property is set to 'false'. You need either to explicitly
    disable SSL by setting useSSL=false, or set useSSL=true and provide truststore f
    or server certificate verification.
    [ERROR|DBAdmin.execCommands:1020] SQLException message: The server time zone val
    ue 'Afr. centrale Ouest' is unrecognized or represents more than one time zone.
    You must configure either the server or JDBC driver (via the serverTimezone conf
    iguration property) to use a more specifc time zone value if you want to utilize
     time zone support.
    [ERROR|DBAdmin.execCommands:1021] ==> SQLException: DB create error [jdbc:mysql:
    //localhost:3306/]
    [ERROR|DBAdmin.execCommands:1021] Message:   The server time zone value 'Afr. ce
    ntrale Ouest' is unrecognized or represents more than one time zone. You must co
    nfigure either the server or JDBC driver (via the serverTimezone configuration p
    roperty) to use a more specifc time zone value if you want to utilize time zone
    support.
    [ERROR|DBAdmin.execCommands:1021] SQLState:  01S00
    [ERROR|DBAdmin.execCommands:1021] ErrorCode: 0
    [DBAdmin.execCommands:1021] java.sql.SQLException: The server time zone value 'A
    fr. centrale Ouest' is unrecognized or represents more than one time zone. You m
    ust configure either the server or JDBC driver (via the serverTimezone configura
    tion property) to use a more specifc time zone value if you want to utilize time
     zone support.
    java.sql.SQLException: The server time zone value 'Afr. centrale Ouest' is unrec
    ognized or represents more than one time zone. You must configure either the ser
    ver or JDBC driver (via the serverTimezone configuration property) to use a more
     specifc time zone value if you want to utilize time zone support.
            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
    a:129)
            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
    a:97)
            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
    a:89)
            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
    a:63)
            at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.jav
    a:73)
            at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(
    SQLExceptionsMapping.java:76)
            at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:832)
    
            at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
            at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
    
            at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.j
    ava:207)
            at java.sql.DriverManager.getConnection(DriverManager.java:664)
            at java.sql.DriverManager.getConnection(DriverManager.java:247)
            at org.opengts.dbtools.DBConnection.getConnection(DBConnection.java:821)
    
            at org.opengts.dbtools.DBConnection.createStatement(DBConnection.java:95
    1)
            at org.opengts.dbtools.DBConnection.createStatement(DBConnection.java:94
    0)
            at org.opengts.dbtools.DBConnection._executeUpdate(DBConnection.java:120
    5)
            at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:1160
    )
            at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:1142
    )
            at org.opengts.dbtools.DBProvider.createDatabase(DBProvider.java:1622)
            at org.opengts.dbtools.DBAdmin.execCommands(DBAdmin.java:1010)
            at org.opengts.db.DBConfig._main(DBConfig.java:2012)
            at org.opengts.db.DBConfig.main(DBConfig.java:2154)
    Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The serv
    er time zone value 'Afr. centrale Ouest' is unrecognized or represents more than
     one time zone. You must configure either the server or JDBC driver (via the ser
    verTimezone configuration property) to use a more specifc time zone value if you
     want to utilize time zone support.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
    orAccessorImpl.java:62)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
    onstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
            at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFac
    tory.java:61)
            at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFac
    tory.java:85)
            at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:128)
            at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtoc
    ol.java:2236)
            at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtoc
    ol.java:2260)
            at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(Connection
    Impl.java:1314)
            at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.jav
    a:963)
            at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:822)
    
            ... 15 more
    
    C:\eclipse\workspace\OpenGTS>

    aidez moi a comprendre. merci

    • Partager sur Facebook
    • Partager sur Twitter
    A Vaincre sans péril on finit par triompher sans gloire  ->  le Cid de corneille

    OpenGTS java

    × Après avoir cliqué sur "Répondre" vous serez invité à vous connecter pour que votre message soit publié.
    × Attention, ce sujet est très ancien. Le déterrer n'est pas forcément approprié. Nous te conseillons de créer un nouveau sujet pour poser ta question.
    • Editeur
    • Markdown