Skip to content

Instantly share code, notes, and snippets.

@vkasala
Last active July 20, 2023 03:17
Show Gist options
  • Save vkasala/54e89d4f8dabb1f80e08 to your computer and use it in GitHub Desktop.
Save vkasala/54e89d4f8dabb1f80e08 to your computer and use it in GitHub Desktop.
Wildfly CLI Datasource configuration with jdbc driver
#artificer.config.file.refresh = 60000
#artificer.config.baseurl = https://www.artificer.org/artificer-server
artificer.config.auditing.enabled = false
artificer.config.auditing.enabled-derived = false
# If you deploy SNAPSHOT artifacts to Artificer through Maven, updating an existing artifact is disallowed by default.
# To allow it, set this property to true.
artificer.config.maven.allow-snapshots = false
# Due to performance considerations, JMS support is disabled by default. Enable here.
artificer.config.events.jms.enabled = false
# Artificer will automatically attempt to discover a JMS ConnectionFactory through the literal JNDI name
# "ConnectionFactory". However, that name can be overridden here.
artificer.config.events.jms.connectionfactory = ConnectionFactory
# By default, Artificer publishes events through the "artificer/events/topic" JMS topic name (JNDI). But, it will also publish
# to any other names listed here (comma-delimited).
artificer.config.events.jms.topics = artificer/events/topic
# In addition to the above topics, Artificer will also publish non-expiring events to any JMS queue names (JNDI)
# listed here (comma-delimited).
artificer.config.events.jms.queues =
# blob or filesystem
artificer.file.storage = blob
# If filesystem, above, provide a path
#artificer.file.storage.filesystem.path =
# Hibernate (note that *any* Hibernate settings can be used)
hibernate.show_sql = false
hibernate.dialect = org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class = oracle.jdbc.driver.OracleDriver
hibernate.connection.datasource = java:jboss/datasources/OracleDS
hibernate.cache.use_query_cache = true
hibernate.cache.use_second_level_cache = true
hibernate.cache.region.factory_class = org.jboss.as.jpa.hibernate4.infinispan.InfinispanRegionFactory
hibernate.cache.infinispan.cachemanager = java:jboss/infinispan/container/hibernate
hibernate.cache.default_cache_concurrency_strategy = transactional
hibernate.transaction.factory_class = org.hibernate.transaction.JTATransactionFactory
hibernate.transaction.jta.platform = org.hibernate.service.jta.platform.internal.JBossAppServerJtaPlatform
# Hibernate Search (note that *any* Hibernate Search settings can be used)
hibernate.search.default.directory_provider = filesystem
hibernate.search.default.indexBase = lucene/indexes
#hibernate.generate_statistics = true
#hibernate.cache.use_structured_entries = true
# Create JBOSS module with JDBC driver
module add --name=com.oracle --resources=../jdbc/ojdbc14.jar --dependencies=javax.api,javax.transaction.api
# Create driver
/subsystem=datasources/jdbc-driver=oracle:add(driver-name="oracle",driver-module-name="com.oracle",driver-class-name=oracle.jdbc.driver.OracleDriver)
# Create datasource
data-source add --jndi-name=java:jboss/datasources/OracleDS --name=OraclePool --connection-url=jdbc:oracle:thin:@vmg05.mw.lab.eng.bos.redhat.com:1521:qaora10 --driver-name=oracle --password=dballo06 --user-name=dballo06
# Enable created datasource
data-source enable --name=OracleDS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment