Hi Oscar,
I gave maximum permissions on the db to the user. Isis created the
'simple' schema in my local db and it's writing data there. I need to
use a different schema. I followed the pet-clinic tutorial and changed
the schema in the entity class, but isis is constantly using 'simple'
schema.
Do you happen to know what am I missing?
Best regards,
Sebastian
W dniu 2015-07-07 o 00:15, GESCONSULTOR pisze:
Hi Sebastian and welcome to the mailing list.
My team has been using Isis on PostgreSQL extensively for the last years and it
runs smoothly.
On this SNAPSHOT there are new features regarding schemes.
Seems that Isis is trying to create a table on the scheme named "Simple".
Has the user specified on the connection enough permissions for creating
schemes ? Can you manually create that scheme and run the app again, once the
scheme exists, and DataNucleus can automatically create tables on it?
HTH,
Oscar
El 6/7/2015, a las 21:10, Sebastian Sobiech <[email protected]>
escribió:
Hello,
I'm trying to see if our team can use Apache Isis for our project. Our goal is
to use it on our PostgreSQL database and run it on Jetty for development
purposes. I am in charge of investigating this framework.
I have encountered big problems with running the sampleapp from isis-master
repo. I use IntellJ IDEA 14.x with JDK 1.8.
I run it from the webapp directory with jetty:run command.
No matter if I use the HSQLDB or PostgreSQL I always receive this error:
javax.servlet.ServletException: com.google.inject.ProvisionException: Guice provision errors:<|<|1) Error in custom provider, org.datanucleus.exceptions.NucleusDataStoreException: An exception was thrown while adding/validating class(es) : invalid schema
name: SIMPLE in statement [CREATE TABLE simple."SimpleObject"|(| "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,| "name" NVARCHAR(40) NOT NULL,| "version" BIGINT NOT NULL,| CONSTRAINT "SimpleObject_PK"
PRIMARY KEY ("id")|)]|java.sql.SQLException: invalid schema name: SIMPLE in statement [CREATE TABLE simple."SimpleObject"|(| "id" BIGINT GENERATED BY DEFAULT AS IDENTITY,| "name" NVARCHAR(40) NOT NULL,|
"version" BIGINT NOT NULL,| CONSTRAINT "SimpleObject_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:246)<|?at
org.datanucleus.store.rdbms.datasource.dbcp.DelegatingStatement.execute(DelegatingStatement.java:246)<|?at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:864)<|?at
org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:815)<|?at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:531)<|?at
org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:594)<|?at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3355)<|?at
org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2871)<|?at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119)<|?at
org.datanucleus.store.rdbms.RDBMSStoreManager.createSchemaForClasses(RDBMSStoreManager.java:3838)<|?at org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.createSchema(DataNucleusApplicationComponents.java:143)<|?at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.initialize(DataNucleusApplicationComponents.java:122)<|?at
org.apache.isis.objectstore.jdo.datanucleus.DataNucleusApplicationComponents.<init>(DataNucleusApplicationComponents.java:104)<|?at
