Servoy Forum

Good morning from the sunny and warm Canary Islands.

I have a problem with a solution that is accesing data thru Relativity.

It is table view a form that, after a number of rows, no information is shown. I´ve been digging on this and I guess that the problem is because the error I see in the server log.

The code I´m using to load data in the forms foundset is:

Code: Select all


function onShow(firstShow, event) {

   fvFormTitle = 'Rutero';


   var _SQL = 'SELECT RutNumdia, RutNumord, RutNumsem, RutNumven FROM mrutas WHERE rutnumven=?';

   forms.lstClientesRutero.foundset.loadRecords(_SQL, [globals.currentUsuarioID])
   forms.lstClientesRutero.foundset.sort('rutnumsem asc, rutnumdia asc, rutnumord asc')

}



and the error I get in the server log:







I do not know if it might help but this is the table structure:




This occurs only in webclient, in smartclient work fine

Can anyone help me on this?

Thanks in advance

Hi Manolo,

What version of Relativity are you using? I found a bug fix on that error on an old Relativity version 3.23. It is very strange that runs fine under Smartclient but not under Webclient. Are you trying the same sql in both?

Have you tried another SQL tool to test that sql? It seems to be related to data present in Cobol files as you mention that Servoy shows some data and stop at a certain place.

Regards,

Thanks Juan Manuel for reply

Responding to your questions

I am using the same sql both smart client and web client

In the eclipse sql explorer in prespective works well

To view the version I got an ls unix, and I get this

[root @ management relativity-ds] # ls-l

Total 20

-rwxrwxrwx 1 root root 81 February 17, 2011 make_rst

drwxrwxrwx 4 root root 12288 October 26 9:31 RelRM12.05

-rwxrwxrwx 1 root root 66 February 17, 2011 RUNACTIVE

[root @ management relativity-ds] # pwd

/ opt / relativity-ds

[root @ management relativity-ds] #

I do not know if the directory 'RelRM12.05' is the version.

Hi Manolo,

It´s very strange that works fine on Smart and not on Web, if the data is the problem. I have sent a newest JDBC Relativity Driver to Juan Antonio today. Please let me know the results and if the problem persists you will need to open a case with LiveRMC or Servoy Spain in order to study the problem with Relativity.

Regards,

Thanks Juan Manuel.

I proved the new Jdbc Relativity Driver, but does not work.

I will talk with LiveRMC or Servoy Spain to solve the problem