Discussion :

[Sebastien.B]

Salut,

J'utilise actuellement la base de données H2 (v1.1.114) pour stocker et traiter des données issues de différents fichiers TXT via un programme en Java. J'ai ce message d'erreur lors du traitement d'un de mes fichiers (beaucoup de lignes dans les fichiers et traitements très longs, pas très pratique pour localiser le soucis...):
"Lock file modification time is in the future"


Le message en détail:

SEVERE: null
org.h2.jdbc.JdbcSQLException: Error opening database: Lock file
modification time is in the future; if required please delete the file
c:\xxx\test.lock.db manually and retry; dist=-10702 [8000-114]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.store.FileLock.getExceptionFatal(FileLock.java:471)
at org.h2.store.FileLock.waitUntilOld(FileLock.java:283)
at org.h2.store.FileLock.lockFile(FileLock.java:330)
at org.h2.store.FileLock.lock(FileLock.java:130)
at org.h2.engine.Database.open(Database.java:555)
at org.h2.engine.Database.openDatabase(Database.java:219)
at org.h2.engine.Database.<init>(Database.java:214)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
at org.h2.Driver.connect(Driver.java:58)"
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at xxx.xxxxxx.<init>(xxxxx.java:303)
at xxx.xxxxxx.main(xxxxx.java:487)

J'ai posté cela dans le Online Error Analyser et ça me dit:

ERROR_OPENING_DATABASE_1 = 8000
The error with code 8000 is thrown when there was a problem trying to
create a database lock. See the message and cause for details.

Une idée pour corriger ce problème?

Merci

Sébastien

[Sebastien.B]

Maintenant j'ai droit à un autre message un peu plus loin dans l'importation/traitement du fichier TXT:

Error opening database: Lock file recently modified

org.h2.jdbc.JdbcSQLException: Error opening database: Lock file recently modified [8000-114]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.store.FileLock.getExceptionFatal(FileLock.java:471)
at org.h2.store.FileLock.waitUntilOld(FileLock.java:295)
at org.h2.store.FileLock.lockFile(FileLock.java:330)
at org.h2.store.FileLock.lock(FileLock.java:130)
at org.h2.engine.Database.open(Database.java:555)
at org.h2.engine.Database.openDatabase(Database.java:219)
at org.h2.engine.Database.<init>(Database.java:214)
at org.h2.engine.Engine.openSession(Engine.java:58)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at org.h2.engine.SessionFactoryEmbedded.createSession(SessionFactoryEmbedded.java:17)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:245)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:223)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:89)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at xxxx.xxxxx<init>(xxxxx.java:303)
at xxxx.xxxxx.main(xxxxx.java:487)

Des idées?

Merci.