I got the latest version of db.props for oracle from cvs. The problem
with the NUMERIC data type was solved (except for the problem of default
values for BigDecimal I mentioned in a previous email).
Now, there is another problem: in the latest db.props VARBINARY is
assigned as:
VARBINARY = RAW
The RAW type requires a size in oracle. So, when I try to create
application, there is a problem with Turbine's tables using VARBINARY
types without size. Either the problem is in the db.props and the
assignment should be something like:
VARBINARY = LONG RAW
or the problem is in turbine-schema.xml and it has to include the size
for the columns with VARBINARY type.
Thanks,
Gabriel
Gabriel Moreno wrote:
> Hi,
> How can I create a table with torque that has a column with datatype
> number(4) in Oracle?
> If I use DECIMAL or NUMERIC, it'll produce something like:
> CREATE TABLE mytable ( id (4) NOT NULL)
> it is not writting the datatype.
>
> If I use INTEGER, it'll produce something like:
> CREATE TABLE mytable ( id INTEGER(4) NOT NULL)
> which is invalid.
>
> I've seen that the conversions are in the file:
> conf/torque/templates/sql/base/oracle/db.props
> but I don't know what the impact of changing it is in the java code
> generated for the peers.
>
> Thanks,
>
> Gabriel
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
