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.

Solutions on the web2240

  • via JIRA by Wyatt Alt, 9 months 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.
  • 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.
  • Stack trace

    • 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)[puppetdb.jar:na] at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:36)[puppetdb.jar:na] at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:47)[puppetdb.jar:na] at com.jolbox.bonecp.PreparedStatementHandle.setObject(PreparedStatementHandle.java:925)[puppetdb.jar:na] at clojure.java.jdbc.internal$set_parameters$fn__6334.invoke(internal.clj:279)[na:na] at clojure.core$map_indexed$mapi__6395$fn__6396.invoke(core.clj:6692)[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40)[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49)[puppetdb.jar:na] at clojure.lang.Cons.next(Cons.java:39)[puppetdb.jar:na] at clojure.lang.RT.next(RT.java:598)[puppetdb.jar:na] at clojure.core$next.invoke(core.clj:64)[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2856)[puppetdb.jar:na] at clojure.java.jdbc.internal$set_parameters.invoke(internal.clj:277)[na:na] at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:336)[na:na] at clojure.lang.AFn.applyToHelper(AFn.java:156)[puppetdb.jar:na] at clojure.lang.AFn.applyTo(AFn.java:144)[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626)[puppetdb.jar:na] at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263)[na:na] at clojure.lang.RestFn.invoke(RestFn.java:442)[puppetdb.jar:na] at clojure.java.jdbc$insert_records$ins_v__6411.invoke(jdbc.clj:278)[na:na] at clojure.core$map$fn__4245.invoke(core.clj:2557)[puppetdb.jar:na] at clojure.lang.LazySeq.sval(LazySeq.java:40)[puppetdb.jar:na] at clojure.lang.LazySeq.seq(LazySeq.java:49)[puppetdb.jar:na] at clojure.lang.ChunkedCons.chunkedNext(ChunkedCons.java:59)[puppetdb.jar:na] at clojure.lang.ChunkedCons.next(ChunkedCons.java:43)[puppetdb.jar:na] at clojure.lang.RT.next(RT.java:598)[puppetdb.jar:na] at clojure.core$next.invoke(core.clj:64)[puppetdb.jar:na] at clojure.core$dorun.invoke(core.clj:2856)[puppetdb.jar:na] at clojure.core$doall.invoke(core.clj:2871)[puppetdb.jar:na] at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279)[na:na] at clojure.lang.RestFn.applyTo(RestFn.java:139)[puppetdb.jar:na] at clojure.core$apply.invoke(core.clj:626)[puppetdb.jar:na] at com.puppetlabs.puppetdb.scf.storage$eval9818$fact_value_new_ids__9819$fn__9820.invoke(storage.clj:855)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9818$fact_value_new_ids__9819.invoke(storage.clj:846)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9842$fact_values_to_ids__9843$fn__9844.invoke(storage.clj:883)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9842$fact_values_to_ids__9843.invoke(storage.clj:861)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9868$new_fact_value_ids_STAR___9869$fn__9870.invoke(storage.clj:905)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9868$new_fact_value_ids_STAR___9869.invoke(storage.clj:886)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9892$new_fact_value_ids__9893$fn__9894.invoke(storage.clj:915)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval9892$new_fact_value_ids__9893.invoke(storage.clj:908)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10050$update_facts_BANG___10051$fn__10055.invoke(storage.clj:1034)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10050$update_facts_BANG___10051.invoke(storage.clj:1027)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245$fn__10249$fn__10251.invoke(storage.clj:1235)[na:na] at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91)[puppetdb.jar:na] at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245$fn__10249.invoke(storage.clj:1232)[na:na] at com.puppetlabs.puppetdb.scf.storage$eval10244$replace_facts_BANG___10245.invoke(storage.clj:1225)[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546$fn__11559.invoke(command.clj:381)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762$fn__6763.invoke(jdbc.clj:290)[na:na] at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761$fn__6762.invoke(jdbc.clj:290)[na:na] at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__6761.invoke(jdbc.clj:287)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741$fn__6742.invoke(jdbc.clj:259)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740$fn__6741.invoke(jdbc.clj:258)[na:na] at com.puppetlabs.jdbc$eval6739$retry_sql_STAR___6740.invoke(jdbc.clj:250)[na:na] at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:286)[na:na] at com.puppetlabs.puppetdb.command$eval11543$fn__11546.invoke(command.clj:379)[na:na] at clojure.lang.MultiFn.invoke(MultiFn.java:231)[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$produce_message_handler$fn__11715.invoke(command.clj:647)[na:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664$fn__11668.invoke(command.clj:554)[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91)[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__11664.invoke(command.clj:553)[na:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649$fn__11650.invoke(command.clj:507)[na:na] at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$7da976d4.call(Unknown Source)[na:na] at com.yammer.metrics.core.Timer.time(Timer.java:91)[puppetdb.jar:na] at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__11649.invoke(command.clj:506)[na:na] at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__11659.invoke(command.clj:529)[na:na] at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__11639.invoke(command.clj:467)[na:na] at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__11673.invoke(command.clj:569)[na:na] at com.puppetlabs.mq$create_message_listener$reify__10820.onMessage(mq.clj:270)[na:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560)[puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498)[puppetdb.jar:na] at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467)[puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325)[puppetdb.jar:na] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263)[puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058)[puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050)[puppetdb.jar:na] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947)[puppetdb.jar:na] at java.lang.Thread.run(Thread.java:745)[na:1.7.0_65]

    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

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 2 years ago