> > IMHO torque:jdbc is no good as a totally automatic way to create a > > schema.xml. It is good as a first guess, but nothing more, because the
> > informations from the jdbc driver are not complete enough to extract a > > good schema. > > If it worked for you so far, you were lucky. > > > Or maybe Torque have lots of features I don't know about. > > But what kind of features in my database could be a problem for torque:jdbc? > > I love torque, because I can just define my database in sql and then run > maven torque:jdbc to get a schema.xml file, that maps > all the tables to classes, with primary and foreign keys, and allow me > to retrieve data from the database. The problem might be that the mapping is different from what you expect. I do not have an example ready because I do not use torque:jdbc myself, but searching the mailing list should find some complaints. Thomas