Re: JDBC Connection properties for RDi Data Source (Jon Paris)

On Nov 6, 2017, at 1:34 PM, Vicki Wilson <VWilson@xxxxxxxxxxxxx> wrote:

Jon,

No - the naming only applies to the library list issue and allows you to query without specifying the library list.

I think for the commitment control issue you would add another line that would say commit=*NONE in the options. I can't verify this because I do not work currently have to do deal with commitment control. (Did you raise your eyebrows on that one...)

Vicki

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of wdsci-l-request@xxxxxxxxxxxx
Sent: Monday, November 06, 2017 10:00 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: WDSCI-L Digest, Vol 15, Issue 351

Send WDSCI-L mailing list submissions to
wdsci-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.midrange.com/mailman/listinfo/wdsci-l
or, via email, send a message with subject or body 'help' to
wdsci-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
wdsci-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than "Re: Contents of WDSCI-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Re: JDBC Connection properties for RDi Data Source Explorer
(Jon Paris)
2. Re: JDBC Connection properties for RDi Data Source (Jon Paris)


----------------------------------------------------------------------

message: 1
date: Mon, 6 Nov 2017 12:51:39 -0500
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: [WDSCI-L] JDBC Connection properties for RDi Data Source
Explorer

To show the view Window -> Show View -> Other ...

Type "data" in the filter and select Data Source Explorer.

Right click on Database Connections and select "New" - you'll see the dialog. The "Optional" tag is where you are supposed to be able to put keywords and values but it just wasn't working for me. Hopefully with the keyword reference page that Matt has given me I will do better.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Nov 6, 2017, at 11:48 AM, dlclark@xxxxxxxxxxxxxxxx wrote:

"WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx> wrote on 11/06/2017 09:32:23 AM:

Yes - but how do I actually specify it? I' thought I'd tried that
but to no effect.

If you have access to the URL itself, then you specify
naming=system to get it to use the library list. Otherwise, if a GUI
window, you'd have to tell me how to get to the RDi Data Explorer so I
can see what you see.


Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331




**********************************************************************
*********************** This email message and any attachments is for
use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in error,
please immediately notify the sender and delete and destroy the
message and all copies. All unauthorized direct or indirect use or
disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in transmission.
**********************************************************************
***********************
--
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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/wdsci-l.

------------------------------

message: 2
date: Mon, 6 Nov 2017 12:53:02 -0500
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: [WDSCI-L] JDBC Connection properties for RDi Data Source

So that affects the commit status as well Vikki?


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Nov 6, 2017, at 12:47 PM, Vicki Wilson <VWilson@xxxxxxxxxxxxx> wrote:


I specify it by adding

naming=system

in the Optional box on the Driver properties.

Vicki Wilson

Phooey - not enough caffeine yet this morning. Previously sent with wrong subject line.

________________________________
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> on behalf of Jon Paris
<jon.paris@xxxxxxxxxxxxxx>
Sent: 06 November 2017 16:48
To: Wdsci-L
Subject: Re: [WDSCI-L] JDBC Connection properties for RDi Data Source
Explorer

I guess I wasn't clear enough Matt.

I have that setting in ACS.

But as the subject says - I'm trying to find how to do it for RDi's Data Explorer.


Jon Paris

www.partner400.com<http://www.partner400.com>
Partner400 - Your partner in iSeries
education<http://www.partner400.com/>
www.partner400.com
If you are looking for the very best in IBM i* Education, Consulting and Mentoring services you have come to the right place! We are dedicated to helping our ...



www.SystemiDeveloper.com<http://www.SystemiDeveloper.com>
System i Developer - Home Page<http://www.systemideveloper.com/>
www.systemideveloper.com
Modernize at the RPG & DB2 Summit. i can, can you? Refresh your skills at the RPG & DB2 Summit and feel the thrill of delivering innovative software solutions to your ...

On Nov 6, 2017, at 10:08 AM, Tyler, Matt <matt.tyler@xxxxxxxxxxxxxx> wrote:

I believe its adding "with NC" to the end of modification statements should get you what you want.

But if you want it set permanently then on the JDBC config page, tab "System" in the middle is the "Isolation level:" drop down .

I see this on ACS 1.1.7.2

-Matt

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon
Paris
Sent: Saturday, November 4, 2017 6:19 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] JDBC Connection properties for RDi Data Source
Explorer

In ACS Run SQL scripts I can specify an isolation level of *NC and *NONE - which is what I want for the occasional editing/updating of non-journaled tables that I do. I also specify *LIBL or a list of libraries, naming conventions, etc.

I can find properties for the JT400 driver that appear to match (except the *NC/*NONE bit) and have entered them in the connection properties, but they seem to be ignored although I see no error messages.

Can anyone tell me how I'm supposed to do this - it is driving me nuts. I thought I had it working previously but this is a new install and I can't get it working.

P.S. I also have my default scheme specified in the connection - but it is still trying to find tables in a library matching my user name.


Jon Paris

www.partner400.com<http://www.partner400.com>
www.SystemiDeveloper.com<http://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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/wdsci-l.


------------------------------

Subject: Digest Footer

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


------------------------------

End of WDSCI-L Digest, Vol 15, Issue 349
****************************************
--
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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at https://archive.midrange.com/wdsci-l.

------------------------------

Subject: Digest Footer

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


------------------------------

End of WDSCI-L Digest, Vol 15, Issue 351
****************************************
--
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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.