-
1. Re: How to remove Hypersonic DB as ESB internal data source
tcunning Mar 21, 2008 1:08 AM (in response to dsun)For #1 - yes. I'm assuming that you're suggesting changing the backing store for the registry - that should be as easy as changing the jbossesb.sar/juddi-ds.xml and changing a line in the jbossesb.sar/esb.juddi.xml to point to the oracle database creation and import files rather than the hsqldb ones.
For #2, there's now a "two_servers" QS checked in to the CP branch which demonstrates this scenario. I believe there's a section of the Administration Guide (Chapter 5 : ServiceBinding Manager) which covers this. It'll refer you to Chapter 10 of the JBoss AS Server documentation - here's a link :
http://labs.jboss.com/file-access/default/members/jbossas/freezone/docs/Server_Configuration_Guide/beta422/html/Additional_Services-Services_Binding_Management.html -
2. Re: How to remove Hypersonic DB as ESB internal data source
dsun Mar 27, 2008 5:57 PM (in response to dsun)For #1, do I have to change any config file to use oracle-ds.xml instead of hsqldb-ds.xml?
Under C:\jboss\server\default\deploy\jbossesb.sar\juddi-sql, I can't find create_database.sql. Instead, I can find it at C:\jboss\server\default\deploy\jbossesb.esb\message-store-sql\oracle. -
3. Re: How to remove Hypersonic DB as ESB internal data source
tcunning Mar 28, 2008 6:52 AM (in response to dsun)"dsun" wrote:
For #1, do I have to change any config file to use oracle-ds.xml instead of hsqldb-ds.xml?
Under C:\jboss\server\default\deploy\jbossesb.sar\juddi-sql, I can't find create_database.sql. Instead, I can find it at C:\jboss\server\default\deploy\jbossesb.esb\message-store-sql\oracle.
For JUDDI, the only change you have to make is in jbossesb.sar/esb.juddi.xml - here is the line you want to change.<entry key="juddi.sqlFiles">juddi-sql/hsqldb/create_database.sql,juddi-sql/hsqldb/import.sql</entry>
Change the hsqldb references to Oracle. The create_database.sql script is stored within the juddi jar, and will be pulled in as a resource.
Also you may want to also change message-store-ds.xml/ jbossesb-service.xml to use Oracle as well, and there are other components that you could change (jms, jbpm) to use Oracle depending on whether you are using them or not. -
4. Re: How to remove Hypersonic DB as ESB internal data source
dsun Mar 28, 2008 11:15 AM (in response to dsun)In juddi-ds.xml, I successfully changed <local-tx-datasource> section to use Oracle DB.
How should I change the following section to use Oracle?
juddiDB
true -
5. Re: How to remove Hypersonic DB as ESB internal data source
dsun Mar 28, 2008 11:20 AM (in response to dsun)
In juddi-ds.xml, I successfully changed <local-tx-datasource> section to use Oracle DB.
How should I change the following section to use Oracle?
<mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=Hypersonic,database=juddiDB"
juddiDB</attribute
true</attribute
mbean
Now I have the following error:
2008-03-28 11:13:31,928 ERROR [main] org.jboss.deployment.MainDeployer - Could not create deployment: file:/C:/jboss/server/tibco/deploy/jbossesb.sar/juddi-ds.xml
org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jca:service=LocalTxCM,name=juddiDB
at org.jboss.system.ServiceCreator.install(ServiceCreator.java:103)
at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:449)
at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:171)
at org.jboss.system.ServiceController.install(ServiceController.java:226)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source) -
6. Re: How to remove Hypersonic DB as ESB internal data source
kconner Mar 31, 2008 4:43 AM (in response to dsun)You need to remove that section as it is defining the hypersonic equivalent of your Oracle/jUDDI database configuration.