net.sf.hibernate.QueryException: Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id]

Hibernate JIRA | Irakli Nadareishvili | 1 decade ago
  1. 0

    Hi, Oracle Intermedia queries that have a "?" fails with Hibernate 2.1. The following OQL fails with a message : net.sf.hibernate.QueryException: Not all positional parameters have been set select cpv.id , message.message , cpv.indent from cpv in class org.digijava.module.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id Hibernate 2.0 was ignoring the '?' within the contains clause, while 2.1 thinks it is a replacement parameter. We experience this problem on 2.1 beta4, 2.1 beta6. No such issues with 2.0 or 2.1beta1 Please, advise. Stack Trace: net.sf.hibernate.QueryException: Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id] at net.sf.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQuer yImpl.java:88) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:43) at app.HBTest.main(HBTest.java:280)

    Hibernate JIRA | 1 decade ago | Irakli Nadareishvili
    net.sf.hibernate.QueryException: Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id]
  2. 0

    Hi, Oracle Intermedia queries that have a "?" fails with Hibernate 2.1. The following OQL fails with a message : net.sf.hibernate.QueryException: Not all positional parameters have been set select cpv.id , message.message , cpv.indent from cpv in class org.digijava.module.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id Hibernate 2.0 was ignoring the '?' within the contains clause, while 2.1 thinks it is a replacement parameter. We experience this problem on 2.1 beta4, 2.1 beta6. No such issues with 2.0 or 2.1beta1 Please, advise. Stack Trace: net.sf.hibernate.QueryException: Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id] at net.sf.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQuer yImpl.java:88) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:43) at app.HBTest.main(HBTest.java:280)

    Hibernate JIRA | 1 decade ago | Irakli Nadareishvili
    net.sf.hibernate.QueryException: Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id]
  3. 0

    bad sql in htmlpageFactory.getLiveHTMLPages

    GitHub | 4 years ago | dotjorgeu
    net.sf.hibernate.QueryException: unexpected token: html [from inode in class com.dotmarketing.portlets.htmlpages.model.HTMLPage html, com.dotmarketing.portlets.htmlpages.model.HTMLPageVersionInfo vv where type='htmlpage' and identifier=vv.identifier and vv.live_inode=inode and vv.deleted=0]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate HQL Query throwing Exception

    Stack Overflow | 4 years ago | user1514616
    net.sf.hibernate.QueryException: , expected in SELECT [SELECT SUM(CASE WHEN s.SettlementCurrencyName = r.ContractCurrency THEN p.ContractNet WHEN s.SettlementCurrencyName = r.LocalCurrency THEN p.ContractNet/ta.LiquidationRate WHEN s.SettlementCurrencyName IS NULL THEN p.ContractNet/ta.LiquidationRate ELSE p.ContractNet/ta.LiquidationRate END)"PAID AMOUNT", COUNT(t.TX_IDENTIFIER) "PAID TXS" FROM com.uniteller.txcore.Payment p, com.uniteller.txcore.Transaction t, com.uniteller.txcore.TxAccounting ta, com.uniteller.txcore.Remittance r, com.uniteller.txcore.SellingAgentSettlement s WHERE t.isLRCTx = 1 AND t.SellingCompany = :lrcCode AND s.SettlementCurrencyName(+) = r.ContractCurrency AND s.Id.DestCurrencyName(+) = r.ContractCurrency AND s.Id.Code(+) = r.SellingAgent AND r.ContractCurrency = :contractCurrency AND p.PaidAccountDt > :lastPaidAcDt AND p.TxIdentifier = t.TxIdentifier AND p.TxIdentifier = r.TxIdentifier AND p.TxIdentifier = ta.TxIdentifier]
  6. 0

    HibernateQueryException with mapping a class with a composite key with Hibernate version 2.1.7

    Stack Overflow | 1 year ago | humpah
    net.sf.hibernate.QueryException: in expected: ln [from LocalizedNames ln where ln.locale=?]

    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. net.sf.hibernate.QueryException

      Not all positional parameters have been set [se lect cpv.id , message.message , cpv.indent from cpv in class org.digijava.modul e.eproc.dbentity.CPV , from message in class org.digijava.kernel.entity.Message where contains(message.message,'?asd', 1) > 0 and ( message.key = 'cpv:'||cpv8 and message.locale = 'en' ) order by cpv.id]

      at net.sf.hibernate.impl.AbstractQueryImpl.verifyParameters()
    2. net.sf.hibernate
      QueryImpl.list
      1. net.sf.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:88)
      2. net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:43)
      2 frames
    3. app
      HBTest.main
      1. app.HBTest.main(HBTest.java:280)
      1 frame