Problems testing connections

[2002 JI Open Discussion]

By: Mark Rhodes - mrhodes2

Problems testing connections

2003-04-11 16:19

Using iReport-0.0.9

using MSSQL JDBC drivers

 

I get the following error(s) when trying to test my connection.

 

java.lang.ArrayIndexOutOfBoundsException: 0 >= 0

at com/businesslogic/ireport/ui/DBConnectionForm.buttonTest_click

at com/ms/wfc/core/EventHandler.invoke

at com/ms/wfc/core/Component.fireEvent

at com/ms/wfc/ui/Control.onClick

at com/ms/wfc/ui/Button.onClick

at com/ms/wfc/ui/Button.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.SendMessage

at com/ms/wfc/ui/Control.sendMessage

at com/ms/wfc/ui/Control.reflectMessage

at com/ms/wfc/ui/Control.wmCommand

at com/ms/wfc/ui/Control.wndProc

at com/ms/wfc/ui/Form.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.CallWindowProc

at com/ms/wfc/app/Window.defWndProc

at com/ms/wfc/ui/Control$ControlWindow.defWndProc

at com/ms/wfc/ui/Control.defWndProc

at com/ms/wfc/ui/Control.wmMouseUp

at com/ms/wfc/ui/Control.wndProc

at com/ms/wfc/ui/Button.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.DispatchMessage

at com/ms/wfc/app/Application$ThreadContext.runMessageLoop

at com/ms/wfc/app/Application.runDialog

at com/ms/wfc/ui/Form.showDialog

at com/ms/wfc/ui/Form.showDialog

at com/businesslogic/ireport/ui/DBConnectionsForm.buttonModF_click

at com/ms/wfc/core/EventHandler.invoke

at com/ms/wfc/core/Component.fireEvent

at com/ms/wfc/ui/Control.onClick

at com/ms/wfc/ui/Button.onClick

at com/ms/wfc/ui/Button.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.SendMessage

at com/ms/wfc/ui/Control.sendMessage

at com/ms/wfc/ui/Control.reflectMessage

at com/ms/wfc/ui/Control.wmCommand

at com/ms/wfc/ui/Control.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.CallWindowProc

at com/ms/wfc/app/Window.defWndProc

at com/ms/wfc/ui/Control$ControlWindow.defWndProc

at com/ms/wfc/ui/Control.defWndProc

at com/ms/wfc/ui/Control.wmMouseUp

at com/ms/wfc/ui/Control.wndProc

at com/ms/wfc/ui/Button.wndProc

at com/ms/wfc/ui/Control$ControlWindow.wndProc

at com/ms/wfc/app/Window.callback

at com/ms/wfc/win32/Windows.DispatchMessage

at com/ms/wfc/app/Application$ThreadContext.runMessageLoop

at com/ms/wfc/app/Application.run

at com/businesslogic/ireport/MainForm.main

 

I also continue to have problems reading fields since version .0.0.6. When I read fields, it just goes to elaboration form and the progress bar keeps going and going. I have to use version .6 to read fields, then save, reopen in version 0.9 to complete the report.

 

The following are my database connection settings. One is for MS JDBC/ other for jTds. Niether test of reads fields. Both work fine when compiling.

 

CON0_DATABASE=

CON0_DRIVER=com.microsoft.jdbc.sqlserver.SQLServerDriver

CON0_NAME=nt4

CON0_PASSWORD=

CON0_SAVE=false

CON0_URL=jdbc:microsoft:sqlserver://[dns]:1433

CON0_USERNAME=

 

 

CON1_DATABASE=mlhq

CON1_DRIVER=net.sourceforge.jtds.jdbc.Driver

CON1_NAME=nt4-jtds

CON1_PASSWORD=

CON1_SAVE=false

CON1_URL=jdbc:jtds:sqlserver://[dns]:1433;TDS=8.0

CON1_USERNAME=mrhodes

 

where [dns] is our sql server.