Build failed about JBoss ESB Sample QuickStarts Helloworld

[tobaby]

Hello,

I am new to JBoss ESB.

There are two question I confused.

The first question:

I downloaded SOA 5.1.0 GA and followed the step in <JBoss_Enterprise_SOA_Platform-5-SOA_Getting_Started_Guide-en-US.pdf>

But when I launch the server, it can launch successfully, but it has a warning as below:

2011-05-26 16:56:39,368 INFO  [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.1.0.GA_SOA (build: SVNTag=5.1.0.GA_SOA date=201102110032)] Started in 4m:23s:735ms

2011-05-26 16:57:35,604 WARN  [com.arjuna.ats.jta.logging.loggerI18N] (Thread-13) [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery  got XA exception javax.transaction.xa.XAException: Error trying to connect to provider java:/DefaultJMSProvider, XAException.XAER_RMERR

Should I pay attention to this warning?

The second question:

I launched a terminal window and navigate to the helloworld directory.

When I run

ant deploy, Quickstart_helloworld.esb build and deploy successfully.

But when I run ant runtest, this build failed.

The terminal window of running ant runtest shows:

C:\Users\Administrator>cd c:\jboss-soa-p-5\jboss-as\samples\quickstarts\hellowor
ld

c:\jboss-soa-p-5\jboss-as\samples\quickstarts\helloworld>ant runtest
Buildfile: c:\jboss-soa-p-5\jboss-as\samples\quickstarts\helloworld\build.xml

check-jbossesb-dist:

qslib-dependencies:

non-qslib-dependencies:

jbossesb-quickstart-override:

jbossesb-source-dependencies:

jbossesb-server-dependencies:
     [echo] Using profile: default

check-as-version:
     [echo] c:\jboss-soa-p-5\jboss-as\server\default

jbossesb-dependencies-as4:

jbossesb-dependencies-as5:

messaging-config:

messaging-dependencies:

jbossmq-dependencies:

hornetq-dependencies:

quickstart-specific-dependencies:

classpath-dependencies-as4:

classpath-dependencies-as5:

quickstart-specific-checks:

dependencies:

compile:
    [javac] c:\jboss-soa-p-5\jboss-as\samples\quickstarts\conf\base-build.xml:43
7: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=la
st; set to false for repeatable builds
    [javac] c:\jboss-soa-p-5\jboss-as\samples\quickstarts\conf\base-build.xml:44
2: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=la
st; set to false for repeatable builds

runtest:
     [echo] Runs Test JMS Sender
     [java] Exception in thread "main" javax.naming.NameNotFoundException: Conne
ctionFactory not bound
     [java]     at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)

     [java]     at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)

     [java]     at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
     [java]     at org.jnp.server.NamingServer.lookup(NamingServer.java:443)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
     [java]     at java.lang.reflect.Method.invoke(Method.java:597)
     [java]     at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.jav
a:305)
     [java]     at sun.rmi.transport.Transport$1.run(Transport.java:159)
     [java]     at java.security.AccessController.doPrivileged(Native Method)
     [java]     at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
     [java]     at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTranspor
t.java:535)
     [java]     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCP
Transport.java:790)
     [java]     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPT
ransport.java:649)
     [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Thread
PoolExecutor.java:886)
     [java]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPool
Executor.java:908)
     [java]     at java.lang.Thread.run(Thread.java:619)
     [java]     at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServe
r(StreamRemoteCall.java:255)
     [java]     at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCa
ll.java:233)
     [java]     at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:142)
     [java]     at org.jnp.server.NamingServer_Stub.lookup(Unknown Source)
     [java]     at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:72
6)
     [java]     at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:68
6)
     [java]     at javax.naming.InitialContext.lookup(InitialContext.java:392)
     [java]     at org.jboss.soa.esb.samples.quickstart.helloworld.test.SendJMSM
essage.setupConnection(SendJMSMessage.java:52)
     [java]     at org.jboss.soa.esb.samples.quickstart.helloworld.test.SendJMSM
essage.main(SendJMSMessage.java:81)

BUILD FAILED
c:\jboss-soa-p-5\jboss-as\samples\quickstarts\helloworld\build.xml:14: Java retu
rned: 1

Total time: 18 seconds
c:\jboss-soa-p-5\jboss-as\samples\quickstarts\helloworld>

The server console shows:

2011-05-26 17:16:38,008 WARN  [org.jboss.system.server.profileservice.hotdeploy.HDScanner] (HDScanner) Failed to process changes
org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS MISSING DEPENDENCIES:
  Deployment "jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_esb,service=Queue" is missing the following dependencies:
    Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
  Deployment "jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_gw,service=Queue" is missing the following dependencies:
    Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "Configured")
    Dependency "jboss.messaging:service=ServerPeer" (should be in state "Create", but is actually in state "Configured")
  Deployment "jboss.esb.vfszip:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/Quickstart_helloworld.esb/" is missing the following dependencies:
    Dependency "<UNKNOWN jboss.esb.vfszip:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/Quickstart_helloworld.esb/>" (should be in state "Installed", but is actually in state "** UNRESOLVED Demands 'jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_esb,service=Queue' **")
    Dependency "<UNKNOWN jboss.esb.vfszip:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/Quickstart_helloworld.esb/>" (should be in state "Installed", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
    Dependency "<UNKNOWN jboss.esb.vfszip:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/Quickstart_helloworld.esb/>" (should be in state "Installed", but is actually in state "** UNRESOLVED Demands 'jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_gw,service=Queue' **")

DEPLOYMENTS IN ERROR:
  Deployment "jboss.messaging:service=ServerPeer" is in error due to the following reason(s): Configured
  Deployment "<UNKNOWN jboss.esb.vfszip:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/Quickstart_helloworld.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_gw,service=Queue' **, ** UNRESOLVED Demands 'jboss.esb.quickstart.destination:name=quickstart_helloworld_Request_esb,service=Queue' **, ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
  Deployment "jboss.messaging:service=PostOffice" is in error due to the following reason(s): Configured

at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:1008)
at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:954)
at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:870)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.checkComplete(MainDeployerAdapter.java:128)
at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:416)
at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:294)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

Can some body provide expert comments for me?

Thanks.

[tobaby]

I found there are many warnings in the server.log.

I don't know whether I miss some config.

消息编辑者为：Jasmine Zhang The Content of server.log is too long. I posted it into the attachment.

[tcunning]

It looks like there are problems with whatever datasources you have configured. 

[tobaby]

Hi Tom,

Is your meaning that the database configuration has errors?

I use Sybase ASE 15.5.

I will check it now.

Thanks.

[tobaby]

Hi Tom,

You are right.

I redeploy a clean server, and this time I use the default database configuration.

Now I can deploy and run helloworld sample successfully.

But when I run the database configuration script to config datbase using Sybase ASE 15.5,

the server has errors, and the helloworld sample can't run correctly.

Following is the output when running the database configuration script:(The red text is my input)

c:\jboss-soa-p-5\jboss-as\tools\schema>ant
Buildfile: c:\jboss-soa-p-5\jboss-as\tools\schema\build.xml

execute:
   [groovy] JBoss SOA Platform Database Configuration Script
   [groovy] ------------------------------------------------
   [groovy]
   [groovy] This script is used to configure the SOA platform and all its
   [groovy] constituent components against a new RDBMS.  Deployment scripts
   [groovy] are currently available for the following databases:
   [groovy]   DB2 9.7, MS SQL 2008, MySQL 5.0, MySQL 5.1, Oracle 10g,
   [groovy]   Oracle 11g, Oracle 11RAC, PostgreSQL 8.2.4, PostgreSQL 8.3.7, Post
greSQL 8.4.x,
   [groovy]   Sybase ASE 15
   [groovy]
   [groovy] ** Warnings **
   [groovy]   This script may not work correctly if you have made manual
   [groovy]   changes to the database configuration.
   [groovy]   This script is only intended to do initial configuration.
   [groovy]   It is not intended to be used multiple times.
   [groovy]
   [groovy] Which server configuration are you changing?
   [groovy]   all, default, minimal, production, standard,
   [groovy]   web [default]:
default
   [groovy] Using profile directory:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\
   [groovy]
   [groovy] Profile is not clustered
   [groovy]
   [groovy]
   [groovy] Please enter the database you wish to configure:
   [groovy]   db2-97, mssql2008, mysql50, mysql51, oracle10g,
   [groovy]   oracle11g, oracle11RAC, postgresql824, postgresql837, postgresql84
,
   [groovy]   sybase15
sybase15
   [groovy] Database driver found for Sybase ASE 15:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\lib\jconn4.jar
   [groovy]
   [groovy] Using hibernate dialect:
   [groovy]   org.hibernate.dialect.SybaseDialect
   [groovy]
   [groovy] Using jUDDI directory:
   [groovy]   sybase
   [groovy]
   [groovy] Backing up files:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\ejb2-timer-service
.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb-registry.
sar\juddi_config\META-INF\persistence.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb-registry.
sar\juddi-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb.esb\jboss
esb-service.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbpm.esb\hibernate
.cfg.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbpm.esb\jbpm-serv
ice.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\uuid-key-generator
.sar\META-INF\jboss-service.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\META-I
NF\bpel-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\META-I
NF\jboss-beans.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\bpel.p
roperties
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\messaging\messagin
g-jboss-beans.xml
   [groovy]
   [groovy] Please enter the database instance name [soa]:
soa
   [groovy] Please enter the hostname or IP Address of the DB instance [localhos
t]:

10.72.14.60

   [groovy] Please enter the TCP port for the DB instance [4100]:
5000
   [groovy] Please enter the DB instance Username:
sa
   [groovy] Please enter the DB instance Password:

   [groovy]
   [groovy] Deleting HSQLDB files:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\hsqldb-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\messaging\hsqldb-p
ersistence-service.xml
   [groovy]
   [groovy] Configuring supporting scripts
   [groovy]   c:\jboss-soa-p-5\jboss-as\tools\schema\sybase15\sql\antsql.xml
   [groovy]
   [groovy] Setting up general datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\sybase-ds.xml
   [groovy]
   [groovy] Setting up messaging datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\messaging\messagin
g-jboss-beans.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\messaging\sybase-p
ersistence-service.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\messaging\db-jms-d
s.xml
   [groovy]
   [groovy] Setting up jUDDI datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb-registry.
sar\juddi_config\META-INF\persistence.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb-registry.
sar\juddi-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb-registry.
sar\juddi-ds.xml
   [groovy]
   [groovy] Setting up jBPM datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbpm.esb\jbpm-ds.x
ml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbpm.esb\hibernate
.cfg.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbpm.esb\jbpm-serv
ice.xml
   [groovy]
   [groovy] Setting up ESB datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb.esb\messa
ge-store-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\jbossesb.esb\jboss
esb-service.xml
   [groovy]
   [groovy] Setting up RiftSaw datasources:
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\META-I
NF\bpel-ds.xml
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\bpel.p
roperties
   [groovy]   c:\jboss-soa-p-5\jboss-as\server\default\deploy\riftsaw.sar\META-I
NF\jboss-beans.xml
   [groovy]

BUILD SUCCESSFUL
Total time: 51 seconds
c:\jboss-soa-p-5\jboss-as\tools\schema>

I wonder which data I input are incorrect.

Would Somebody tell me how to config with Sybase?

Thanks.

[tcunning]

Jasmine, do you have a support contract?   You mentioned you were using SOA-P 5.1.0.GA and you mentioned your issue is coming up after running the database configuration script.      If you do, I'd definitely log a support case and work this issue through support because they'd be more familiar with issues relating to the database config script and Sybase support.

If not, post up your datasource XMLs (-ds.xml) and we can go over them here.

[tobaby]

Hi Tom,

I don't have a support contract.

Following is the content of sybase-ds.xml. I found the file content was no change after I ran the database config script. Is it right?

But it should worked when I launched the JBoss SOA server. I found many tables in the Sybase database, and there were many links in the status of AWAITING COMMAND from the JBoss SOA server.

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>@JNDINAME@</jndi-name>
    <connection-url>jdbc:sybase:Tds:@HOSTNAME@:@PORT@/@DATABASE_NAME@</connection-url>
    <driver-class>com.sybase.jdbc4.jdbc.SybDataSource</driver-class>
    <user-name>@USERNAME@</user-name>
    <password>@PASSWORD@</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <min-pool-size>@MINPOOLSIZE@</min-pool-size>
    <max-pool-size>@MAXPOOLSIZE@</max-pool-size>
    <metadata>
      <type-mapping>Sybase</type-mapping>
    </metadata>
  </local-tx-datasource>

</datasources>

Thanks.

[tcunning]

That definitely does not look right.     Can you manually change the tokens to the values you entered while running the script?

[tobaby]

Hi, Tom

I manually change the sybase-ds.xml as following:

===========================================================

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>@JNDINAME@</jndi-name>
    <connection-url>jdbc:sybase:Tds:10.72.14.60:5000/soa</connection-url>
    <driver-class>com.sybase.jdbc4.jdbc.SybDataSource</driver-class>
    <user-name>sa</user-name>
    <password>ztenv123</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <min-pool-size>@MINPOOLSIZE@</min-pool-size>
    <max-pool-size>@MAXPOOLSIZE@</max-pool-size>
    <metadata>
      <type-mapping>Sybase</type-mapping>
    </metadata>
  </local-tx-datasource>

</datasources>

===========================================================

When I launched the server, it still had errors.

The first error is :

===========================================================

2011-06-01 17:24:08,727 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager

'jboss.jca:service=DataSourceBinding,name=juddiDB' to JNDI name 'java:juddiDB'
2011-06-01 17:24:10,047 INFO  [org.jboss.internal.soa.esb.dependencies.DatabaseInitializer] (main) Initializing java:/juddiDB from listed sql files
2011-06-01 17:24:10,061 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start:

name=jboss.esb:service=JUDDIDatabaseInitializer state=Create mode=Manual requiredState=Installed
java.lang.NullPointerException
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:130)
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:619)
2011-06-01 17:24:10,161 WARN  [com.arjuna.ats.jta.logging.loggerI18N] (Thread-13) [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local

XARecoveryModule.xaRecovery  got XA exception javax.transaction.xa.XAException: Error trying to connect to provider java:/DefaultJMSProvider,

XAException.XAER_RMERR

===========================================================

I found the server would create most a handard links with sybase, and these links were in AWAITING_COMMAND status.

Thanks.

[tcunning]

Please try changing :

@MINPOOLSIZE@ to 15

@MAXPOOLSIZE@ to 50

@JNDINAME@ to "DefaultDS" (without the double quotes)

If you are still seeing errors, please post the datasource XML again with the changes, along with the exception stack trace - posting that was very helpful.

[tobaby]

I found I made a mistake. I should see the sybase-ds.xml in the C:\jboss-soa-p-5\jboss-as\server\default\deploy directory not in the C:\jboss-soa-p-5\jboss-as\tools\schema\sybase15\template directory.

The content of sybase-ds.xml in the C:\jboss-soa-p-5\jboss-as\server\default\deploy directory is right as following:

===================================================

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:sybase:Tds:10.72.14.60:5000/soa</connection-url>
    <driver-class>com.sybase.jdbc4.jdbc.SybDataSource</driver-class>
    <user-name>sa</user-name>
    <password>ztenv123</password>
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <min-pool-size>15</min-pool-size>
    <max-pool-size>50</max-pool-size>
    <metadata>
      <type-mapping>Sybase</type-mapping>
    </metadata>
  </local-tx-datasource>

</datasources>

===================================================

It still had errors. The first error was the same as before.

===================================================

2011-06-02 08:25:42,200 INFO  [org.jboss.resource.deployers.RARDeployment] (main) Required license terms exist, view vfsfile:/C:/jboss-soa-p-5/jboss-as/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
2011-06-02 08:25:42,416 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=juddiDB' to JNDI name 'java:juddiDB'
2011-06-02 08:25:42,433 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=BPELDB' to JNDI name 'java:BPELDB'
2011-06-02 08:25:45,199 INFO  [org.jboss.internal.soa.esb.dependencies.DatabaseInitializer] (main) Initializing java:/juddiDB from listed sql files
2011-06-02 08:25:45,204 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb:service=JUDDIDatabaseInitializer state=Create mode=Manual requiredState=Installed
java.lang.NullPointerException
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.executeSql(DatabaseInitializer.java:130)
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.initDatabase(DatabaseInitializer.java:122)
at org.jboss.internal.soa.esb.dependencies.DatabaseInitializer.startService(DatabaseInitializer.java:159)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:619)

===================================================

I found the latter errors was caused by the first error.

The second error is :

===================================================

2011-06-02 08:26:28,989 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/uddi-console
2011-06-02 08:26:29,250 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/uddi-console]] (main) Servlet /uddi-console threw load() exception
org.apache.commons.configuration.ConfigurationException: No manager by name uddi-portlet-manager was found.  Please check your client uddi.xml files, and make sure this manager was started
at org.apache.juddi.v3.client.config.UDDIClientContainer.getUDDIClerkManager(UDDIClientContainer.java:36)
at org.jboss.internal.soa.esb.registry.console.InitAttributeServlet.init(InitAttributeServlet.java:67)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1048)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:950)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4122)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4417)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:321)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:145)
at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1454)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1172)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1193)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1113)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:826)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:556)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:789)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:699)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1652)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:938)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:988)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:778)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:543)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:619)
2011-06-02 08:26:29,405 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=JBossESBDS' to JNDI name 'java:JBossESBDS'
2011-06-02 08:26:29,478 INFO  [org.jboss.internal.soa.esb.dependencies.DatabaseInitializer] (main) java:/JBossESBDS datasource is already initialized

===================================================

Thanks.

[tcunning]

Do you see any earlier errors in your server.log or boot.log?     It doesn't seem like that should be the first error.

Also, are tables being created in your database?

[tcunning]

Alright, I think I've figured this one out.

Here's how to fix:

Edit jbossesb-registry.sar/juddi-ds.xml

I think you will see this towards the end of the file :

      <attribute name="SqlFiles">

         juddi-sql/sybase/import.sql

      </attribute>

The problem is that the sybase directory doesn't exist.     Sybase should be using the sqlserver scripts.

So change "juddi-sql/sybase/import.sql" to "juddi-sql/sqlserver/import.sql"

Then try starting SOA-P and see what happens.     If that doesn't work, we have one more option, which is to have hibernate autocreate your tables rather than create them from static SQL.      Try this change and see what happens first.

[tobaby]

Hi Tom,

I changed the jbossesb-registry.sar/juddi-ds.xml as you said. And it worked!

The server launched successfully and had no error.

I deployed the helloworld sample and it ran correctly.

Thank you very much!

[tobaby]

One more question:

I am confused why the server will create almost a handard links with Sybase,

and these links are in AWAITING_COMMAND status and seem to be not active.

Can the number of links from the database server be configured somewhere?

Thanks.