(Resending as there seem to be some problem with the thread view in the
Nabble site http://www.nabble.com/Fornax-Platform-f17564.html)
Hi All,
I am using sculptor 1.6 and am facing some issues with the DDL
Generation.
I am using the "inverse" relation between two entities. My database type
is defined via db.product=oracle.
Now, here is the problem. In the generated ddl for oracle, I am getting
the resultant ddl as
CREATE TABLE PERSON (
ID NUMBER(20) NOT NULL,
ENTITYID VARCHAR2(100) NOT NULL,
FIRSTNAME VARCHAR2(100),
CONTACT_INDEX INTEGER(10),
CLIENT NUMBER(20)
);
Running this in SQL in Oracle ( specifically the CONTACT_INDEX
INTEGER(10) part ) leads to problem, as the integer field shouldn't have
a length attribute, for oracle.
Is there a way to overcome this problem?
I have given the following values in the sculptor-generator.properties
db.oracle.type.PositiveInteger=NUMBER
db.oracle.type.Integer=NUMBER
db.oracle.type.Number=NUMBER
db.oracle.length.Integer=10
db.oracle.type.int=NUMBER
db.oracle.type.BigInteger=NUMBER
db.oracle.type.discriminatorType.INTEGER=NUMBER
db.oracle.length.discriminatorType.INTEGER=5
Regards,
Abhilash John
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Fornax-developer mailing list
Fornax-developer@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fornax-developer