How to use the jdbc object store in the standalone application

[zhfeng]

Hi all,

I'm working on the sharding-sphere issue to save the transaction logs into the backend database for the cloud native environment. I think it could use the jdbc object store type and this example should be running as a standalone application. Also I'd checked the jboss-as transaction subsystem which uses the DataSourceJDBCAccess for getting the DataSource from the JNDI configuration. So I wonder it is possible to support this standalone case and how I can set the property of the JdbcAccess ?

Thanks,

Amos

[tomjenkinson]

Thanks for the query! It's not exactly what you are asking for but you can probably reverse engineer the configuration from our jts-docker example: quickstart/jts-docker at master · jbosstm/quickstart · GitHub

[mmusgrov]

We have a quickstart that shows how to use narayana in standalone mode. You need to edit the quickstart properties file to configure the object store and the options that can be set are in section "A.1.1.5. The JDBC store" of the following appendix of the Narayana Project Documentation

[zhfeng]

Thanks tomjenkinson - I just found the configuration with the jdbc object store here quickstart/jbossts-properties.xml at master · jbosstm/quickstart · GitHub which uses DynamicDataSourceJDBCAccess with the postgres datasource. I will take a look at these properties.

[zhfeng]

Thanks mmusgrov for providing this standalone quickstart.