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(Row.java:1101)

at com.itko.lisa.vse.jdbc.driver.RSMetaData$ColumnMetaData.<init>(RSMetaData.java:718)

at com.itko.lisa.vse.jdbc.driver.RSMetaData.<init>(RSMetaData.java:65)

at com.itko.lisa.vse.jdbc.driver.PreparedStatement.<init>(PreparedStatement.java:143)

at com.itko.lisa.vse.jdbc.driver.Connection.prepareStatement(Connection.java:376)

at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:396)

at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:346)

at com.itko.lisa.jdbc.JDBCNodeEditor.doExec(JDBCNodeEditor.java:479)

at com.itko.lisa.jdbc.JDBCNodeEditor.access$500(JDBCNodeEditor.java:55)

at com.itko.lisa.jdbc.JDBCNodeEditor$6.doCallback(JDBCNodeEditor.java:414)

at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:248)

at java.lang.Thread.run(Unknown Source)

 

Steps

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://10.226.124.41:1433/databaseName=Account/sa

-> Following configuration in JDBC step

  • JDBC Driver     com.itko.lisa.vse.jdbc.driver.Driver
  • URL jdbc:lisasim:driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;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

Outcomes