topic Re: Space in JDBC connection string in Catalog and Lineage

Space in JDBC connection string

lachlanwcast — Tue, 07 Dec 2021 22:35:04 GMT

Hi there,

Any ideas how to escape a space within the database name in the JDBC string?

utils.error.code.DYNAMIC_ERROR - Illegal character in opaque part at index 62: jdbc:sqlserver://

Have tried using /, '' , "", [] to no avail!

Any thoughts?

Re: Space in JDBC connection string

ybl — Wed, 11 Mar 2020 10:15:42 GMT

You should find what you need in the Admin >> Database Drivers page of QDC. Edit the detail of SQL Server driver and you'll get capabilities to manage escape char and other interesting parameters.

Re: Space in JDBC connection string

lachlanwcast — Sat, 21 Mar 2020 08:17:59 GMT

Hi there,

We have been trying a few options with that page, but the issue is still present, even when selecting the escape characters

We are currently liasing with Qlik Support to resolve the issue as their suggestions and use of underscore as escape characters are not working.

Thanks,

Lachlan

Re: Space in JDBC connection string

eeh — Mon, 23 Mar 2020 01:07:22 GMT

Hi Lachlan,

I've been able to connect to a database with a space in the name by using "+" in place of the space.

For example,

jdbc:postgresql://myhost/my db

would be replaced by

jdbc:postgresql://myhost/my+db

in the case of a Postgres database name "my db".

Hope that helps!

Allen Skees