Jdbc:oracle:thin:user/pass%@106.76.87.103:1532/yesh

[yeshveer_yadav]

call apoc.load.jdbc("jdbc:oracle:thin:user/pass%@106.76.87.103:1532/yesh","....")
i am unable to make connection as this is not accepting % in the password.

is there any solution ?

[stefan_armbrust]

try either

call apoc.load.jdbc("jdbc:oracle:thin:user/\"pass%\"@106.76.87.103:1532/yesh","....")

or

call apoc.load.jdbc("jdbc:oracle:thin:user/\\"pass%\\"@106.76.87.103:1532/yesh","....")

Maybe you need even a thrid \ for quoting ... or change your password 😉

[yeshveer_yadav]

Hi @stefan.armbruster
tried in both the ways
1st case error : Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure apoc.load.jdbc: Caused by: java.net.URISyntaxException: Illegal character in opaque part at index 22:URL
2nd case error : Neo.ClientError.Statement.SyntaxError: Invalid input

thanks but can not change password.. may be this can one bug for neo4j

[stefan_armbrust]

That's for sure not a neo4j bug - as mentioned before it's a quoting issue. Maybe you need to URL encode the %.

[yeshveer_yadav]

HI @stefan.armbruster
after ecoding % which is %25
error :Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure apoc.load.jdbc: Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

lets see how we resolve this bug or this quoting issue

[yeshveer_yadav]

@michael.hunger i hope you can help with this.

thanks

[michael_hunger · Accepted solution]

Are you using the most recent apoc version?

you can pass username and password now in the config, see

https://neo4j.com/docs/labs/apoc/current/database-integration/load-jdbc/#_load_jdbc_resources

CALL apoc.load.jdbc('jdbc:derby:derbyDB', 'PERSON',[],{credentials:{user:'apoc',password:'Ap0c!#Db'}})

[yeshveer_yadav]

thanks @michael.hunger earlier also i saw that but could not use for oracle database due to some syntax error.
but this time it worked.
once again thanks for support.