caosy

PI JDBC not working properly on Mybatis.

Discussion created by caosy on Nov 14, 2012
Latest reply on Nov 19, 2012 by michaelh

Hello all!

 

I've just tried to access PI AF Server from Mybatis through PI JDBC driver.

 

Inside the Mybatis PIJDBC calls the following procedure.
① PreparedStatement.execute();
② PreparedStatement.getResultSet();
At the step ②, Exception occurs.

 

Error message is as follows.
[org.springframework.jdbc.UncategorizedSQLException]
Cause: java.sql.SQLException: [RDSA OLE DB Provider] IID_ICommand: DB_E_PARAMNOTOPTIONAL

 

I tried to find out the cause, when you run the procedure ②,
Statement the parent class of PreparedStatement Will call method of getResultSet().
It seems it become the Exception of OLEDB for not pass parameters to the SQL in the Statement.

 

Can somebody explain, can I solve this problem, and how? Thank you!

Outcomes