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 | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

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

    GitHub | 7 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