Orbeon Demo, Demo Forms... etc.

[Grant LUI]

Hi,

I'm currently evaluating Orbeon 2024.1 CE, but I also use and have experience with 2023.1 CE (using a relational MariaDB database).

After setting up 2024.1 CE using the relational MariaDB database just like I did for 2023.1 CE (I did follow the steps to remove the embedded SQLite, i.e., setting the "oxf.fr.persistence.sqlite.active" to "false AND "oxf.fr.persistence.provider.*.*.*" to "MySQL" AND deleting the file "orbeon-demo.sqlite"), I note that the "Orbeon Demo: Bookshelf" section displays "error communicating with the database. "

If I put the file "orbeon-demo.sqlite" back to the WEB-INF folder, the error disappears from the section, except that the demo forms are not there. If I delete the .sqlite file, the error message appears again.

It seems that the 2024.1 CE still relies on the embedded SQLite even if I carry out the steps to remove it as mentioned in the online documentation.

Does anyone have similar experience and if so what are the resolutions?

Cheers!

Kar

[ebruchez]

Kar,

Are you using "MySQL" (capitalized), or just "mysql"? Unless you made some custom configuration, you need the lower case option.

Try setting all of the following properties:

<property
    as="xs:boolean"
    name="oxf.fr.persistence.sqlite.active"
    value="false"/>
<property
    as="xs:string"  
    name="oxf.fr.persistence.provider.orbeon.*.form"                    
    value="mysql"/>
<property
    as="xs:string"  
    name="oxf.fr.persistence.provider.orbeon-features.*.form"                    
    value="mysql"/>
<property
    as="xs:string"
    name="oxf.fr.persistence.provider.*.*.*"
    value="mysql"/>

I hope this helps,

-Erik

[Alessandro Vernet]

Kar,

For reference, in case you are wondering about some of the properties mentioned by Erik, see:

https://doc.orbeon.com/form-runner/persistence/relational-db#disabling-the-embedded-sqlite-provider

-Alex

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orbeon+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/orbeon/f5a00f9e-4afa-42ad-8f46-d5fc244aeb61n%40googlegroups.com.

[Grant LUI]

Hi Erik,

By the way, I confirm that adding your suggested two extra properties below makes no difference. The error on the "Orbeon Demo: Bookshelf" section continues to show, while other sections, such as the "Form Builder Forms" and "Published Forms" sections, work normally and are definitely retrieving data from the MariaDB.

<property
    as="xs:string"  
    name="oxf.fr.persistence.provider.orbeon.*.form"                    
    value="mysql"/>
<property
    as="xs:string"  
    name="oxf.fr.persistence.provider.orbeon-features.*.form"                    
    value="mysql"/>

I did a keyword search to confirm if the forms I created were written into the MariaDB and yes they are.

Like I said, I note that the "Orbeon Demo: Bookshelf" section on 2024.1 CE still relies on the embedded SQLite even if I carry out the steps to remove it and set up the required parameters to use MariaDB.

And just as I said in my initial thread:

"If I put the file "orbeon-demo.sqlite" back to the WEB-INF folder, the error disappears from the section, except that the demo forms are not there. If I delete the .sqlite file, the error message appears again."

I do not believe I have any problems with regards to Orbeon <-> MariaDB configuration. Please advise me if you have different thoughts, cheers!

[Grant LUI]

Hi Alex,

I read this, as already mentioned in my original thread.

I otherwise wouldn't be able to come up with knowledge about "oxf.fr.persistence.sqlite.active" to "false AND "oxf.fr.persistence.provider.*.*.*" and successfully got 2023.1 CE properly setup using a relational MariaDB database if I hadn't read. Cheers!

[Grant LUI]

Hi Ebruchez,

Not capitalized, all lower case.

Sorry if I didn't mention it clearly, but the relational database MariaDB can be connected without problem for all other sections except the "Orbeon Demo: Bookshelf" section. Please see the screenshot below. Cheers!

On Friday, March 14, 2025 at 8:12:55 AM UTC+8 ebruchez wrote:

[ebruchez]

Kar,

> "Orbeon Demo: Bookshelf" section continues to show

By removing the SQLite demo database, you don't have the demo forms anymore. The tile showing the Bookshelf form data on the Landing page therefore fails. So make sure to remove that tile, as well as the other demo forms tiles. You can do this by setting the following property:

    <property

        as="xs:string"

        name="oxf.fr.landing.cards"

        value="quick-links published-forms form-builder-forms"/>

I hope this helps,

-Erik

[Joel Oates]

Hello,

Just adding that I was having this issue also, the sqlite database was still being started up when I had set the properties mentioned, I ended up having to excluding WEB-INF/orbeon-demo.sqlite and WEB-INF/lib/sqlite-jdbc*.jar in my build

- Joel