java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[SET TABLE tempo SOURCE "test/gene.txt;ignore\_first=true;fs=\t"\]

hsqldb | ladykrystana | 10 years ago
  1. 0

    Set table source and null pointer exception

    hsqldb | 10 years ago | ladykrystana
    java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[SET TABLE tempo SOURCE "test/gene.txt;ignore\_first=true;fs=\t"\]
  2. 0

    Got the following error on db start up.

    GitHub | 2 years ago | sztankatt
    java.sql.SQLException: Unexpected token: SEARCHNAME in statement [CREATE TABLE savedsearches ( id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY searchName]
  3. 0

    How to set user classpath precedence when not a mapreduce job?

    Stack Overflow | 3 years ago | user2708246
    java.sql.SQLException: Unexpected token AS, requires ( in statement [create table click as]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HSQL - Unexpected token: PROCEDURE in statement

    Stack Overflow | 2 years ago | emeraldjava
    org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 19 of resource class path resource [hsql/attribution-hsqldb.sql]: CREATE PROCEDURE policy_Attribution(p_valDate Date) MODIFIES SQL DATA BEGIN ATOMIC CREATE TABLE #retvals ( Policy_ID INT, Attribution_Name CHAR(64), Attribution_Type CHAR(20), Risk CHAR(20), Revenue FLOAT, Claims FLOAT ) INSERT INTO #retvals VALUES (1, 'name', 'type', 'risk', 1.5, 1.6) INSERT INTO #retvals VALUES (2, 'name2', 'type2', 'risk2', 0.5, 0.6) INSERT INTO #retvals VALUES (3, 'name3', 'type3', 'risk3', 2.5, 2.6) SELECT * FROM #retvals END
  6. 0

    HSQLDB and Liquibase, Table already exists: DATABASECHANGELOGLOCK

    Stack Overflow | 2 years ago | Gleeb
    java.sql.SQLException: Table already exists: DATABASECHANGELOGLOCK in statement [CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK]

    3 unregistered visitors
    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. java.sql.SQLException

      S1000 General error java.lang.NullPointerException in statement \[SET TABLE tempo SOURCE "test/gene.txt;ignore\_first=true;fs=\t"\]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      3 frames
    3. Unknown
      DBTools.AlterAddColumn
      1. DBTools.AlterAddColumn(DBTools.java:138)
      1 frame