Hi expert, I am now facing yet another problem. There is a stackoverflow solution https://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should where I had tried before but the solution is not a permanent cure so I would like to know how to make the error go away …

Posting screenshots is of little use. You should add the entire stacktrace so that the root Exception can be seen. That’s where you need to look.

Hi vlad, Here’s the full stack-trace for this part of error: (keep my fingers crossed that it can go thru) Mar 25, 2018 11:58:32 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 22262 ms INFO [http-nio-8080-exec-7]: Subject added 2018-03-25 12:05:32,124 http-nio-8080-exec-7 …

The error is pretty straightforward: [image] karengsh: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘hi5s.subject_tutor’ doesn’t exist Based on your JDBC URL: jdbc:mysql://localhost:3306/hi5s you are already connected to the hi5s catalog. And, since MySQL do…

Hi vlad, But, I do not have a model by SubjectTutor. Are you suggesting I create one ? Under the model layer, I only have Tutor, Subject and User From the documentation that I read, there is none that mention that I should create a class to cater to the join table. Could you let me know if I ha…

You need to add your entity mappings to the post so we can better understand your domain model.

Here’s the entity mappings: @Entity (name = "Subject") @Table(name = "subject") public class Subject implements Serializable { /** * */ private static final long serialVersionUID = -7607227309942205498L; @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private int subject_id; …

This mapping is wrong: [image] karengsh: @JoinTable(name=“tutor_id”, joinColumns=@JoinColumn(name=“subject_id”)) public String getSubject() { return subject; } @JoinTable is for associations not for basic properties. Now, if you auto-generated the schema, the mapping will work. The prob…

Hi vlad, You advised me to use Bidirectional long ago. And then I was fighting with millions of issue - harddisk crash, re-do my entire project, debugging problem with Eclipse that now then I can come back. On hindsight, I should not put in the Join table inside the code I showed you cos I was me…

Yes, you should use bidirectional. But to do so, you must have a proper one-to-many database table relationship as well. If you have a join table in the database, you won’t be able to use a bidirectional association which only requires a FK on the child table. Just generate the schema with Hibern…

Hi Vlad, Just to check my understanding of your message is correct. So, you are saying I deleted all my database in MySQL and let hbm2ddl do the job ? So, I will change this to create instead of update ? property name=“hibernate.hbm2ddl.auto”>update Is it correct? Or are you saying I remove my…

Error accessing tables metadata

Hibernate ORM

vlad March 27, 2018, 7:06am 14

You can use hbm2ddl to generate the initial schema, then use Flyway for automatic migrations and to have a way to store incremental migration scripts in Git.

Read this article for more details.

Topic		Replies	Views
SQLSyntaxErrorException: Unknown column <columnName> in field list Hibernate ORM	20	27004	November 14, 2018
Hibernate validation fails because of "missing table"s even tho they exist Hibernate ORM	1	4073	June 24, 2024
Error viewing tables of database with hibernate tools Hibernate Tools	8	8098	January 31, 2020
Why my order of execute is wrong? Hibernate ORM	5	7345	November 16, 2018
[solved] Missing table, mix entity tables with persistence Units Hibernate ORM	21	7036	April 4, 2018

Error accessing tables metadata

Related topics