java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.

Oracle Community | 807589 | 8 years ago
  1. 0

    Invalid object name

    Oracle Community | 8 years ago | 843859
    java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.
  2. 0

    quartz

    Oracle Community | 8 years ago | 807589
    java.sql.SQLException: Invalid object name 'QRTZ_BLOB_TRIGGERS'.
  3. 0

    The data types nvarchar(max) and ntext are incompatible in the equal to operator.

    Stack Overflow | 4 years ago | Sha
    java.sql.SQLException: The data types nvarchar(max) and ntext are incompatible in the equal to operator.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Quartz Developer - org.quartz.JobPersistenceException: Couldn't acquire next trigger: Invalid

    nabble.com | 12 months ago
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: Invalid column name 'PRIORITY'. [See nested exception: java.sql.SQLException: Invalid column name 'PRIORITY'.] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport .java:2700) at org.quartz.impl.jdbcjobstore.JobStoreSupport$35.execute(JobStoreSupport.java:26 58) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStore Support.java:3662) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport .java:2654)
  6. 0

    Thank you. Unfortunately, 1.4.4 has the same issue I've been dealing with. XEP 136 does not work when using Microsoft SQL Server as the external database. It looks like the plugin has had issues with MS SQL Server in the past (issue OF-755 resolved by Daryl Herzmann). Can anyone add this to JIRA? Here's the error log (using Openfire 4.0.1 and Monitoring Service 1.4.4): {code} 2016.02.01 10:31:29 org.jivesoftware.util.Log - Error selecting conversations java.sql.SQLException: An expression of non-boolean type specified in a context where a condition is expected, near 'RowNum'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:1029) at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at $java.lang.AutoCloseable$$EnhancerByProxool$$416dbe86.executeQuery(<generated>) at com.reucon.openfire.plugin.archive.impl.JdbcPersistenceManager.findConversation s(JdbcPersistenceManager.java:234) at com.reucon.openfire.plugin.archive.xep0136.IQListHandler.list(IQListHandler.jav a:49) at com.reucon.openfire.plugin.archive.xep0136.IQListHandler.handleIQ(IQListHandler .java:34) at com.reucon.openfire.plugin.archive.xep0136.Xep0136Support$1.handleIQ(Xep0136Sup port.java:48) at org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:66) at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372) at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:115) at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:78) at org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:342) at org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHandler .java:99) at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:307) at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:199) at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandl er.java:181) at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceive d(DefaultIoFilterChain.java:690) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapte r.java:109) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flus h(ProtocolCodecFilter.java:407) at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecF ilter.java:236) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(D efaultIoFilterChain.java:417) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilt erChain.java:47) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceiv ed(DefaultIoFilterChain.java:765) at org.apache.mina.core.filterchain.IoFilterEvent.fire(IoFilterEvent.java:74) at org.apache.mina.core.session.IoEvent.run(IoEvent.java:63) at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTask(Ordere dThreadPoolExecutor.java:769) at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.runTasks(Order edThreadPoolExecutor.java:761) at org.apache.mina.filter.executor.OrderedThreadPoolExecutor$Worker.run(OrderedThr eadPoolExecutor.java:703) at java.lang.Thread.run(Unknown Source) {code}

    Jive Software Open Source | 10 months ago | Daryl Herzmann
    java.sql.SQLException: An expression of non-boolean type specified in a context where a condition is expected, near 'RowNum'.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid object name 'QRTZ_BLOB_TRIGGERS'.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsStatement.executeSQLQuery
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
      5 frames