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.