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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 3 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

    Postgresql PSQL Exception in Inserting to database using Java

    Stack Overflow | 2 months ago | ashlrem
    java.lang.RuntimeException: org.postgresql.util.PSQLException: The column index is out of range: 12, number of columns: 11.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

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

    Strange jdbcReam Exception occurs on Tomcat

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

    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