Windows 2000, Red Hat 7.3
Torque: 3.0rc2
ant: 1.5
MySQL (on Win2000)
PostgreSQL (on Linux)
=== PROBLEM ===
I am trying to create two database: MySql and PostgreSQL. My intention is to do it with Torque. PostgreSQL DB initialization went well, but it failed on MySQL.
Hi everyone,
I have data in project-schema.xml of type BIT. In sql files generated by Torque, in PostgreSQL configuration, I see that BIT is converted to boolean. And in MySQL, it is converted to BIT.
Well, Torque failed to create all tables in MySQL with BIT data type in it. I was told by my friend that MySQL doesn't have BIT datatype. but
JDBC BIT type is definetely in Troque dtd, and for PostgreSQL it did converted to boolean, so BIT data type must be supported.
Is this a common problem with Torque&MySQL?
Or this happens to many other DBs?
I just have to edit BIT part by myself?
Or is there a good alternative way to do this?
I'd appreciate your comment.
Thank you in advance.