Eclipse Community Forums: EGL Development Tools » Connection profile issue in 0.8.2

Home » Archived » EGL Development Tools » Connection profile issue in 0.8.2(Same issue as in 0.8.1.)

Connection profile issue in 0.8.2 [message #1003739]

Mon, 21 January 2013 17:47

Eclipse User

For details, see the old 0.8.1 thread:

http://www.eclipse.org/forums/index.php/t/378205/

Target database is DB2 on IBM i.

In an SQL binding, when working with connection profiles, we want to end up with a connection URL like this:

jdbc:as400:www.xxxxxxxxxxxxxxx.com;libraries=ddarnelldt;prompt=false

or (optionally)

jdbc:as400:www.xxxxxxxxxxxxxxx.com;naming=system;libraries=ddarnelldt;prompt=false

In driver properties I can create a connection URL that looks like those above but it is ignored in the connection profile.

In the connection profile I can specify a default schema but it is also apparently ignored.

In the connection profile the "Connection URL" is read-only.

The net result is that we cannot use connection profiles with DB2 on IBM i. We have to use the "Specify connection information" option and key in the details of every connection.

Bug? Enhancement request?

--Dan

Re: Connection profile issue in 0.8.2 [message #1004618 is a reply to message #1003739]

Wed, 23 January 2013 09:53

Eclipse User

Hi Dan,

I tried to use the optional properties under "Driver Properties", but they weren't being appended to the URL. I didn't see any way to modify this URL in the connection profile dialog (mind you I don't have IBMi so I was using DB2 on Linux). Since we just get the URL from the connection profile and don't mess with it, I suggest asking on the datatools forum to see if someone there knows how to append to the URL.

-Justin

Re: Connection profile issue in 0.8.2 [message #1004753 is a reply to message #1004618]

Wed, 23 January 2013 15:06

Eclipse User

Hi Justin,

I think I understand where you are coming from. So this aspect of the tooling is not an EDT thing -- you are just leveraging what is coming out of the datatools effort. Correct?

--Dan

Re: Connection profile issue in 0.8.2 [message #1004755 is a reply to message #1004753]

Wed, 23 January 2013 15:11

Eclipse User

That's right, we're just using what's already part of Eclipse.

-Justin

Previous Topic:	Error Using sysLib.wait(2);
Next Topic:	@MVC

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 08:03:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter