Hi Alvin, First time i tried to build my xml schema file, i looked at documentation (the best documentation is source code!) and found that this property tells to Torque which database schema will be dumped. For example : I have an Oracle schema called XYZ that holds tables and views i need to access. So there is an Oracle user called XYZ too. Well, when using JDBC ant target, you have to set up all torque.database properties related to connection process. There you will set up URL, DB username (in our example, XYZ), DB password, etc... And, if you want to use JDBC ant target, you have to set up torque.database.schema property too. That property will tell to Torque which schema to dump. And a tip, torque.database.schema's value have to be always in upper case. Why? Because in lower case it won't work out. I think this is a kind of bug, isn't it? Coming back to our example, your torque.database.schema property's value will be XYZ (in upper case) too, due to Oracle peculiarities. Did you get it? This is a kind of axiom. We can't prove it. We have to believe (or look at source code if you are a skeptical guy). Best regards, Daniel.
--- Alvin Antony <[EMAIL PROTECTED]> wrote: > Hi Daniel, > > Thank you for the reply and it is almost clear except the value of > "torque.database.schema" > > I found the process is just doing nothing with out this property > > if you don't mind could you explain a bit more what means property > "torque.database.schema"? > > I am not sure about the value of this property from description > about this property here, > > http://jakarta.apache.org/turbine/torque/properties-reference.html > "Used by the JDBC -> XML process, and by the SQL Ant Task that will > initialize your target database with the generated SQL. This is only > used by Oracle at this time. This must be UPPERCASE! " > > > > Thanks to all you , helping me to start with torque, > > Alvin > > > > > >>> [EMAIL PROTECTED] 11/20 12:44 >>> > Hi Alvin, > I had same condition when i'd started to work with Torque. You can do > like me. Configure your > Torque dist (at build.properties) with appropriate connection strings > to your DB, not forgeting to > add torque.database.schema property and not forgeting to write schema > name in upper case. After > you did that, just run : ant -f build-torque.xml jdbc > This command will cause Torque to connect to your database, and > generate a XML schema definition > to it. If you don't need to customize that definition, just run : ant > -f build-torque.xml om and > all classes to acces your database will be generated. > I hope i was clear enough. > > Regards, > Daniel. > > > --- Alvin Antony <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > please pardon me if this is a stupid Q:-) > > > > How I can make use of the Torque, when the database and the tables > are already existing for an > > application? > > > > I can't find my self in the Torque website, on where I define that , > the database is existing > > and create the xml schema of the database schema automatically! > > > > can somebody of you help me on this ? > > > > the database is mssql! > > > > with regards and thanks > > > > Alvin > > > > > > > > > > > > > > > > Alvin Antony > > > > Entwickler > > Internet und Virtuelle Hochshule > > Universit�t M�nchen > > > > Leopoldstr .3 > > 80802 M�nchen > > Germany > > > > Office Tel + 49.89.21804005 > > + 49.89.21025979 > > Office Fax + 49.89.21025980 > > > > > > -- > > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus � Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
