아래 오류의 문제는 JDBC드라이버가 맞지 않았다.
● MSSQL버전확인
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
결과
9.00.4035.00
SP3
Standard Edition
기존에는 mssql2008용 구버전 JDBC드라이버를 썼는데
http://www.microsoft.com/downloads/ko-kr/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707
여기에서 받은 라이브러리를 쓰니 해결됨.
sqljdbc_3.0.1301.101_kor.tar.gz세상은 알수없음
[문제의 에러화면]
at com.microsoft.sqlserver.jdbc.TDSPacket.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(UnknownSource)
at konan.jdbcgateway.connect.JDBCConnector.executeQuery(JDBCConnector.java:472)
at konan.jdbcgateway.frame.Synchronizer.getBulkConnector(Synchronizer.java:130)
at konan.jdbcgateway.frame.Synchronizer.initialize(Synchronizer.java:47)
at konan.jdbcgateway.frame.MainFrameSynchronizer.initialize(MainFrameSynchronizer.java:20)
at konan.jdbcgateway.frame.SingleSynchronizerHandler.initialize(SingleSynchronizerHandler.java:31)
at konan.jdbcgateway.frame.MainFrame.startConn(MainFrame.java:55)
at konan.jdbcgateway.task.Gateway.run(Gateway.java:76)
at konan.jdbcgateway.Controller.Startup(Controller.java:348)
at konan.jdbcgateway.Controller.doStart(Controller.java:738)
at konan.jdbcgateway.Controller.main(Controller.java:718)