org.postgresql.util.PSQLException: 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.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the 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.
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.
via Google Groups by Markus Schulz, 3 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.
via Google Groups by Markus Schulz, 3 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.
via Google Groups by Gopan Sugathan, 3 months ago
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.
via GitHub by billrobertson42
, 2 years ago
Can't infer the SQL type to use for an instance of clojure.lang.MapEntry. Use setObject() with an explicit Types value to specify the type to use.
org.postgresql.util.PSQLException: 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.
at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1920)
at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:36)
at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:47)
at com.jolbox.bonecp.PreparedStatementHandle.setObject(PreparedStatementHandle.java:925)
at clojure.core$map_indexed$mapi__6395$fn__6396.invoke(core.clj:6692)
at clojure.lang.LazySeq.sval(LazySeq.java:40)
at clojure.lang.LazySeq.seq(LazySeq.java:49)
at clojure.lang.Cons.next(Cons.java:39)
at clojure.lang.RT.next(RT.java:598)
at clojure.core$next.invoke(core.clj:64)
at clojure.core$dorun.invoke(core.clj:2856)
at clojure.java.jdbc.internal$set_parameters.invoke(internal.clj:277)
at clojure.lang.AFn.applyToHelper(AFn.java:156)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invoke(core.clj:626)
at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278)
at clojure.core$map$fn__4245.invoke(core.clj:2557)
at clojure.lang.LazySeq.sval(LazySeq.java:40)
at clojure.lang.LazySeq.seq(LazySeq.java:49)
at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.lang.ChunkedCons.next(ChunkedCons.java:43)
at clojure.lang.RT.next(RT.java:598)
at clojure.core$next.invoke(core.clj:64)
at clojure.core$dorun.invoke(core.clj:2856)
at clojure.core$doall.invoke(core.clj:2871)
at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invoke(core.clj:626)
at com.puppetlabs.puppetdb.scf.storage$eval9818$fact_value_new_ids__9819$fn__9820.invoke(storage.clj:855)
at com.puppetlabs.puppetdb.scf.storage$eval9818$fact_value_new_ids__9819.invoke(storage.clj:846)
at com.puppetlabs.puppetdb.scf.storage$eval9842$fact_values_to_ids__9843$fn__9844.invoke(storage.clj:883)
at com.puppetlabs.puppetdb.scf.storage$eval9842$fact_values_to_ids__9843.invoke(storage.clj:861)
at com.puppetlabs.puppetdb.scf.storage$eval9868$new_fact_value_ids_STAR___9869$fn__9870.invoke(storage.clj:905)
at com.puppetlabs.puppetdb.scf.storage$eval9868$new_fact_value_ids_STAR___9869.invoke(storage.clj:886)
at com.puppetlabs.puppetdb.scf.storage$eval9892$new_fact_value_ids__9893$fn__9894.invoke(storage.clj:915)
at com.puppetlabs.puppetdb.scf.storage$eval9892$new_fact_value_ids__9893.invoke(storage.clj:908)
at com.puppetlabs.puppetdb.scf.storage$eval10050$update_facts_BANG___10051$fn__10055.invoke(storage.clj:1034)
at com.puppetlabs.puppetdb.scf.storage$eval10050$update_facts_BANG___10051.invoke(storage.clj:1027)
at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245$fn__10249$fn__10251.invoke(storage.clj:1235)
at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245$fn__10249.invoke(storage.clj:1232)
at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245.invoke(storage.clj:1225)
at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:381)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290)
at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287)
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259)
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258)
at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250)
at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286)
at com.puppetlabs.puppetdb.command$eval11543$fn__11546.invoke(command.clj:379)
at clojure.lang.MultiFn.invoke(MultiFn.java:231)
at com.puppetlabs.puppetdb.command$produce_message_handler$fn__11715.invoke(command.clj:647)
at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664$fn__11668.invoke(command.clj:554)
at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664.invoke(command.clj:553)
at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649$fn__11650.invoke(command.clj:507)
at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)
at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649.invoke(command.clj:506)
at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__11659.invoke(command.clj:529)
at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__11639.invoke(command.clj:467)
at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__11673.invoke(command.clj:569)
at com.puppetlabs.mq$create_message_listener$reify__10820.onMessage(mq.clj:270)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)
at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)
at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)
at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)
at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)
at java.lang.Thread.run(Thread.java:745)

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
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.