Hi Sebastian.

Please use the "schema" property of the @PersistenceCapable annotation as 
detailed in [1].

[1] 
https://isis.apache.org/guides/rg.html#_rg_annotations_manpage-PersistenceCapable



> El 7/7/2015, a las 1:20, Sebastian Sobiech <[email protected]> 
> escribió:
> 
> 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
> 
> 

Reply via email to