Last active
October 24, 2024 12:45
-
-
Save vkasala/54e89d4f8dabb1f80e08 to your computer and use it in GitHub Desktop.
Wildfly CLI Datasource configuration with jdbc driver
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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