postgresql is case sensitive
1.- do everything in the petclinic-extended until, finished the changes made in
step5
2.- Install postgreSQL and create the scheme "petclinic"
3.- Run the schema tool (eclipse), it shows:
mar 09, 2016 1:27:01 PM org.datanucleus.metadata.MetaDataManager loadClasses
GRAVE: �La clase domainapp.dom.modules.petclinic.QPet is not in the
CLASSPATH!. Por favor compruebe la especificaci�n y el CLASSPATH.
org.datanucleus.exceptions.ClassNotResolvedException: �La clase
domainapp.dom.modules.petclinic.QPet no esta en el CLASSPATH!. Por favor
compruebe la especificaci�n y el CLASSPATH.
mar 09, 2016 1:27:01 PM org.datanucleus.store.schema.SchemaTool main
INFORMACIÓN: SchemaTool ha terminado con exito
SchemaTool ha terminado con exito
4.- after that i run the petclinic as Mavel Build... with goals "clean install"
they show me this:
Caused by: org.hsqldb.HsqlException: nombre de esquema incorrecto: PETCLINIC
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getSchemaHsqlName(Unknown Source)
at org.hsqldb.Session.getSchemaHsqlName(Unknown Source)
at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
at org.hsqldb.StatementSchema.getResult(Unknown Source)
at org.hsqldb.StatementSchema.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 27 more
13:33:32,608 [Schema Thread-0 DEBUG] Hay un error en la
creaci�n de los elementos del esquema - restaurando
13:33:32,608 [Schema Thread-0 DEBUG] Rolling back transaccion
del esquema
"org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@273977c1"
13:33:32,608 [Schema Thread-0 DEBUG] Cerrando la conneccion
de la transaccion del esquema
"org.datanucleus.store.rdbms.datasource.dbcp.PoolingDataSource$PoolGuardConnectionWrapper@273977c1"
Una excepcion estaba tirada durante la addicion/validacion de algunas class(es)
: nombre de esquema incorrecto: PETCLINIC in statement [CREATE TABLE
petclinic."Pet"
(
"id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
"name" NVARCHAR(40) NOT NULL,
"version" BIGINT NOT NULL,
CONSTRAINT "Pet_PK" PRIMARY KEY ("id")
)]
java.sql.SQLException: nombre de esquema incorrecto: PETCLINIC in statement
[CREATE TABLE petclinic."Pet"
(
"id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
"name" NVARCHAR(40) NOT NULL,
"version" BIGINT NOT NULL,
CONSTRAINT "Pet_PK" PRIMARY KEY ("id")
)]
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
at
org.datanucleus.store.rdbms.datasource.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.datanucleus.store.rdbms.datasource.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at
org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:760)
at
org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:711)
at
org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:425)
at
org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:488)
at
org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380)
at
org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190)
at
org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841)
at
org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
at
org.datanucleus.store.rdbms.RDBMSStoreManager.createSchema(RDBMSStoreManager.java:4051)
at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.createSchema(DataNucleusApplicationComponents.java:127)
at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.init(DataNucleusApplicationComponents.java:111)
at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.<init>(DataNucleusApplicationComponents.java:97)
at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusPersistenceMechanismInstaller.createDataNucleusApplicationComponentsIfRequired(DataNucleusPersistenceMechanismInstaller.java:112)
at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusPersistenceMechanismInstaller.createObjectStore(DataNucleusPersistenceMechanismInstaller.java:89)
at
org.apache.isis.core.runtime.system.persistence.PersistenceSessionFactory.createPersistenceSession(PersistenceSessionFactory.java:94)
at
org.apache.isis.core.runtime.system.session.IsisSessionFactoryDefault.openSession(IsisSessionFactoryDefault.java:217)
at
org.apache.isis.core.runtime.system.context.IsisContextStatic.openSessionInstance(IsisContextStatic.java:70)
at
org.apache.isis.core.runtime.system.context.IsisContext.openSession(IsisContext.java:275)
at
org.apache.isis.core.runtime.system.IsisSystemFixturesHookAbstract.shutdownServices(IsisSystemFixturesHookAbstract.java:183)
at
org.apache.isis.core.runtime.system.IsisSystemFixturesHookAbstract.shutdown(IsisSystemFixturesHookAbstract.java:172)
at
org.apache.isis.core.integtestsupport.IsisSystemForTest.shutdown(IsisSystemForTest.java:429)
at
org.apache.isis.core.integtestsupport.IsisSystemForTest.access$100(IsisSystemForTest.java:67)
at
org.apache.isis.core.integtestsupport.IsisSystemForTest$Builder$1.run(IsisSystemForTest.java:265)
Caused by: org.hsqldb.HsqlException: nombre de esquema incorrecto: PETCLINIC
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getSchemaHsqlName(Unknown Source)
at org.hsqldb.Session.getSchemaHsqlName(Unknown Source)
at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
at org.hsqldb.StatementSchema.getResult(Unknown Source)
at org.hsqldb.StatementSchema.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 27 more
org.datanucleus.exceptions.NucleusDataStoreException: Una excepcion estaba
tirada durante la addicion/validacion de algunas class(es) : nombre de esquema
incorrecto: PETCLINIC in statement [CREATE TABLE petclinic."Pet"
(
"id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
"name" NVARCHAR(40) NOT NULL,
"version" BIGINT NOT NULL,
CONSTRAINT "Pet_PK" PRIMARY KEY ("id")
)]
________________________________
De: Dan Haywood <[email protected]>
Enviado: miércoles, 9 de marzo de 2016 01:15 p. m.
Para: Angel Manuel Barrera Lugo
Cc: users
Asunto: Re: Problem in petclinic tutorial // schema name incorrect
I'm trying to remember, is postgresql case sensitive?
There's some code in Isis that applies some heuristics for this; is also
puddings to use the raw underlying datanucleus properties to influence things.
Could you spell out exactly what you did to create the error so I can try to
replicate?
Thx, Dan
On 9 Mar 2016 19:08, "Angel Manuel Barrera Lugo"
<[email protected]<mailto:[email protected]>> wrote:
Well finally i have the schema (postgresSQL) and everything but still have this
error:
Caused by: org.hsqldb.HsqlException: nombre de esquema incorrecto: PETCLINIC
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getSchemaHsqlName(Unknown Source)
at org.hsqldb.Session.getSchemaHsqlName(Unknown Source)
at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
at org.hsqldb.StatementSchema.getResult(Unknown Source)
at org.hsqldb.StatementSchema.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 64 more
Caused by: java.sql.SQLException: nombre de esquema incorrecto: PETCLINIC in
statement [CREATE TABLE petclinic."Pet"
(
"id" BIGINT GENERATED BY DEFAULT AS IDENTITY,
"name" NVARCHAR(40) NOT NULL,
"version" BIGINT NOT NULL,
CONSTRAINT "Pet_PK" PRIMARY KEY ("id")
)]
