Android Question Connect database in oracle from B4A

[jose luis gudino]

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

#AdditionalJar: ojdbc8.jar

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)

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

any idea of the problem?
Thanks in advance

 

[JohnJ]

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

#AdditionalJar: ojdbc8.jar

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)

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

any idea of the problem?
Thanks in advance

There are lots

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

#AdditionalJar: ojdbc8.jar

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)

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

any idea of the problem?
Thanks in advance

There are lots of posts in the forum on connecting to an oracle database. The driver name in your post looks a bit strange

 

[jose luis gudino]

Thanks for the information. I did connect to the database via jRDC and it works perfectly. The idea is to make the connection in the same way as it was done with B4J

 

[OliverA]

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

 

[jose luis gudino]

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

#AdditionalJar: ojdbc7.jar

Hello, I tried, but it didn't work

 

[OliverA]

Hello, I tried, but it didn't work

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

 

[jose luis gudino]

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

It's strange, it doesn't show any message in the usb log

 

[OliverA]

Did you turn off the log filtering?

 

[jose luis gudino]

Did you turn off the log filtering?

yes, I have disabled the filters

 

[josejad]

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

Do you know you can connect from B4A with jRDC2 too?

 

[OliverA]

If you change Oracle_Ready to

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

Will you get (eventually) a "Not ok" ?

 

[jose luis gudino]

Yes, I have managed to make the connection with jRCD2, I think I am going to use it, it is more convenient