Android Question Connect database in oracle from B4A

jose luis gudino said:

Hello, I am using the following code to connect to an Oracle database from B4A but I have not been able to do so.

B4X:

#AdditionalJar: ojdbc8.jar

B4X:

Dim DBLocation ="xxx.xxx.xx.xxx" As String
    Dim DBUsername ="vamos" As String
    Dim DBPassword ="Jlg10644263" As String
    sql.InitializeAsync("Oracle", "oracle.jdbc.driver.OracleDriver", $"jdbc:oracle:thin:@${DBLocation}:1521:xe"$, DBUsername, DBPassword)

B4X:

Sub Oracle_Ready (Success As Boolean)
    If Success Then
        Log("Ok")
    End If
End Sub

any idea of the problem?
Thanks in advance

Click to expand...

jose luis gudino said:

Hello, I am using the following code to connect to an Oracle database from B4A but I have not been able to do so.

B4X:

#AdditionalJar: ojdbc8.jar

B4X:

Dim DBLocation ="xxx.xxx.xx.xxx" As String
    Dim DBUsername ="vamos" As String
    Dim DBPassword ="Jlg10644263" As String
    sql.InitializeAsync("Oracle", "oracle.jdbc.driver.OracleDriver", $"jdbc:oracle:thin:@${DBLocation}:1521:xe"$, DBUsername, DBPassword)

B4X:

Sub Oracle_Ready (Success As Boolean)
    If Success Then
        Log("Ok")
    End If
End Sub

any idea of the problem?
Thanks in advance

Click to expand...

OliverA said:

Try using ojdbc7.jar w/Android. Android's Java-cloned sub-system may not be able to handle all of the Java 8 code used in ojdbc8.jar

Click to expand...

#AdditionalJar: ojdbc7.jar

jose luis gudino said:

Hello, I tried, but it didn't work

Click to expand...

OliverA said:

Nothing in the logs? You may have to do some USB debugging and/or turn log filtering off

Click to expand...

OliverA said:

Did you turn off the log filtering?

Click to expand...

jose luis gudino said:

The idea is to make the connection in the same way as it was done with B4J

Click to expand...