Red Hat Bugzilla – Bug 843094
Lack of information and direction creates errors in the server start up when trying to configure an Oracle DefaultDS
Last modified: 2017-10-09 20:09:28 EDT
Description of problem: Lack of information and direction creates errors in the server start up when trying to configure an Oracle DefaultDS.
Version-Release number of selected component (if applicable):
How reproducible: go to 2.3. Configuring a datasource for Oracle DB
If I follow the directions here I get error after error and the solutions are not simple to track down. So I wrote out the commands for a linux install that will walk you through the steps that need to added to make the set up of an Oracle DS as DefaultDS work.
1. cd /var/lib/jbossas/server/xxx/deploy/messaging/
2. rm hsqldb-persistence-service.xml
a. this is in the docs/examples/jms/ also so you don’t need to save a copy of it.
3. cp /var/lib/jbossas/docs/examples/jms/oracle-persistance-service.xml .
4. vim oracle-persistence-service.xml
a. do a find on ‘Channel’
b. comment out the 4 lines below the Note that tells you to comment out the lines, like so.
5. chown jboss:jboss *
6. cd /var/lib/jbossas/server/xxx/deploy
7. vim default-oracle-ds.xml
a. The database listed in <type-mapping>Oracle9i</type-mapping> should match one of the <type-mapping> found in /var/lib/jbossas/server/xxx/conf/standardjbosscmp-jdbc.xml
b. In this case make sure it is set to <type-mapping>Oracle9i</type-mapping>
8. restart jBoss.
This link is older but helped; https://community.jboss.org/wiki/ChangeDefaultDataSource
Also it would help if you could list what the Roles and Permissions should be set to for the User that is used in the DefaultDS for Oracle. SYSTEM with all permissions is not practical for most databases. You explain this for the MySQL install but not for Oracle.
Steps to Reproduce:
I now realized that some of this is sort of explained in section 2.5. Configuring JBoss Messaging Persistence Manager. However there is nothing in setting up the DefaultDS to tell you to go there to resolve the errors that are created when you start the server. Also this section does not cover everything I listed above.
The original section in Getting Started Guide was removed (out of the scope of this BZ) during recent docs restructuring, only general information remained:
Detailed information about configuration of datasources is located in chapter 15 and 16 of the Administration and Configuration Guide:
Plus, there are examples of Oracle datasource configuration in appendix B3:
The two last mentioned links cover the information requested above.
Docs updated in 2012; marking this as Verified.