Try to use the external database following document, but not work.

[ywang4362a]

HI! All,

We are trying to use oracle database as external database for AS6.0. We are following the jboss_jca_guide. But encount several problems.

1. 2.5 Change Database for the JMS services is invalid, see my previous post and kindly replied.

2. 2.7 Specify Database Dialect for Java persisetnce API, there is no such file: <JBoss_Home>/server/all/ deploy/ejb3.deployer/META-INF/persistence.properties

3. 2.8. Change Other JBoss AS Services to Use the External Database, we follow 2.8.1 The Easy Way. However, after we run jboss, it does not use our external database (I donot see any table is created in my oracle database). For sure, we change JNDI name in oracle-ds.xml and we put oracle-ds.xml to <JBoss_Home>/server/all/deploy/. We also remove <JBoss_Home>/server/all/deploy/hsqldb-ds.xml file.

Anyone can give us the hints?

Thanks a lot!

[ywang4362a]

Also, we notifice it is still using as60 internal database from startup screen:

07:17:03,005 INFO  [Version] Hibernate Validator 3.1.0.GA

07:17:03,070 INFO  [Version] Hibernate Validator 4.1.0.Final

07:17:03,081 INFO  [DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.

engine.resolver.JPATraversableResolver.

07:17:03,192 INFO  [DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.

engine.resolver.JPATraversableResolver.

07:17:03,198 INFO  [DefaultTraversableResolver] Instantiated an instance of org.hibernate.validator.

engine.resolver.JPATraversableResolver.

07:17:03,204 INFO  [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.

FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.

07:17:03,214 INFO  [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.c

onnection.InjectedDataSourceConnectionProvider

07:17:03,218 INFO  [InjectedDataSourceConnectionProvider] Using provided datasource

07:17:03,299 INFO  [SettingsFactory] Database ->

       name : HSQL Database Engine

    version : 1.8.0

      major : 1

      minor : 8

07:17:03,300 INFO  [SettingsFactory] Driver ->

       name : HSQL Database Engine Driver

    version : 1.8.0

      major : 1

      minor : 8

07:17:03,331 INFO  [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect

[wdfink]

As Jaikiran an me post in the other thread JBoss6 is different to versions before. Messaging is provided by HornetMQ where a database is not longer used, the messages are stored different.

I suppost you did not have the related document for JBoss6.

[ywang4362a]

Hi!

Thanks for your reply. The documentation I followed is in here:

http://docs.jboss.org/jbossas/6/JCA_Guide/en-US/pdf/JCA_Guide.pdf

Seems it is for jboss AS version 6. But maybe I am wrong. If not, do you have any idea when the document will be updated?

Thanks a lot!

[wdfink]

Mmh,

looks like that the documentation you found is out of date.

The official site I use is http://community.jboss.org/wiki/JBossApplicationServerOfficialDocumentationPage but here I found your link

and the Admin Guide is a dead link.

=> Jaikiran, a question for you, how do report this kind of documentation errors? broken link and outdated chapters?

For HornetMQ you should use the related links, but because there is no database there is nothing to change.

[ywang4362a]

Hi!

By following your link, it goes to the same document in my original document. Many thanks!