NEED JASPER META TABLES INFORMIX SPECIFIC

[saradhasivaraman]

HI ,

Can anyone help me to get jasper meta tables in informix specific database.

[marianol]

I assuming here that by "jasper meta tables" you are refering to the JasperServer repository database.
From the Supported platform documentation (page 3) http://community.jaspersoft.com/sites/default/files/docs/jaspersoft_platform_support_v4.7.pdf it looks like informix is not supported as a repository database. So you are on your own there.

You can try by installing form a war file and creating the repository DB manually, see Chapter 6 of the Install Guide ( http://community.jaspersoft.com/sites/default/files/docs/jasperreports-server-install-guide.pdf ) and modify the *.dll files in <js-install>/buildomatic/install_resources/ and pick one that is similar syntax and modify it  to match the informix syntax. The <js-install>/buildomatic/install_resources/sql/db2/*.dll files may be a good start, but I have very little experience with informix.

[marianol]

By the way, why don't you stick o postgres? It will be way better just to keep the repo in postgres and you will not have any problems in installing or upgrading JRS

[mgeise]

Even if you are able to do this, it is not likely that the server will operate correctly as the informix will not recognize many of the SQL statements used during the server operations. You don't need to have the repository within informix to report off of data that is stored within an informix database.