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)
