37655


h2databaseの接続ができなくて困っています。

コンソール自体の起動はできて、 JDBC URL:jdbc:h2:tcp://localhost/~/test  
のテスト動作も問題なくおこなえますが、別のアドレスJDBC URL：jdbc:h2:~/terasolunaを指定すると、以下のようにログがでます。

[code]

    一般エラー: java.lang.RuntimeException: rowcount remaining=-1 SYS
    General error: java.lang.RuntimeException: rowcount remaining=-1 SYS [50000-78] HY000/50000 (ヘルプ)
    org.h2.jdbc.JdbcSQLException: 一般エラー: java.lang.RuntimeException: rowcount remaining=-1 SYS
    General error: java.lang.RuntimeException: rowcount remaining=-1 SYS [50000-78] 
        at org.h2.message.Message.getSQLException(Message.java:103) 
        at org.h2.message.Message.convert(Message.java:257) 
        at org.h2.engine.Database.<init>(Database.java:226) 
        at org.h2.engine.Engine.openSession(Engine.java:56) 
        at org.h2.engine.Engine.openSession(Engine.java:125) 
        at org.h2.engine.Engine.getSession(Engine.java:108) 
        at org.h2.engine.Session.createSession(Session.java:242) 
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108) 
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87) 
        at org.h2.Driver.connect(Driver.java:57) 
        at org.h2.server.web.WebServer.getConnection(WebServer.java:625) 
        at org.h2.server.web.WebThread.test(WebThread.java:1028) 
        at org.h2.server.web.WebThread.process(WebThread.java:440) 
        at org.h2.server.web.WebThread.processRequest(WebThread.java:184) 
        at org.h2.server.web.WebThread.process(WebThread.java:239) 
        at org.h2.server.web.WebThread.run(WebThread.java:194) 
    Caused by: java.lang.RuntimeException: rowcount remaining=-1 SYS 
        at org.h2.message.Message.getInternalError(Message.java:179) 
        at org.h2.table.TableData.addIndex(TableData.java:202) 
        at org.h2.engine.Database.open(Database.java:564) 
        at org.h2.engine.Database.<init>(Database.java:207) 
        ... 13 more 
    
[/code]

再度、やり直すたびに、ポート番号は特定してタスクを消去して競合しないようにはしていますが、考えられる原因はどのようなものがあありますでしょうか？

追加:h2db_init実行時のログ

[code]

    C:\Users\hironori\Desktop\pleiades\workspace\terasoluna-spring-thin-blank\h2db>
    ava -cp h2.jar org.h2.tools.RunScript -url jdbc:h2:~/terasoluna -user sa -scrip
     terasoluna.script -showResults
    Exception in thread "main" org.h2.jdbc.JdbcSQLException: 一般エラー: java.lang.
    untimeException: rowcount remaining=-1 SYS
    General error: java.lang.RuntimeException: rowcount remaining=-1 SYS [50000-78]
            at org.h2.message.Message.getSQLException(Message.java:103)
            at org.h2.message.Message.convert(Message.java:257)
            at org.h2.engine.Database.<init>(Database.java:226)
            at org.h2.engine.Engine.openSession(Engine.java:56)
            at org.h2.engine.Engine.openSession(Engine.java:125)
            at org.h2.engine.Engine.getSession(Engine.java:108)
            at org.h2.engine.Session.createSession(Session.java:242)
            at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
            at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87)
            at org.h2.Driver.connect(Driver.java:57)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at org.h2.tools.RunScript.process(RunScript.java:319)
            at org.h2.tools.RunScript.run(RunScript.java:151)
            at org.h2.tools.RunScript.main(RunScript.java:94)
    Caused by: java.lang.RuntimeException: rowcount remaining=-1 SYS
            at org.h2.message.Message.getInternalError(Message.java:179)
            at org.h2.table.TableData.addIndex(TableData.java:202)
            at org.h2.engine.Database.open(Database.java:564)
            at org.h2.engine.Database.<init>(Database.java:207)
            ... 12 more
    
[/code]

オプション追加実行後のログ

[code]

    C:\Users\hironori\Desktop\pleiades\workspace\terasoluna-spring-thin-blank\h2db>j
    ava -Dh2.check=false -cp h2.jar org.h2.tools.RunScript -url jdbc:h2:~/terasoluna
     -user sa -script terasoluna.script -showResults
    Exception in thread "main" org.h2.jdbc.JdbcSQLException: テーブル USERLIST が見
    つかりません
    Table USERLIST not found; SQL statement:
    CREATE INDEX PUBLIC.IDX_USERLIST ON PUBLIC.USERLIST(ID) [42102-78]
            at org.h2.message.Message.getSQLException(Message.java:103)
            at org.h2.message.Message.getSQLException(Message.java:114)
            at org.h2.message.Message.getSQLException(Message.java:77)
            at org.h2.schema.Schema.getTableOrView(Schema.java:348)
            at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:60)
            at org.h2.engine.MetaRecord.execute(MetaRecord.java:85)
            at org.h2.engine.Database.open(Database.java:584)
            at org.h2.engine.Database.<init>(Database.java:207)
            at org.h2.engine.Engine.openSession(Engine.java:56)
            at org.h2.engine.Engine.openSession(Engine.java:125)
            at org.h2.engine.Engine.getSession(Engine.java:108)
            at org.h2.engine.Session.createSession(Session.java:242)
            at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
            at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87)
            at org.h2.Driver.connect(Driver.java:57)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at org.h2.tools.RunScript.process(RunScript.java:319)
            at org.h2.tools.RunScript.run(RunScript.java:151)
            at org.h2.tools.RunScript.main(RunScript.java:94)
    
[/code]


CC BY-SA 3.0
2017-08-31T09:41:52.043
37639
2017-09-01T04:59:38.720
2017-09-01T04:59:38.720
21092
25002
question
sql database
H2databaseの接続エラーについて


`h2db_init.bat`の次の行に

[code]

    java -cp h2.jar org.h2.tools.RunScript -url %H2URL% -user %H2USER% -script terasoluna.script -showResults
    
[/code]

`-Dh2.check=false`というオプションを付加してから、実行したら結果が変わりませんか？

[code]

    java -Dh2.check=false -cp h2.jar org.h2.tools.RunScript -url %H2URL% -user %H2USER% -script terasoluna.script -showResults
    
[/code]


CC BY-SA 3.0
2017-09-01T04:07:25.147
37655
2017-09-01T04:07:25.147
21092
37639
answer