B4J Question [ABMaterial] Where should I declare and connect my DB?

Cableguy

Expert
Licensed User
Longtime User
Hi guys

So it's time I make my ABM project connect to its DB...
Many questions arise but I'll start with only 2...
1 - where should I declare my connector?
In Main, Application or Page?
2 - where and when shall I open the connection and close it, knowing that I will be accessing it in a few pages
 
Last edited:
Sort by date Sort by votes

Cableguy

Expert
Licensed User
Longtime User
Good idea!
 
Upvote 0

Harris

Expert
Licensed User
Longtime User
alwaysbusy said:
Don't forget the samples in @Harris his tutorials: https://www.b4x.com/android/forum/threads/abmaterial-for-dummies-beginner-lessons.88346
Click to expand...


More specifically,

https://www.b4x.com/android/forum/threads/abmaterial-for-dummies-beginner-lessons.88346/#post-560669

In the Template Main (lesson3.zip) you will find:

B4X: 
' init the mysql driver
    ' you will need YOUR database name, user name (login), passowrd and pool size
    
    '                                               DB Name                               username        password      pool size
    ' DBM.InitializeMySQL("jdbc:mysql://localhost/   harris   ?characterEncoding=utf8",    "harris",     "b12xw3455",      100     )
    ' or...
    ' DBM.InitializeMySQL("jdbc:mysql://localhost/database?characterEncoding=utf8",  "username", "password",  100)
    
    
    DBM.InitializeMySQL("jdbc:mysql://localhost/harris?characterEncoding=utf8",     "harris",    "b12xxxx",   100)
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
B4J Tutorial [ABMaterial] Since Feedback is still down... I have a "wish"/question to make....
Replies
6
Views
1K
Cableguy
  • Question
B4J Question jserver what does this log line means ?
Replies
1
Views
643
Erel
  • Question
B4J Question [ABMaterial] 2 Requests (since feedback is down, I post them here)
Replies
0
Views
702
Cableguy
  • Question
B4J Question [ABMaterial - Back to Basics] How do I connect to a local database?
Replies
3
Views
1K
Harris
A
  • Question
B4J Question Specify debugger port
Replies
1
Views
1K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…