How to use the jdbc object store in the standalone application

zhfeng Jun 6, 2019 10:04 AM

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

1. Re: How to use the jdbc object store in the standalone application

tomjenkinson Jun 6, 2019 11:32 AM (in response to zhfeng)

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
Actions
2. Re: How to use the jdbc object store in the standalone application

mmusgrov Jun 7, 2019 7:54 AM (in response to zhfeng)

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
Actions
3. Re: How to use the jdbc object store in the standalone application

zhfeng Jun 10, 2019 3:50 AM (in response to tomjenkinson)

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.
Actions
4. Re: How to use the jdbc object store in the standalone application

zhfeng Jun 10, 2019 3:52 AM (in response to mmusgrov)

Thanks mmusgrov for providing this standalone quickstart.
Actions

Go to original post