Skip to Main Content

Embedded Technologies

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!

Error run listMidlets.sh

3188679Mar 3 2016 — edited Mar 25 2016

pi@raspberrypi ~ $ sudo sh javame8.2/bin/listMidlets.sh

Java is starting. Press Ctrl-C to exit

Frame buffer device detected: BCM2708

Frame buffer '/dev/fb0' detected: 592x448, depth=16

Failed to open /dev/input/by-id

[ERROR] [LCD] iso=-1:javacall_init_frame_buffer: failed to init keyboards

[CRITICAL] [PROXY] iso=-1:Can't create server

can not connect to device manager

[ERROR] [AMS] iso=0:The MIDlet suite could not be run.

How fix?

Comments

Frank Kulash
Answer

Hi,
Whenever you have a question, please post a little sample data in a usable form (such as CREATE TABLE and INSERT statements), so the people who want to help you car re-create the problem and test their ideas. Also post the exact results you want from the given data, and an explanation (in general terms) of you get those results from that data. Always say which version of Oracle you're using (e.g. 12.2.0.1.0).
See: https://community.oracle.com/tech/apps-infra/kb/articles/4-how-to-ask-questions-in-developer-community-spaces
If col1, col2, col3, ... are NUMBER columns (or any kind of NUMBER expressions) you can find how many of them that are positive numbers like this:

CASE WHEN col1 > 0 THEN 1 ELSE 0 END +
CASE WHEN col2 > 0 THEN 1 ELSE 0 END +
CASE WHEN col3 > 0 THEN 1 ELSE 0 END ...

If all the expressions are 0 or greater (i.e. no NULLs or negative values) then you can use:

SIGN (col1) +
SIGN (col2) +
SIGN (col3) ...

You can reduce the amount of code by unpivoting the columns, but that will make the query slower. Which is more important in this case: concise code or performance?

Marked as Answer by Sainaa · Jan 27 2021
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 22 2016
Added on Mar 3 2016
1 comment
1,497 views