try the name of the database user...? or maybe % which is a wildcard for some databases...
-----Original Message----- From: Jeremy [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 6:16 PM To: OJB Users List Subject: Re: AW: reverse-db (reverse-db2) Thanks David, now I just need to find the name for a Mysql schema.... Any clues, anyone? I guess I can find the definitions for this in the jdbc class somewhere. - Again, thanks a bunch for the help...Jeremy David Mitchell wrote: > The schema name it's asking for isnt the schema name that you're generating, > it's a jdbc thing. I believe it's really the name of the user who created > the tables, so different users could have different tables with the same > name. > > Not sure what the setting is for other databases, but for SQL server it > always seems to be "dbo", regardless of who I log in as. "catalog" on the > other hand, seems to map to the name of the database. > > -dave > > > -----Original Message----- > From: Jeremy [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 2:59 PM > To: OJB Users List > Subject: 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] > > > +---------------------------------------------------------+ > This message may contain confidential and/or privileged information. If you > are not the addressee or authorized to receive this for the addressee, you > must not use, copy, disclose or take any action based on this message or any > information herein. If you have received this message in error, please > advise the sender immediately by reply e-mail and delete this message. > Thank you for your cooperation. > +---------------------------------------------------------+ > > --------------------------------------------------------------------- > 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] +---------------------------------------------------------+ This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. +---------------------------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
