
‎04-14-2020 11:34 AM
Hi,
I had a doubt that while using apoc.load.jdbc....can i specify any other server ip other than that on which neo4j is running currently.
ex.
neo4j is running on 192.168.XXX.XXX
but the mysql database is present at :192.168.YYY.YYY
can i use 192.168.YYY.YYY instead of localhost in the below example
CALL apoc.load.jdbc('jdbc:mysql://localhost:3306/proddb1?user=root&password=football','select title from movies where studio='MGM Studios'') YIELD row
Solved! Go to Solution.
- Labels:
-
Import-Export

‎04-15-2020 07:12 AM
URL encoding of the password value.
For example the character ^ becomes %5E when you do url encode.
So instead of Pa^^word give Pa%5E%5Eword as the password value and try.

‎04-14-2020 11:51 AM
you should be able to use another machine IP address in apoc jdbc url.

‎04-15-2020 02:02 AM
Thanks for the heads up..
Actually now the problem is .......I have '^' character in my password so its showing illegal use of character in query.
how can I escape this ^

‎04-15-2020 02:29 AM
Just a wild guess from me:
Please try backtick key to store password. eg Pa^^word

‎04-15-2020 06:23 AM
Thanks but i had tried it already.......that doesn't work either.
Backtick itself becomes a illegal character

‎04-15-2020 03:48 AM
Since it is part of URL try url encoded value for it and see if it works.

‎04-15-2020 06:25 AM
Actually i didn't get what u said,
did u mean to pass the password as parameter
can u please explain?
Thanks in advance

‎04-15-2020 07:12 AM
URL encoding of the password value.
For example the character ^ becomes %5E when you do url encode.
So instead of Pa^^word give Pa%5E%5Eword as the password value and try.

‎04-15-2020 10:46 AM
Hey anthapu,
Thank u very much for your help......!!!
It worked fine for me...!
