Hi Jeremy, reverse-db2 is not usable yet, this is work in progress and it just does reverse engineering of the database, but even this is incomplete and generating repository.xml is not working.
Concerning your problem with reverse-db, this is a known issue with MySQL. This has been fixed in CVS, so either you can fetch the current source from CVS or wait for the next release of OJB, where these changes should be included. Reversedb is completely independent of other OJB settings, there is no need to set any properties or profiles, you just do a plain connect to the database and read the schema, then you can create java stubs and repository.xml from it. The reason you are seeing garbage in the reversedb tree is simply because it is not initialised on startup. The treemodel gets replaced once you hit the "Read Schema" button. This is nothing to worry about. HTH, Florian > -----Ursprungliche Nachricht----- > Von: Jeremy [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 07. Februar 2003 18:52 > An: [EMAIL PROTECTED] > Betreff: reverse-db (reverse-db2) > > > Hello, > I have been banging my head against how to map out a pre-existing > database. I changed the mysql.profile to my mysql db, and changed the > build.properties to use the mysql db. Really, this should be > superfluous, shouldn't it? I mean, given what documentation on the > subject of the reverse-db component, I thought that connecting to a > database was all that was necessary (using mysql:jdbc), as it would then > read in the database tables and values, then create a schema or map of > the database. When I connect to the database, I get no message as to > whether it connects or not (using the tests, though, I am able to create > the tables for them in the mysql db, and I see traffic, so I believe it > is actually connecting), and when I try 'read', I get: > > [reversedb] java.sql.SQLException: null: Can't read dir of './%/' > (Errcode: 2) > [reversedb] at com.mysql.jdbc.MysqlIO.nextRow(Unknown Source) > [reversedb] at com.mysql.jdbc.MysqlIO.getResultSet(Unknown Source) > [reversedb] 12:null: Can't read dir of './%/' (Errcode: 2) > > Also, why am I seeing in the reverse-db browse window part of the test > suite? I mean, before I connect to the db, is it reading in the > repository.xml? Do I need to create my own repository.xml or > build.xml/build.properties to define a blank db template or something > for the reverse-db component to fill in? > > As an after note, reverse-db2 seems to connect to my database, but using > the open database like this -->jdbc:mysql://localhost/testdb > shows me all the databases present, not just testdb, with unknown schema > (schema not specifies) and new ojb repository gives me that it can't > find it's OJB.properties file (uses default settings) and it can't find > it's repository.xml. So what do I put in this repository.xml, I mean, > it isn't creating a new db, I was hoping it would map a pre-existing one. > Thanks, > Jeremy Capps > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
