Oracle connection

[liwen-wang]

Hi,

I have used your package to successfully connect my oracle database, and get table data much faster than pandas. But when I connect the second oracle database, I met a trouble and got
RuntimeError: parse error: invalid port number

The first conn str looks like;
url='xxx.site.com:1521/devel'
conn=f'oracle://{user}:{password}@{url}'

The second conn str I used is a custom jdbc url:
url='(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=abc-ef.xyz.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=mm.xyz.com)))'
conn=f'oracle://{user}:{password}@{url}'

Both connections strings worked fine on pandas.

How would I update the above connection string to make it work?
Thank you for your help

Liwen

[wangxiaoying]

Hi @liwen-wang , I think the first connection is correct. Is there any special characters in your connection string? Can you try to url encode each part of the conn?

[liwen-wang]

Hi Xiaoying, You are right. After encoding each part of connection, it works now. Thank you very much. Liwen From: Xiaoying Wang ***@***.***> Date: Thursday, October 13, 2022 at 12:47 PM To: sfu-db/connector-x ***@***.***> Cc: Wang, Liwen ***@***.***>, Mention ***@***.***> Subject: Re: [sfu-db/connector-x] Oracle connection (Discussion #371) ***CAUTION:*** This email is not from a BCM Source. Only click links or open attachments you know are safe.

…

________________________________ Hi @liwen-wang<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_liwen-2Dwang&d=DwMCaQ&c=ZQs-KZ8oxEw0p81sqgiaRA&r=t6o15idjqfhNZ0-bBhFHPA&m=IpcMLeY5brE1wYHDYqEt1m2LBSvzTnfCXOwCmMbfRGjmkibDiv_TMtV0fe08027H&s=a02a-H4uOO6gUSKjSYKyeT4D6uVqWTB6MTy67ABxwn4&e=> , I think the first connection is correct. Is there any special characters in your connection string? Can you try to url encode each part of the conn? — Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_sfu-2Ddb_connector-2Dx_discussions_371-23discussioncomment-2D3872480&d=DwMCaQ&c=ZQs-KZ8oxEw0p81sqgiaRA&r=t6o15idjqfhNZ0-bBhFHPA&m=IpcMLeY5brE1wYHDYqEt1m2LBSvzTnfCXOwCmMbfRGjmkibDiv_TMtV0fe08027H&s=B-adebL13h7B4yG4NCaGVgbnoNnTJgZlnAGUOWKazgY&e=>, or unsubscribe<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AIPVPDGZB3MBG22PH3VR6PDWDBDMFANCNFSM6AAAAAAQ7BRESY&d=DwMCaQ&c=ZQs-KZ8oxEw0p81sqgiaRA&r=t6o15idjqfhNZ0-bBhFHPA&m=IpcMLeY5brE1wYHDYqEt1m2LBSvzTnfCXOwCmMbfRGjmkibDiv_TMtV0fe08027H&s=OaO11fUy0WUZ6MJE4HZXqQ6zmiQ_jZmIESi_gX2ZM98&e=>. You are receiving this because you were mentioned.Message ID: ***@***.***>