2 Replies Latest reply: Feb 4, 2009 8:34 PM by Sean Wu RSS

    Failed to add metatmatrix as a datasource in Jasper iReport

    Sean Wu Newbie

      Hi all,

      I tried to add metamatrix as a datasource in iReport but failed.
      I tried the same configuration in a plain java code and it worked!
      The enviroment is:
      Jasper Server 3.1, iReport 3.1, Metamatrix 5.5.sp2
      The exception is :
      --------------------------------------------------------------------
      > Exception
      >
      > Message:
      > com.metamatrix.jdbc.MMSQLException: Error establishing socket to host
      > and port: 192.168.27.88:31000 <http://192.168.27.88:31000>. Reason:
      > invalid type code: 30
      > Level:
      > SEVERE
      > Stack Trace:
      > Error establishing socket to host and port: 192.168.27.88:31000
      > <http://192.168.27.88:31000>. Reason: invalid type code: 30
      > com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
      > com.metamatrix.jdbc.MMDriver.connect(MMDriver.java:127)
      > com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:113)
      > com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:420)
      > com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:316)
      > com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:25)
      > com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:271)
      > javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      > javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      > javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      > javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      > javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      > java.awt.Component.processMouseEvent(Component.java:6134)
      > javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
      ------------------------------------------------------------------------