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)
------------------------------------------------------------------------