I am trying to read and update RM/cobol files directly, but I am unsuccessful .
What am I doing wrong??
The data is stored on a IBM AIX 3.2 system with OS UNIX .
With Microsoft Access no problem. I can read and update using the ODBC/JDBC driver
from Microfocus Relativity so the server is running perfectly.
If I create a new form and I select the file I want Servoy comes with all sorts of errors.
You can see in the attachment the configuration of the data I want to use.
I am using Servoy 5.2.4.
First, your screen shows odbc:Relativity…
You shoud use jdbc:relativity://192.100.100.1:5210/zegro (assuming you have Relativity DataServer running on 192.100.100.1 at port 5210
You also need the Relativity JDBC (RelJDBC.jar) copied into the folder Drivers inside Servoy´s application_server folder.
After doing this, is you still receive errors please let me know what errors you are receiving and the version of Relativity you are running.
We have a Webinar on Relativity and Servoy tomorrow in spanish, we can do another in English if more people is interested.
Thank you for the quick reaction.
The Relativity dataserver is running on the Unix machine and is accessible by, for instance
Microsoft excel or access. Using Relativity designer I declared a table for the file AKTIE.
i am using relativity version 12.
the file is indexed and contains 2 record keys. 1 primary key and 1 alternate.
in Servoy I create a new form and select the table from the DISTRI server.
so far so good but if a execute the smart client in Servoy I get the following message:
Kan record niet laden
com.servoy.j2db.dataprocessing.DataException: [Relativity JDBC Driver][SimbaLNA][Liant][Relativity RM Server]Dynamic parameter #1 type mismatch.
Servoy 6 contains some fixes in this area, the type info as described in the other thread is passed to the driver.
It was added to add support for boolean columns in Postgres.
I expect the Relativity driver will work better with Servoy 6.
Please check your table definition into Relaltivity. For each column defined as smallint please change to integer. Then try again. If the problem persist we can arrange a meeting using gotomeeting or Skype tomorrow.
Hi Juan
Unfortunately it did not work. I still get the error :
Kan record niet laden
com.servoy.j2db.dataprocessing.DataException: [Relativity JDBC Driver][SimbaLNA][Liant][Relativity RM Server]Dynamic parameter #1 type mismatch.
I would like to arrange a meeting with you about this problem tell me how and when?
kind regards
jeroen
Please send me an email to juan@prorm.com attaching the RelJDBC.jar you are using and the error in the servoy-admin log to see the SQL with the problem.
Also if you can send me the Relativity catalog, the COBOL file and the solution, I can test it here and try to help.
I have built a short tutorial on how to use Relativity to access COBOL data files inside Servoy. It also shows how to access COBOL data from other client tools like MS Access.
