org.apache.openjpa.persistence.PersistenceException: The column index is out of range: 2, number of columns: 1. FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC [java.lang.String]

james-server-user | raghunath.umapathi@xyramsoft.com | 3 years ago
  1. 0

    Error while retrieve mappings

    james-server-user | 3 years ago | raghunath.umapathi@xyramsoft.com
    org.apache.openjpa.persistence.PersistenceException: The column index is out of range: 2, number of columns: 1. FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC [java.lang.String]
  2. 0

    Re: Error while retrieve mappings

    james-server-user | 2 years ago | Eric Charles
    org.apache.openjpa.persistence.PersistenceException: The column index is out of range: 2, number of columns: 1. FailedObject: SELECT rrt FROM JamesRecipientRewrite rrt WHERE (rrt.user LIKE :user OR rrt.user='*') and (rrt.domain like :domain or rrt.domain='*') ORDER BY rrt.domain DESC [java.lang.String]
  3. 0

    Birt PostgreSQL - stored procedure dataset

    Stack Overflow | 5 years ago | Petr Kostroun
    org.postgresql.util.PSQLException: Index of column is out of bounds: 1, column count: 0.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Strange jdbcReam Exception occurs on Tomcat

    Stack Overflow | 2 years ago | user3798092
    org.postgresql.util.PSQLException: This statement has been closed.
  6. 0

    Index of column out of range : 2, number of column 1

    Stack Overflow | 1 year ago | AndroidTestor
    org.postgresql.util.PSQLException: L'indice de la colonne est hors limiteĀ : 2, nombre de colonnesĀ : 1.

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

      The column index is out of range: 2, number of columns: 1.

      at org.postgresql.core.v3.SimpleParameterList.bind()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.setString
      1. org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:51)
      2. org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:116)
      3. org.postgresql.jdbc2.AbstractJdbc2Statement.bindString(AbstractJdbc2Statement.java:2186)
      4. org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1302)
      5. org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1288)
      5 frames
    3. Commons DBCP
      DelegatingPreparedStatement.setString
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)
      2 frames
    4. OpenJPA Aggregate Jar
      QueryImpl.getResultList
      1. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:312)
      2. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.setString(LoggingConnectionDecorator.java:1419)
      3. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:312)
      4. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:312)
      5. org.apache.openjpa.jdbc.sql.DBDictionary.setString(DBDictionary.java:1203)
      6. org.apache.openjpa.jdbc.sql.DBDictionary.setUnknown(DBDictionary.java:1408)
      7. org.apache.openjpa.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:544)
      8. org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:453)
      9. org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:429)
      10. org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:479)
      11. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:420)
      12. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:391)
      13. org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
      14. org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
      15. org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
      16. org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
      17. org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
      18. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
      19. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
      20. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
      21. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
      22. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
      23. org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
      24. org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
      25. org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
      26. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
      27. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
      28. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
      29. org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
      30. org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
      31. org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
      31 frames
    5. org.apache.james
      JPARecipientRewriteTable.mapAddressInternal
      1. org.apache.james.rrt.jpa.JPARecipientRewriteTable.mapAddressInternal(JPARecipientRewriteTable.java:84)
      1 frame