[
https://issues.apache.org/jira/browse/ISIS-789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481468#comment-14481468
]
ASF subversion and git services commented on ISIS-789:
------------------------------------------------------
Commit 99ab05f5d54b71e3c5f10345d44b512a11f3ff32 in isis's branch
refs/heads/ISIS-789 from [~danhaywood]
[ https://git-wip-us.apache.org/repos/asf?p=isis.git;h=99ab05f ]
ISIS-789: disable datanucleus.schema.validateAll (rather than just *Tables and
*Columns)...
... because otherwise DN4 (unlike DN3) attempts to validate the non-existing
view that is created for view models (eg Estatio's InvoiceSummaryForInvoiceRun
that is annotated with a @PersistenceCapable(identityType =
IdentityType.NONDURABLE, ... extensions = { @Extension(vendorName =
"datanucleus", key = "view-definition", ... }
where DN4 was throwng an exception about missing columns, stack trace showing
that view validation was being performed.
in full that annotation is:
@javax.jdo.annotations.PersistenceCapable(
identityType = IdentityType.NONDURABLE,
table = "InvoiceSummaryForInvoiceRun",
extensions = {
@Extension(vendorName = "datanucleus", key = "view-definition",
value = "CREATE VIEW \"InvoiceSummaryForInvoiceRun\" " +
"( " +
" {this.runId}, " +
" {this.total}, " +
" {this.netAmount}, " +
" {this.vatAmount}, " +
" {this.grossAmount} " +
") AS " +
"SELECT " +
" \"Invoice\".\"runId\" , " +
" COUNT(DISTINCT(\"Invoice\".\"id\")) AS
\"total\", " +
" SUM(\"InvoiceItem\".\"netAmount\") AS
\"netAmount\", " +
" SUM(\"InvoiceItem\".\"vatAmount\") AS
\"vatAmount\", " +
" SUM(\"InvoiceItem\".\"grossAmount\") AS
\"grossAmount\" " +
"FROM \"Invoice\" " +
" INNER JOIN \"Lease\" " +
" ON \"Invoice\".\"leaseId\" =
\"Lease\".\"id\" " +
" INNER JOIN \"FixedAsset\" " +
" ON \"FixedAsset\".\"id\" =
\"Invoice\".\"fixedAssetId\" " +
" INNER JOIN \"InvoiceItem\" " +
" ON \"InvoiceItem\".\"invoiceId\" =
\"Invoice\".\"id\" " +
"WHERE " +
" NOT \"Invoice\".\"runId\" IS NULL " +
"GROUP BY " +
" \"Invoice\".\"runId\"")
})
> Upgrade to DN 4.0
> -----------------
>
> Key: ISIS-789
> URL: https://issues.apache.org/jira/browse/ISIS-789
> Project: Isis
> Issue Type: Improvement
> Components: Core: Objectstore: JDO
> Affects Versions: objectstore-jdo-1.4.1
> Reporter: Dan Haywood
> Assignee: Dan Haywood
> Priority: Minor
> Fix For: 1.9.0
>
>
> NB: DN 4.0 only supports Java 7, so this is also dependent on our moving to
> Java 7 across board (see ISIS-568).
> NB: should also check ISIS-647 (fix for
> http://www.datanucleus.org/servlet/jira/browse/NUCCORE-1103).
> - will possibly want to enable to get better perf?
> NB: also know that there's a change to the way that polymorphism works, is
> mapped differently (in Estatio).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
