B4J Question SQL Connection and time out

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 22, 2014

• #2

Use InitializeAsync instead: http://www.b4x.com/android/forum/threads/jsql-v1-20-asynchronous-initialization.42251/

 

Upvote 0

Fabrice La

Active Member

Licensed User

Longtime User

• Jun 22, 2014

• #3

Thanks Erel

Now my appli goes directly to the next step without the database connection, not good.
How to wait until the connection is timeout or success using the ProgressIndicator?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 22, 2014

• #4

See the code I posted in the library thread.

 

Upvote 0

Fabrice La

Active Member

Licensed User

Longtime User

• Jun 23, 2014

• #5

yes I saw it but StartMessageLoop I can't use it "java.lang.RuntimeException: StartMessageLoop should only be called in non-UI applications."

My appli need to have the database connection to run (Login). how to wait untill the connection is done to be able to run login ?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 23, 2014

• #6

This is the code:

B4X:

Sub AppStart (Args() As String)
   sql1.InitializeAsync("sql1", "com.mysql.jdbc.Driver", _
     "jdbc:mysql://localhost/example?characterEncoding=utf8", "user", "password")
   StartMessageLoop 'only required in a console app
End Sub

Sub sql1_Ready (Success As Boolean)
   Log(Success)
   If Success = False Then
     Log(LastException)
     Return
   End If
   Dim rs As ResultSet = sql1.ExecQuery("SELECT table_name FROM information_schema.tables")
   Do While rs.NextRow
     Log(rs.GetString2(0))
   Loop
   rs.Close
End Sub

As written in the comment you only need to call StartMessageLoop in a console app. You need to handle the Ready event. It will be raised when the connection is ready.

 

Upvote 0

Fabrice La

Active Member

Licensed User

Longtime User

• Jun 23, 2014

• #7

How to run an UI application and Non-UI Application (console) in the same time and share SQL connection ?
Do you have exemple ?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 23, 2014

• #8

Please start a new thread for a new question.

 

Upvote 0

Fabrice La

Active Member

Licensed User

Longtime User

• Jun 23, 2014

• #9

I will start a new thread.

In my case it is the same.

My application try to connect to a remote Mysql and need to be connected to run (Login) means UI fx appli.

As always you have good solutions for question and I thank you for that.

The solution you provide is to use the InitializeAsync connection but this one use a Non-UI application. Related to this my concern is :

Is it possible to run UI and Non-UI in paralell and share SQL connection

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 23, 2014

• #10

InitializeAsync works exactly the same in a UI app and a non-UI app. Ignore the StartMessageLoop call if you use it from a UI app.

 

Upvote 0

Fabrice La

Active Member

Licensed User

Longtime User

• Jun 23, 2014

• #11

I did it try it but the appli goes to login form but no login possible before dataconnection

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 23, 2014

• #12

You need to show the login form after SQL_Ready event is raised.

 

Upvote 0