pardon me if this post is not related to this forum and also suggest where i can post this if its not here.
I need to convert list to sql Array type so i am calling stored procedure. It contains 2 in parameters(varchar, integer) and one out(Array). When i am calling
com.ibm.db2.jcc.a.SqlException: Jdbc type 2003 not yet supported.
Please advise me how i can resolve this exception. Thanks in advance....![/color]
Are you using the latest version of the JDBC driver? Because all JDBC drivers should support that method by now.
Edit: actually, not necessarily. From the Javadoc pages:
Throws: SQLFeatureNotSupportedException - if sqlType is a ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC driver does not support this data type
Still, the latest version may have added support for the ARRAY type.
how you do this all depends, do you have live customers? as they will need to be updated as well, do you have systems people who will need to do this for production and everywhere else? or are you still in developement and you are the only user.
I can only explain how you do you it on your local machine, and that is go to the ibm site, download a new version replace the jar in your classpath and you are off.
something is wrong with your setup compared to production and everybody else in your team, sorry there really isn't much more I can do.
Find somebody else at work for whom it is working and ask them about possible setup issues, which drivers they are using etc.
My issue is resolved with db2cc.jar file.
Steps i followed:
Websphere admin consele>Resources>JDBC providers>select all scopes>New> Provide the requied inforamtion and it asked me for db2cc.jar and db2jcc_license_cu.jar location and provided the path of jar files.