SQL Server is not supported for the reverse-db tool. Wallace J Gelhar Facilities Planning & Management Computer Information Systems Intern [EMAIL PROTECTED] (715) 836-3411
-----Original Message----- From: Tony Mandatori [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 1:46 PM To: [EMAIL PROTECTED] Subject: SQLServer 2000 error using reverse-db OJB'ers I tried installing OJB and following the reverse engineering (reverse-db) approach for a sample database using the following parameters: JDBCDriverClass: com.microsoft.jdbc.sqlserver.SQLServerDriver JDBC URL: jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=SmallTestCasebase ;SelectMethod=cursor Username: sa Password: Connection is successful, but reading the database causes the following error: [reversedb] 0:[Microsoft][SQLServer 2000 Driver for JDBC]Specified parameter values not supported for method: getColumnPrivileges [reversedb] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Specified parameter values not supported for method: getColumnPrivileges [reversedb] at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) [reversedb] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) [reversedb] at com.microsoft.jdbc.base.BaseDatabaseMetaData.getPrimaryKeys(Unknown Source) [reversedb] at org.apache.ojb.tools.mapping.reversedb.DBMeta.read(DBMeta.java:279) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.analyzeSchema(J FrmMainFrame.java:181) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.jButton2ActionP erformed(JFrmMainFrame.java:380) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.access$100(JFrm MainFrame.java:120) [reversedb] at org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame$2.actionPerform ed(JFrmMainFrame.java:249) [reversedb] at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) [reversedb] at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractB utton.java:1817) [reversedb] at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.ja va:419) [reversedb] at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) [reversedb] at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonList ener.java:245) [reversedb] at java.awt.Component.processMouseEvent(Component.java:5093) [reversedb] at java.awt.Component.processEvent(Component.java:4890) [reversedb] at java.awt.Container.processEvent(Container.java:1566) [reversedb] at java.awt.Component.dispatchEventImpl(Component.java:3598) [reversedb] at java.awt.Container.dispatchEventImpl(Container.java:1623) [reversedb] at java.awt.Component.dispatchEvent(Component.java:3439) [reversedb] at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450) [reversedb] at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165) [reversedb] at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095) [reversedb] at java.awt.Container.dispatchEventImpl(Container.java:1609) [reversedb] at java.awt.Window.dispatchEventImpl(Window.java:1585) [reversedb] at java.awt.Component.dispatchEvent(Component.java:3439) [reversedb] at java.awt.EventQueue.dispatchEvent(EventQueue.java:450) [reversedb] at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThrea d.java:197) [reversedb] at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread. java:150) [reversedb] at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144) [reversedb] at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136) [reversedb] at java.awt.EventDispatchThread.run(EventDispatchThread.java:99) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
