can i connect mysql database or firebird database with LAMW
lazarus / 43-Android

----------------------------------------------------------------------
kadrisoft2006 · 2016-09-21 14:09

hi all
i need information ,
can i connect mysql database or firebird database with LAMW  using
zeosdb or other dac connections.

----------------------------------------------------------------------
Handoko · 2016-09-21 17:26

LAMW has jSqliteDataAccess and jSqliteCursor, they are located under
Android Bridges Extra tab on the Component Palette.

If you understand JVM programming, you can connect Firebird 'manually'
just like what this fellow did:
http://forum.lazarus.freepascal.org/index.php/topic,32686.msg210936.ht
ml#msg210936

Info about using JVM on Lazarus:
http://wiki.freepascal.org/Lazarus_JVM

----------------------------------------------------------------------
jmpessoa · 2016-09-21 19:19

Hi kadrisoft2006,

[Just a attempt... not tested!]

You can get  a "libfbclient.so.3.0.0" here:

http://www.firebirdnews.org/firebird-client-3-0-alpha-2-for-android-
download/

Then go to your " Controls.java" in your project folder ".../src/....
and repeat this pattern:

Code: Java  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i //Load
Pascal Librarystatic {/*--nogui--    try {       
System.loadLibrary("freetype"); // for "libfreetype.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibFreetype",
"exception", e);    }--graphics--*/      try {       
System.loadLibrary("controls"); //for "libcontrols.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibControls",
"exception", e);    }  } 
and then include all firebird ".pas" interface to your  ".../jni"
project folder

and then include "libfbclient.so.3.0.0" in your project folder 
"...\libs\armeabi"  together "libcontrols.so"

before your try any "build":

      Copy "llibfbclient.so.3.0.0" to NDK location   
"....\platforms\android-XX\arch-arm\usr\lib"
      where XX = 14 or 15 or 16... or 21 .. etc

      For Lamw project you can look for "XX" value in menu:
      "Project" --->> "Project Options" ---> "Compile Options" -->>
"Paths" --->> Libraries [-Fl]

More info: please read the section:
 "Version 0.6 - rev. 22 - 18 April 2015" 
in LAMW "readme.txt"

----------------------------------------------------------------------
kadrisoft2006 · 2016-09-22 06:55

thanks for all your information.
after insert the code ;

Code: Java  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i //Load
Pascal Librarystatic {/*--nogui--    try {       
System.loadLibrary("freetype"); // for "libfreetype.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibFreetype",
"exception", e);    }--graphics--*/     try {       
System.loadLibrary("controls"); //for "libcontrols.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibControls",
"exception", e);    }  } 
when iam build all my add code deleted !

----------------------------------------------------------------------
jmpessoa · 2016-09-22 18:30

Hi kadrisoft2006,

The displayed code is the standard/default...

you need something like:

Code: Java  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i //Load
Pascal Librarystatic {     try {       
System.loadLibrary("fbclient"); // for "libfbclient.so.3.0.0    }
catch (UnsatisfiedLinkError e) {         Log.e("JNI_Load_Libfbclient",
"exception", e);    }  /*--nogui--    try {       
System.loadLibrary("freetype"); // for "libfreetype.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibFreetype",
"exception", e);    }--graphics--*/    try {       
System.loadLibrary("controls"); //for "libcontrols.so"    } catch
(UnsatisfiedLinkError e) {         Log.e("JNI_Load_LibControls",
"exception", e);    }  } 
But yes,  LAMW will overwrite your modifications and return to default
one!!!

so, you will need [BEFORE load your project!] go to Lazarus menu

"Tools"---> "[Lamw] Android Module Wizard" --->
"[configure] CanUpdateJavaTemplate"

and set it to "False" .

NOTE: you can persist your modification hard code it in the
LAMW framework "Controls.java" located in folder  "...\java"