Thank you for the help. I added several definitions and I think it also
fixed a problem with the autoincrement with MSSQL. I would have sent a
patch if I know how to make one. Anyway the file is very small.
Here is the new db.props file:
-------------------
# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to Sybase mappings.
BIT = BIT
TINYINT = TINYINT
SMALLINT = SMALLINT
INTEGER = INT
BIGINT =
FLOAT = FLOAT
REAL = REAL
DOUBLE =
NUMERIC = NUMERIC
DECIMAL = DECIMAL
CHAR = CHAR
VARCHAR = VARCHAR
LONGVARCHAR = TEXT
DATE = DATETIME
TIME = TIMESTAMP
TIMESTAMP = DATETIME
BINARY = BINARY
VARBINARY = IMAGE
LONGVARBINARY = IMAGE
NULL = NULL
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB =
CLOB =
REF =
AUTOINCREMENT = true
NOTNULL = NOT NULL
removeNotNullWithAutoIncrement = false
suppressDefaults = false
---------------------
-----Mensaje original-----
De: Diethelm Guallar, Gonzalo [mailto:[EMAIL PROTECTED]]
Enviado el: Thursday, August 23, 2001 11:17 AM
Para: '[EMAIL PROTECTED]'
Asunto: RE: Torque is not generating FLOAT type
[There are small variations to this answer depending on
the version of Turbine you are using.]
The mappings for each type are under
torque/templates/sql/base/<DB>/db.props [DB is mssql in your case]
I can see that for MSSQL, JDBC type FLOAT has no mapping defined.
What would be the correct type for a JDBC FLOAT in MSSQL? Stick it
in there, and try. And if you think it is the correct answer
always, submit a patch (or at least a message with the
type mapping you come up with).
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
> -----Original Message-----
> From: Humberto Hernadez Torres [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 10:02 AM
> To: [EMAIL PROTECTED]
> Subject: Torque is not generating FLOAT type
>
>
> We are generating the project-sql with torque but it is not generating
> the type column for the FLOAT types. We are using MS SQL.
>
> An example of our project-schema.xml is:
> <database>
> <table name="PROMOCION" idMethod="idbroker">
> <column name="IDE_PROMOCION" required="true" primaryKey="true"
> type="INTEGER"/>
> <column name="PRO_MARCA" size="60" type="VARCHAR"/>
> <column name="PRO_MODELO" size="60" type="VARCHAR"/>
> <column name="PRO_CANTIDAD" type="INTEGER"/>
> <column name="PRO_PRECIO" type="FLOAT"/>
> </table>
> </database>
>
> This is the resulting project-schema.sql file:
> // Some lines deleted. Notice the type in the PRO_PRECIO Column.
>
> CREATE TABLE PROMOCION
> (
> IDE_PROMOCION INT NOT NULL,
> PRO_MARCA VARCHAR (60) NULL,
> PRO_MODELO VARCHAR (60) NULL,
> PRO_CANTIDAD INT NULL,
> PRO_PRECIO NULL,
>
> CONSTRAINT PROMOCION_PK PRIMARY KEY(IDE_PROMOCION),);
>
>
>
> ---------------------------------------------------------------------
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
