org.hibernate.exception.DataException: could not load collection by subselect: [com.pallasathenagroup.entities.Scope.subScopes#<1818, 2336, 2322, 2323, 2325, 2314, 2316, 2311, 2312, 765, 1779, 758, 1772, 1773, 2395, 1372, 2398, 1889, 1354, 1360, 2364, 2360, 1836, 1325, 1183, 2196, 1674, 2186, 2187, 2172, 2174, 2175, 2176, 1664, 2164, 2165, 2158, 1250, 2274, 2275, 1764, 1765, 1766, 2278, 1767, 1769, 2266, 2268, 2269, 1247, 2271, 2273, 1746, 1747, 1748, 2261, 2262, 2263, 2264, 2265, 2250, 2251, 2252, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 701, 704, 691, 2218, 1571, 1572, 36, 1056, 1538, 1539, 1540, 1542, 1543, 2042, 2045, 1536, 2560, 1, 2039, 2040, 2538, 2033, 1637, 2151, 2152, 2141, 1618, 2136, 1611, 1612, 1609, 574, 1591, 1592, 2105, 1938, 397, 1936, 1937, 1923, 1924, 1925, 1926, 1415, 1416, 1928, 1929, 1417, 1404, 1917, 1409, 1909, 2424, 2007, 2001, 2498, 2490, 2491, 2492, 1981, 2493, 2494, 2495, 2496, 2497, 1458, 2482, 1459, 2489, 2478, 2480, 1456>]

GitHub | JWGmeligMeyling | 6 months 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

    Hibernate integration: CTE seems to break @Fetch(Subselect)

    GitHub | 6 months ago | JWGmeligMeyling
    org.hibernate.exception.DataException: could not load collection by subselect: [com.pallasathenagroup.entities.Scope.subScopes#<1818, 2336, 2322, 2323, 2325, 2314, 2316, 2311, 2312, 765, 1779, 758, 1772, 1773, 2395, 1372, 2398, 1889, 1354, 1360, 2364, 2360, 1836, 1325, 1183, 2196, 1674, 2186, 2187, 2172, 2174, 2175, 2176, 1664, 2164, 2165, 2158, 1250, 2274, 2275, 1764, 1765, 1766, 2278, 1767, 1769, 2266, 2268, 2269, 1247, 2271, 2273, 1746, 1747, 1748, 2261, 2262, 2263, 2264, 2265, 2250, 2251, 2252, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 701, 704, 691, 2218, 1571, 1572, 36, 1056, 1538, 1539, 1540, 1542, 1543, 2042, 2045, 1536, 2560, 1, 2039, 2040, 2538, 2033, 1637, 2151, 2152, 2141, 1618, 2136, 1611, 1612, 1609, 574, 1591, 1592, 2105, 1938, 397, 1936, 1937, 1923, 1924, 1925, 1926, 1415, 1416, 1928, 1929, 1417, 1404, 1917, 1409, 1909, 2424, 2007, 2001, 2498, 2490, 2491, 2492, 1981, 2493, 2494, 2495, 2496, 2497, 1458, 2482, 1459, 2489, 2478, 2480, 1456>]

Root Cause Analysis

  1. org.postgresql.util.PSQLException

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

    at org.postgresql.core.v3.SimpleParameterList.bind()
  2. PostgreSQL JDBC Driver
    SimpleParameterList.setBinaryParameter
    1. org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:64)
    2. org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:131)
    2 frames
  3. org.postgresql.jdbc
    PgPreparedStatement.setLong
    1. org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1094)
    2. org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:326)
    2 frames
  4. Hibernate
    PersistentBag.get
    1. org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$1.doBind(BigIntTypeDescriptor.java:46)
    2. org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74)
    3. org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
    4. org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:272)
    5. org.hibernate.loader.Loader.bindNamedParameters(Loader.java:2096)
    6. org.hibernate.loader.Loader.bindParameterValues(Loader.java:2016)
    7. org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1950)
    8. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1903)
    9. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881)
    10. org.hibernate.loader.Loader.doQuery(Loader.java:926)
    11. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:343)
    12. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:313)
    13. org.hibernate.loader.Loader.loadCollectionSubselect(Loader.java:2387)
    14. org.hibernate.loader.collection.SubselectOneToManyLoader.initialize(SubselectOneToManyLoader.java:62)
    15. org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:682)
    16. org.hibernate.event.internal.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:75)
    17. org.hibernate.internal.SessionImpl.initializeCollection(SessionImpl.java:2142)
    18. org.hibernate.collection.internal.AbstractPersistentCollection$4.doWork(AbstractPersistentCollection.java:567)
    19. org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:249)
    20. org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:563)
    21. org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:132)
    22. org.hibernate.collection.internal.PersistentBag.get(PersistentBag.java:449)
    22 frames
  5. com.pallasathenagroup.portal
    TestRun.main
    1. com.pallasathenagroup.portal.core.TestRun.main(TestRun.java:83)
    1 frame