7 Replies Latest reply on Jun 27, 2012 6:45 AM by Hari Kishore Yecharla

    when I was checking the datasource through admin console I am getting the unknown error for the data source

    Hari Kishore Yecharla Newbie

      Mon Jun 25 16:14:21 GMT+530 2012

      Unknown error

      Unexpected HTTP response: 500  
      Request { "address" => [
      ("subsystem" => "datasources"),
      ("data-source" => "TradisOnlineJNDI"),
      ("statistics" => "pool")
      ],
      "operation" => "read-resource",
      "include-runtime" => true } 
      Response
      Internal Server Error { "outcome" => "failed",
      "failure-description" => "JBAS014739: No handler for read-resource at address [
      (\"subsystem\" => \"datasources\"),
      (\"data-source\" => \"TradisOnlineJNDI\"),
      (\"statistics\" => \"pool\") ]",
      "rolled-back" => true
      }

      You can see the attached files. Could any body please let me know where it went wrong. Thanks in advance

        • 1. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
          Wolf-Dieter Fink Master

          Looks like an connection problem, could you describe what you are doing?

          Do you can use it with a fresh AS7 instance and the ExampleDS?

           

          Also you should post what version do you use.

          • 2. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
            Hari Kishore Yecharla Newbie

            I am using the jboss-as-7.1.1.Final. You can see the Image in that for the default datasource it is not getting any error. But whatever the datasources I have added are getting the above mentioned error messages. JbossConsole.JPG

             

            This is the below message displaying in the console

            **************************************************************************************************************************************************************************************************************************************

            Calling "D:\Soft\jboss-as-7.1.1.Final\bin\standalone.conf.bat"
            ===============================================================================

              JBoss Bootstrap Environment

              JBOSS_HOME: D:\Soft\jboss-as-7.1.1.Final

              JAVA: C:\Program Files\Java\jdk1.6.0_23\bin\java

              JAVA_OPTS: -XX:+TieredCompilation -Dprogram.name=standalone.bat -Xms64M -Xmx512M -XX:MaxPermSize=256M -Dsun.rmi.dgc.cl
            ient.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.war
            ning=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djboss.server.default.config=standalone.xml

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

            12:20:06,585 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA
            12:20:07,569 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA
            12:20:07,741 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting
            12:20:10,803 INFO  [org.xnio] XNIO Version 3.0.3.GA
            12:20:10,803 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-h
            ttp)
            12:20:10,834 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA
            12:20:10,928 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA
            12:20:10,959 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
            12:20:11,553 INFO  [org.jboss.as.security] (MSC service thread 1-3) JBAS013100: Current PicketBox version=4.0.7.Final
            12:20:11,975 INFO  [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting JCA Subsystem (JBoss IronJacam
            ar 1.0.9.Final)
            12:20:12,350 INFO  [org.jboss.as.naming] (MSC service thread 1-1) JBAS011802: Starting Naming Service
            12:20:12,553 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deployi
            ng JDBC-compliant driver class org.h2.Driver (version 1.3)
            12:20:12,896 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-3) JBAS015400: Bound mail session [java:jboss/mai
            l/Default]
            12:20:13,459 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-1) Starting Coyote HTTP/1.1 on http--
            127.0.0.1-8080
            12:20:13,787 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data sourc
            e [java:jboss/datasources/ExampleDS]
            12:20:14,006 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-4) JBoss Web Services - S
            tack CXF Server 4.0.2.GA
            12:20:14,381 INFO  [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on /127.0.0.1:9999
            12:20:14,396 INFO  [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on /127.0.0.1:4447
            12:20:20,271 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeplo
            ymentService for directory D:\Soft\jboss-as-7.1.1.Final\standalone\deployments
            12:20:20,271 WARN  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015002: Deployment of 'O
            rionLite.war' requested, but the deployment is not present
            12:20:20,708 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
            JBAS014775:    New missing/unsatisfied dependencies:
                  service jboss.jdbc-driver.jtds (missing) dependents: [service jboss.data-source.java:jboss/datasources/TradisAwacs
            JNDI, service jboss.data-source.java:jboss/datasources/TradisOnlineJNDI]

            12:20:20,911 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
            12:20:20,911 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with erro
            rs) in 16514ms - Started 135 of 216 services (4 services failed or missing dependencies, 74 services are passive or on-d
            emand)
            ********************************************************************************************************************************************************************************************************************************************************************

            I have commented the driver source    <!--<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>      -->

             

            <drivers>
                                <driver name="jtds" module="net.sourceforge.jtds">
                                    <!--<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>      -->
                                    <driver-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</driver-class>
                                </driver>
            </drivers>

             

            If you have any observations please let me know.

             

             

            Thanks

            Hari Kishore

            • 3. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
              Wolf-Dieter Fink Master

              Nice one not easy to find.

               

              Your module.xml is wrong.

               

              Add the xmlns attribute

              <module xmlns="urn:jboss:module:1.0" ...

              • 5. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
                Hari Kishore Yecharla Newbie

                I corrected that now my module.xml file is look like this and it is present in the {jbossHomeDirector}/modules/net/sourceforge/jtds/main and I copied the jtds-1.2.5.jar file in main.

                 

                <?xml version="1.0" encoding="UTF-8"?>
                <module xmlns="urn:jboss:domain:1.0" name="net.sourceforge.jtds">
                        <resources>
                           <resource-root path="jtds-1.2.5.jar"/>
                        </resources>
                        <dependencies>
                           <module name="javax.api"/>
                     <module name="javax.transaction.api"/>
                        </dependencies>
                </module>

                 

                As you mentioned in the above conversation I have checked with the default Datasource, at that moment I have observed that standalone.xml is looking for the module xmlns="urn:jboss:domain:1.0 but in the module.xml file it is showing module xmlns="urn:jboss:domain:1.1" that's it is not recognized earlier in that case I have deleted default ds and tried. Now using the same module.xml file But still I am getting the same error.

                 

                This is my standalone.xml

                ***************************************************************************************************************************************************************************************************************************************************************************

                <subsystem xmlns="urn:jboss:domain:datasources:1.0">
                            <datasources> 
                   
                                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                                    <driver>h2</driver>
                                    <security>
                                        <user-name>sa</user-name>
                                        <password>sa</password>
                                    </security>
                                </datasource>
                  
                                <datasource jndi-name="java:jboss/datasources/TradisOnlineJNDI" pool-name="TradisOnlineJNDI" enabled="true" use-java-context="true">
                                    <connection-url>jdbc:jtds:sqlserver://10.1.126.17:1433/LiveStock_Dlala;DB_CLOSE_DELAY=-1</connection-url>
                                    <driver>jtds</driver>
                                    <!--<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                                                                              <pool>
                                                                                  <min-pool-size>10</min-pool-size>
                                                                                  <max-pool-size>100</max-pool-size>
                                                                                  <prefill>true</prefill>
                                                                             </pool>-->
                                    <security>
                                        <user-name>sa</user-name>
                                    </security>                   
                                </datasource>
                                <datasource jndi-name="java:jboss/datasources/TradisAwacsJNDI" pool-name="TradisAwacsJNDI" enabled="true" use-java-context="true">
                                    <connection-url>jdbc:jtds:sqlserver://10.1.126.17:1433/Awacs;DB_CLOSE_DELAY=-1</connection-url>
                                    <driver>jtds</driver>
                                    <!--<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                                                                          <pool>
                                                                                <min-pool-size>10</min-pool-size>
                                                                                 <max-pool-size>100</max-pool-size>
                                                                          <prefill>true</prefill>
                                                                        </pool>-->
                                    <security>
                                        <user-name>sa</user-name>
                                    </security>                  
                                </datasource>
                   
                                <drivers>
                                    <driver name="jtds" module="net.sourceforge.jtds">
                                         <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
                                         <!--<xa-datasource-class>net.sourceforge.jtds.jdbcx.JtdsDataSource</xa-datasource-class>>-->
                                    </driver>
                     <driver name="h2" module="com.h2database.h2">
                                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                                    </driver>
                                </drivers>
                            </datasources>
                        </subsystem>

                ***************************************************************************************************************************************************************************************************************************************************************************

                 

                The jboss console

                 

                ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                Calling "D:\Soft\jboss-as-7.1.1.Final\bin\standalone.conf.bat"
                ===============================================================================

                  JBoss Bootstrap Environment

                  JBOSS_HOME: D:\Soft\jboss-as-7.1.1.Final

                  JAVA: C:\Program Files\Java\jdk1.6.0_23\bin\java

                  JAVA_OPTS: -XX:+TieredCompilation -Dprogram.name=standalone.bat -Xms64M -Xmx512M -XX:MaxPermSize=256M -Dsun.rmi.dgc.cl
                ient.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.war
                ning=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djboss.server.default.config=standalone.xml

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

                15:11:56,681 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA
                15:11:56,947 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA
                15:11:57,040 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting
                15:12:00,916 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-h
                ttp)
                15:12:00,994 INFO  [org.xnio] XNIO Version 3.0.3.GA
                15:12:01,307 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA
                15:12:01,385 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
                15:12:01,557 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsy
                stem
                15:12:01,682 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem
                15:12:01,713 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem
                15:12:01,729 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem
                15:12:01,994 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinis
                pan subsystem.
                15:12:02,010 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Exten
                sion
                15:12:02,322 INFO  [org.jboss.as.security] (MSC service thread 1-3) JBAS013100: Current PicketBox version=4.0.7.Final
                15:12:03,213 INFO  [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 3.2.3.GA
                15:12:06,135 INFO  [org.jboss.as.connector] (MSC service thread 1-3) JBAS010408: Starting JCA Subsystem (JBoss IronJacam
                ar 1.0.9.Final)
                15:12:07,057 INFO  [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting Naming Service
                15:12:07,526 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deployi
                ng JDBC-compliant driver class org.h2.Driver (version 1.3)
                15:12:10,151 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-4) Starting Coyote HTTP/1.1 on http--
                127.0.0.1-8080
                15:12:10,448 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) JBAS015400: Bound mail session [java:jboss/mai
                l/Default]
                15:12:12,808 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-3) JBoss Web Services - S
                tack CXF Server 4.0.2.GA
                15:12:14,355 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on /127.0.0.1:9999
                15:12:14,355 INFO  [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on /127.0.0.1:4447
                15:12:15,402 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data sourc
                e [java:jboss/datasources/ExampleDS]
                15:12:24,138 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeplo
                ymentService for directory D:\Soft\jboss-as-7.1.1.Final\standalone\deployments
                15:12:24,153 WARN  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015002: Deployment of 'O
                rionLite.war' requested, but the deployment is not present
                15:12:24,559 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
                JBAS014775:    New missing/unsatisfied dependencies:
                      service jboss.jdbc-driver.jtds (missing) dependents: [service jboss.data-source.java:jboss/datasources/TradisAwacs
                JNDI, service jboss.data-source.java:jboss/datasources/TradisOnlineJNDI]

                15:12:24,747 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
                15:12:24,747 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with erro
                rs) in 28488ms - Started 135 of 216 services (4 services failed or missing dependencies, 74 services are passive or on-d
                emand)

                ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                I have given all the information. Can you plz suggest me where did I go wrong?

                 

                Thanks

                Hari Kishore

                 

                Message was edited by: Hari Kishore Yecharla

                • 6. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
                  Wolf-Dieter Fink Master

                  Your module must be wrong.

                  I take a fresh copy of 7.1.1.Final.

                  I add the module.xml to modules/net/sourceforge/jtds/main and download the driver here.

                  I add the driver to the standalone.xml

                  {code}

                  <drivers>

                    <driver name="jtds" module="net.sourceforge.jtds">

                      <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

                    </driver>

                    <driver name="h2" module="com.h2database.h2">

                      <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                    </driver>

                  </drivers>

                  {code}

                   

                  After that you should see this loglines

                  INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class net.sourceforge.jtds.jdbc.Driver (version 1.2)

                  INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

                   

                  Without that the datasource can not be created.

                  Could you check this?

                  1 of 1 people found this helpful
                  • 7. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
                    Hari Kishore Yecharla Newbie

                    When we are placing the driver jar file. It will automatically make the index file of the driver jar file which is present in the module/../.../main folder. Now the datasource are bound.

                     

                    Thanks

                    Hari Kishore Y