英文:
How to connect H2 database in pentaho
问题
H2托管在嵌入式Spring应用程序中,并保存在一个文件中
URL: jdbc:h2:file:C:\gesdb
该应用程序在8080端口上运行。
我可以通过浏览器控制台看到表employee和表中的值。
在尝试建立与Pentaho的连接时出现错误:“连接已断开:意外状态1213486160 [90067-214]”。
Pentaho连接详细信息
数据库名称 -> 绝对文件路径
端口号 -> 8080
尝试过FILE_LOCK=NO;
仍然没有运气,
无法找出错误的根本原因。
英文:
H2 is hosted in an embedded spring application and saved in a file
url: jdbc:h2:file:C:\gesdb
The application is running on 8080 port.
I could see the table employee and values in the table through browser console.
While trying to establish the connection in pentaho error occurs "Connection is broken : unexpected status 1213486160 [90067-214]"
Pentaho connection details
Database Name -> Absolute file path
Port number -> 8080
Have tried FILE_LOCK=NO;
still no luck,
Could not figure out the root cause of the error.
答案1
得分: 1
默认情况下,您无法对h2数据库进行多个连接。
即使您在URL链接中添加;AUTO_SERVER=TRUE
,它也取决于版本。
英文:
By default you can't do multiple connection to h2 db.
Even if you add ;AUTO_SERVER=TRUE
to url link, it depends on version
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论