• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Torque: MySQL BIT type?

 
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
30 seconds to difuse a loaf of bread ... here, use this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic