Skip to Main Content
Forums

Java Programming

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 do you run Java Puzzle Ball ?

9a14f127-8560-49af-a391-1434f9fe7f39Apr 27 2017 — edited Oct 30 2019

I've downloaded the JavaPuzzleBall jar file and now I'm trying to run it.

I've tried

java -jar JavaPuzzleBall.jar

java -cp JavaPuzzleBall.jar  javafxapplication01.JavaPuzzleBall

I've tried extracting the contents of the jar file into a directory and then, from this directory, running

java -cp .  javafxapplication01.JavaPuzzleBall

I've tried all the above using -classpath instead of -cp

In all cases the response I get is

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

I can see the JavaPuzzleBall.class file in the jar file in the correct location and when I extracted the contents it was there in the javafxapplication01 directory.

I've downloaded the jar file three times in case it had been corrupted, but still the same result.

Any ideas what the problem may be ?

Stuart

Comments

Karthick2003

First step can you describe TABLE1 and TABLE2?

2611484

I already edit the question

Karthick2003 
Describe means like this

SQL> desc emp
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMPNO                                     NOT NULL NUMBER
 ENAME                                              VARCHAR2(6)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER
 HIREDATE                                           DATE
 SAL                                                NUMBER
 COM                                                NUMBER
 DEPTNO                                             NUMBER

SQL> desc dept
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                    NOT NULL NUMBER
 DNAME                                              VARCHAR2(10)
 LOC                                                VARCHAR2(8)

SQL>
2611484

I posted the desc of table

Karthick2003

>  and c.status like 'ANSWERED%'

I dont see STATUS column in Table2

2611484

sorry i accidentally erase, now there's a status table

Karthick2003

Ok got it, Change this

select 'Data'
       ||','||to_char(d.dtime_day,'MM/dd/yyyy')
       ||','||sg1_cnt

To

select 'Data'
       ||','||dtime_day 


       ||','||sg1_cnt

dtime_day is already converted in the inner query.

2611484

i changed it already but i got zero results only, which is not right. each item have large total of result

Karthick2003

> i changed it already

Should I use my crystal ball to find it out?

> but i got zero results only, which is not right. each item have large total of result

Without your data i cant do much.

Moazzam 
select 'Data'


||','||to_char(d.dtime_day,'MM/dd/yyyy')


||','||sg1_cnt


||','||sg2_cnt


||','||sg3_cnt


||','||sg4_cnt


||','||sg5_cnt


||','||sg6_cnt


||','||sg7_cnt


||','||sg8_cnt


||','||sg9_cnt


||','||sg10_cnt

In the above select statement, which tables contains the columns (sg1_cnt, sg2_cnt, sg3_cnt.....etc), I think by removing these columns from SELECT shall fix the issue.

Karthick2003

Those come from the PIVOT. That is fine.

2611484

i change the sql script, but i got still zero results

Karthick2003 
33795304-702b-48ff-b4ba-e896b1db94db wrote:




i change the sql script, but i got still zero results

That means some of your conditions are failing. As said already without knowing what's in the table cant help. Just check you join and where conditions.

padders

Just to be clear, are you asking us to tell you why a query we haven't seen returns no rows based on data we haven't seen?

1 person found this helpful
2611484

I just posted some data of each table coumn

2611484

I already edited my post - sql sript and added more info about table columns

1 - 16

Post Details

Added on Apr 27 2017
#java-puzzle-ball
9 comments
1,981 views