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

Stack Overflow | Dan | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Hibernate Entity OneToOne with same Primary and Foreign Key Bidirectional Relationship

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

    Dev server startup failure (was "Error on dev server first admin login")

    Google Groups | 3 years ago | Edward Pan
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. 0

    Error on dev server first admin login

    Google Groups | 3 years ago | Edward Pan
    org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    GitHub | 3 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]
  6. 0

    print all exception locations in java

    Stack Overflow | 4 years ago | p00ya00
    org.hibernate.exception.SQLGrammarException: could not execute query
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