com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this_.organizationId' in 'field list'

Stack Overflow | Dan | 4 months ago
  1. 0

    Hibernate Entity OneToOne with same Primary and Foreign Key Bidirectional Relationship

    Stack Overflow | 4 months ago | Dan
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this_.organizationId' in 'field list'
  2. 0

    JDBC error: Unknown column 'product0_.active' in 'field list'

    GitHub | 2 years ago | rhodebump
    org.quartz.JobExecutionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select product0_.id as id19_, product0_.version as version19_, product0_.active as active19_, product0_.brand_name as brand4_19_, product0_.category_id as category5_19_, product0_.cold_chain as cold6_19_, product0_.controlled_substance as controlled7_19_, product0_.created_by_id as created8_19_, product0_.date_created as date9_19_, product0_.default_uom_id as default10_19_, product0_.description as descrip11_19_, product0_.essential as essential19_, product0_.hazardous_material as hazardous13_19_, product0_.last_updated as last14_19_, product0_.lot_control as lot15_19_, product0_.manufacturer as manufac16_19_, product0_.manufacturer_code as manufac17_19_, product0_.manufacturer_name as manufac18_19_, product0_.model_number as model19_19_, product0_.name as name19_, product0_.ndc as ndc19_, product0_.package_size as package22_19_, product0_.price_per_unit as price23_19_, product0_.product_code as product24_19_, product0_.reconditioned as recondi25_19_, product0_.serialized as serialized19_, product0_.unit_of_measure as unit27_19_, product0_.upc as upc19_, product0_.updated_by_id as updated29_19_, product0_.vendor as vendor19_, product0_.vendor_code as vendor31_19_, product0_.vendor_name as vendor32_19_ from product product0_ where product0_.product_code is null or product0_.product_code='']; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query [See nested exception: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select product0_.id as id19_, product0_.version as version19_, product0_.active as active19_, product0_.brand_name as brand4_19_, product0_.category_id as category5_19_, product0_.cold_chain as cold6_19_, product0_.controlled_substance as controlled7_19_, product0_.created_by_id as created8_19_, product0_.date_created as date9_19_, product0_.default_uom_id as default10_19_, product0_.description as descrip11_19_, product0_.essential as essential19_, product0_.hazardous_material as hazardous13_19_, product0_.last_updated as last14_19_, product0_.lot_control as lot15_19_, product0_.manufacturer as manufac16_19_, product0_.manufacturer_code as manufac17_19_, product0_.manufacturer_name as manufac18_19_, product0_.model_number as model19_19_, product0_.name as name19_, product0_.ndc as ndc19_, product0_.package_size as package22_19_, product0_.price_per_unit as price23_19_, product0_.product_code as product24_19_, product0_.reconditioned as recondi25_19_, product0_.serialized as serialized19_, product0_.unit_of_measure as unit27_19_, product0_.upc as upc19_, product0_.updated_by_id as updated29_19_, product0_.vendor as vendor19_, product0_.vendor_code as vendor31_19_, product0_.vendor_name as vendor32_19_ from product product0_ where product0_.product_code is null or product0_.product_code='']; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query]
  3. 0

    print all exception locations in java

    Stack Overflow | 4 years ago | p00ya00
    org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Single Table Inheritance WITHOUT Discriminator column

    Stack Overflow | 5 years ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'apprentice0_.DTYPE' in 'where clause'
  6. 0

    Hibernate bidirectional OneToMany with JoinTable and polymorphic classes with table per concrete class

    Stack Overflow | 4 years ago | Simone Gianni
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'page1_.pub_id' in 'field list'

  1. mortalman7 1 times, last 5 months ago
  2. Kialandei 1 times, last 2 weeks ago
  3. davidvanlaatum 8 times, last 2 months ago
  4. AndrewProg 2 times, last 3 months ago
  5. kuldeep 2 times, last 3 months ago
27 more registered users
63 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. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Unknown column 'this_.organizationId' in 'field list'

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[?:1.7.0_79]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[?:1.7.0_79]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[?:1.7.0_79]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:526)[?:1.7.0_79]
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:400)[mysql-connector-java-5.1.36.jar:5.1.36]
    2. com.mysql.jdbc.Util.getInstance(Util.java:383)[mysql-connector-java-5.1.36.jar:5.1.36]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)[mysql-connector-java-5.1.36.jar:5.1.36]
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)[mysql-connector-java-5.1.36.jar:5.1.36]
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)[mysql-connector-java-5.1.36.jar:5.1.36]
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)[mysql-connector-java-5.1.36.jar:5.1.36]
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)[mysql-connector-java-5.1.36.jar:5.1.36]
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)[mysql-connector-java-5.1.36.jar:5.1.36]
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)[mysql-connector-java-5.1.36.jar:5.1.36]
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)[mysql-connector-java-5.1.36.jar:5.1.36]
    10 frames
  4. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:404)[c3p0-0.9.5-pre10.jar:0.9.5-pre10]
    1 frame
  5. Hibernate
    ResultSetReturnImpl.extract
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)[hibernate-core-4.3.11.Final.jar:4.3.11.Final]
    1 frame