Re: JDBC Connection properties for RDi Data Source Explorer

Thanks Tim - I think I can specify it via the connection string - but now I've seen yours I'll see if I can work out the "GUI" version.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Nov 6, 2017, at 11:05 AM, Tim Fathers <X700-IX2J@xxxxxxxxxxx> wrote:


Not sure how you're setting them at the moment but do you have the option to add properties to the driver connection string, as opposed to via a UI? Our Tomcat settings are as follows and the JT400 driver definitely honours these:

jdbc:as400://GER400;naming=system;errors=full;ignore <as400://GER400;naming=system;errors=full;ignore> warnings=0100C, 02000;prompt=no;date format=iso;query optimize goal=1;lob threshold=100000;extended metadata=true;libraries=QTEMP LIBL250.....

I think "autoCommit=yes" is the same as "no commit"

Tim.

________________________________
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx <mailto:wdsci-l-bounces@xxxxxxxxxxxx>> on behalf of Jon Paris <jon.paris@xxxxxxxxxxxxxx <mailto: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/><http://www.partner400.com <http://www.partner400.com/>>
Partner400 - Your partner in iSeries education<http://www.partner400.com/ <http://www.partner400.com/>>
www.partner400.com <http://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/><http://www.SystemiDeveloper.com <http://www.systemideveloper.com/>>
System i Developer - Home Page<http://www.systemideveloper.com/ <http://www.systemideveloper.com/>>
www.systemideveloper.com <http://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 <mailto: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 <mailto:wdsci-l-bounces@xxxxxxxxxxxx>] On Behalf Of Jon Paris
Sent: Saturday, November 4, 2017 6:19 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx <mailto: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/><http://www.partner400.com <http://www.partner400.com/>>
www.SystemiDeveloper.com <http://www.systemideveloper.com/><http://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 <mailto:WDSCI-L@xxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l <https://lists.midrange.com/mailman/listinfo/wdsci-l>
or email: WDSCI-L-request@xxxxxxxxxxxx <mailto:WDSCI-L-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l <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 <mailto:WDSCI-L@xxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l <https://lists.midrange.com/mailman/listinfo/wdsci-l>
or email: WDSCI-L-request@xxxxxxxxxxxx <mailto:WDSCI-L-request@xxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l <https://archive.midrange.com/wdsci-l>.