How to configuring SAS 9.2 DataSource (JDBC mayby) on JBOSS 7?

[wwasjaa]

How to configuring SAS 9.2 DataSource (JDBC mayby) on JBOSS 7?

I wont only read data from SAS Files. Are mayby other opportunities to connect SAS with jboss?

SAS describe the configuration for Jboss, but not for JBOSS 7x.

http://support.sas.com/documentation/cdl/en/jdbcref/59666/HTML/default/viewer.htm#n1m3245dulfqj5n171lw28lluwxe.htm

[wdfink]

You need to configure the datasource and add the jdbc driver as module, if the jdbc driver is not jdbc4 compliant you have a bit extra work.

But all the stuff is described here Data Source Configuration in AS 7  you should be able to create the datasource for AS7 with that wiki.

[wwasjaa]

Thanks for the reply.

SAS I have two jar files:

1.) sas.core.jar

1.) sas.svc.connection.jar      (I modify this JAR --> jar -uf jdbc-driver.jar META-INF/services/java.sql.Driver )

The server starts correctly.

But if I test the datasource connection on the admin console, I get the following error.

Full log:

14:48:46,696 INFO  [org.jboss.modules] JBoss Modules version 1.1.1.GA

14:48:46,881 INFO  [org.jboss.msc] JBoss MSC version 1.0.2.GA

14:48:46,939 INFO  [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting

14:48:47,797 INFO  [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)

14:48:47,798 INFO  [org.xnio] XNIO Version 3.0.3.GA

14:48:47,808 INFO  [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA

14:48:47,816 INFO  [org.jboss.remoting] JBoss Remoting version 3.2.3.GA

14:48:47,828 INFO  [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers

14:48:47,837 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem

14:48:47,837 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem

14:48:47,840 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem

14:48:47,842 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.

14:48:47,867 INFO  [org.jboss.as.connector] (MSC service thread 1-14) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)

14:48:47,870 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension

14:48:47,874 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem

14:48:47,884 INFO  [org.jboss.as.security] (MSC service thread 1-10) JBAS013100: Current PicketBox version=4.0.7.Final

14:48:47,902 INFO  [org.jboss.as.naming] (MSC service thread 1-1) JBAS011802: Starting Naming Service

14:48:47,943 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-11) JBAS015400: Bound mail session [java:jboss/mail/Default]

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

14:48:48,091 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class com.sas.rio.MVADriver (version 9.3)

14:48:48,106 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.2)

14:48:48,107 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-11) JBoss Web Services - Stack CXF Server 4.0.2.GA

14:48:48,370 WARN  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015005: Reliable deployment behaviour is not possible when auto-deployment of exploded content is enabled (i.e. deployment without use of ".dodeploy"' marker files). Configuration of auto-deployment of exploded content is not recommended in any situation where reliability is desired. Configuring the deployment scanner's auto-deploy-exploded setting to "false" is recommended.

14:48:48,375 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\standalone\deployments

14:48:48,758 INFO  [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on localhost/127.0.0.1:4447

14:48:48,772 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-16) Starting Coyote HTTP/1.1 on http-localhost-127.0.0.1-8080

14:48:48,776 INFO  [org.jboss.as.remoting] (MSC service thread 1-10) JBAS017100: Listening on /127.0.0.1:9999

14:48:49,043 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Bound data source [java:jboss/sasDS]

14:48:49,049 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-5) JBAS010400: Bound data source [java:jboss/postgresDS]

14:48:49,050 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

14:48:49,191 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-3) Starting Coyote HTTP/1.1 on http-localhost-127.0.0.1-8443

14:48:49,237 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

14:48:49,238 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 2843ms - Started 144 of 221 services (74 services are passive or on-demand)

14:54:47,592 WARN  [org.jboss.modules] (HttpManagementService-threads - 4) Failed to define class com.sas.iom.SAS.IDataServicePackage.InvalidEngine in Module "org.sas:main" from local module loader @ed4b5a (roots: C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\modules): java.lang.LinkageError: Failed to link com/sas/iom/SAS/IDataServicePackage/InvalidEngine (Module "org.sas:main" from local module loader @ed4b5a (roots: C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\modules))

  at org.jboss.modules.ModuleClassLoader.defineClass(ModuleClassLoader.java:396) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ModuleClassLoader.loadClassLocal(ModuleClassLoader.java:243) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ModuleClassLoader$1.loadClassLocal(ModuleClassLoader.java:73) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.Module.loadModuleClass(Module.java:517) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:182) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) [jboss-modules.jar:1.1.1.GA]

  at com.sas.rio.MVAConnection.<init>(MVAConnection.java:205)

  at com.sas.rio.MVADriver.connect(MVADriver.java:277)

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:627) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:121) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:60) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:74) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:466) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:121) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:309) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:299) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:294)

  at org.jboss.as.domain.http.server.DomainApiHandler.doHandle(DomainApiHandler.java:201)

  at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:208)

  at org.jboss.as.domain.http.server.security.SubjectAssociationHandler.handle(SubjectAssociationHandler.java:51)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_25]

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_25]

  at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_25]

  at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.0.0.GA.jar:2.0.0.GA]

Caused by: java.lang.NoClassDefFoundError: org/omg/CORBA/UserException

  at java.lang.ClassLoader.defineClass1(Native Method) [rt.jar:1.7.0_25]

  at java.lang.ClassLoader.defineClass(Unknown Source) [rt.jar:1.7.0_25]

  at java.security.SecureClassLoader.defineClass(Unknown Source) [rt.jar:1.7.0_25]

  at org.jboss.modules.ModuleClassLoader.doDefineOrLoadClass(ModuleClassLoader.java:327) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ModuleClassLoader.defineClass(ModuleClassLoader.java:391) [jboss-modules.jar:1.1.1.GA]

  ... 50 more

Caused by: java.lang.ClassNotFoundException: org.omg.CORBA.UserException from [Module "org.sas:main" from local module loader @ed4b5a (roots: C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\modules)]

  at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) [jboss-modules.jar:1.1.1.GA]

  ... 55 more

14:54:47,652 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (HttpManagementService-threads - 4) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:627) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:121) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:60) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:74) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:466) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:121) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:309) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:299) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:294)

  at org.jboss.as.domain.http.server.DomainApiHandler.doHandle(DomainApiHandler.java:201)

  at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:208)

  at org.jboss.as.domain.http.server.security.SubjectAssociationHandler.handle(SubjectAssociationHandler.java:51)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_25]

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_25]

  at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_25]

  at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.0.0.GA.jar:2.0.0.GA]

Caused by: java.lang.NoClassDefFoundError: com/sas/iom/SAS/IDataServicePackage/InvalidEngine

  at com.sas.rio.MVAConnection.<init>(MVAConnection.java:205)

  at com.sas.rio.MVADriver.connect(MVADriver.java:277)

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  ... 39 more

Caused by: java.lang.ClassNotFoundException: com.sas.iom.SAS.IDataServicePackage.InvalidEngine from [Module "org.sas:main" from local module loader @ed4b5a (roots: C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\modules)]

  at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398) [jboss-modules.jar:1.1.1.GA]

  at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120) [jboss-modules.jar:1.1.1.GA]

  ... 42 more

What is missing?

module.xml

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.0" name="org.sas">

  <resources>

  <resource-root path="sas.svc.connection.jar"/>

  <resource-root path="sas.core.jar"/>

  </resources>

   <dependencies>

  <module name="javax.api"/>

  </dependencies>

</module>

subdatasource

<datasource jta="false" jndi-name="java:jboss/sasDS" pool-name="sasDS" enabled="true" use-java-context="true" use-ccm="false">

                    <connection-url>jdbc:sasiom://10.10.144.28:8591</connection-url>

                    <driver-class>com.sas.rio.MVADriver</driver-class>

                    <driver>sasdriver</driver>

                    <pool>

                        <min-pool-size>5</min-pool-size>

                        <max-pool-size>20</max-pool-size>

                    </pool>

                    <security>

                        <user-name>user</user-name>

                        <password>PWPWPWP</password>

                    </security>

                </datasource>

driver:

<driver name="sasdriver" module="org.sas">

                        <xa-datasource-class>com.sas.rio.MVADataSource</xa-datasource-class>

                    </driver>

[wwasjaa]

Module:

<?xml version="1.0" encoding="UTF-8"?> 

<module xmlns="urn:jboss:module:1.0" name="org.sas"> 

  <resources>

  <resource-root path="sas.svc.connection.jar"/>

  <resource-root path="sas.core.jar"/>

  <resource-root path="sas.security.sspi.jar"/>

  </resources>

   <dependencies>

  <module name="org.jacorb"/>

  <module name="org.apache.log4j"/>

  <module name="javax.api"/>

  <module name="javax.transaction.api"/> 

  </dependencies> 

</module>

Config:

                <datasource jta="false" jndi-name="java:jboss/sasDS" pool-name="sasDS" enabled="true" use-java-context="true" use-ccm="false">

                    <connection-url>jdbc:sasiom://10.10.144.21:8591?librefs=data '/sas/work/tmp'</connection-url>

                    <driver-class>com.sas.rio.MVADriver</driver-class>

                    <driver>sasdriver</driver>

                    <pool>

                        <min-pool-size>5</min-pool-size>

                        <max-pool-size>20</max-pool-size>

                    </pool>

                    <security>

                        <user-name>sas</user-name>

                        <password>Id4drDD</password>

                    </security>

                </datasource>

                <drivers>

                    <driver name="sasdriver" module="org.sas">

                        <xa-datasource-class>com.sas.rio.MVADataSource</xa-datasource-class>

                    </driver>

                </drivers>

If testing datasource connection on the admin console, I get the following error

16:13:12,521 ERROR [stderr] (HttpManagementService-threads - 1) java.lang.ClassNotFoundException: org.jacorb.orb.ORBSingleton from [Module "org.jboss.as.connector:main" from local module loader @ed4b5a (roots: C:\TIE\jboss-as-7.1.1\jboss-as-7.1.1.Final\modules)]

16:13:12,525 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:190)

16:13:12,527 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:468)

16:13:12,529 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:456)

16:13:12,532 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)

16:13:12,535 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:120)

16:13:12,537 ERROR [stderr] (HttpManagementService-threads - 1) at java.lang.Class.forName0(Native Method)

16:13:12,539 ERROR [stderr] (HttpManagementService-threads - 1) at java.lang.Class.forName(Unknown Source)

16:13:12,541 ERROR [stderr] (HttpManagementService-threads - 1) at org.omg.CORBA.ORB.create(ORB.java:97)

16:13:12,543 ERROR [stderr] (HttpManagementService-threads - 1) at org.omg.CORBA.ORB.init(ORB.java:40)

16:13:12,544 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.ORBBase.getSingletonORB(ORBBase.java:701)

16:13:12,546 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.ORBBase.get_primitive_tc(ORBBase.java:299)

16:13:12,548 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.AnyImpl.<init>(AnyImpl.java:67)

16:13:12,550 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.ORBBase.create_any(ORBBase.java:470)

16:13:12,552 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.brg.Engine.flowSendUserPass(Engine.java:3478)

16:13:12,554 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.brg.Engine.flow(Engine.java:656)

16:13:12,555 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.brg.Engine.initClient(Engine.java:618)

16:13:12,557 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.iom.orb.brg.ORBImpl.uri_to_object(ORBImpl.java:119)

16:13:12,560 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ClusterEnvelope.createObject(ClusterEnvelope.java:278)

16:13:12,562 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ClusterEnvelope.getConnection(ClusterEnvelope.java:73)

16:13:12,565 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.AggregationKernel.doGetConnection(AggregationKernel.java:241)

16:13:12,567 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ConnectionFactoryKernel.getConnection(ConnectionFactoryKernel.java:325)

16:13:12,570 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ConnectionFactoryShell.getConnection(ConnectionFactoryShell.java:69)

16:13:12,572 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ConnectionFactoryShell.getConnection(ConnectionFactoryShell.java:56)

16:13:12,575 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ConnectionFactory.getConnection(ConnectionFactory.java:71)

16:13:12,578 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.services.connection.ConnectionFactory.getConnection(ConnectionFactory.java:46)

16:13:12,580 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.rio.RIOUtil.getWorkspace(RIOUtil.java:1585)

16:13:12,582 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.rio.RIOUtil.<init>(RIOUtil.java:122)

16:13:12,584 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.rio.MVAConnection.<init>(MVAConnection.java:205)

16:13:12,587 ERROR [stderr] (HttpManagementService-threads - 1) at com.sas.rio.MVADriver.connect(MVADriver.java:277)

16:13:12,589 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)

16:13:12,592 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)

16:13:12,595 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761)

16:13:12,599 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343)

16:13:12,603 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

16:13:12,606 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

16:13:12,608 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:627)

16:13:12,611 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88)

16:13:12,614 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:121)

16:13:12,617 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:60)

16:13:12,619 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385)

16:13:12,621 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272)

16:13:12,624 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200)

16:13:12,627 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:74)

16:13:12,629 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385)

16:13:12,632 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272)

16:13:12,634 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200)

16:13:12,637 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:466)

16:13:12,640 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385)

16:13:12,642 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272)

16:13:12,645 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200)

16:13:12,647 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:121)

16:13:12,650 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:309)

16:13:12,652 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:299)

16:13:12,654 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:294)

16:13:12,657 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.domain.http.server.DomainApiHandler.doHandle(DomainApiHandler.java:201)

16:13:12,659 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:208)

16:13:12,661 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.domain.http.server.security.SubjectAssociationHandler.handle(SubjectAssociationHandler.java:51)

16:13:12,664 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

16:13:12,666 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)

16:13:12,668 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

16:13:12,670 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)

16:13:12,672 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

16:13:12,674 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)

16:13:12,676 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

16:13:12,678 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)

16:13:12,680 ERROR [stderr] (HttpManagementService-threads - 1) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

16:13:12,682 ERROR [stderr] (HttpManagementService-threads - 1) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

16:13:12,684 ERROR [stderr] (HttpManagementService-threads - 1) at java.lang.Thread.run(Unknown Source)

16:13:12,685 ERROR [stderr] (HttpManagementService-threads - 1) at org.jboss.threads.JBossThread.run(JBossThread.java:122)

16:13:12,755 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (HttpManagementService-threads - 1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:627) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final]

  at org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:121) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:60) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:74) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:466) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:121) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:309) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:299) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final]

  at org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:294)

  at org.jboss.as.domain.http.server.DomainApiHandler.doHandle(DomainApiHandler.java:201)

  at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:208)

  at org.jboss.as.domain.http.server.security.SubjectAssociationHandler.handle(SubjectAssociationHandler.java:51)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)

  at org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)

  at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)

  at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_25]

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_25]

  at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_25]

  at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.0.0.GA.jar:2.0.0.GA]

Caused by: java.sql.SQLException: Unable to establish a connection: Unable to return workspace. Could not instantiate ORB implementation: org.jacorb.orb.ORBSingleton

  at com.sas.rio.MVALocalizedError.throwLocalizedException(MVALocalizedError.java:201)

  at com.sas.rio.MVAConnection.<init>(MVAConnection.java:227)

  at com.sas.rio.MVADriver.connect(MVADriver.java:277)

  at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249) [ironjacamar-jdbc-1.0.9.Final.jar:1.0.9.Final]

  ... 39 more

I added the jacorb dependency. What is wrong?