Hi expert,
My recent debug told me that my tables do not exist but it is there in MySQL.
Now, I found out from https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html that the name has to be same and case sensitive.
Now, my tables name even though are same as Models they differ in the first character.
For example, I have subject table but my Models is Subject.
The error I am getting now :
Error accessing tables metadata
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExcepti
onTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(Stand
ardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.
java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.
java:97)
at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseM
etaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.jav
a:98)
at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseM
etaDataImpl.populateTablesWithColumns(InformationExtractorJdbcDatabaseMetaDataIm
pl.java:383)
at org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseM
etaDataImpl.getTables(InformationExtractorJdbcDatabaseMetaDataImpl.java:337)
at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.getTables
Information(DatabaseInformationImpl.java:120)
at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMi
gration(GroupedSchemaMigratorImpl.java:65)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(A
bstractSchemaMigrator.java:203)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(Abstra
ctSchemaMigrator.java:110)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabas
eAction(SchemaManagementToolCoordinator.java:183)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(Schema
ManagementToolCoordinator.java:72)
at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309
)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBu
ilderImpl.java:452)
at util.HibernateUtil.getSessionFactory(HibernateUtil.java:42)
at Business.RegisterService.register(RegisterService.java:24)
at controller.tutorController.doPost(tutorController.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:166)
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.
java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140
)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogVa
lve.java:651)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:417)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java
:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtoco
l.java:754)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.jav
a:1376)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:
49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.ja
va:61)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hi5
s.subject' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
My question is :
- how to overcome this table not found error?
- do i need to alter the model such that the Subject to becomes subject - cos my database is using small cap subject?