Thank you for your answer Florian. Contribution? Why not!! Could you explain me what are the tricks about reverse-db and the improvements in reverse-db2? In reverse-db2, what are the tasks to finish it? Could you easely modify reverse-db to adapt it with MSSQL? Where are the sources of these tools?
Thank you Sylvain -----Message d'origine----- De: Florian Bruckner [mailto:bfl@;florianbruckner.com] Date: dimanche, 10. novembre 2002 12:44 �: OJB Users List Objet: AW: [FAQ] reversedb howto Hi Sylvain, reversedb was developed and tested with Informix IDS 9, Oracle 8.1.7 and DB2. Because those databases behave so differently I had to use some tricks which I thought were clever, but are a cause of major problems with other databases (MySql, MSSQL, etc.). Therefore I decided to try a second attempt with a different approach with portability in mind, the result is reverse-db2, but it simply isn't finished yet. I currently do not have the time to drive development of reverse-db2 and there are more important goals to achieve for OJB than writing a reverse-engineering tool, so other commiters are busy with other tasks. If you see the need for improvement in this area you are more than welcome to contribute, any help is appreciated. regards, Florian > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:Sylvain.Thevoz@;swisscom.com] > Gesendet: Freitag, 08. November 2002 17:00 > An: [EMAIL PROTECTED] > Betreff: RE: [FAQ] reversedb howto > > > The tool reverse-db2 works fine! It has found all tables and fields! > > But we can't generate repository with this tool??!? > > Sylvain > > -----Message d'origine----- > De: Th�voz Sylvain, IT-DCS-CPS-CLI-DAR > Date: vendredi, 8. novembre 2002 16:42 > �: [EMAIL PROTECTED] > Objet: RE: [FAQ] reversedb howto > > > I have traced what's happen in database and when I perform a > "Read" the following stuffs are executed in the database (MS SQL > Server 2000): > > use % > use % > exec sp_pkeys @table_qualifier = null, @table_owner = null, > @table_name = null > > and nothing else! > > Anyone could help me to debug this problem? > Thank you > Sylvain > > -----Message d'origine----- > De: Th�voz Sylvain, IT-DCS-CPS-CLI-DAR > Date: vendredi, 8. novembre 2002 14:50 > �: [EMAIL PROTECTED] > Objet: RE: [FAQ] reversedb howto > > > Thank you Thomas, I have found it. > > I can connect the database and make a "Read" but the tool > produces only a root element called "DBMeta" (on the left) and I > can't expend it. On the right there are some information about > the database like Database Product Name, etc... > > What is the problem?? > Should I add something in my database or another place? > > Thank you > Sylvain > > -----Message d'origine----- > De: Mahler Thomas [mailto:thomas.mahler@;itellium.com] > Date: vendredi, 8. novembre 2002 14:31 > �: 'OJB Users List' > Objet: [FAQ] reversedb howto > > > Hi again Sylvain, > > It's answerered here: > http://archives.apache.org/eyebrowse/ReadMsg?listName=ojb-user@;jak > arta.apach > e.org&msgId=511095 > > cheers, > Thomas > > > -----Urspr�ngliche Nachricht----- > > Von: [EMAIL PROTECTED] [mailto:Sylvain.Thevoz@;swisscom.com] > > Gesendet: Freitag, 8. November 2002 14:23 > > An: [EMAIL PROTECTED] > > Betreff: RE: OJB Scheme Generator: connect to database > > > > > > OK, now the connection works and I can make a "Read"!! > > > > But now how do you use this OJB Scheme Generator tool?? > > > > Thank you > > Sylvain > > > > > > -----Message d'origine----- > > De: Thomas Mahler [mailto:thma@;apache.org] > > Date: jeudi, 7. novembre 2002 19:07 > > �: OJB Users List > > Objet: Re: OJB Scheme Generator: connect to database > > > > > > Not all jdbc drivers support all features needed by the > > reversedb tool. > > Try to use a different driver, e.g. Jnetdirect or Opta2000. > > > > cheers, > > Thomas > > > > [EMAIL PROTECTED] wrote: > > > Thank you, I think the connection works but when I press in > > the "Read" button there is an error: > > > > > > [reversedb] java.sql.SQLException: [Microsoft] [SQL Server > > 2000 Driver for JDBC]Specified parameter values not supported > > for method: getColumnPrivileges > > > > > > Any idea? > > > Thank you > > > Sylvain > > > > > > -----Message d'origine----- > > > De: Mahler Thomas [mailto:thomas.mahler@;itellium.com] > > > Date: jeudi, 7. novembre 2002 15:15 > > > �: 'OJB Users List' > > > Objet: AW: OJB Scheme Generator: connect to database > > > > > > > > > For the OJB demo database it is: > > > driver: "org.hsqldb.jdbcDriver" > > > url: "jdbc:hsqldb:OJB" > > > user: "sa" > > > passwd: "" > > > > > > > > >>-----Urspr�ngliche Nachricht----- > > >>Von: [EMAIL PROTECTED] > > [mailto:Sylvain.Thevoz@;swisscom.com] > > >>Gesendet: Donnerstag, 7. November 2002 14:56 > > >>An: [EMAIL PROTECTED] > > >>Betreff: OJB Scheme Generator: connect to database > > >> > > >> > > >>Hello, > > >> > > >>I want to use the OJB Scheme Generator to generate java > > >>classes and mapping from an existing database. > > >> > > >>But I have a problem to connect to the database. > > >>I'm not sure with the connection URL. > > >>They are: > > >>JDBC Driver Class > > >>JDBC URL > > >>Username > > >>Password > > >> > > >>Has someone an example of these connection info?? > > >> > > >>Thank you > > >>Sylvain > > >> > > >>-- > > >>To unsubscribe, e-mail: > > >><mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > >>For additional commands, e-mail: > > >><mailto:ojb-user-help@;jakarta.apache.org> > > >> > > >> > > > > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > > For additional commands, e-mail: > > <mailto:ojb-user-help@;jakarta.apache.org> > > > > > > > > > -- > > > To unsubscribe, e-mail: > > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > > For additional commands, e-mail: > > <mailto:ojb-user-help@;jakarta.apache.org> > > > > > > > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > For additional commands, e-mail: > > <mailto:ojb-user-help@;jakarta.apache.org> > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > > For additional commands, e-mail: > > <mailto:ojb-user-help@;jakarta.apache.org> > > > > > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
