jUDDI migration to Oracle 11g assistance
alcarazj Dec 5, 2012 1:40 PMI deployed JBoss ESB 4.11 (jbossesb-4.11.zip) onto JBoss AS 6.1 (6.1.0.Final).
Now, I am migrating the JBoss ESB jUDDI registry to Oracle 11g.I have a juddiv3 database just created by the DBA. I have the server name, SID, user ID and password for it.
I have:
1. Added the classes12.jar oracle driver to ServerName/lib.
2. Edited the persistence.xml to <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
3. Created a oracle-ds.xml and dropped it under ServerName/deploy.
4. Created juddi_sequence (orm.xml) file using the "Oracle Sequence name" example in chapter 11.3 jUDDI User Guide
5. Started JBoss with errors and WARN messages along the way.
09:15:46,406 WARN [org.hibernate.util.DTDEntityResolver] recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
......
09:15:49,592 ERROR [org.hibernate.util.xml.ErrorLogger] Error parsing XML (5) : cvc-complex-type.3.1: Value '1.0' of attribute 'version' of element 'entity-mappings' is not valid with respect to the corresponding attribute use. Attribute 'version' has a fixed value of '2.0'
......
ERROR [ProfileServiceBootstrap] Failed to load profile:: org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
......
DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbossesb.esb" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbossesb.esb>" (should be in state "Installed", but is actually in state "** UNRESOLVED Demands 'jboss.esb:service=JuddiClient' **")
Deployment "jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbpm.esb" is missing the following dependencies:
Dependency "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbpm.esb>" (should be in state "Installed", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
......
DEPLOYMENTS IN ERROR:
Deployment "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/slsb.esb>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
Deployment "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbrules.esb>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
......
Deployment "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/jbossesb.esb>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:service=JuddiClient' **
Deployment "<UNKNOWN jboss.esb.vfs:///opt/jbossesb-6.1.0.Final/server/all/deploy/spring.esb>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:1228) [:2.2.2.GA]
at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:905) [:2.2.2.GA]
at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.checkComplete(MainDeployerPlugin.java:87) [:6.1.0.Final]
at org.jboss.profileservice.deployment.ProfileDeployerPluginRegistry.checkAllComplete(ProfileDeployerPluginRegistry.java:107) [:0.2.2]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:135) [:6.1.0.Final]
at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56) [:6.1.0.Final]
at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-6]
at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417) [jboss-bootstrap-impl-base.jar:2.1.0-alpha-6]
at java.lang.Thread.run(Thread.java:662) [:1.6.0_29]
09:15:52,239 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-jsoa-sals02%2F10.2.180.99-8080
09:15:52,245 INFO [org.apache.coyote.ajp.AjpProtocol] Starting Coyote AJP/1.3 on ajp-jsoa-sals02%2F10.2.180.99-8009
09:15:52,248 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-jsoa-sals02%2F10.2.180.99-8443
09:15:52,249 INFO [org.jboss.bootstrap.impl.base.server.AbstractServer] JBossAS [6.1.0.Final "Neo"] Started in 1m:21s:61ms
JBoss start okay; but, ESB and registry extensions does not.
Does anyone have any better instructions on how to migrate to an Oracle 11g database?