B4J Question Where are the jMQTTBroker v2 messages stored?

byz · Aug 11, 2024

hi,guys:
Where are the jMQTTBroker v2 messages stored?
I'm using https://www.b4x.com/android/forum/threads/mqttbroker.61548/#content Post as a message broker for MQTT, I would like to ask where the message is? Whether it can be stored persistently, such as sqlite or mysql. I didn't find any way to store messages in the MqttBroker class.

Erel · Aug 13, 2024

Try to add this line before the broker is started:

B4X:

broker.As(JavaObject).GetFieldJO("config").RunMethod("setProperty", Array("persistent_store", File.Combine(File.DirApp, "mqtt.db")))

The persistent file is created. I haven't tested how exactly it is used.

Erel · Aug 13, 2024

Try to add this line before the broker is started:

B4X:

broker.As(JavaObject).GetFieldJO("config").RunMethod("setProperty", Array("persistent_store", File.Combine(File.DirApp, "mqtt.db")))

The persistent file is created. I haven't tested how exactly it is used.

byz · Aug 13, 2024

Erel said:
Try to add this line before the broker is started:

B4X:

broker.As(JavaObject).GetFieldJO("config").RunMethod("setProperty", Array("persistent_store", File.Combine(File.DirApp, "mqtt.db")))

The persistent file is created. I haven't tested how exactly it is used.

Thank you, Erel.I'll try later and bring the results to feed back here.

byz · Aug 13, 2024

Erel said:
Try to add this line before the broker is started:

B4X:

broker.As(JavaObject).GetFieldJO("config").RunMethod("setProperty", Array("persistent_store", File.Combine(File.DirApp, "mqtt.db")))

The persistent file is created. I haven't tested how exactly it is used.

?This code works.
It is stored in H2 database, not sqlite database.

https://github.com/andsel/moquette/blob/main/ChangeLog.txt

amorosik · Aug 16, 2024

byz said:
?This code works.
It is stored in H2 database, not sqlite database.

https://github.com/andsel/moquette/blob/main/ChangeLog.txt

How do you open a db file in H2 format?

byz · Aug 16, 2024

amorosik said:
How do you open a db file in H2 format?

I opened it with Notepad, and I can see that it is the H2 database, but I don't see the stored contents, and more information can be viewed on the official website of the H2 database. https://h2database.com/html/main.html

B4J Question Where are the jMQTTBroker v2 messages stored?

byz

Active Member

Erel

Erel

B4X founder

byz

Active Member

byz

Active Member

amorosik

Expert

byz

Active Member

Similar Threads

B4J Question Where are the jMQTTBroker v2 messages stored?

byz

Active Member

Erel

B4X founder

byz

Active Member

byz

Active Member

amorosik

Expert

byz

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency