java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/WebAppDS

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • GitHub comment 1#143594357
    via GitHub by d33tah
    ,
  • Error In Preview Data Model
    via GitHub by chengkuangan
    ,
  • Cannot Connect over TCP - I suck
    via by bxgrant,
  • #1: {code} 06:11:43.940 ERROR [pool-15-thread-1] [DownloadFilesHandler:152] Read timed out java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) ~[na:1.8.0_92] at java.net.SocketInputStream.socketRead(SocketInputStream.java:116) ~[na:1.8.0_92] at java.net.SocketInputStream.read(SocketInputStream.java:170) ~[na:1.8.0_92] at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.readFully(InputRecord.java:465) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.readV3Record(InputRecord.java:593) ~[na:1.8.0_92] at sun.security.ssl.InputRecord.read(InputRecord.java:532) ~[na:1.8.0_92] at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:973) ~[na:1.8.0_92] at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:930) ~[na:1.8.0_92] at sun.security.ssl.AppInputStream.read(AppInputStream.java:105) ~[na:1.8.0_92] at org.apache.http.impl.conn.LoggingInputStream.read(LoggingInputStream.java:87) ~[httpclient-4.5.1.jar:4.5.1] at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:139) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.SessionInputBufferImpl.fillBuffer(SessionInputBufferImpl.java:155) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.SessionInputBufferImpl.read(SessionInputBufferImpl.java:208) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.impl.io.ContentLengthInputStream.read(ContentLengthInputStream.java:178) ~[httpcore-4.4.3.jar:4.4.3] at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:137) ~[httpclient-4.5.1.jar:4.5.1] at org.apache.commons.io.input.ProxyInputStream.read(ProxyInputStream.java:98) ~[commons-io-2.4.jar:2.4] at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[na:1.8.0_92] at java.io.PushbackInputStream.read(PushbackInputStream.java:186) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:238) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.read(ZipInputStream.java:194) ~[na:1.8.0_92] at java.io.FilterInputStream.read(FilterInputStream.java:107) ~[na:1.8.0_92] at org.apache.commons.io.input.ProxyInputStream.read(ProxyInputStream.java:77) ~[commons-io-2.4.jar:2.4] at java.nio.file.Files.copy(Files.java:2908) ~[na:1.8.0_92] at java.nio.file.Files.copy(Files.java:3027) ~[na:1.8.0_92] at com.liferay.sync.engine.documentlibrary.handler.DownloadFileHandler.copyFile(DownloadFileHandler.java:210) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.DownloadFilesHandler.doHandleResponse(DownloadFilesHandler.java:146) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:194) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:55) [com.liferay.sync.engine-3.1.1.jar:na] at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:222) [httpclient-4.5.1.jar:4.5.1] at com.liferay.sync.engine.session.Session.execute(Session.java:305) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.session.Session$2.run(Session.java:273) [com.liferay.sync.engine-3.1.1.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_92] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_92] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_92] 06:11:43.941 DEBUG [pool-15-thread-1] [DownloadFilesHandler:162] Unexpected end of ZLIB input stream java.io.EOFException: Unexpected end of ZLIB input stream at java.util.zip.InflaterInputStream.fill(InflaterInputStream.java:240) ~[na:1.8.0_92] at java.util.zip.InflaterInputStream.read(InflaterInputStream.java:158) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.read(ZipInputStream.java:194) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.closeEntry(ZipInputStream.java:140) ~[na:1.8.0_92] at java.util.zip.ZipInputStream.getNextEntry(ZipInputStream.java:118) ~[na:1.8.0_92] at com.liferay.sync.engine.documentlibrary.handler.DownloadFilesHandler.doHandleResponse(DownloadFilesHandler.java:102) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:194) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.documentlibrary.handler.BaseHandler.handleResponse(BaseHandler.java:55) [com.liferay.sync.engine-3.1.1.jar:na] at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:222) [httpclient-4.5.1.jar:4.5.1] at com.liferay.sync.engine.session.Session.execute(Session.java:305) [com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.session.Session$2.run(Session.java:273) [com.liferay.sync.engine-3.1.1.jar:na] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_92] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_92] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_92] {code} #2: {code} 08:53:46.516 DEBUG [pool-9-thread-3] [SyncAccountService:240] IO Exception: "java.net.UnknownHostException: Liferays-MacBook-Pro-21.local: Liferays-MacBook-Pro-21.local: unknown error" [90028-174] org.h2.jdbc.JdbcSQLException: IO Exception: "java.net.UnknownHostException: Liferays-MacBook-Pro-21.local: Liferays-MacBook-Pro-21.local: unknown error" [90028-174] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) ~[h2-1.3.174.jar:1.3.174] at org.h2.message.DbException.get(DbException.java:161) ~[h2-1.3.174.jar:1.3.174] at org.h2.message.DbException.convert(DbException.java:276) ~[h2-1.3.174.jar:1.3.174] at org.h2.util.NetUtils.getLocalAddress(NetUtils.java:263) ~[h2-1.3.174.jar:1.3.174] at org.h2.server.TcpServer.getURL(TcpServer.java:195) ~[h2-1.3.174.jar:1.3.174] at org.h2.tools.Server.start(Server.java:462) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.startServer(Database.java:713) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.open(Database.java:577) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.openDatabase(Database.java:236) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Database.<init>(Database.java:231) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.openSession(Engine.java:56) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.openSession(Engine.java:160) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSessionAndValidate(Engine.java:139) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSession(Engine.java:122) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.Engine.createSession(Engine.java:28) ~[h2-1.3.174.jar:1.3.174] at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323) ~[h2-1.3.174.jar:1.3.174] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105) ~[h2-1.3.174.jar:1.3.174] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90) ~[h2-1.3.174.jar:1.3.174] at org.h2.Driver.connect(Driver.java:73) ~[h2-1.3.174.jar:1.3.174] at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[na:1.8.0_92] at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[na:1.8.0_92] at com.j256.ormlite.jdbc.JdbcConnectionSource.makeConnection(JdbcConnectionSource.java:252) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadWriteConnection(JdbcPooledConnectionSource.java:136) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.jdbc.JdbcPooledConnectionSource.getReadOnlyConnection(JdbcPooledConnectionSource.java:111) ~[ormlite-jdbc-4.48.jar:na] at com.j256.ormlite.dao.BaseDaoImpl.queryForId(BaseDaoImpl.java:221) ~[ormlite-core-4.48.jar:na] at com.liferay.sync.engine.service.SyncAccountService.fetchSyncAccount(SyncAccountService.java:236) ~[com.liferay.sync.engine-3.1.1.jar:na] at com.liferay.sync.engine.filesystem.SyncWatchEventProcessor.run(SyncWatchEventProcessor.java:134) [com.liferay.sync.engine-3.1.1.jar:na] {code}
    via by Shinn Lok,
    • java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/WebAppDS at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137) at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:67)[hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:52)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:368)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:305)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:294)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:452)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737)[hibernate-core-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84)[hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904)[hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889)[hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73)[hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final] at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162)[jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final] at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85)[jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final] at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[rt.jar:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[rt.jar:1.7.0_79] at java.lang.Thread.run(Thread.java:745)[rt.jar:1.7.0_79] Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/WebAppDS at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129) ... 19 more Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:371) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329) ... 22 more Caused by: javax.resource.ResourceException: Could not create connection at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343) ... 25 more Caused by: org.h2.jdbc.JdbcSQLException: Verbindung ist unterbrochen: "unexpected status 1308622848" Connection is broken: "unexpected status 1308622848" [90067-161] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.engine.SessionRemote.done(SessionRemote.java:553) at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:109) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:373) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:267) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110) at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94) at org.h2.Driver.connect(Driver.java:72) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249) ... 28 more

    Users with the same issue

    bernardpaulus
    bernardpaulus1 times, last one,
    osvzs
    osvzs1 times, last one,
    Andreas Häber
    Andreas Häber114 times, last one,
    Shadd518
    Shadd5182 times, last one,
    Unknown visitor1 times, last one,
    144 more bugmates