[JBoss Tools] - How to filter available annotations?
by Francesco Stupazzoni
Francesco Stupazzoni [https://community.jboss.org/people/sandman42] created the discussion
"How to filter available annotations?"
To view the discussion, visit: https://community.jboss.org/message/823906#823906
--------------------------------------------------------------
Hi,
I'm using Eclipse Helios to write a web service using JBOSS tools.
When I show up the annotation properties view, it says "No suitable ESB library can be found on the projects classpath. To select a 1.6. or above compliant JRE configure the installed JREs or change the JRE on the Java build path."
Googliing around I have seen I have to filter annotations, removing those from ESB, I did it with no results.
JRE is correct, i.e. it's c:\program files\java\jdk1.6.0_39, that's JAVA_HOME, too, Java build path should be ok, too.
What's wrong?
Thanks and ciao
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/823906#823906]
Start a new discussion in JBoss Tools at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
11 years
[JBoss Portal] - JBoss EAP 6.1 LDAP Configuration
by Tugrul Ocak
Tugrul Ocak [https://community.jboss.org/people/tgrlocak] created the discussion
"JBoss EAP 6.1 LDAP Configuration"
To view the discussion, visit: https://community.jboss.org/message/823854#823854
--------------------------------------------------------------
I am working on migrating a project from WebSphere to JBoss. I made work my project in GateIn Portal which comes default in JBoss installation. Now I have another problem about login(sign in). I have no idea how will I manage login information of users in my WebSphere Portal. I want my users to use the JBoss(or GateIn - I still didn't understand which is what) with their username and passwords they are using in WebSphere Portal.
WebSphere Portal uses a LDAP server for authentication(I assume that - because I am not the one who developed the application at first time). WebSphere Portal has 6 different applications in it and we want to seperate them using JBoss. So the research mission is on me and I am trying to set it up for JBoss. Now I think my only problem is about users' sign in, and again I think I will use a LDAP server and configuration to achieve it. But I couldn't understand the pdfs from RedHat Customer Support. If there is anyone who can help me about this issue I will be very grateful.
I hope I made myself clear :)
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/823854#823854]
Start a new discussion in JBoss Portal at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
11 years
[Datasource Configuration] - Oracle Datasource Connection is not done
by Gayratbek Komilov
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&con...]
11 years
[Datasource Configuration] - How to fix ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. in jboss 6.1
by Ankit Pandey
Ankit Pandey [https://community.jboss.org/people/ankit.pandey] created the discussion
"How to fix ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. in jboss 6.1"
To view the discussion, visit: https://community.jboss.org/message/823389#823389
--------------------------------------------------------------
Hi,
I am connecting SQLServer but sometimes I got
2013-06-17 12:56:00,068 ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:319)
2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:1839)
2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConne..................
My Jboss Configuration is
<local-tx-datasource>
<jndi-name>jdbc/abc.008</jndi-name>
<connection-url>jdbc:sqlserver://ip:2499;databaseName=DB</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>pass</password>
<autoReconnect>true</autoReconnect>
<failOverReadOnly>false</failOverReadOnly>
<maxReconnects>50</maxReconnects>
<initialTimeout>15</initialTimeout>
<check-valid-connection-sql>select 1 </check-valid-connection-sql>
</local-tx-datasource>
I have to restart JBoss for getting working connection again which is not the real possible solution obviously. I want to avoid this Jboss restart everytime..
It's very urgent...
Please Help...
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/823389#823389]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
11 years