B4J Question Berkeley Database

[umsid]

Hi,
is it possible to use Berkeley Database with B4J?

if yes, does anybody have a small tutorial for me?

I am searching for a database, for multiuser but do not want to install sql server or anything else.
I want to create (and use) database file with B4J may be also with B4A

With Sqlite is all this possible, but the database is not usable as multiuser version.

Thanks for helping
Guenter

 

[Erel]

With Sqlite is all this possible, but the database is not usable as multiuser version.

What do you mean with multiuser? Do you want to access the database from different processes?

There is a JDBC driver for Berkeley DB: https://github.com/perbone/jejdbc (there are others as well).

You can use jSQL library in B4J and JdbcSQL in B4A to connect to any DB that provides a JDBC driver.

 

[umsid]

Hello Erel,
I am programming a scoring app for sports. There I need 2 or 3 computers, where persons will input results.
So the app has work in a network. I know, that here SQLite have problems, cause it locks every time the complete database.
I do not want to install a server with mysql, I am searching for a "one-file database", which I can create direct from B4J, so cunstomer has nothing to do withour installing the app.
In past I tried to programm my app in Java, but I didn't get worm with Java, so I decide to use B4J to create this app.
With Java, I used H2 Database (http://www.h2database.com).
there you can create the database direct with java (no extra installation is necessary), it is usable as local, server and combinded database.
there is a possibility to encrypt database.

The problem is, that I am new in B4J and I didn't know, how to implement for example this H2Database.

As topic of my thread, I wrote Berkely Database, cause I thought, that it is not possible to use H2 with B4J.
But now, where you wrote, that I can connect to any database, I remembered this H2 Database.

May be, it is interested (H2 is complete java) for B4X to implement this database as B4X library??

Do you have a link (tutorial) for me, how to implement a database connection with jdbcSQL?

Thanks a lot for your answer
Guenter

 

[Erel]

May be, it is interested (H2 is complete java) for B4X to implement this database as B4X library??

You don't need a special library for databases that provide a JDBC driver.

Start with this tutorial: https://www.b4x.com/android/forum/threads/35185