AnsweredAssumed Answered

JDBC Virtualization  - SQL Server 2008

Question asked by ektaS on May 5, 2015
Latest reply on May 6, 2015 by ArpiJakab

Hello ,


I am trying to do JDBC virtualization for backend SQL Server 2008 using Lisa 6.0. I am able to test connection successfully but I am getting error while executing SQL.


Error :

java.lang.ArrayIndexOutOfBoundsException: 31

at com.itko.lisa.vse.jdbc.driver.Row.getClassForType(

at com.itko.lisa.vse.jdbc.driver.RSMetaData$ColumnMetaData.<init>(

at com.itko.lisa.vse.jdbc.driver.RSMetaData.<init>(

at com.itko.lisa.vse.jdbc.driver.PreparedStatement.<init>(

at com.itko.lisa.vse.jdbc.driver.Connection.prepareStatement(

at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(

at com.itko.lisa.jdbc.JDBCNode.executeSQL(

at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(

at com.itko.lisa.jdbc.JDBCNodeEditor.access$500(

at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(

at com.itko.util.swing.panels.ProcessingDialog$

at Source)



Below are the steps I have followed. Please let me know if I am missing something


-> Copied lisajdbcsim.jar  into SQL server Lib folder C:\Program Files\Microsoft SQL Server\100\SDK\Lib\x86

-> Recorder Set up

  • Tranport protocol - JDBC (Driver based)
  • Driverhost - localhost, port 2999 and maxport - 2999
  • URL : jdbc:sqlserver://

-> Following configuration in JDBC step

  • JDBC Driver     com.itko.lisa.vse.jdbc.driver.Driver
  • URL;state=record;jdbcSimPort=2999;url=jdbc:sqlserver://localhost:1433;databaseName=Account;
  • Maximum rows to Fetch -1
  • User Connection Pool and Return result set - Checked
  • Query: Select * from dbo.User1