java.sql.SQLException: File input/output error: java.io.IOException: end of line characters not allowed in statement \[INSERT INTO avs\_folders(id, name,display\_names,visible,parent\_id,sequence,owner\_id,created\_on,created\_by\_id,last\_modified\_on,last\_modified\_by\_id) values (?,?,?,?,?,?,?,?,?,?,?)\]

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 1.4 Root Login Error
    via opencrx by bus_dev5
    ,
  • url not working
    via opencrx by sfh2
    ,
  • Get following error: [java] Caused by: java.sql.SQLException: Try to insert null into a non-nullable column: column: NUMBONES table: PET in statement [insert into Pet (name, weight, lives, ANIMAL_TYPE, id) values (?, ?, ?, 'CAT', null)] [java] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source) [java] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) [java] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316) [java] at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1773) From this code. This used to work. @Entity @Inheritance(strategy = InheritanceType.SINGLE_TABLE, discriminatorType = DiscriminatorType.STRING) @DiscriminatorColumn(name = "ANIMAL_TYPE", nullable = true) public class Pet implements java.io.Serializable { private int id; private String name; private double weight; @Id(generate = GeneratorType.AUTO) public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public double getWeight() { return weight; } public void setWeight(double weight) { this.weight = weight; } } @Inheritance(strategy = InheritanceType.SINGLE_TABLE, discriminatorType = DiscriminatorType.STRING, discriminatorValue = "DOG") public class Dog extends Pet { private int numBones; public int getNumBones() { return numBones; } public void setNumBones(int numBones) { this.numBones = numBones; } } @Entity @Inheritance(strategy = InheritanceType.SINGLE_TABLE, discriminatorType = DiscriminatorType.STRING, discriminatorValue = "CAT") public class Cat extends Pet { int lives; public int getLives() { return lives; } public void setLives(int lives) { this.lives = lives; } }
    via by Bill Burke,
  • db:: 3.64::Routing query output to STDOUT 3a
    via by Unknown author,
  • ODI Error
    via by 669885,
  • Conditional email
    via by _Phil,
  • ODI 10.1.3.6 Error
    via by user4783187,
    • java.sql.SQLException: File input/output error: java.io.IOException: end of line characters not allowed in statement \[INSERT INTO avs\_folders(id, name,display\_names,visible,parent\_id,sequence,owner\_id,created\_on,created\_by\_id,last\_modified\_on,last\_modified\_by\_id) values (?,?,?,?,?,?,?,?,?,?,?)\] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) at com.aurigalogic.activesite.folder.FolderDAO.create(FolderDAO.java:54) at com.aurigalogic.activesite.folder.FolderMgr.save(FolderMgr.java:144) at com.aurigalogic.activesite.folder.FolderAction.save(FolderAction.java:295) at com.aurigalogic.activesite.folder.FolderAction.perform1(FolderAction.java:40)

    Users with the same issue

    Unknown visitor1 times, last one,