John Kaster

Behind the Screen

Specifying JDBC connection properties for Blackfish SQL

with 2 comments

Recently, I needed to set the port for JDBC connection property for one of the Blackfish SQL databases we use on the Embarcadero Developer Network. After looking at the documentation online, I couldn’t find a way to set it in the connection string. (I’m not an expert on JDBC, but the port specification syntax appears to vary by vendor.)

So, I asked Adrian Andrei, and he referred to the source to determine the appropriate syntax.

You can specify some additional connection-specific properties as a name/value after the base connection string, like so:

jdbc:borland:dslocal:/acme/db/acme.jds;tempDir=/tmp;readonly=true;port=1234

In Blackfish SQL, the default port is 2508, so the following would set the default port:

jdbc:borland:dslocal:/acme/db/acme.jds;tempDir=/tmp;readonly=true;port=2508

This syntax should work in both JDBC URLs and programatically  if you are passing a Properties instance.

Advertisements

Written by John Kaster

March 16, 2010 at 9:09 am

Posted in 79, 85

2 Responses

Subscribe to comments with RSS.

  1. Last week I was noticing the gap in your blog postings, and wondered if you were still with the company. Guess this answers that!

    What’s with the “Borland” in the jdbc string? Didn’t they make QuattroPro?

    Brion

    March 17, 2010 at 4:06 pm

  2. LOL. All you have to do is check the newsgroups and you’ll know I’m still “here”. I’m just really busy with our complete server migration from our Scotts Valley data center to a new location in San Jose, with a much bigger “pipe.”

    I’ve posted some thing on EDN recently, too. 😉

    John Kaster

    March 17, 2010 at 4:10 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: