org.jboss.jca.adapters.jdbc.WrappedConnection.checkException

[sundarcse1216]

Dear All,

         I am facing Wrapped connection check Exception. while access more threats in my DAO implementation.

I am using Jboss-as7 and Postrgesql-9.3. Please any one can help me.

Exception:

security-web-3.1.2.RELEASE.jar:3.1.2.RELEASE]

09:00:44,016 ERROR [com.example.daoimpl.StudentDAOImpl] Unable to retrieve Datas java.sql.SQLException: Error: java.sql.SQLException: Error

    at org.jboss.jca.adapters.jdbc.WrappedConnection.checkException(WrappedConnection.java:1643)

    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.1.2.RELEASE.jar:3.1.2.RELEASE]

Caused by: java.lang.NullPointerException

09:04:44,914 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: org.postgresql.jdbc4.Jdbc4Connection@1d586266: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.1.2.RELEASE.jar:3.1.2.RELEASE]

09:04:44,952 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@e37220d[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@ddedcc0 connection handles=0 lastUse=1487581437438 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@4d9c084e pool internal context=SemaphoreArrayListManagedConnectionPool@2dee9329[pool=PortalDS] xaResource=LocalXAResourceImpl@226ec85d[connectionListener=e37220d connectionManager=658d2ca3 warned=false currentXid=null] txSync=null]: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) [spring-security-web-3.1.2.RELEASE.jar:3.1.2.RELEASE]

Thanks in Advance,

Sundar S.

[andey]

Hi,

This WARN means that JBoss detected an invalid connection when checking connections. Basically this WARN message has no impact as long as there is no ERROR message around the WARN message.

If you cannot get JDBC connection, there will be an ERROR message in the log and your application will receive an exception.

You have to setup postgre valid connection checker in your datasource configuration.:

~~~

<validate-on-match>true</validate-on-match>

<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker" />

<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter" />

~~~

See the admin guide fro optimal solution approach for postgre:

https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Application_Platform/6.4/html-single/Administration_and_Configuration_Guide/index.html#Example_PostgreSQL_Datasource1