B4J Question Is it BUG, that in debug mode no exception but release mode yes?

[rosippc64a]

Hi Everybody,
I have a code piece, what works good in debug mode, but not in release mode. I think it should generate an exception in debug mode also, but it doesn't.

            If szf.GetString("IdoszakielszIN")="I" Then
                sb.Append($"
                    <invoiceDeliveryPeriodStart>${szf.GetString("Idoszakkezdete")}</invoiceDeliveryPeriodStart>
                    <invoiceDeliveryPeriodEnd>${szf.GetString("Idoszakvege")}</invoiceDeliveryPeriodEnd>
                    <invoiceAccountingDeliveryDate>${szf.GetString("Idoszakvege")}</invoiceAccountingDeliveryDate>
                "$)
            End If

The value of szf.GetString("IdoszakielszIN") is null. So in debug mode the compare null="I" is valid and the result is false, in release mode generate an exception ((NullPointerException) java.lang.NullPointerException).
I use postgres database and the szf.GetString("IdoszakielszIN") resulted a real null, not a string converted 'null'.
Is it a bug, or normal?

 

[alwaysbusy]

Have your tried swichting the condition? May have something to do with the casting.

If "I" = szf.GetString("IdoszakielszIN") Then

Alwaysbusy

 

[rosippc64a]

Yes, I tried, but fail. The solution was I give default value ("N") to this db field.

Here is the question not that, but whether it is normal that the same code works otherwise in debug mode as in release mode in B4J?

 

[keirS]

If you want to know whether a string is null it's quite easy:

R = JSQL.ExecQuery("select * from test2")
    Dim JO As JavaObject = R
    Do While R.NextRow
         Dim ISNull As Object =  JO.RunMethod("getObject",Array As Object("st2"))
         If ISNull = Null Then
             Log("String is Null")
        Else
            Log(R.GetString("st2"))
        End If
        
        
Loop

 

[rosippc64a]

Thank you @keirS, interesting solution, I think will use, but additionally I would that null="I" comparison (doesn't matter it is a good or wrong) do work at the same manner in debug and release mode!

 

[rosippc64a]

@Erel please check this out!

 

[Erel]

Combining nulls with strings is problematic and not recommended. The problem is that in some cases the null is converted to "null" and in some cases it wont.

I expect this code to work properly:

If "I" = szf.GetString("IdoszakielszIN") Then

 

[rosippc64a]

Thank you @Erel you are right. That is interesting, since there was a moment when it failed (post #3), but now it works well.
As I wrote there was another solution giving default value to the database field, I just wondering what would be the reason of that, that b4j program works different in debug and release mode.