org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]

GitHub | 5igm | 4 months ago
  1. 0

    Could you offer the name of supported economic plugins?

    GitHub | 4 months ago | 5igm
    org.h2.jdbc.JdbcSQLException: Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]
  2. 0

    when upgrade from 3.11->3.14->4.0->4.1 sql error

    GitHub | 2 months ago | heran
    org.h2.jdbc.JdbcSQLException: Table "ACCOUNT" already exists; SQL statement: CREATE TABLE PUBLIC.ACCOUNT (USER_NAME VARCHAR(100) NOT NULL, MAIL_ADDRESS VARCHAR(100) NOT NULL, PASSWORD VARCHAR(40) NOT NULL, ADMINISTRATOR BOOLEAN NOT NULL, URL VARCHAR(200), REGISTERED_DATE TIMESTAMP NOT NULL, UPDATED_DATE TIMESTAMP NOT NULL, LAST_LOGIN_DATE TIMESTAMP, IMAGE VARCHAR(100), GROUP_ACCOUNT BOOLEAN NOT NULL, FULL_NAME VARCHAR(100) NOT NULL, REMOVED BOOLEAN) [42101-190]
  3. 0

    H2 "OTHER" data type throws Exception when storing String or Boolean

    Stack Overflow | 1 year ago | Steve McLeod
    org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "foobar"; SQL statement: insert into test (key, value) values (?, ?) -- (?1, ?2) [90004-188]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to generate an api-token on rundeck 1.5

    GitHub | 4 years ago | connaryscott
    org.h2.jdbc.JdbcSQLException: Value too long for column AUTH_ROLES VARCHAR(255) NOT NULL: 'GS-Members-MISMO-CORP,GS-EComm-WebAdmins,GS-WebSiteAccess-MIS-CORP,Web Admins-eCommerce,$MISMO,GS-PrivNAS-AK-CORP,GS-Everyone-M... (303); SQL statement: insert into auth_token (id, version, auth_roles, token, user_id) values (null, ?, ?, ?, ?) [90005-112]
  6. 0

    creating a job on the UI leads to "value too long for column USER_RULE_LIST..."

    GitHub | 3 years ago | connaryscott
    org.h2.jdbc.JdbcSQLException: Value too long for column USER_ROLE_LIST VARCHAR(255): 'SNC-Ecommerce Search,GS-Members-MISMO-CORP,$MISMO,GS-PrivNAS-AK-CORP,GS-APMQALDAP,GS-APMPRDLDAP,IT eCommerce Organization,SNC-E... (412); SQL statement: insert into scheduled_execution (id, version, adhoc_execution, adhoc_filepath, adhoc_local_string, adhoc_remote_string, arg_string, date_created, day_of_month, day_of_week, description, do_nodedispatch, exec_count, group_path, hour, job_name, last_updated, loglevel, minute, month, multiple_executions, next_execution, node_exclude, node_exclude_name, node_exclude_os_arch, node_exclude_os_family, node_exclude_os_name, node_exclude_os_version, node_exclude_precedence, node_exclude_tags, node_include, node_include_name, node_include_os_arch, node_include_os_family, node_include_os_name, node_include_os_version, node_include_tags, node_keepgoing, node_rank_attribute, node_rank_order_ascending, node_threadcount, project, scheduled, seconds, total_time, rduser, user_role_list, uuid, workflow_id, year) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-112]
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.h2.jdbc.JdbcSQLException

    Value too long for column "ID VARCHAR(36)": "'nation-0821d04a-e64c-437c-8a6a-1a8635e9175e' (43)"; SQL statement: INSERT INTO economylitevirts (`id`, `balance`, `currency`) VALUES (?, ?, ?) [22001-192]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcPreparedStatement.executeUpdate
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.table.Column.validateConvertUpdateSequence(Column.java:335)
    4. org.h2.table.Table.validateConvertUpdateSequence(Table.java:784)
    5. org.h2.command.dml.Insert.insertRows(Insert.java:151)
    6. org.h2.command.dml.Insert.update(Insert.java:114)
    7. org.h2.command.CommandContainer.update(CommandContainer.java:98)
    8. org.h2.command.Command.executeUpdate(Command.java:258)
    9. org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
    10. org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
    10 frames
  3. HikariCP-java6
    HikariProxyPreparedStatement.executeUpdate
    1. com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
    2. com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
    2 frames
  4. io.github.flibio
    LiteEconomyService.getOrCreateAccount
    1. io.github.flibio.economylite.utils.sql.SqlManager.executeUpdate(SqlManager.java:118)
    2. io.github.flibio.economylite.impl.VirtualServiceCommon.setBalance(VirtualServiceCommon.java:77)
    3. io.github.flibio.economylite.impl.economy.LiteEconomyService.getOrCreateAccount(LiteEconomyService.java:81)
    3 frames
  5. com.arckenver.nations
    NationCreateExecutor.execute
    1. com.arckenver.nations.cmdexecutor.nation.NationCreateExecutor.execute(NationCreateExecutor.java:111)
    1 frame
  6. org.spongepowered.api
    SimpleDispatcher.process
    1. org.spongepowered.api.command.args.ChildCommandElementExecutor.execute(ChildCommandElementExecutor.java:179)
    2. org.spongepowered.api.command.spec.CommandSpec.process(CommandSpec.java:332)
    3. org.spongepowered.api.command.dispatcher.SimpleDispatcher.process(SimpleDispatcher.java:333)
    3 frames
  7. org.spongepowered.common
    SpongeCommandManager.process
    1. org.spongepowered.common.command.SpongeCommandManager.process(SpongeCommandManager.java:274)
    1 frame
  8. net.minecraft.command
    ServerCommandManager.func_71556_a
    1. net.minecraft.command.ServerCommandManager.func_71556_a(SourceFile:82)
    1 frame
  9. Minecraft
    CPacketChatMessage.func_148833_a
    1. net.minecraft.network.NetHandlerPlayServer.func_147361_d(NetHandlerPlayServer.java:913)
    2. net.minecraft.network.NetHandlerPlayServer.func_147354_a(NetHandlerPlayServer.java:892)
    3. net.minecraft.network.play.client.CPacketChatMessage.func_148833_a(SourceFile:37)
    4. net.minecraft.network.play.client.CPacketChatMessage.func_148833_a(SourceFile:9)
    4 frames
  10. org.spongepowered.common
    PacketUtil.onProcessPacket
    1. org.spongepowered.common.network.PacketUtil.onProcessPacket(PacketUtil.java:118)
    1 frame
  11. Minecraft
    PacketThreadUtil$1.run
    1. net.minecraft.network.PacketThreadUtil$1.redirect$onProcessPacket$0(SourceFile:39)
    2. net.minecraft.network.PacketThreadUtil$1.run(SourceFile:13)
    2 frames
  12. Java RT
    FutureTask.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    2. java.util.concurrent.FutureTask.run(Unknown Source)
    2 frames
  13. net.minecraft.util
    Util.func_181617_a
    1. net.minecraft.util.Util.func_181617_a(SourceFile:45)
    1 frame
  14. MC Server
    MinecraftServer.run
    1. net.minecraft.server.MinecraftServer.func_71190_q(MinecraftServer.java:668)
    2. net.minecraft.server.dedicated.DedicatedServer.func_71190_q(DedicatedServer.java:387)
    3. net.minecraft.server.MinecraftServer.func_71217_p(MinecraftServer.java:613)
    4. net.minecraft.server.MinecraftServer.run(MinecraftServer.java:471)
    4 frames
  15. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame