Hello Alexander, I have the same problem.
Florian Bruckner (the developer of this tool) told me few weeks ago: "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." Regards Sylvain -----Message d'origine----- De: Alexander Enns [mailto:[EMAIL PROTECTED]] Date: mercredi, 8. janvier 2003 11:54 �: [EMAIL PROTECTED] Objet: MSSQL and reverse-db tool Hi folks, an exception will be thrown when I'm trying to reverse my database. My configuration: Database: MSSQL 2000 JDBC Driver: INET Sprinta2000 OJB: 0.9.8 Exception: [reversedb] java.sql.SQLException: [AEN1]The database name component of the obje ct qualifier must be the name of the current database. [reversedb] at com.inet.tds.e.a(Unknown Source) [reversedb] at com.inet.tds.a.if(Unknown Source) [reversedb] at com.inet.tds.a.do(Unknown Source) [reversedb] at com.inet.tds.g.a(Unknown Source) [reversedb] at com.inet.tds.g.getTables(Unknown Source) [reversedb] at org.apache.ojb.tools.mapping.reversedb.DBMeta.read(Unknown So urce) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.anal yzeSchema(Unknown Source) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.jBut ton2ActionPerformed(Unknown Source) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.acce ss$100(Unknown Source) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame$2.ac tionPerformed(Unknown Source) [reversedb] at javax.swing.AbstractButton.fireActionPerformed(AbstractButton .java:1450) [reversedb] at javax.swing.AbstractButton$ForwardActionEvents.actionPerforme d(AbstractButton.java:1504) [reversedb] at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultBut tonModel.java:378) [reversedb] at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel. java:250) [reversedb] at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Basi cButtonListener.java:216) [reversedb] at java.awt.Component.processMouseEvent(Component.java:3715) [reversedb] at java.awt.Component.processEvent(Component.java:3544) [reversedb] at java.awt.Container.processEvent(Container.java:1164) [reversedb] at java.awt.Component.dispatchEventImpl(Component.java:2593) [reversedb] at java.awt.Container.dispatchEventImpl(Container.java:1213) [reversedb] at java.awt.Component.dispatchEvent(Component.java:2497) [reversedb] at java.awt.LightweightDispatcher.retargetMouseEvent(Container.j ava:2451) [reversedb] at java.awt.LightweightDispatcher.processMouseEvent(Container.ja va:2216) [reversedb] at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2 125) [reversedb] at java.awt.Container.dispatchEventImpl(Container.java:1200) [reversedb] at java.awt.Window.dispatchEventImpl(Window.java:914) [reversedb] at java.awt.Component.dispatchEvent(Component.java:2497) [reversedb] at java.awt.EventQueue.dispatchEvent(EventQueue.java:339) [reversedb] at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDi spatchThread.java:131) [reversedb] at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDisp atchThread.java:98) [reversedb] at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.j ava:93) [reversedb] at java.awt.EventDispatchThread.run(EventDispatchThread.java:85) This exception will be thrown in org.apache.ojb.tools.mapping.reversedb.DBMeta by getting tables from meta object. java.sql.ResultSet rs = dbMeta.getTables("%", "%", "%", null); I could reproduce this exception in my code. If I set the first parameter to null or catalogname in the function no exception will be thrown. It would be hepful to have possibility to set such parameter (catalog, schema) from outside too. Had somebody such a problem by another databases? -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
