org.h2.jdbc.JdbcSQLException: Datenumwandlungsfehler beim Umwandeln von "(1, 2)" Data conversion error converting "(1, 2)"; SQL statement: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) [22018-192] Error Code: 22018 Call: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) bind => [1, 2] Query: ReadAllQuery(referenceClass=RoleEntity sql="SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN (?))")

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Spring JIRA by Igor Mukhin, 1 year ago
Datenumwandlungsfehler beim Umwandeln von "(1, 2)" Data conversion error converting "(1, 2)"; SQL statement: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) [22018-192] Error Code: 22018 Call: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) bind => [1, 2] Query: ReadAllQuery(referenceClass=RoleEntity sql="SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN (?))")
via Google Groups by Szymon Kuryło, 1 year ago
Function alias "PROCEDURE" not found; SQL statement: EXECUTE PROCEDURE logProc() [90077-191] Error Code: 90077 Call: EXECUTE PROCEDURE logProc() Query: ResultSetMappingQuery(name="log" )
via Google Groups by Wojciech Marciniak, 6 months ago
Błąd ogólny: "java.lang.NullPointerException" General error: "java.lang.NullPointerException"; SQL statement: select * from team where parent = ? [50000-191] Error Code: 50000 Call: SELECT count(*) FROM (select * from(select distinct * from MEMBERS(18 ))) Query: DataReadQuery(sql=" SELECT count(*) FROM (select * from(select distinct * from MEMBERS(18)))")
via eclipse.org by Unknown author, 2 years ago
General error: "java.lang.NullPointerException" [50000-123] Error Code: 50000
via Google Groups by FAP, 1 year ago
Feature not supported: "autoServerMode && (readOnly || fileLockMethod == NO || fileLockMethod == SERIALIZED)" [50100-140] Error Code: 50100
via Stack Overflow by Jens
, 1 year ago
, password, phone, statusnr, systemusergroupidnr) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [-1, editby, 0, firstname, 2014-03-17 18:28:42.512, 2014-03-17 18:28:42.512, 2014-03-17 18:28:42.512, lastname, name, password, phone, 0, -1] Query: InsertObjectQuery(name (-1))
org.h2.jdbc.JdbcSQLException: Datenumwandlungsfehler beim Umwandeln von "(1, 2)" Data conversion error converting "(1, 2)"; SQL statement: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) [22018-192] Error Code: 22018 Call: SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN ((?,?))) bind => [1, 2] Query: ReadAllQuery(referenceClass=RoleEntity sql="SELECT ID, NAME FROM PBT_ROLE WHERE (ID IN (?))")
at java.math.BigDecimal.(BigDecimal.java:494)
at java.math.BigDecimal.(BigDecimal.java:383)
at java.math.BigDecimal.(BigDecimal.java:806)
at org.h2.value.Value.convertTo(Value.java:961)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.value.Value.convertTo(Value.java:1011)
at org.h2.mvstore.db.MVSecondaryIndex.convertToKey(MVSecondaryIndex.java:322)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:258)
at org.h2.mvstore.db.MVSecondaryIndex.find(MVSecondaryIndex.java:254)
at org.h2.index.BaseIndex.find(BaseIndex.java:128)
at org.h2.index.IndexCursor.find(IndexCursor.java:169)
at org.h2.table.TableFilter.next(TableFilter.java:466)
at org.h2.command.dml.Select.queryFlat(Select.java:541)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:654)
at org.h2.command.dml.Query.query(Query.java:341)
at org.h2.command.dml.Query.query(Query.java:309)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:110)
at org.h2.command.Command.executeQuery(Command.java:201)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2056)
at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693)
at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460)
at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)

Users with the same issue

4 times, 1 month ago
2 times, 1 month ago
2 times, 8 months ago
2 times, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
16 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.