Re: Is iSphere plugin going to support Kerberos?

Good to know. I updated the test project to properly load the connections combo and to display an error message when it could not create a JDBC connection.

Thomas.

-----Ursprüngliche Nachricht-----
Von: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] Im Auftrag von Tyler, Matt
Gesendet: Montag, 22. Januar 2018 22:48
An: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Betreff: Re: [WDSCI-L] Is iSphere plugin going to support Kerberos?

I also loaded the test plugin and did receive the same response.

-Matt


-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Tools/400
Sent: Monday, January 22, 2018 2:43 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] Is iSphere plugin going to support Kerberos?

Arco,

That are great news, because it is what I expected to see. It seems that it is time to contact IBM for that issue.

From my point of view it seems to be a defect that the following code

does not return a connection when Kerberos comes into play:


private Connection getISphereJDBCConnection() {

Connection jdbcConnection = null;

try {
IBMiConnection ibmiConnection =
comboConnections.getISeriesConnection();
jdbcConnection = ibmiConnection.getJDBCConnection(null, false);
} catch (SQLException e) {
}

return jdbcConnection;
}

But according to your response the following code returns a Kerberos JDBC connection:

private Connection getKerberosJDBCConnection() {

Connection jdbcConnection = null;

try {
AS400JDBCDriver as400JDBCDriver = new AS400JDBCDriver();
if (DriverManager.getDriver("jdbc:AS400") == null) {
DriverManager.registerDriver(as400JDBCDriver);
}
IBMiConnection ibmiConnection =
comboConnections.getISeriesConnection();
AS400 system = ibmiConnection.getAS400ToolboxObject();
jdbcConnection = as400JDBCDriver.connect(system);
} catch (Throwable e) {
}

return jdbcConnection;
}

From my point of view there is a bug in IBMiConnection.

I wonder whether it makes sense to open a PMR when I do not have the equipment to do the tests myself.

Thank you,

Thomas.


Am 22.01.2018 um 20:11 schrieb Arco Simonse:

Hi Thomas,

I'm getting a result for the "Execute Kerberos Java" button: Loaded
from
SYSIBM.SYSDUMMY1: Y

Using the "Execute iSphere Java" results in the error below.

Regards,
-Arco

!ENTRY org.eclipse.ui 4 0 2018-01-22 20:08:26.261 !MESSAGE Unhandled
event loop exception !STACK 0 java.lang.NullPointerException at
de.tools400.test.kerberos.views.TestKerberosView.executeSql(TestKerber
osView.java:178)
at
de.tools400.test.kerberos.views.TestKerberosView.access$1(TestKerberos
View.java:174)
at
de.tools400.test.kerberos.views.TestKerberosView$1.widgetSelected(Test
KerberosView.java:87)
at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:2
49) at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4418)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4236)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3824)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(Par
tRenderingEngine.java:1121)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.jav
a:336)
at
org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartR
enderingEngine.java:1022)
at
org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Work
bench.java:150) at
org.eclipse.ui.internal.Workbench$5.run(Workbench.java:693)
at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.jav
a:336)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java
:610) at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
at
org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplic
ation.java:138)
at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle
.java:196)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplic
ation(EclipseAppLauncher.java:134)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Ecl
ipseAppLauncher.java:104)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.jav
a:388)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.jav
a:243) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
ava:90)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
orImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)
at org.eclipse.equinox.launcher.Main.run(Main.java:1519)
at org.eclipse.equinox.launcher.Main.main(Main.java:1492)


2018-01-20 22:44 GMT+01:00 Tools/400 <thomas.raddatz@xxxxxxxxxxx>:

I uploaded an Eclipse test project (Test Kerberos Connection.zip) to
SourceForge at:

https://urldefense.proofpoint.com/v2/url?u=https-3A__sourceforge.net_
projects_isphere_files&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFL
hr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WLaGx_v6tUwo
FvPC3cxXcSJHRPcqv6Nur4U8F5iDgIk&s=03u7mPHWrRggrkx0r8HkH0CO94C1scf0jBb
M3jUbF7E&e=

If was great if somebody, who knows how to import the project to
Eclipse and to launch an Eclipse application in debug mode, could
download and import the project to RDi 9.5 or RDi 9.6.

The project adds a "Tools/400 -> Kerberos Test" view, which contains
two
buttons:

Execute iSphere Java
Execute Kerberos Java

The first one uses the original iSphere Java code to get a JDBC
connection for executing a "select * from sysibm.sysdummy1" statement.
It uses the getJDBCConnection() method of class IBMiConnection to get
a JDBC connection.

The second button registers the AS400JDBCDriver JDBC driver and uses
method getAS400ToolboxObject() of class IBMiConnection to get an
AS400 object, which it passes to connect() of AS400JDBCDriver for
getting a JDBC connection.

I really would like to know if the second approach can connect to an
IBM i using Kerberos authentication.

Thomas.

--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WLaGx_v6tUwoFvPC3cxXcSJHRPcqv6Nur4U8F5iDgIk&s=dFgYHEklt7krIbIRB071z22Wttp5UFGxiZjp8aHX0uc&e=
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WLaGx_v6tUwoFvPC3cxXcSJHRPcqv6Nur4U8F5iDgIk&s=kJroGcGUBVC3KseLGAQWpDUL6jmdqoxhDOJjNI1iOcM&e=.