[H2 Database] Database "JDBC URL" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-206] 90149/90149 해결방법

 

1. 만들 URL을 입력한다

=> jdbc:h2:~/(만들 이름)    ex.jdbc:h2:~/shop

2. 정상적으로  DB로 이동된 것을 확인할 수 있다

3. 여기에서 왼쪽 상단의 버튼을 눌러 빠져나온 다음 아래 URL을 입력한다

=> jdbc:h2:tcp://localhost/~/(아까 입력했던 만들 이름)      ex. jdbc:h2:tcp://localhost/~/shop

4. 정상적으로 이동된 것을 확인할 수 있다

Database "C:/Users/Limhyeona/shop" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-206] 90149/90149 (도움말)
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "C:/Users/Limhyeona/shop" not found, either pre-create it or allow remote database creation (not recommended in secure environments) [90149-206]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:697)
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:496)
    at org.h2.message.DbException.get(DbException.java:227)
    at org.h2.message.DbException.get(DbException.java:203)
    at org.h2.engine.Engine.throwNotFound(Engine.java:189)
    at org.h2.engine.Engine.openSession(Engine.java:72)
    at org.h2.engine.Engine.openSession(Engine.java:222)
    at org.h2.engine.Engine.createSession(Engine.java:201)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:175)
    at java.base/java.lang.Thread.run(Thread.java:834)

    at org.h2.message.DbException.getJdbcSQLException(DbException.java:697)
    at org.h2.engine.SessionRemote.readException(SessionRemote.java:637)
    at org.h2.engine.SessionRemote.done(SessionRemote.java:606)
    at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:163)
    at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:433)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:325)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:117)
    at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:287)
    at org.h2.server.web.WebServer.getConnection(WebServer.java:785)
    at org.h2.server.web.WebApp.login(WebApp.java:1029)
    at org.h2.server.web.WebApp.process(WebApp.java:226)
    at org.h2.server.web.WebApp.processRequest(WebApp.java:176)
    at org.h2.server.web.WebThread.process(WebThread.java:139)
    at org.h2.server.web.WebThread.run(WebThread.java:94)
    at java.base/java.lang.Thread.run(Thread.java:834)