search

jasimcse / fsnet

Automatically exported from code.google.com/p/fsnet
0 stars 0 forks source link

Consultation creation does not work #237

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. click on "create a consultation"
2. fill in the form
3. hit "create consultation"

What is the expected output? What do you see instead?

It looks like we have an issue with the way the information is persisted.

Etat HTTP 500 -

type Rapport d''exception

message

description Le serveur a rencontré une erreur interne () qui l'a empêché de 
satisfaire la requête.

exception

javax.servlet.ServletException: javax.persistence.RollbackException: Exception 
[EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Incorrect integer value: 'F' for 
column 'CLOSINGATMAXVOTERS' at row 1
Error Code: 1366
Call: INSERT INTO CONSULTATION (LIMITCHOICESPERPARTICIPANTMIN, 
IFNECESSARYWEIGHT, CLOSINGATMAXVOTERS, LIMITCHOICESPERPARTICIPANTMAX, 
SHOWBEFORECLOSING, SHOWBEFOREANSWER, TYPE, MAXVOTERS, CURRENTVOTERS, 
CLOSINGATDATE, LIMITPARTICIPANTSPERCHOICE, MAXDATE, DESCRIPTION, 
ALLOWALLTOMODIFY, LIMITCHOICESPERPARTICIPANT, OPENED, ID) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    bind => [0, 0.0, F, 0, F, F, null, 0, 0, F, F, null, Quand pouvons nous organiser la recontre étudiants/enseignants pour faire le point sur la formation, F, F, F, 88]
    org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    fr.univartois.ili.fsnet.core.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
    fr.univartois.ili.fsnet.auth.IsAuthenticatedFilter.doFilter(IsAuthenticatedFilter.java:54)
cause mère

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse 
Persistence Services - 2.1.2.v20101206-r8635): 
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Incorrect integer value: 'F' for 
column 'CLOSINGATMAXVOTERS' at row 1
Error Code: 1366
Call: INSERT INTO CONSULTATION (LIMITCHOICESPERPARTICIPANTMIN, 
IFNECESSARYWEIGHT, CLOSINGATMAXVOTERS, LIMITCHOICESPERPARTICIPANTMAX, 
SHOWBEFORECLOSING, SHOWBEFOREANSWER, TYPE, MAXVOTERS, CURRENTVOTERS, 
CLOSINGATDATE, LIMITPARTICIPANTSPERCHOICE, MAXDATE, DESCRIPTION, 
ALLOWALLTOMODIFY, LIMITCHOICESPERPARTICIPANT, OPENED, ID) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    bind => [0, 0.0, F, 0, F, F, null, 0, 0, F, F, null, Quand pouvons nous organiser la recontre étudiants/enseignants pour faire le point sur la formation, F, F, F, 88]
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    fr.univartois.ili.fsnet.actions.ManageConsultations.create(ManageConsultations.java:48)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
    org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
    org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:166)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    fr.univartois.ili.fsnet.core.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
    fr.univartois.ili.fsnet.auth.IsAuthenticatedFilter.doFilter(IsAuthenticatedFilter.java:54)
cause mère

Exception [EclipseLink-4002] (Eclipse Persistence Services - 
2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Incorrect integer value: 'F' for 
column 'CLOSINGATMAXVOTERS' at row 1
Error Code: 1366
Call: INSERT INTO CONSULTATION (LIMITCHOICESPERPARTICIPANTMIN, 
IFNECESSARYWEIGHT, CLOSINGATMAXVOTERS, LIMITCHOICESPERPARTICIPANTMAX, 
SHOWBEFORECLOSING, SHOWBEFOREANSWER, TYPE, MAXVOTERS, CURRENTVOTERS, 
CLOSINGATDATE, LIMITPARTICIPANTSPERCHOICE, MAXDATE, DESCRIPTION, 
ALLOWALLTOMODIFY, LIMITCHOICESPERPARTICIPANT, OPENED, ID) VALUES (?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    bind => [0, 0.0, F, 0, F, F, null, 0, 0, F, F, null, Quand pouvons nous organiser la recontre étudiants/enseignants pour faire le point sur la formation, F, F, F, 88]
    org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:373)
    org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144)
    org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3348)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1422)
    org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:610)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1527)
    org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:264)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1148)
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    fr.univartois.ili.fsnet.actions.ManageConsultations.create(ManageConsultations.java:48)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
    org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
    org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:166)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    fr.univartois.ili.fsnet.core.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
    fr.univartois.ili.fsnet.auth.IsAuthenticatedFilter.doFilter(IsAuthenticatedFilter.java:54)
cause mère

java.sql.SQLException: Incorrect integer value: 'F' for column 
'CLOSINGATMAXVOTERS' at row 1
    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
    com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
    com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
    org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:788)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:373)
    org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144)
    org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3348)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1422)
    org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:610)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1527)
    org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:264)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1148)
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84)
    org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
    fr.univartois.ili.fsnet.actions.ManageConsultations.create(ManageConsultations.java:48)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
    org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
    org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:166)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    fr.univartois.ili.fsnet.core.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
    fr.univartois.ili.fsnet.auth.IsAuthenticatedFilter.doFilter(IsAuthenticatedFilter.java:54)
note La trace complète de la cause mère de cette erreur est disponible dans 
les fichiers journaux de Apache Tomcat/7.0.6.

Apache Tomcat/7.0.6

Original issue reported on code.google.com by daniel.l...@gmail.com on 13 Feb 2011 at 4:17

GoogleCodeExporter commented 9 years ago 
Incorrect integer value: 'F' for column 'CLOSINGATMAXVOTERS' at row 1
=> it looks like you are using the old Consultation table with the new 
Consultation Entity. 

Are you sure to have deleted the database before deploying the new entities ? 

Here is a code to perfom this task :

EntityManager em = PersistenceProvider.createEntityManager();
em.getTransaction().begin();
em.createNativeQuery("DROP TABLE Consultation").executeUpdate();
em.createNativeQuery("DROP TABLE ConsultationChoice").executeUpdate();
em.createNativeQuery("DROP TABLE ConsultationChoiceVote").executeUpdate();
em.createNativeQuery("DROP TABLE ConsultationVote").executeUpdate();
em.getTransaction().commit();
em.close();

Original comment by pierre.d...@gmail.com on 13 Feb 2011 at 4:47

GoogleCodeExporter commented 9 years ago 
We need a specific servlet to call this on the public instance :)

Original comment by daniel.l...@gmail.com on 13 Feb 2011 at 4:57

GoogleCodeExporter commented 9 years ago 
I've just committed it. Can you try it please ?

Original comment by pierre.d...@gmail.com on 13 Feb 2011 at 5:09

GoogleCodeExporter commented 9 years ago 
Thanks.

Unfortunately, the table Consultation is not known:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 
2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Unknown table 'Consultation'
Error Code: 1051
Call: DROP TABLE Consultation
Query: DataModifyQuery(sql="DROP TABLE Consultation")
    org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:797)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:235)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:215)
    org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
    org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
    org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:643)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2908)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
    org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:534)
    fr.univartois.ili.fsnet.auth.DropConsultationDatabase.doGet(DropConsultationDatabase.java:33)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
cause mère

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 
'Consultation'
    sun.reflect.GeneratedConstructorAccessor1231.newInstance(Unknown Source)
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    java.lang.reflect.Constructor.newInstance(Unknown Source)
    com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
    com.mysql.jdbc.Util.getInstance(Util.java:384)
    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
    com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
    com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
    com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
    org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:788)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:863)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583)
    org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:980)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:206)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:192)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:235)
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:215)
    org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
    org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:740)
    org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:643)
    org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2908)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1291)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1273)
    org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1247)
    org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeUpdate(EJBQueryImpl.java:534)
    fr.univartois.ili.fsnet.auth.DropConsultationDatabase.doGet(DropConsultationDatabase.java:33)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

Under MYSQL, table names look like uppercase from the initial error message :)

s/Consultation/CONSULTATION/g

Original comment by daniel.l...@gmail.com on 13 Feb 2011 at 5:29

GoogleCodeExporter commented 9 years ago 
I'm using MYSQL and it works, are you using derby ?

In my phpmyadmin view, tables are in lowercase. However if i write Consultation 
with a 'C' in uppercase, it looks like JPA can transform the string in the good 
format.

i'm going to search a solution. Maybe we can delete a table with a jpql request 
?

Original comment by pierre.d...@gmail.com on 13 Feb 2011 at 5:39

GoogleCodeExporter commented 9 years ago 
I've just tried with derby and mysql.

Derby : there was a bug in the order of the delete instructions. (Fixed in the 
last commit)

Mysql : It works. 

I can't reproduce the bug. Then it's hard to debug :(.

Maybe you have tried to delete the tables two times ? (otherwise i don't 
understand why it doesn't work for you :( ).

Please try to create a consultation to see if the initial bug persist ?

Original comment by pierre.d...@gmail.com on 13 Feb 2011 at 6:12

GoogleCodeExporter commented 9 years ago 
No, it is mysql:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

That's strange. I do not know which version of MySQL is installed.

Original comment by daniel.l...@gmail.com on 13 Feb 2011 at 6:13

GoogleCodeExporter commented 9 years ago 
I can confirm this issue.

See attached file for more information.

Original comment by mat.boni...@gmail.com on 14 Feb 2011 at 5:57

Attachments:

GoogleCodeExporter commented 9 years ago 
We are aware of the issue. We need to cleanup the database by hand. We will see 
afterward if it works.

Original comment by daniel.l...@gmail.com on 14 Feb 2011 at 6:59

GoogleCodeExporter commented 9 years ago 
The issue is sorted out after deleting previous tables from the database.

Original comment by daniel.l...@gmail.com on 14 Feb 2011 at 9:38