Gayratbek Komilov [https://community.jboss.org/people/gayrat.komilov] created the discussion
"Oracle Datasource Connection is not done" To view the discussion, visit: https://community.jboss.org/message/823778#823778 -------------------------------------------------------------- *I try to test the Connection JBOSS console , This happens in in standalone .* Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final) 10:30:43,410 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension 10:30:43,412 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011 940: Activating OSGi Subsystem 10:30:43,410 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) JBA S013101: Activating Security Subsystem 10:30:43,415 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS0 11800: Activating Naming Subsystem 10:30:43,425 INFO [org.jboss.as.naming] (MSC service thread 1-7) JBAS011802: St arting Naming Service 10:30:43,431 INFO [org.jboss.as.mail.extension] (MSC service thread 1-8) JBAS01 5400: Bound mail session [java:jboss/mail/Default] 10:30:43,434 INFO [org.jboss.as.connector.subsystems.datasources] (ServerServic e Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class oracle.jd bc.OracleDriver (version 11.2) 10:30:43,434 INFO [org.jboss.as.security] (MSC service thread 1-6) JBAS013100: Current PicketBox version=4.0.7.Final 10:30:43,568 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-4) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080 10:30:43,620 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC se rvice thread 1-6) JBoss Web Services - Stack CXF Server 4.0.2.GA 10:30:43,676 INFO [org.jboss.as.remoting] (MSC service thread 1-8) JBAS017100: Listening on /127.0.0.1:4447 10:30:43,676 INFO [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on /127.0.0.1:9999 10:30:43,681 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-5) JBAS015012: Started FileSystemDeploymentService for directory C:\jboss-as-7 .1.1.Final\standalone\deployments 10:30:43,798 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-8) JBAS010400: Bound data source [java:/jdbc/ora] 10:30:43,798 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:/jdbc/as400XA] 10:30:43,810 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBA S015876: Starting deployment of "App1.ear" 10:30:43,852 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBA S015876: Starting deployment of "View.war" 10:30:43,852 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBA S015876: Starting deployment of "Model.jar" 10:30:43,881 INFO [org.jboss.as.jpa] (MSC service thread 1-2) JBAS011401: Read persistence.xml for Model 10:30:43,937 INFO [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeplo ymentUnitProcessor] (MSC service thread 1-6) JNDI bindings for session bean name d Facade in deployment unit subdeployment "Model.jar" of deployment "App1.ear" a re as follows: java:global/App1/Model/Facade!ru.intf.Model.FacadeLocal java:app/Model/Facade!ru.intf.Model.FacadeLocal java:module/Facade!ru.intf.Model.FacadeLocal java:global/App1/Model/Facade java:app/Model/Facade java:module/Facade 10:30:43,963 INFO [org.jboss.as.jpa] (MSC service thread 1-4) JBAS011402: Start ing Persistence Unit Service 'App1.ear#Model' 10:30:44,045 INFO [org.hibernate.annotations.common.Version] (MSC service threa d 1-4) HCANN000001: Hibernate Commons Annotations {4.0.1.Final} 10:30:44,049 INFO [org.hibernate.Version] (MSC service thread 1-4) HHH000412: H ibernate Core {4.0.1.Final} 10:30:44,051 INFO [org.hibernate.cfg.Environment] (MSC service thread 1-4) HHH0 00206: hibernate.properties not found 10:30:44,052 INFO [org.hibernate.cfg.Environment] (MSC service thread 1-4) HHH0 00021: Bytecode provider name : javassist 10:30:44,139 INFO [org.hibernate.ejb.Ejb3Configuration] (MSC service thread 1-4 ) HHH000204: Processing PersistenceUnitInfo [ name: Model ...] 10:30:44,140 INFO [org.jboss.web] (MSC service thread 1-6) JBAS018210: Register ing web context: /View 10:30:44,178 INFO [org.hibernate.service.jdbc.connections.internal.ConnectionPr oviderInitiator] (MSC service thread 1-4) HHH000130: Instantiating explicit conn ection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvid er 10:30:44,216 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (MSC service thread 1-4) IJ000604: Throwable while attempting to get a new conne ction: null: javax.resource.ResourceException: Could not create connection at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManage dConnection(XAManagedConnectionFactory.java:447) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManag edConnection(XAManagedConnectionFactory.java:385) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManag edConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnecti onPool.java:761) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManag edConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConne ction(AbstractPool.java:397) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection( AbstractPool.java:365) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getMan agedConnection(AbstractConnectionManager.java:329) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getMa nagedConnection(TxConnectionManagerImpl.java:368) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.alloca teConnection(AbstractConnectionManager.java:464) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDa taSource.java:129) at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.get Connection(InjectedDataSourceConnectionProvider.java:67) [hibernate-entitymanage r-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProvide rJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:253) [hibernate-cor e-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcSer vicesImpl.java:119) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.service.internal.StandardServiceRegistryImpl.configureS ervice(StandardServiceRegistryImpl.java:75) [hibernate-core-4.0.1.Final.jar:4.0. 1.Final] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initialize Service(AbstractServiceRegistryImpl.java:159) [hibernate-core-4.0.1.Final.jar:4. 0.1.Final] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService (AbstractServiceRegistryImpl.java:131) [hibernate-core-4.0.1.Final.jar:4.0.1.Fin al] at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java: 71) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j ava:2270) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2266 ) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav a:1735) [hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactor yImpl.java:84) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con figuration.java:904) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Con figuration.java:889) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFa ctory(HibernatePersistence.java:73) [hibernate-entitymanager-4.0.1.Final.jar:4.0 .1.Final] at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEn tityManagerFactory(PersistenceUnitServiceImpl.java:162) [jboss-as-jpa-7.1.1.Fina l.jar:7.1.1.Final] at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(Persistence UnitServiceImpl.java:85) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(Se rviceControllerImpl.java:1811) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceCont rollerImpl.java:1746) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt .jar:1.7.0_10] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [r t.jar:1.7.0_10] at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_10] Caused by: javax.resource.ResourceException: Could not find accessor on XADataSo urce: at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXADataSo urce(XAManagedConnectionFactory.java:629) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManage dConnection(XAManagedConnectionFactory.java:430) ... 30 more Caused by: java.lang.NoSuchMethodException: com.ibm.as400.access.AS400JDBCXAData Source.setURL(java.lang.String) at java.lang.Class.getMethod(Unknown Source) [rt.jar:1.7.0_10] at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXADataSo urce(XAManagedConnectionFactory.java:597) ... 31 more 10:30:44,316 WARN [org.hibernate.engine.jdbc.internal.JdbcServicesImpl] (MSC se rvice thread 1-4) HHH000342: Could not obtain connection to query metadata : jav ax.resource.ResourceException: IJ000453: Unable to get managed connection for ja va:/jdbc/as400XA 10:30:44,322 INFO [org.hibernate.dialect.Dialect] (MSC service thread 1-4) HHH0 00400: Using dialect: org.hibernate.dialect.DB2400Dialect 10:30:44,329 INFO [org.hibernate.engine.jdbc.internal.LobCreatorBuilder] (MSC s ervice thread 1-4) HHH000422: Disabling contextual LOB creation as connection wa s null 10:30:44,334 INFO [org.hibernate.engine.transaction.internal.TransactionFactory Initiator] (MSC service thread 1-4) HHH000268: Transaction strategy: org.hiberna te.engine.transaction.internal.jta.CMTTransactionFactory 10:30:44,338 INFO [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (M SC service thread 1-4) HHH000397: Using ASTQueryTranslatorFactory 10:30:44,428 INFO [org.jboss.as] (MSC service thread 1-7) JBAS015951: Admin con sole listening on http://127.0.0.1:9990 http://127.0.0.1:9990 10:30:44,429 INFO [org.jboss.as] (MSC service thread 1-7) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 2020ms - Started 235 of 322 services (82 servic es are passive or on-demand) 10:30:44,455 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018 559: Deployed "App1.ear" 10:30:51,138 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 conne ction at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLo calManagedConnection(LocalManagedConnectionFactory.java:277) [ironjacamar-jdbc-1 .0.9.Final.jar:1.0.9.Final] at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.creat eManagedConnection(LocalManagedConnectionFactory.java:235) [ironjacamar-jdbc-1.0 .9.Final.jar:1.0.9.Final] at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManag edConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnecti onPool.java:761) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final] at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManag edConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final] at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConne ction(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.internalTestCo nnection(AbstractPool.java:627) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Fin al] at org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnec tion(OnePool.java:88) [ironjacamar-core-impl-1.0.9.Final.jar:1.0.9.Final] at org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invok eCommandOn(PoolOperations.java:121) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Fi nal] at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.j ava:60) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.executeStep(Abstract OperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(Abstr actOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.completeStep(Abstrac tOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.jav a:74) [jboss-as-connector-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.executeStep(Abstract OperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(Abstr actOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.completeStep(Abstrac tOperationContext.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(Abstract OperationContext.java:385) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.doCompleteStep(Abstr actOperationContext.java:272) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.AbstractOperationContext.completeStep(Abstrac tOperationContext.java:200) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerIm pl.java:121) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelController Impl.java:309) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelController Impl.java:299) [jboss-as-controller-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.domain.http.server.DomainApiHandler.processRequest(Domai nApiHandler.java:294) at org.jboss.as.domain.http.server.DomainApiHandler.doHandle(DomainApiHa ndler.java:201) at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHand ler.java:208) at org.jboss.as.domain.http.server.security.SubjectAssociationHandler.ha ndle(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(S erverImpl.java:710) at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78 ) at org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmRe adinessFilter.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_10] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [r t.jar:1.7.0_10] at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_10] at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-thread s-2.0.0.GA.jar:2.0.0.GA] Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL lev el 1 ORA-12705: Cannot access NLS data files or invalid environment specified at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthentica te.java:431) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja va:366) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.ja va:752) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java: 538) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio n.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLo calManagedConnection(LocalManagedConnectionFactory.java:249) [ironjacamar-jdbc-1 .0.9.Final.jar:1.0.9.Final] ... 39 more -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/823778#823778] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
