You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Heiko Braun <he...@fork.de> on 2001/06/14 16:10:40 UTC
torque -> mysql column types
hi,
i am currently working on my project schema file,
and i was wondering if torque supports the
mysql column types SET and ENUM.
i looked at the corresponding db.props file
and found an _empty_ mapping for the ARRAY type:
-- SNIP --
# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to MySQL mappings
[...]
STRUCT=
ARRAY=
--- /SNIP ---
can i just extend the db.props like
ARRAY=SET
and for the mysql ENUM type declare an additional mapping?
VARCHAR=ENUM
but this way i would have the jdbc type VARCHAR
mapped two times, once for mysql VARCHAR _and_ for mysql ENUM...
thanks,
----------------------------------------------
heiko braun, fork unstable media [development]
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: torque -> mysql column types
Posted by Jason van Zyl <jv...@apache.org>.
On 6/14/01 10:10 AM, "Heiko Braun" <he...@fork.de> wrote:
>
> hi,
> i am currently working on my project schema file,
> and i was wondering if torque supports the
> mysql column types SET and ENUM.
If they are not JDBC column types than they are
not supported. Look in the src/dtd/database.dtd
for all the supported JDBC column types.
> i looked at the corresponding db.props file
> and found an _empty_ mapping for the ARRAY type:
No one has asked to use it, and there isn't support
for that type in the peers or in village so it
probably wouldn't work in turbine, but if you
just want to generate SQL than you can probably
add what you want.
> -- SNIP --
>
> # Taken from java.sql.Types in the IBM 1.3 JDK
> # JDBC to MySQL mappings
> [...]
> STRUCT=
> ARRAY=
>
> --- /SNIP ---
>
>
> can i just extend the db.props like
>
> ARRAY=SET
>
> and for the mysql ENUM type declare an additional mapping?
>
> VARCHAR=ENUM
>
> but this way i would have the jdbc type VARCHAR
> mapped two times, once for mysql VARCHAR _and_ for mysql ENUM...
>
>
> thanks,
>
> ----------------------------------------------
> heiko braun, fork unstable media [development]
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
jvz.
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org