Skip to Main Content
Forums

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlcl lb diff / Messaqe can not be null

djzJan 1 2022 — edited Jan 10 2022

Hi there,
I would like to run "lb diff" in sqlcl (21.4). I am connected to a database (using tnsnames.ora) and now try to "lb diff" but get a "Messaqe can not be null" error:

lb diff -url host2:1521/my.service.de -user username -pass "xxxxxxxxxxxxxxx"
Processing has failed for your request.
Messaqe can not be null
=> what does this mean? NB: the small letter Q occurs in the original notification.

Essentially the error message of the complete command is not helpful, at least not for me.

Also trying different URLs
"jdbc:oracle:thin:@host2:152/my.service.de"
"//host2:1521?my.service.de"

do not work. Of. course I am able to log into that db/user combination directly using SQLcl.
Any idea what I am doing wrong or where some debug- or trace-log can be found?

Alternatively an working example command line would be helpful.
HNY, cheers, Dirk

Comments

djz

lb diff -url host2:1521:my.service.de -user username -pass "xxxxxxxxxxxxxxx"
does the trick ( colon instead of slash ), would it be gettint now the error
class oracle.jdbc.driver.T4CConnection cannot be cast to class liquibase.database.jvm.JdbcConnection

djz

Perhaps notewothy: I am using GraalVM

1 - 2

Post Details

Added on Jan 1 2022
2 comments
204 views