org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of org.apache.poi.xssf.usermodel.XSSFCellStyle. Use setObject() with an explicit Types value to specify the type to use.


Solutions on the web25

Solution icon of stackoverflow
Can't infer the SQL type to use for an instance of org.apache.poi.xssf.usermodel.XSSFCellStyle. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
via Google Groups by Markus Schulz, 2 months ago
Can't infer the SQL type to use for an instance of [Ljava.lang.String;. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
via Google Groups by rdunklau, 1 year ago
Can't infer the SQL type to use for an instance of java.util.Date. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
via Google Groups by Markus Schulz, 2 months ago
Can't infer the SQL type to use for an instance of [Ljava.lang.String;. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
via Google Groups by rawi, 1 year ago
Can't infer the SQL type to use for an instance of java.util.LinkedHashMap. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of web
via gmane.org by Unknown author, 1 year ago
Can't infer the SQL type to use for an instance of java.util.Date. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
via Google Groups by 雨森郷太郎, 2 months ago
Can't infer the SQL type to use for an instance of java.util.Date. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of web
via JIRA by Wyatt Alt, 1 year ago
Can't infer the SQL type to use for an instance of java.math.BigInteger. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of stackoverflow
Can't infer the SQL type to use for an instance of java.util.ArrayList. Use setObject() with an explicit Types value to specify the type to use.

Solution icon of googlegroups
Can't infer the SQL type to use for an instance of java.lang.Byte. Use setObject() with an explicit Types value to specify the type to use.

Stack trace

org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of org.apache.poi.xssf.usermodel.XSSFCellStyle. Use setObject() with an explicit Types value to specify the type to use.
	at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1917)
	at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:36)
	at com.tcs.Skeleton.skeletonDataToDatabase(Skeleton.java:157)
	at com.tcs.Test.main(Test.java:121)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago