부하 테스트시 에러
cubrid & jboss select error
에러 내용.
Error attempting to get column 'PORTLET_TYPE' from result set.
Connection or Statement might be closed
cubrid error code [-21017];
org.springframework.jdbc.UncategorizedSQLException: Error attempting to get column 'COLUMN_NAME' from result set. Cause: cubrid.jdbc.driver.CUBRIDException: Connection or Statement might be closed[CAS INFO-127.0.0.1:30000,2,28785],[SESSION-929488],[URL-jdbc:cubrid:127.0.0.1:30000:cubridTest:cubridTest:********:?charset=utf-8].;
uncategorized SQLException; SQL state [null]; error code [-21017]; Connection or Statement might be closed[CAS INFO-127.0.0.1:30000,2,28785],[SESSION-929488],[URL-jdbc:cubrid:127.0.0.1:30000:cubridTest:cubridTest:********:?charset=utf-8].; nested exception is cubrid.jdbc.driver.CUBRIDException: Connection or Statement might be closed[CAS INFO-127.0.0.1:30000,2,28785],[SESSION-929488],[URL-jdbc:cubrid:127.0.0.1:30000:cubridTest:cubridTest:********:?charset=utf-8].
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy149.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
해결 방법.
cubrid
cubrid_broker.conf 파일에 아래 부분 추가. broker 부분 재부팅.
STATEMENT_POOLING = ON
jboss 설정
standdalone-ha.xml 파일의 datasource 영역에 아래 부분 추가.
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>