7 Replies Latest reply on Jun 27, 2012 6:45 AM by hari309965

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

    hari309965

      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
          wdfink

          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
            hari309965

            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
              wdfink

              Nice one not easy to find.

               

              Your module.xml is wrong.

               

              Add the xmlns attribute

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

              • 4. Re: when I was checking the datasource through admin console I am getting the unknown error for the data source
                wdfink

                BTW where is your module.xml example from is it incorrect from here?

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

                  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
                    wdfink

                    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
                      hari309965

                      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