How pass structure datatype to MS SQL database from Java

Question

I am trying to call a stored procedure whose one parameter is sqlstructure type of MS SQL.I have passed String[] array but it threw this exception

WARNING: #{reportingCharts.getGraphValuesOnLocationBasis}: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [{CALL dbo.up_Chart_SelectPersonCountByRankLocation(?,?,?,?,?)}]; SQL state [null]; error code [0]; The conversion from UNKNOWN to UNKNOWN is unsupported.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.
javax.faces.FacesException: #{reportingCharts.getGraphValuesOnLocationBasis}: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [{CALL dbo.up_Chart_SelectPersonCountByRankLocation(?,?,?,?,?)}]; SQL state [null]; error code [0]; The conversion from UNKNOWN to UNKNOWN is unsupported.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.

So I think it is not accepting the array as a parameter for structure.
Unfortunately nowhere I can find an example about how to use it in java.
How can i pass my this array/list to this stored procedure? OR what would be the alternate for c# SqlDbType.Structured in java?

Im not Java programmer, but maybe this will help: JDBC has separate ARRAY (java.sql.Array) and STRUCT (java.sql.Struct) data types. From the other side - im not sure that SQL Server can accept structures from JDBC. — Kamil
– Kamil, Commented Sep 27, 2012 at 7:07
possible duplicate of stackoverflow.com/questions/9375553/… — khan
– khan, Commented Oct 19, 2012 at 4:38

khan · Accepted Answer · 2012-10-19 04:43:41Z

1

Refer to Microsoft JDBC Driver Team Blog , the JDBC driver supported by TVP has not been released yet. There is a workaround :packing the values in a binary form ,cracking it on the server and passing it to a table valued function. For JDBC driver this argument has to be passed as binary.
See this link you will find all the MSsql datatypes for java.

answered Oct 19, 2012 at 4:43

khan

2,6748 gold badges40 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How pass structure datatype to MS SQL database from Java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related