Hi Jeremy, the schema and catalog regular expression is just for constraining reverse engineering to specific catalogs and schemas. If you do not want to restrict the resverse engineering just leave this field blank (as an empty regular expression matches any string).
The reason you have an "empty schema" is simply because MySQL doesn't know schemas. JDBC Metadata knows of catalogs and schemas. What they are mapped to depends on the database you use. MySQL puts its database name into catalog and because it doesn't have information about the owner of a table it simply leaves the schema blank. No need to worry, its just how MySQL works. If you had Oracle for example you'd have empty catalogs and see your users (i.e. table owners) as schemas. If you had Microsoft you see the database names as catalogs and the table owner as schema (and this doesn't have to be dbo, it just ususally is because most people don't care about defining different schemas within MSSQL). regards, Florian > -----Ursprungliche Nachricht----- > Von: Jeremy [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 07. Februar 2003 21:59 > An: OJB Users List > Betreff: Re: AW: reverse-db (reverse-db2) > > > Florian, > Thanks for the info, extremely helpful. One more thing that maybe > you could explain a little, now with the CVS version it is asking me for > catalogue regular expression, followed by schema regular expression. I > grok that the catalogue regular expression it is looking for is the > database name, but the schema regular expression escapes me as no schema > is generated yet (that's what this tool does, right? generate schema > from existing data?) so it comes up with an empty schema when I specify > something like a table name or (.*?). Is there anything else I need to > tell it about the schema somewhere? > Thanks, > Jeremy > > Florian Bruckner wrote: > > 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] > > > > > > --------------------------------------------------------------------- > 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]
