8 Replies Latest reply on Apr 24, 2008 5:39 PM by Jay Gokul

    help with jboss-mysql-specjappserver2004

    Feng Xian Newbie

      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?

        • 1. Re: help with jboss-mysql-specjappserver2004
          Clebert Suconic Master

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

          • 2. Re: help with jboss-mysql-specjappserver2004
            Feng Xian Newbie

            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

            • 3. Re: help with jboss-mysql-specjappserver2004
              Clebert Suconic Master

              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.

              • 4. Re: help with jboss-mysql-specjappserver2004
                Feng Xian Newbie

                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?

                • 5. Re: help with jboss-mysql-specjappserver2004
                  Clebert Suconic Master

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

                  • 6. Re: help with jboss-mysql-specjappserver2004
                    Feng Xian Newbie

                    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?

                    • 7. Re: I need a copy of specjappserver2004
                      hmpadi Newbie

                      hi:
                      Could you give a copy of SPECjAppServer2004.I would make use of SPECjAppServer2004 for testing jboss.
                      my mail:wanghua111@hotmail.com

                      • 8. Re: help with jboss-mysql-specjappserver2004
                        Jay Gokul Newbie

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