Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to write a 10G model clause for this

user517698Jun 14 2009 — edited Jun 17 2009
Hi ,

I am using Oracle 10G and i am trying to use the MODEL clause to cater for the following logics

data :


Row MCH_ID Date Failure_reason Working_hour(hrs) Working%
1 1 6/1/2009 8 0
2 1 6/2/2009 8 8
3 1 6/3/2009 8 16
4 1 6/4/2009 8 24
5 1 6/5/2009 Hydraulic 0 32
6 1 6/6/2009 Hydraulic 0 0
7 1 6/7/2009 8 0
8 1 6/8/2009 8 8
9 1 6/9/2009 8 16


Logics :
1 - 1st row will be 0 for working% & failure%
2 - if machine is working the next day , working% will add 8 hours
3 - if machine is down then the next day, the working% will be reset to 0%



pls advise

tks & rgds

Edited by: user517698 on Jun 14, 2009 7:02 PM

Comments

NickR2600-Oracle

That is really strange.  Let me investigate.  In the meantime, I have heard of incidences where the game won't run on OpenJDK, but will run on OracleJDK.

Thanks.

Maybe it is the point.

I also installed Oracle JDK.

I will keep trying.

NickR2600-Oracle

I'm able to get the game to work on Java 10.  Is your system using the runtime environment that comes with the Oracle JDK?  I don't believe OpenJDK includes a corresponding JavaFX implementation (OpenJFX) by default, which means you'd have to install additional packages to get the game to work using OpenJDK.

Gargoyle

I'm also on 18.04, and the game doesn't run for me on openjdk 10. This is what I did:-

sudo apt install openjdk-8-jdk openjfx

sudo update-alternatives --config java

From this menu, choose Java version 8 and then you should be able to run with:-

java -jar JavaPuzzleBall.jar

e37c10de-847c-4789-b50b-9e09f1131e8a

It worked!

Great!

Thanks for the help of you all.

Lee Turner

I seem to be having the same problem running the Jar:

java -version

openjdk version "1.8.0_131"

OpenJDK Runtime Environment (Zulu 8.21.0.1-macosx) (build 1.8.0_131-b11)

OpenJDK 64-Bit Server VM (Zulu 8.21.0.1-macosx) (build 25.131-b11, mixed mode)

java -jar JavaPuzzleBall.jar

Error: Could not find or load main class javafxapplication01.JavaPuzzleBall

Any ideas ?

NickR2600-Oracle

Hi Lee,

The culprit is OpenJDK.  OpenJDK doesn't include a JavaFX counterpart by default.  One option is to install additional OpenJFX packages to make up the difference.  Or another option is to install and run the game with Oracle's JRE.

Nick

Libor Modrovský

Hi, sorry I got to this great course late.

I have problems with running the game as well. Any idea ? Thanks.

c:\userdata\!>java -version

java version "10.0.1" 2018-04-17

Java(TM) SE Runtime Environment 18.3 (build 10.0.1+10)

Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10.0.1+10, mixed mode)

c:\userdata\!>java -jar c:\userdata\!\JavaPuzzleBall.jar

Exception in Application start method

java.lang.reflect.InvocationTargetException

        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.base/java.lang.reflect.Method.invoke(Unknown Source)

        at javafx.graphics/com.sun.javafx.application.LauncherImpl.launchApplicationWithArgs(Unknown Source)

        at javafx.graphics/com.sun.javafx.application.LauncherImpl.launchApplication(Unknown Source)

        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.base/java.lang.reflect.Method.invoke(Unknown Source)

        at java.base/sun.launcher.LauncherHelper$FXHelper.main(Unknown Source)

Caused by: java.lang.RuntimeException: Exception in Application start method

        at javafx.graphics/com.sun.javafx.application.LauncherImpl.launchApplication1(Unknown Source)

        at javafx.graphics/com.sun.javafx.application.LauncherImpl.lambda$launchApplication$2(Unknown Source)

        at java.base/java.lang.Thread.run(Unknown Source)

Caused by: java.lang.NullPointerException: Input stream must not be null

        at javafx.graphics/javafx.scene.image.Image.validateInputStream(Unknown Source)

        at javafx.graphics/javafx.scene.image.Image.<init>(Unknown Source)

        at javafxapplication01.JavaPuzzleBall.init(JavaPuzzleBall.java:49)

        at javafxapplication01.JavaPuzzleBall.start(JavaPuzzleBall.java:189)

        at javafx.graphics/com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$9(Unknown Source)

        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runAndWait$11(Unknown Source)

        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$9(Unknown Source)

        at java.base/java.security.AccessController.doPrivileged(Native Method)

        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$10(Unknown Source)

        at javafx.graphics/com.sun.glass.ui.InvokeLaterDispatcher$Future.run(Unknown Source)

        at javafx.graphics/com.sun.glass.ui.win.WinApplication._runLoop(Native Method)

        at javafx.graphics/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(Unknown Source)

        ... 1 more

Exception running application javafxapplication01.JavaPuzzleBall

Libor Modrovský

the above example is in Windows 10.

While ago I tried it in Virtual Box - Oracle DB Developer VM, and it works ( but it is slower ).

I would appreciate to make in run on Win10 as well, but it is not urgent.

Thank you.

Libor.

NickR2600-Oracle

That's a new one.  I'll have to see if I can reproduce it.  Is anyone else having trouble on Windows 10?

3705343

It ran fine for me.

User_60O5F

I did it using OpenJDK 12, this version has no JavaFX installed so I manually installed on the computer. The command I used was

java --module-path "C:\your\path\openjfx-11.0.2_windows-x64_bin-sdk\javafx-sdk-11.0.2\lib" --add-modules=javafx.controls,javafx.fxml,javafx.media --illegal-access=permit -jar JavaPuzzleBall.jar

It works great!

1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 15 2009
Added on Jun 14 2009
14 comments
2,920 views