Skip to Main Content
Forums

Java SE (Java Platform, Standard Edition)

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!

[OSX] Unsupported Plug-in / Applets

3121955May 29 2020

Hi guys,

I came across a site with Java applets on it :

https://physics.uwb.edu.pl/main/ptf/fizyka2000/applets_EL.html

I have a MacBook and these plug-ins are not supported.

Yet Adobe Flash and Java are up-to-date and the preferences set-up shall permit them all.

Mac OSX version 10.15.5 (19F96)

Safari version 13.1.1 (15609.2.9.1.2)

Flash Player (NPAPI and PPAPI Plug-in) version 32.0.0.371.

See some screenshots here attached.

I have never experienced such difficulties on other sites.

What could I do?

Many thanks in advance for your attention.

Kindest regards

Rani

Screenshot 2020-05-29 at 16.36.34.png

Screenshot 2020-05-29 at 16.34.44.png

Screenshot 2020-05-29 at 16.33.26.png

Screenshot 2020-05-29 at 16.56.55.png

Screenshot 2020-05-29 at 16.41.03.png

Comments

Holger.Lehmann

Hi,

you have to transfer either a number (1,0) or varchar2(Y, N) to boolean true or false.

But always take the same solution for the whole application, keeps things easier.

Regards

Holger

1 person found this helpful

Al-Salamu Alikum We Rahmatu Allah We Barakatu,

Mohmed, what are you trying to do ?

May be you need to use Boolean in a function logic from forms or db. No  ?

If you need such a flag for such a logic (yes or no) you can use a Number or a Char Datatype.

Then, if the value column  is 1 then return Boolean function with TRUE & vise versa.

If it is 0 You can return False.

need to change the db item types.

Amatu Allah.

1 person found this helpful
Mohamed Ali Soltani

Hi @"Holger.Lehmann",

W Alikum Al-Salamu We Rahmatu Allah We Barakatu @"Amatu Allah Neveen Ebrahim",

Thank you for your answer.

My main question is : Does any of both can make a bug later ? Does both have same effect on performance ?

Holger.Lehmann

Hi Mohamed,

regarding performance this should have no impact.

In most cases I've seen usage of a varchar2(1) flag.

And in my current project there is a PL/SQL function, that converts Boolean values to a varchar2(1) flag.

  FUNCTION myBool_To_Flag_Function (PBoolean IN boolean) RETURN varchar2 IS

1 person found this helpful
Mohamed Ali Soltani

Hi Holger,

I haven't thought about it. It's really a good idea.

Thank you !

Amatu Allah Neveen Ebrahim
Answer

   You don't have to think about any database field as a Boolean value.

Just create a db field as Number, Char or Varchar2 datatype.

Number data type is a db type which i prefer it's faster than other data types.

I recommend using a pl/sql function with a Boolean return value using if statement to switch between two values either 0 or 1.

-------------------------------------------------------------

EXAMPLE:

========

FUNCTION TEST RETURN BOOLEAN IS
v_flage  NUMBER;
BEGIN
     BEGIN
      SELECT your_db_flg
      INTO  v_flage  
      FROM  your_table
     WHERE -- condition--- ;
  EXCEPTION
        WHEN NO_DATA_FOUND THEN RETURN 0;
  END;
 IF v_flage   = 1 THEN
     
           RETURN TRUE;
 ELSIF v_flage  = 0 THEN
     
         RETURN FALSE;
 END IF;
END;

Amatu Allah.

Marked as Answer by Mohamed Ali Soltani · Sep 27 2020
1 person found this helpful
Mohamed Ali Soltani

Thank you

You are welcome.

Andreas Weiden

Would you mind prooving this statement?

- Number data type is a db type which i prefer it's faster than other data types.

I don't think that there is any remarkable performance-difference with using a a NUMBER storing 0 and and a VARCHAR storing Y or N

A datatype decision should always be made to best fit its purpose.

Hello Andreas,

I agree.

Thanks for your comments.

1 - 10

Post Details

Added on May 29 2020
#java-applet-development
0 comments
345 views