admin管理员组

文章数量:1384679

SQLcl provides bridge command that I would like to use to copy few tables with data to local instance of h2. Based on SQLcl description it can connect databases from different vendors. I was under impression that it only supports oracle java driver, but it appears there is a way to set driver specific to h2. I would imagine I can point it to h2 java driver and establish connection somehow. I can connect to h2 from my app using syntax listed in h2 documentation, something like this:

jdbc:h2:mem:test

But when I try to use same string in sqlcl bridge command I am getting message that syntax is incorrect, or credentials are bad. Connection to remote oracle instance works fine with string like this:

jdbc:oracle:thin:user/[email protected]:9999/aaa

I already can fetch data into csv file and upload it to h2. I thought approach with bridge command would be better. I am not interested in migrating entire db or something like that. Only ~20 tables from one schema with up to 10k rows each. Would appreciate any suggestions.

本文标签： Connect SQLcl to h2 databaseStack Overflow

版权声明：本文标题：Connect SQLcl to h2 database - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744529065a2610919.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。