Hi, do you know the eclipse plugin for OJB on http://www.impart.ch/download/? this plugin is based on reverse-db. You can also use it with out eclipse(Start com.impart.ojbgenerator.Main). The Source Code is also includet. In the ImpartOJBGenerator.properties you have some samples to connect to defferent DB's
regards matthias -----Ursprungliche Nachricht----- Von: Florian Bruckner [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 11. Februar 2003 13:20 An: OJB Users List Betreff: AW: reverse-db (yet again) Hi Jeremy, I've tested the reverse engineering part of reverse-db with the following database/JDBC driver combinations: - Informix IDS 9 with Informix JDBC (9.21JC2, 9.21JC3) - Oracle 8.1.7 and 9.2.0 with Oracle JDBC (9.2.0) - IBM DB2 UDB 7.2 with IBM Type 3 JDBC driver (7.02) - Mysql 3.23 with mm.mysql JDBC (2.something) - Microsoft SQL Server 2000 with Microsoft JDBC driver For these databases I know that you can capture the schema data. I haven't looked into xml and java file generation, but it is possible that there are still severe problems, this is something I will have to look at. But please bear in mind that I am doing this in my spare time and I just have very limited time currently. I just can say it again and again (this of course addresses everybody on the list): you have the sources, I am sure you know how to code java, so please, please, please help me by not just yelling "It doesn't work, fix it!" but by trying to find the source of the failure, trying to find a fix or a workaround - If we can work together this way, we can get things going much quicker. regards, Florian > OK, now that I know the new version supports MySQL and now that I know > that the schema with a MySQL DB would always be represented as empty. I > still am not getting what I expect to happen. I connect to my db > server, read the database I want to generate classes and mapping for, > then save xml. The file generated as repository.xml, is severely > lacking in things like mapping. Also, 'Generate Java' doesn't seem to > be generating anything at all. I must be missing something very > obvious. I am using MySQL 4.0.7 gamma and > mysql-connector-java-2.0.14-bin.jar (RH7.3, OJB 0.9.9, J2sdk1.4.1). I > am trying to generate the mapping and java classes for an existing db. > > Here is all I can get the reverse-db tool to accomplish: > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE descriptor-repository SYSTEM "repository.dtd"> > <descriptor-repository version="0.9.9"> > <jdbc-connection-descriptor > jcd-alias="default" > default-connection="true" > platform="XXXX" > jdbc-level="1.0" > driver="XXX" > protocol="XXX" > subprotocol="XXX" > dbalias="XXX" > username="XXX" > password="XXX"> > </jdbc-connection-descriptor> > > > </descriptor-repository> > > Sorry to bother with something that is probably obvious, but really > there is no documentation at all on this topic, and I am starting to > worry that I will have to manually generate the mappings and classes for > this big 'ol database. > > Thanks, Jeremy > > > --------------------------------------------------------------------- > 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]
