Search Results

databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL are supported. Others are also supported. The recommended method to connect to remote databases is jRDC2: https://www.b4x.com/android/forum/threads/61801/#content Connecting to the database directly has... password and directly access the database. - Hard to maintain - changes to the database design will require... mobile usage. - Reliability issues due to unstable connectivity. I don't recommend using it in...

can connect to any database platform that provides a JDBC driver. This includes: MySQL, SQL Server... without a database server by connecting to a local SQLite database file. The Java web-server is a simple server that connects to the database server and to the Android clients. As this is a Java app....sourceforge.net/ The server uses an open source project named c3p0 to manage the database connection...-database-connector.61801/ This tutorial covers a new framework named Remote Database Connector (RDC...

required for creating a connection between Android device and a remote server. In this case it is a MySQL database. A tutorial for connecting to SQL Server is available here. Android cannot connect directly to the database server (search for JdbcSQL). Therefore we need to create a simple web service that will pass the requests to the database and will return the response. For this example I've created a new database that lists the countries population. The data was derived from a UN...

Hi guys, I need a help, how to configure jRDC to connect to multiple database. Thanks in advance....

Hi Fam With just a few tweaks, one is able to use the php-crud-api to access different databases at runtime. I have updated the api.php file to use HEADERS to ensure that this happens. One needs to include these headers for the api.php file. NB. Please note the X-API-Key for the authorization key...
link: phpsqlite.SetSQLiteConnection(Main.DBHost) phpsqlite.CLEAR_WHERE BANano.Await(phpsqlite...
link: 164469...

Is it possible to use a c3po-config.xml file to configure the connection pooling? I assume it would go in the files folder if it's possible....

Hi Fam Original Project I've been looking at ways to get the api.php file for CRUD REST to work in a dynamic fashion so that I can get it connect to any back-end database. I found a way to do..., sPort) These will be passed to the api.php library so that its dynamic and able to connect to any database back-end. Enjoy!...
link: For SQLite - you set the driver and the host header and the others should be blank. For MySQL - you set the rest of the settings applicable....

Hi guys, In a non UI database, I have a codes like these Sub Process_Globals Private pool As ConnectionPool Private Tm As Timer End Sub Sub AppStart (Args() As String) pool.Initialize...==========================================") Try Qry = pool.GetConnection RS = Qry... ExecQ.TransactionSuccessful Catch Log("unable to connect!") End Try Tm.Enabled = True End Sub When datatabase connection errors happen, Query, ResultSet &...

Hi, I am going through the ABMaterial demo and I haven't seen anything about databases. I guess it will be a matter of B4J and not ABMaterial, is that so? Thank you very much....
link: Thank you very much....
link: Yes, you can use everything you find here on the forum about databases. ABM is just an UI layer...

Hi jRDC gurus! Can the same instance (I one single jRDC server) connect to 2 (or more) databases? If so, can a sample code/ config be provided? Or do I really need to run 1 server per database?...