ひがやすを技術ブログ

電通国際情報サービスのプログラマ

CallableStatementFactory not work with SQLServer

S2Daoに追加したCallableStatementFactoryですが、SQLServerではうまく機能しないようです。SQLServerJDBC Driverは、CallableStatementだとストアドプロシージャと思ってしまうようです。orz
It is CallableStatementFactory which is added to S2Dao, but with SQLServer it seems that functioning is not done well. JDBC Driver of SQLServer, when CallableStatement is used, seems that is thought as StoredProcedure. orz
それでは困るので、CallableStatementFactoryをStatementFactoryに名前を変え、PreparedStatementもCallableStatementも作成できるようにし、通常はPreparedStatementを作成するようにしたいと思います。
Then because it is troubled, CallableStatementFactory changes name into StatementFactory, tries PreparedStatement and CallableStatement to be able to create, usually we would like to try to create PreparedStatement.