coolx.net

Programming

No.

726

Name.

swindler

Subject.

com.sun.rowset.CachedRowSetImpl을 이용하여 show status 값을 가져오는 경우

Main Cate.

Java

Sub Cate.

MySQL

Date.

2013-11-20 11:13

Hit.

2860 (211.36.27.3)

File.

아래와 같은 에러가 발생한다.

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'STATUS' in information_schema
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at com.mysql.jdbc.Field.getCollation(Field.java:493)
at com.mysql.jdbc.ResultSetMetaData.isCaseSensitive(ResultSetMetaData.java:567)
at com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:697)
at com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:620)
at com.pad.db.RowSetMapper.execute(RowSetMapper.java:308)
at com.pad.db.RowSetMapper.execute(RowSetMapper.java:186)
at com.pad.db.RowSetMapper.execute(RowSetMapper.java:68)
at com.pad.dao.EtcDAO.getStatus(EtcDAO.java:159)

아마도 CacheedRowSetImpl내부적으로 metadata를 얻기 위해서
show full columns 와 같은 명령어를 사용하는데서 문제가 생기지 않나 싶다.
(정확하지는 않다.)

따라서, 다음과 같이 수정했다.
select VARIABLE_VALUE from information_schema.GLOBAL_STATUS where Variable_name ='Queries';

[바로가기 링크] : http://coolx.net/cboard/develop/726


[Modify] [Delete]		[Reply] [List]