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/ |
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/ |
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/ |
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? _______________________________________________ Ibm-netrexx mailing list [hidden email] Online Archive : http://ibm-netrexx.215625.n3.nabble.com/ |
Jeff,
it seems that the work on that keeps being postponed. I will see if I can easily catch it earlier. René.
_______________________________________________ Ibm-netrexx mailing list [hidden email] Online Archive : http://ibm-netrexx.215625.n3.nabble.com/ |
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/ |
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/ |
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/ |
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/ |
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/ |
Free forum by Nabble | Edit this page |