Android Question jdbcSQL connection to mysql debug mode works correctly but release mode doesn't work

[mostosoft]

see please sub button1_click
why in debug mode it can connect to remote database and in release mode it doesn't work?
what's the error?
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

thanks

#Region Project Attributes
#ApplicationLabel: B4A Example
#VersionCode: 1
#VersionName:
'SupportedOrientations possible values: unspecified, landscape or portrait.
#SupportedOrientations: unspecified
#CanInstallToExternalStorage: False
#End Region

#Region Activity Attributes
#FullScreen: False
#IncludeTitle: True
#AdditionalJar: mysql-connector-java-5.1.34-bin.jar
#End Region

Sub Process_Globals
'These global variables will be declared once when the application starts.
'These variables can be accessed from all modules.
'#AdditionalJar: mysql-connector-java-5.0.8-bin.jar

Dim list As List
list.Initialize

End Sub

Sub Globals
'These global variables will be redeclared each time the activity is created.
'These variables can only be accessed from this module.

Private ListView1 As ListView
End Sub
Sub Activity_Create(FirstTime As Boolean)
'Do not forget to load the layout file created with the visual designer. For example:
Activity.LoadLayout("Layout1")


End Sub

Sub Activity_Resume

End Sub

Sub Activity_Pause (UserClosed As Boolean)

End Sub


Sub Button1_Click
Dim sql As JdbcSQL
Dim jsql As JdbcResultSet
sql.Initialize2("com.mysql.jdbc.Driver", "jdbc:mysql://sql2.freesqldatabase.com:3306/databasename","user","password")
jsql=sql.ExecQuery("select ragsoc from aappuntamento ")
Do While jsql.NextRow
Log(jsql.GetString("ragsoc"))
Loop
sql.Close
End Sub

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

Don't use blocking methods with remote databases.
See the example: https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content

 

[mostosoft]

Thank You Erel, It works!