Hi,
I am having trouble connecting to bit,io online postgress db.
There error is "java.sql.SQLException: No suitable driver found for postgresql://xxxxxxxx but I think this maybe because SSL is not in the connection statement.
Can anyone help?
I am having trouble connecting to bit,io online postgress db.
There error is "java.sql.SQLException: No suitable driver found for postgresql://xxxxxxxx but I think this maybe because SSL is not in the connection statement.
Can anyone help?
B4X:
Sub Class_Globals
Private Root As B4XView
Private xui As XUI
Private SQL As SQL
#Region Database Location
Private DBLocation As String = "postgresql://connection from bit io"
Private DBUsername As String = "bit io user"
Private DBPassword As String = "bit io pass"
#End Region
End Sub
Public Sub Initialize
' B4XPages.GetManager.LogEvents = True
End Sub
'This event will be called once, before the page becomes visible.
Private Sub B4XPage_Created (Root1 As B4XView)
Root = Root1
Root.LoadLayout("MainPage")
End Sub
'You can see the list of page related events in the B4XPagesManager object. The event name is B4XPage.
Private Sub Button1_Click
LogError("----------BIT IO (PostgreSQL) ----------")
SQL.InitializeAsync("PostgreSQL", "org.postgresql.Driver", DBLocation, DBUsername, DBPassword)
SQL.Close
End Sub