How do I connect to a database using JDBC filter

Question

Question

prashant na · Apr 15, 2020

hi all,

I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.

I see the connection format is as "

   jdbc:Cache://<host>:<port>/<namespace>

"

What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.

how can I do that? what will be the format

Discussion (4)1

Log in or sign up to continue

Scott Roth · Apr 15, 2020

I would believe the only way to put a schema filter in would be within your query and not in the connection string.

0 0

score 0 · Answer 1 · 2020-04-15T10:20:43-04:00

First start off by looking at the following documentation...

What you use for your connection string all depends on the driver you are using. In the past I have used Microsoft, Oracle, and jTDS JDBC drivers. Currently I am using jTDS because it allows me to use integrated Authentication. so my strings are a little long...

jdbc:jtds:sqlserver://(server name):(port)/(database);instance=xx;domain=xxxx;useNTLMv2=true;cacheMetaData=true;prepareSQL=2;

is just an example.

Scott

score 0 · Answer 2 · 2020-04-15T10:33:08-04:00

Hi Scott,

thanks for your response. I have looked at the given documentation. What I am missing is in the connection string, where do I specify the database/Schema as a filter? This format only connects to a namespace , can I pass an additional parameter of the schema-name or database name ?

   jdbc:Cache://<host>:<port>/<namespace>

score 1 · Answer 3 · 2020-04-15T12:20:25-04:00

I advice solving your problem by tightening security.

Your app user should have access only to the tables needed for the application to run.

If the user doesn't have any additional/admin roles, he won't see any other tables.