-
1. Re: How to configuring SAS 9.2 DataSource (JDBC mayby) on JBOSS 7?
wdfink Oct 30, 2013 3:58 PM (in response to wwasjaa)1 of 1 people found this helpfulYou 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.
-
2. Re: How to configuring SAS 9.2 DataSource (JDBC mayby) on JBOSS 7?
wwasjaa Oct 31, 2013 11:16 AM (in response to wdfink)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>
-
3. Re: How to configuring SAS 9.2 DataSource (JDBC mayby) on JBOSS 7?
wwasjaa Nov 5, 2013 10:15 AM (in response to 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?