help with jboss-mysql-specjappserver2004

[terryxian]

Hi, I encountered some errors when installed jappserver2004 using oracle, so now I switch to MySQL. After modified jboss-MySQL-run.properties, excuted 'ant install', loaded databases and then ran
ant run-tests
I got bunch of errors all like:

Connection refused

java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) at java.net.Socket.connect(Socket.java:452) at java.net.Socket.connect(Socket.java:402) at java.net.Socket.(Socket.java:309) at java.net.Socket.(Socket.java:124) at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:118) at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:683) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:662) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:558) at org.apache.cactus.internal.client.connector.http.HttpClientConnectionHelper.connect_aroundBody0(HttpClientConnectionHelper.java:142) at org.apache.cactus.internal.client.connector.http.HttpClientConnectionHelper.connect_aroundBody1$advice(HttpClientConnectionHelper.java:206) at org.apache.cactus.internal.client.connector.http.HttpClientConnectionHelper.connect(HttpClientConnectionHelper.java) at org.apache.cactus.internal.client.connector.http.DefaultHttpClient.callRunTest(DefaultHttpClient.java:162) at org.apache.cactus.internal.client.connector.http.DefaultHttpClient.doTest_aroundBody0(DefaultHttpClient.java:80) at org.apache.cactus.internal.client.connector.http.DefaultHttpClient.doTest_aroundBody1$advice(DefaultHttpClient.java:206) at org.apache.cactus.internal.client.connector.http.DefaultHttpClient.doTest(DefaultHttpClient.java) at org.apache.cactus.internal.client.connector.http.HttpProtocolHandler.runWebTest(HttpProtocolHandler.java:159) at org.apache.cactus.internal.client.connector.http.HttpProtocolHandler.runTest_aroundBody0(HttpProtocolHandler.java:80) at org.apache.cactus.internal.client.connector.http.HttpProtocolHandler.runTest_aroundBody1$advice(HttpProtocolHandler.java:206) at org.apache.cactus.internal.client.connector.http.HttpProtocolHandler.runTest(HttpProtocolHandler.java) at org.apache.cactus.internal.client.ClientTestCaseCaller.runTest(ClientTestCaseCaller.java:144) at org.apache.cactus.internal.AbstractCactusTestCase.runBareClient(AbstractCactusTestCase.java:215) at org.apache.cactus.internal.AbstractCactusTestCase.runBare(AbstractCactusTestCase.java:133)

It seems that I need to start Apache web server. Is this true?

[clebert.suconic]

Can you please copy your both property files here in a message?

[terryxian]

The property files for mysql and oracle:

==============================================
jboss-MySQL-run.properties:

JBOSS_HOME=/spec/share/jboss-4.0.2
JBOSS_URL=http://localhost:8080
JAS_HOME=/spec/SPECjAppServer2004

JBOSS_EMULATOR_HOME=/spec/share/jboss-4.0.2
JBOSS_EMULATOR_HOST=localhost
JBOSS_EMULATOR_PORT=8080
JBOSS_EMULATOR_SERVER_NAME=specj2004

JDBC_URL = jdbc:mysql://localhost/specj2004
JDBC_DRIVER = com.mysql.jdbc.Driver
JDBC_USER = root
JDBC_PASSWORD = fxian1978

JMS_JDBC_URL = jdbc:mysql://localhost/specj2004
JMS_JDBC_DRIVER = com.mysql.jdbc.Driver
JMS_JDBC_USER = root
JMS_JDBC_PASSWORD = fxian1978
JMS_JDBC_DATASOURCE_NAME=SpecjJMSDS

#The datasource that will be deployed, after applied changes for JDBC_URL, JDBC_DRIVER and JDBC_USER
JDBC_DATASOURCE_NAME = SpecjDS

#The JDBC mapping used into JBoss-CMP
JDBC_DATASOURCE_MAPPING = mySQL


==============================================
jboss-Oracle-run.properties

JBOSS_HOME=/usr/java/jboss-4.0.2
JBOSS_URL=http://localhost:9090
JAS_HOME=/spec/SPECjAppServer2004

JBOSS_EMULATOR_HOME=/usr/java/jboss-4.0.2
JBOSS_EMULATOR_HOST=localhost
JBOSS_EMULATOR_PORT=9090
JBOSS_EMULATOR_SERVER_NAME=specj

JDBC_URL = jdbc:oracle:thin:@129.93.68.45:1521:spec
JDBC_DRIVER = oracle.jdbc.OracleDriver
JDBC_USER = spec
JDBC_PASSWORD = spec

JMS_JDBC_URL = jdbc:oracle:thin:@129.93.68.45:1521:spec
JMS_JDBC_DRIVER = oracle.jdbc.OracleDriver
JMS_JDBC_USER = spec
JMS_JDBC_PASSWORD = spec
JMS_JDBC_DATASOURCE_NAME=SpecjJMSDS

#The datasource that will be deployed, after applied changes for JDBC_URL, JDBC_DRIVER and JDBC_USER
JDBC_DATASOURCE_NAME = SpecjDS

#The JDBC mapping used into JBoss-CMP
JDBC_DATASOURCE_MAPPING = Oracle10G


APPLICATION_HOST = localhost
APPLICATION_PORT = 9090

#DRIVER_JAVA_PARAMETERS=-Xmx512m

server-database=oracle

server-name = specj


APPLICATION_HOST = localhost
APPLICATION_PORT = 8080

#DRIVER_JAVA_PARAMETERS=-Xmx512m

server-database=mysql

server-name = specj2004

[clebert.suconic]

You are missing a bunch of properties in your MySQL-run.

Besides, what this kit does is to make your life easier configuring specj, but you should be able to configure everything yourself.

As you missed some properties, some of the values are apointing to wrong URLs or address.

You should be able to fix it, if you take a look at the configurations generated by the script.

[terryxian]

You are right, I didnt configuring URL in config/run.properties. Now another problem arised. When I start application server :
run.sh -c specj2004

I still got the warning like:
Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor.

Does this warning matter? If so, how to solve this problem?

[clebert.suconic]

You can safely ignore this one. I'm also having that warning.

[terryxian]

Not only one such warning, there are several of them. The following is the output snippet:


16:48:19,434 INFO [EjbModule] Deploying CustomerEnt
16:48:19,682 INFO [EjbModule] Deploying CustomerInventoryEnt
16:48:19,694 INFO [EjbModule] Deploying CorpAuditSes
16:48:19,718 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:19,720 INFO [EjbModule] Deploying CustomerSes
16:48:19,730 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:20,761 INFO [EjbModule] Deploying AssemblyEnt
16:48:20,774 INFO [EjbModule] Deploying BomEnt
16:48:20,794 INFO [EjbModule] Deploying ComponentEnt
16:48:20,806 INFO [EjbModule] Deploying PartEnt
16:48:20,821 INFO [EjbModule] Deploying WorkOrderEnt
16:48:20,833 INFO [EjbModule] Deploying LargeOrderEnt
16:48:20,859 INFO [EjbModule] Deploying InventoryEnt
16:48:20,871 INFO [EjbModule] Deploying LargeOrderSes
16:48:20,896 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:20,898 INFO [EjbModule] Deploying WorkOrderSes
16:48:20,908 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:20,909 INFO [EjbModule] Deploying MfgAuditSes
16:48:20,924 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:20,926 INFO [EjbModule] Deploying LargeOrderMDB
16:48:20,942 INFO [EjbModule] Deploying ReceiveMDB
16:48:24,044 INFO [EjbModule] Deploying OrderLineEnt
16:48:24,057 INFO [EjbModule] Deploying ItemEnt
16:48:24,069 INFO [EjbModule] Deploying OrderEnt
16:48:24,081 INFO [EjbModule] Deploying OrderSes
16:48:24,092 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:24,093 INFO [EjbModule] Deploying OrderAuditSes
16:48:24,104 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:24,105 INFO [EjbModule] Deploying ItemBrowserSes
16:48:24,215 INFO [EjbModule] Deploying FulfillOrderMDB
16:48:25,443 INFO [EjbModule] Deploying SupplierEnt
16:48:25,455 INFO [EjbModule] Deploying SupplierCompEnt
16:48:25,467 INFO [EjbModule] Deploying SComponentEnt
16:48:25,478 INFO [EjbModule] Deploying POEnt
16:48:25,497 INFO [EjbModule] Deploying POLineEnt
16:48:25,509 INFO [EjbModule] Deploying ReceiverSes
16:48:25,520 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:25,521 INFO [EjbModule] Deploying SupplierAuditSes
16:48:25,531 WARN [EjbModule] Could not load the org.jboss.webservice.server.ServiceEndpointInterceptor interceptor
16:48:25,532 INFO [EjbModule] Deploying BuyerMDB
16:48:25,932 INFO [EjbModule] Deploying SequenceEnt
16:48:25,945 INFO [EjbModule] Deploying SequenceSes
====================================

Are all the beans deployed?

[hmpadi]

hi:
Could you give a copy of SPECjAppServer2004.I would make use of SPECjAppServer2004 for testing jboss.
my mail:[e-mail]

[jgokul]

Hi - I am looking for JBoss and SpecjAppserver2004 configuration details with Oracle - wondering if you can share your detailed steps