× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Looks like it is listed in Data Studio as "Derby 10.0 - IBM Data Server Driver for JDBC and SQLJ (JDBC 4.0 ) Default).

Testing now.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Bailey
Sent: Friday, June 28, 2013 8:00 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio


Hi Jon,

That driver was installed by default when I installed the Data Studio software, but I can also create a new driver by selecting the "driver template" with the same name. Checking properties it says that the relevant jar files are located under my SDPShared folder, so maybe you can find them and create your own driver:
C:\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.1.503.v20121002_1809\driver\db2jc44.jar
C:\IBM\SDPShared\plugins\com.ibm.datatools.db2_2.1.503.v20121002_1809\driver\db2jcc_license_cisuz.jar

I've just realised that I am using IBM Data Studio Client 3.2.0, and I don't think that was the version you were looking at... so I may have lead you astray. Please accept my apologies, if that is true. Otherwise, I hope I've given you enough clues so you can work out what may have gone wrong in your case.


-Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: 28 June 2013 15:21
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

So do you know where you got that driver Paul? When I tried to select other drivers I got a path error or something of that nature.


On 2013-06-28, at 7:05 AM, Paul Bailey <PaulBailey@xxxxxxxxxx> wrote:


I see what you mean now, Jon. I think that using the "IBM Toolbox for
Java" (aka JTOpen and jt400.jar) for your IBM i connections is
probably discouraged and using the "IBM Data Server Driver for JDBC
and SQLJ (JDBC 4.0)" drivers will enable those features that are
unavailable from the toolbox. I definitely have the SQL Outline View
and Stored Proc debugging/editing with the JDBC 4.0 driver. (I don't
have pureQuery or the federation server software, and don't use the
other restricted features, so can't tell you about those.)


-Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: 26 June 2013 16:54
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

Check out this page Paul http://www-01.ibm.com/support/docview.wss?uid=swg27038175 and select the DB2 for i tab. On the RHS it identifies the release that various features are supported on. You will see that a significant number are marked with X1. If you look at the bottom of the page and fine the X1 reference you will see:

"X1 - Not supported when a connection is created by using only the IBM Toolbox for Java driver" - but no link, no explanation, nothing. That's what I was talking about.


On 2013-06-26, at 5:22 AM, Paul Bailey <PaulBailey@xxxxxxxxxx> wrote:

If we can talk above the sound of Eric's crickets...

Jon, have you got any examples of which features were unavailable with the default driver? I'm not quite sure what you mean.

I know that there are various "jt400" JDBC drivers and they sometimes have slightly different SQL features (especially between versions), so perhaps the default drivers with Data Studio have limited features and you can just download the "best" jt400.jar and use that? (Try http://jt400.sourceforge.net/ and/or http://pic.dhe.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/rzahh/whatsnew.htm for more details. Sorry I can't provide direct download links.) Obviously this is just for connecting to an IBM i, and you'll need other drivers for other database types.


-Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: 25 June 2013 20:20
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data
Studio

I have a sound board application on my tablet that plays a nice
"crickets chirping" sound, which seems appropriate for this topic
which obviously nobody knows anything about... Sorry I have nothing
of value to contribute, but at least you got a response! ;-D

-Eric DeLong

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Tuesday, June 25, 2013 2:07 PM
To: Wdsci-L
Subject: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

Didn't get a response on this before so I thought I;d try again:

In the list of supported features of Data Studio for IBM i there are a significant number that are marked as not being available using the default driver. Sadly it doesn't tell you which drivers will support those functions or how to obtain them. Are they chargeable features or ???


Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post
a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post
a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Scanned by MailDefender - managed email security from intY -
www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post
a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Scanned by MailDefender - managed email security from intY -
www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l.

Scanned by MailDefender - managed email security from intY - www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.