net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]

Hibernate JIRA | Umit VARDAR | 1 decade ago
  1. 0

    I've got the following error when I set my machines locale to Turkish: org.springframework.orm.hibernate.HibernateQueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]; nested exception is net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)] net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)] at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:166) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at org.springframework.orm.hibernate.HibernateTemplate$17.doInHibernate(HibernateTemplate.java:331) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:170) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:328) ... I think that this stems from a case conversion "IN" -> "in" Please note that in Turkish "IN".toLowerCase != "in"; it is equal to "ın" (i without dot on top) If there is such case conversion in the code pleaase do it in correct locale (US ASCII?) Thank you.

    Hibernate JIRA | 1 decade ago | Umit VARDAR
    net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]
  2. 0

    I've got the following error when I set my machines locale to Turkish: org.springframework.orm.hibernate.HibernateQueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]; nested exception is net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)] net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)] at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:166) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39) at org.springframework.orm.hibernate.HibernateTemplate$17.doInHibernate(HibernateTemplate.java:331) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:170) at org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:328) ... I think that this stems from a case conversion "IN" -> "in" Please note that in Turkish "IN".toLowerCase != "in"; it is equal to "ın" (i without dot on top) If there is such case conversion in the code pleaase do it in correct locale (US ASCII?) Thank you.

    Hibernate JIRA | 1 decade ago | Umit VARDAR
    net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]
  3. 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=?]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 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]

    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

      Incorrect query syntax [FROM com.opensymphony.workflow.spi.hibernate.HibernateCurrentStep step WHERE step.id IN (41)]

      at net.sf.hibernate.hql.QueryTranslator.compile()
    2. net.sf.hibernate
      QueryImpl.list
      1. net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:166)
      2. net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
      3. net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294)
      4. net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562)
      5. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
      6. net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
      6 frames
    3. Hibernate
      HibernateTemplate.find
      1. org.springframework.orm.hibernate.HibernateTemplate$17.doInHibernate(HibernateTemplate.java:331)
      2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:150)
      3. org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:170)
      4. org.springframework.orm.hibernate.HibernateTemplate.find(HibernateTemplate.java:328)
      4 frames