com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'snarkdb.profile' doesn't exist

Google Groups | missingfaktor | 5 years ago
  1. 0

    [ circumflex-orm ] Table not found error.

    Google Groups | 5 years ago | missingfaktor
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'snarkdb.profile' doesn't exist
  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'
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

    Table 'snarkdb.profile' doesn't exist

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)[na:1.6.0_24]
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)[na:1.6.0_24]
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)[na:1.6.0_24]
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)[na:1.6.0_24]
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java-5.1.19.jar:na]
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java-5.1.19.jar:na]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)[mysql-connector-java-5.1.19.jar:na]
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4098)[mysql-connector-java-5.1.19.jar:na]
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4030)[mysql-connector-java-5.1.19.jar:na]
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)[mysql-connector-java-5.1.19.jar:na]
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)[mysql-connector-java-5.1.19.jar:na]
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677)[mysql-connector-java-5.1.19.jar:na]
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2134)[mysql-connector-java-5.1.19.jar:na]
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2300)[mysql-connector-java-5.1.19.jar:na]
    10 frames
  4. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)[c3p0-0.9.1.2.jar:0.9.1.2]
    1 frame
  5. ru.circumflex.orm
    SQLQuery$$anonfun$2.apply
    1. ru.circumflex.orm.SQLQuery$$anonfun$2$$anonfun$apply$1.apply(query.scala:100)[circumflex-orm-2.1.jar:na]
    2. ru.circumflex.orm.SQLQuery$$anonfun$2$$anonfun$apply$1.apply(query.scala:98)[circumflex-orm-2.1.jar:na]
    3. ru.circumflex.orm.Transaction$$anonfun$execute$1.apply(config.scala:282)[circumflex-orm-2.1.jar:na]
    4. ru.circumflex.orm.Transaction$$anonfun$execute$1.apply(config.scala:275)[circumflex-orm-2.1.jar:na]
    5. ru.circumflex.orm.Transaction.execute(config.scala:264)[circumflex-orm-2.1.jar:na]
    6. ru.circumflex.orm.Transaction.execute(config.scala:275)[circumflex-orm-2.1.jar:na]
    7. ru.circumflex.orm.SQLQuery$$anonfun$2.apply(query.scala:98)[circumflex-orm-2.1.jar:na]
    7 frames
  6. ru.circumflex.core
    package$.time
    1. ru.circumflex.core.package$.time(package.scala:28)[circumflex-core-2.1.jar:na]
    1 frame
  7. ru.circumflex.orm
    Deployment$$anonfun$process$1.apply
    1. ru.circumflex.orm.SQLQuery.resultSet(query.scala:97)[circumflex-orm-2.1.jar:na]
    2. ru.circumflex.orm.Criteria.unique(criteria.scala:217)[circumflex-orm-2.1.jar:na]
    3. ru.circumflex.orm.Deployment.processNode(xml.scala:56)[circumflex-orm-2.1.jar:na]
    4. ru.circumflex.orm.Deployment$$anonfun$process$1.apply(xml.scala:38)[circumflex-orm-2.1.jar:na]
    5. ru.circumflex.orm.Deployment$$anonfun$process$1.apply(xml.scala:38)[circumflex-orm-2.1.jar:na]
    5 frames
  8. Scala
    List.foreach
    1. scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:59)[gryphon-scala-0.0.1-SNAPSHOT.jar:na]
    2. scala.collection.immutable.List.foreach(List.scala:45)[gryphon-scala-0.0.1-SNAPSHOT.jar:na]
    2 frames
  9. ru.circumflex.orm
    Deployment.process
    1. ru.circumflex.orm.Deployment.process(xml.scala:38)[circumflex-orm-2.1.jar:na]
    1 frame
  10. in.vayana.snark
    Sample$$anonfun$loadData$1.apply
    1. in.vayana.snark.Sample$$anonfun$loadData$1.apply(PersistenceTest.scala:25)[test/:na]
    2. in.vayana.snark.Sample$$anonfun$loadData$1.apply(PersistenceTest.scala:25)[test/:na]
    2 frames
  11. Scala
    List.foreach
    1. scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:59)[gryphon-scala-0.0.1-SNAPSHOT.jar:na]
    2. scala.collection.immutable.List.foreach(List.scala:45)[gryphon-scala-0.0.1-SNAPSHOT.jar:na]
    2 frames
  12. in.vayana.snark
    PersistenceTest$$anonfun$1.apply
    1. in.vayana.snark.Sample$.loadData(PersistenceTest.scala:25)[test/:na]
    2. in.vayana.snark.PersistenceTest$$anonfun$1.apply$mcV$sp(PersistenceTest.scala:45)[test/:na]
    3. in.vayana.snark.PersistenceTest$$anonfun$1.apply(PersistenceTest.scala:43)[test/:na]
    4. in.vayana.snark.PersistenceTest$$anonfun$1.apply(PersistenceTest.scala:43)[test/:na]
    4 frames