Mailing-List: contact users-help@isis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@isis.apache.org
Received-SPF: pass (nike.apache.org: domain of dharmesh.chohan@atos.net
 designates 160.92.103.80 as permitted sender)
From: "Chohan, Dharmesh" <dharmesh.chohan@atos.net>
To: "users@isis.apache.org" <users@isis.apache.org>
Subject: RE: Domain create table issue
Thread-Topic: Domain create table issue
Thread-Index: Ac8iY2k106cuYSDJQLaPtjjB9mTANAAApBKAAAN60YA=
Date: Wed, 5 Feb 2014 13:47:59 +0000
Message-ID: 
 <24796235A2F23E4DABCBF8D28DD0B6120150B87C@DEERLM99EX1MSX.ww931.my-it-solutions.net>
References: 
 <24796235A2F23E4DABCBF8D28DD0B6120150B7FE@DEERLM99EX1MSX.ww931.my-it-solutions.net>
 <CALJOYLG4ZhgKi2j2CSQCSsScKcdxdG3moL2trcuTL07YSqffBA@mail.gmail.com>
In-Reply-To: 
 <CALJOYLG4ZhgKi2j2CSQCSsScKcdxdG3moL2trcuTL07YSqffBA@mail.gmail.com>
Accept-Language: en-GB, en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi Dan

I could not see the CREATE TABLE for the domain in the logging.

The application works fine, the error was produced when installing the fixt=
ure from wicket viewer Prototyping->Install fixtures.  The error was caused=
 by calling the isisJdoSupport.executeUpdate("delete from  \"TopUpAmount\""=
)

I have removed the line isisJdoSupport.executeUpdate("delete from  \"TopUpA=
mount\"") and now it does not throw the error.  It seems the table is creat=
ed on first use of the domain.

Regards
Dharmesh

-----Original Message-----
From: Dan Haywood [mailto:dan@haywood-associates.co.uk]=20
Sent: Wednesday, February 05, 2014 12:33 PM
To: users
Subject: Re: Domain create table issue

On 5 February 2014 11:14, Chohan, Dharmesh <dharmesh.chohan@atos.net> wrote=
:

> Hi
>
> I have added a new domain as below and when I check the output it does=20
> not create the table for that domain.  The problem comes when=20
> installing the fixture and running the command=20
> isisJdoSupport.executeUpdate("delete from
> \"TopUpAmount\"")
>

I don't quite follow this.

Do you see the 'CREATE TABLE' statement in the logging?  If so, then we kno=
w that the JDO/DN annotations are correct.


To confirm, if you comment out the fixture setup, does Isis boot up ok?

If it does, then check the output; I'm guessing that there might be an issu=
e with the table name; that could be dependent on the JDBC driver you are d=
ependent on.  Postgres requires the double quotes to be escaped, others sup=
port [square brackets] etc.


>
> [snip]
> @ObjectType("TopUp Amount")
> @Bookmarkable
> public class TopUpAmount implements Comparable<TopUpAmount> { .... }
>
>
>
~~~
Also, not sure if it's your issue, but there shouldn't be a space in the @O=
bjectType value.  That gets used internally to create the OID of the object=
, and could be causing a problem later on

Let us know

Dan


> For all other domains ISIS creates a table for them.
>
>
> Any ideas.
>
> Thanks
> Dharmesh
>
>
>
>
>