NetRexx hierarchy problem

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

NetRexx hierarchy problem

Jeff Hennick-3

I have been trying to get the Pipelines stage SQLSELECT with SQLite to work for me.  With little luck until today.  I followed Rony Flatscher's lead from his announcement of SQLite and BSF4ooRexx, and got <https://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/3.32.3.2/sqlite-jdbc-3.32.3.2.jar>.

I found, by the long hard way, that after I installed a current Java JDK, that I had an older RTE.  This is now OK and I can both compile and run pure Java.  And get it to work with SQLite.  This is the Sample.java from Maven working fine:

PS C:\Users\Jeff\documents\pipe tests> java -version java version "14.0.2" 2020-07-14 Java(TM) SE Runtime Environment (build 14.0.2+12-46) Java HotSpot(TM) 64-Bit Server VM (build 14.0.2+12-46, mixed mode, sharing) PS C:\Users\Jeff\documents\pipe tests> javac Sample.java PS C:\Users\Jeff\documents\pipe tests> java Sample name = leo id = 1 name = yui id = 2

So back to SQLSELECT.nrx.  Apparently it is a stage that must be in the STAGES sub-directory.  I un-commented the TRACE RESULTS and tried to compile it with the ANT directive.

This is what I get:

compile.process: [buildnrc] Copying one (1) file to C:\Users\Jeff\netrexx-code\build\classes\org\netrexx\njpipes\stages [buildnrc] Compiling one (1) source file to C:\Users\Jeff\netrexx-code\build\classes\org\netrexx\njpipes\stages [buildnrc] java.lang.Exception: # RxQuit traceback for internal.error [buildnrc] at org.netrexx.process.RxQuit.<init>(RxQuit.java:88) [buildnrc] at org.netrexx.process.RxQuit.<init>(RxQuit.java:62) [buildnrc] at org.netrexx.process.RxClass.scan05(RxClass.java:666) [buildnrc] at org.netrexx.process.RxParser.crossclass(RxParser.java:1226) [buildnrc] at org.netrexx.process.RxTranslator.dotranslate(RxTranslator.java:524) [buildnrc] at org.netrexx.process.RxTranslator.translate(RxTranslator.java:375) [buildnrc] at org.netrexx.process.NetRexxC.process(NetRexxC.java:518) [buildnrc] at org.netrexx.process.NetRexxC.main2(NetRexxC.java:337) [buildnrc] at org.apache.tools.ant.taskdefs.optional.NetRexx.doNetRexxCompile(NetRexx.java:1002) [buildnrc] at org.apache.tools.ant.taskdefs.optional.NetRexx.execute(NetRexx.java:594) [buildnrc] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) [buildnrc] at jdk.internal.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) [buildnrc] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43) [buildnrc] at java.base/java.lang.reflect.Method.invoke(Method.java:564) [buildnrc] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) [buildnrc] at org.apache.tools.ant.Task.perform(Task.java:348) [buildnrc] at org.apache.tools.ant.Target.execute(Target.java:390) [buildnrc] at org.apache.tools.ant.Target.performTasks(Target.java:411) [buildnrc] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) [buildnrc] at org.apache.tools.ant.Project.executeTarget(Project.java:1368) [buildnrc] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [buildnrc] at org.apache.tools.ant.Project.executeTargets(Project.java:1251) [buildnrc] at org.apache.tools.ant.Main.runBuild(Main.java:809) [buildnrc] at org.apache.tools.ant.Main.startAnt(Main.java:217) [buildnrc] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) [buildnrc] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) [buildnrc] Compilation of 'sqlselect.nrx' failed [one error, one warning] [buildnrc] Translate time: 0.1s [buildnrc] NetRexx portable processor 3.09-GA [buildnrc] Copyright (c) RexxLA, 2011,2020. All rights reserved. [buildnrc] Parts Copyright (c) IBM Corporation, 1995,2008. [buildnrc] Program sqlselect.nrx [buildnrc] [C:\Users\Jeff\netrexx-code\build\classes\org\netrexx\njpipes\stages\sqlselect.nrx 11 8 4] Warning: No class es found for import from package 'java.sql.' [buildnrc] [C:\Users\Jeff\netrexx-code\build\classes\org\netrexx\njpipes\stages\sqlselect.nrx 30 25 5] Severe Error: In ternal error: RxClass: hierarchy BUILD FAILED

I have no idea of where to start on "Severe Error: Internal error: RxClass: hierarchy" on line 30,  "class sqlselect extends stage".  But it sure does leave quite a trail!

Note: Prior to that attempt at rebuild, I tried using the previous version of SQLSELECT, which is why I was going to look at the trace output.

PS C:\Users\Jeff\documents\pipe tests> pipc testflight2 pipe (testflight2 ) literal * from FlightRoute where flight = 'KLM765' | sqlselect | console java.lang.Exception: # RxQuit traceback for internal.error at org.netrexx.process.RxQuit.<init>(RxQuit.java:88) at org.netrexx.process.RxQuit.<init>(RxQuit.java:62) at org.netrexx.process.RxClass.scan05(RxClass.java:666) at org.netrexx.process.RxParser.crossclass(RxParser.java:1226) at org.netrexx.process.RxTranslator.dotranslate(RxTranslator.java:524) at org.netrexx.process.RxTranslator.translate(RxTranslator.java:375) at org.netrexx.process.NetRexxC.process(NetRexxC.java:518) at org.netrexx.process.NetRexxC.main2(NetRexxC.java:337) at org.netrexx.process.NetRexxC.main(NetRexxC.java:298) at org.netrexx.process.NetRexxC.main(NetRexxC.java:269) at org.netrexx.njpipes.pipes.compiler.<init>(compiler.java:1495) at org.netrexx.njpipes.pipes.compiler.<init>(compiler.java:1263) at org.netrexx.njpipes.pipes.compiler.main(compiler.java:1587) 12 +++ class testflight2 extends org.netrexx.njpipes.pipes.pipe final +++ ^^^ +++ Severe Error: Internal error: RxClass: hierarchy PS C:\Users\Jeff\documents\pipe tests>

If anyone can shed any light on this, please do.  Thank you.  I very much want to get SQLite working with NetRexx and Pipelines before release of 3.09.

Jeff Hennick



_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jason Martin
You are back to Java 8 and not Java 14 right?

NetRexx is still at 8 for now.

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

rvjansen
Yes, that looks like a Java >8 error message.

René.

> On 12 Aug 2020, at 03:43, Jason Martin <[hidden email]> wrote:
>
> You are back to Java 8 and not Java 14 right?
>
> NetRexx is still at 8 for now.
>
> _______________________________________________
> Ibm-netrexx mailing list
> [hidden email]
> Online Archive : https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm-2Dnetrexx.215625.n3.nabble.com_&d=DwIFaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=_6rXNpPJ1fYV-3bV1za02NiR4PUelvicfHXwtnTXpXE&m=NAX9-H_PZHy6dWYaRa44v3yn11WxdVxdnceHRDnGl4o&s=3vR5pAW8eKAXK7z3HohjKb6wXn9I8bidQlgcmqErajs&e= 
>

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jeff Hennick-3
In reply to this post by Jason Martin

Jason,

Thank you.

Nope, I loaded the "current" JDK version, 14, from the page that came up when searching for JDK.

If we can't use that, we should have a DO CATCH and  a message to that effect even help in where to get it, instead of a screen full of errors.

It now looks like I can select an earlier one from https://jdk.java.net/ , but there is no guidance for what level of Java each JDK has.

Jeff

On 8/11/2020 9:41 PM, Jason Martin wrote:
You are back to Java 8 and not Java 14 right?

NetRexx is still at 8 for now.

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/


_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

rvjansen
Jeff,

it seems that the work on that keeps being postponed. I will see if I can easily catch it earlier.

René.

On 12 Aug 2020, at 13:33, Jeff Hennick <[hidden email]> wrote:

Jason,

Thank you.

Nope, I loaded the "current" JDK version, 14, from the page that came up when searching for JDK.

If we can't use that, we should have a DO CATCH and  a message to that effect even help in where to get it, instead of a screen full of errors.

It now looks like I can select an earlier one from https://jdk.java.net/ , but there is no guidance for what level of Java each JDK has.

Jeff

On 8/11/2020 9:41 PM, Jason Martin wrote:
You are back to Java 8 and not Java 14 right?

NetRexx is still at 8 for now.

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/



_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jason Martin
Needed in NetRexxC.nrx

Maybe in more than one place to catch all entry points


parse System.getProperty("java.version") oldversioning "."

if oldversioning > "2" then do
   say "A Java 8 runtime is required"
   exit
end


-- not really needed

say "whoops something when wrong"

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jason Martin
should be > "1"

was playing around with tests

On 2020-08-12 09:19, Jason Martin wrote:
> if oldversioning > "2"
_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

rvjansen
To be honest I thought about that, but reality is more complex: if you generate a Graal VM native executable, some things work fine >8

> On 12 Aug 2020, at 15:21, Jason Martin <[hidden email]> wrote:
>
> should be > "1"
>
> was playing around with tests
>
> On 2020-08-12 09:19, Jason Martin wrote:
>> if oldversioning > "2"
> _______________________________________________
> Ibm-netrexx mailing list
> [hidden email]
> Online Archive : https://urldefense.proofpoint.com/v2/url?u=http-3A__ibm-2Dnetrexx.215625.n3.nabble.com_&d=DwIFAg&c=jf_iaSHvJObTbx-siA1ZOg&r=_6rXNpPJ1fYV-3bV1za02NiR4PUelvicfHXwtnTXpXE&m=wrEwf8JZLDstU38bk-AsqH4L74_drnURjPFSUapVFXM&s=u_XyzjpvZpcV6VuQ5e-5kY2KbJR8Jmwm19WxOB9s74Y&e= 
>

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jason Martin
Have not played with it.

The OSes I play with probably will not be supported anytime soon if ever.

On 2020-08-12 10:21, René Jansen wrote:
> Graal VM native executable
_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

Reply | Threaded
Open this post in threaded view
|

Re: NetRexx hierarchy problem

Jeff Hennick-3

Jason and René,

Thank you.

For the record, I have reverted to Java SE 8 RTE, and all is OK here.

I have successfully run

pipe (testflight2 ) literal * from FlightRoute where flight = 'KLM765' | sqlselect | console

and got

FLIGHT--ROUTE--UPDATETIME-- KLM765 AUA-BON-AMS 1494132448

(looks like a sweet flight! at both ends.)

I'm next going to see if I can implement a stage for SQLite (and the other JDBC databases) for non-select commands.

And, René, I'll put an optional "SELECT" keyword into sqlselect, for "readability."  So, the above could be as above, or literal select * from FlightRoute where flight = 'KLM765'


_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/