Hello,
i could not change my collation, even if the tables are empty ... i'm a bit
confused here,
i create my db with JPA-hibernate and i once the entityManager 's launched
, i execute some Sql statements. The first statement is "SET COLLATION
FRENCH STRENGTH PRIMARY;" and then i got the org.h2.jdbc.JdbcSQLException.
here's my log if someone can help me with this.
[2013-08-05 14:33:29,454] INFO org.hibernate.annotations.common.Version -
HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
[2013-08-05 14:33:29,459] INFO org.hibernate.Version - HHH000412:
Hibernate Core {4.2.3.Final}
[2013-08-05 14:33:29,460] INFO org.hibernate.cfg.Environment - HHH000206:
hibernate.properties not found
[2013-08-05 14:33:29,461] INFO org.hibernate.cfg.Environment - HHH000021:
Bytecode provider name : javassist
[2013-08-05 14:33:29,687] INFO
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl
- HHH000402: Using Hibernate built-in connection pool (not for production
use!)
[2013-08-05 14:33:29,690] INFO
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl
- HHH000115: Hibernate connection pool size: 20
[2013-08-05 14:33:29,690] INFO
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl
- HHH000006: Autocommit mode: true
[2013-08-05 14:33:29,690] INFO
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl
- HHH000401: using driver [org.h2.Driver] at URL
[jdbc:h2:file:bdd/cwfse_p;]
[2013-08-05 14:33:29,690] INFO
org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl
- HHH000046: Connection properties: {user=sa, autocommit=true,
release_mode=auto}
[2013-08-05 14:33:29,907] INFO org.hibernate.dialect.Dialect - HHH000400:
Using dialect: org.hibernate.dialect.H2Dialect
[2013-08-05 14:33:30,024] INFO
org.hibernate.engine.transaction.internal.TransactionFactoryInitiator -
HHH000268: Transaction strategy:
org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
[2013-08-05 14:33:30,027] INFO
org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory - HHH000397:
Using ASTQueryTranslatorFactory
[2013-08-05 14:33:30,217] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate -
HHH000228: Running hbm2ddl schema update
[2013-08-05 14:33:30,217] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate -
HHH000102: Fetching database metadata
[2013-08-05 14:33:30,218] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate -
HHH000396: Updating schema
[2013-08-05 14:33:30,233] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.BENEFICIAIRE
[2013-08-05 14:33:30,233] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [gestion, cmu, adresse, cle_patient, domaine,
periode_amo_1, id_pat, periode_amo_2, etm, exoneration, prenom, id,
mutuelle, rang, cle, rang_gemellaire, adherent, droits_amc,
date_de_naissance, code_qualite, code_couverture, ald, mt, organisme_amc,
periode_amc_1, droits_amo, periode_amc_2, qualite, code_mutuelle, nom,
numero, taux, identifiant_hote, periodes_amo_2, periodes_amo_1, routage]
[2013-08-05 14:33:30,233] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: [fk_glf0h1cnw4ahibbld4i1tojd9]
[2013-08-05 14:33:30,233] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_7, fk_glf0h1cnw4ahibbld4i1tojd9_index_7]
[2013-08-05 14:33:30,237] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.DOCUMENTS
[2013-08-05 14:33:30,237] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [nomdoc, id_doc, corpsdoc, commentaire]
[2013-08-05 14:33:30,237] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,237] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_d]
[2013-08-05 14:33:30,242] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.MSGERR_ME
[2013-08-05 14:33:30,242] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [id, level, param1, param2, libelle, description, codeh]
[2013-08-05 14:33:30,242] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,242] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_6]
[2013-08-05 14:33:30,248] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.PATIENT
[2013-08-05 14:33:30,248] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [centre, caisse_gestionnaire, organisme_0,
rang_gemellaire_ass, organisme_1, numero_ass, organisme_2, id_pat,
type_carte, alsace_moselle, code_regime, code_gestion, regime, rang_ass,
cle_ass, identifiant_2, identifiant_1, adresse_ass, prenom_ass,
numero_serie, beneficiaireentities, type_porteur, nom_ass,
centre_gestionnaire, datenaissance_ass]
[2013-08-05 14:33:30,248] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,248] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_f]
[2013-08-05 14:33:30,251] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.PRAT_CONFIG
[2013-08-05 14:33:30,251] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [id_pconf, cle, numfse, quittance, numero]
[2013-08-05 14:33:30,251] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,251] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_9]
[2013-08-05 14:33:30,254] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.RADIOPROP
[2013-08-05 14:33:30,254] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [typeimg, pathimg, nomexe, pathexe, id_prop, pathinit2,
pathinit1, actif, nom]
[2013-08-05 14:33:30,254] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,254] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_6c]
[2013-08-05 14:33:30,256] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.REFERENZ
[2013-08-05 14:33:30,256] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [lib, nomreference, id_ref, commentaire]
[2013-08-05 14:33:30,256] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,256] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_3]
[2013-08-05 14:33:30,259] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000261: Table found: CWFSE_P.PUBLIC.STATIQVALUE
[2013-08-05 14:33:30,259] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000037: Columns: [valeur, id_stval, constante, commentaire]
[2013-08-05 14:33:30,259] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000108: Foreign keys: []
[2013-08-05 14:33:30,259] INFO org.hibernate.tool.hbm2ddl.TableMetadata -
HHH000126: Indexes: [primary_key_c]
[2013-08-05 14:33:30,260] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate -
HHH000232: Schema update complete
[2013-08-05 14:33:30,315] FATAL com.cwfse.tool.ExecuteSql - sql excep
org.h2.jdbc.JdbcSQLException: Collation cannot be changed because there is
a data table: "PUBLIC.PATIENT"; SQL statement:
SET COLLATION FRENCH STRENGTH PRIMARY [90089-173]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)
at org.h2.message.DbException.get(DbException.java:171)
at org.h2.message.DbException.get(DbException.java:148)
at org.h2.command.dml.Set.update(Set.java:114)
at org.h2.command.dml.RunScriptCommand.execute(RunScriptCommand.java:79)
at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:58)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:235)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
at com.cwfse.tool.ExecuteSql.<init>(ExecuteSql.java:21)
at com.cwfse.main.Cmain.main(Cmain.java:140)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
