We've had a similar issue a while ago when mixing different schemas within the same dom project. I suggest for the sake of a smooth tutorial to remove all schema directives.
Separately, the tutorial probably uses an old version of Isis and I know there have been some improvements in this field. On 9 March 2016 at 20:37, Angel Manuel Barrera Lugo < [email protected]> wrote: > 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") > )] >
