Creating Domain in Jasper server 5.2 with connection to Sybase generates an error

[felded53]

I tried to create a Domain in Jasper Server 5.2 connecting through datasource (JDBC) for Sybase. And I have following Error message: "Cannot get metadata for /ERP/Data_Sources/ERP_DEV: java.sql.SQLException: JZ0SB: Parameter index out of range: 1". I tested datasourse - the connection is good. I'm able to connect to DB. Is any one have/had same issue?

[hozawa]

I don't think there's not too many Sybase users here. It may be better to create a new bug report at Tracker.

http://community.jaspersoft.com/bug-tracker

 

[Scott Andersen]

 Sybase is not SQL-92 compliant in some ways. It works well with reports developed in Jaspersoft Studio (JSS). However, when you try to connect it to the domain designer there are some methods that are not standard in the Sybase drivers when it comes to the retrieval of the schema - which is needed by the domain designer. (Incidently that is why Sybase is certified on community but not on commercial editions, since community does not have domains / adhoc.)

 

You  have a variety of options to enable your users to use the adhoc design features:

 

1. Use JSS to create a topic.  The steps to do this are covered in The JasperSoft Studio Users guide, section 5.4. 

 

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-topic-use-ad-hoc-views

 

The topic can then be used as a basis for the adhoc designer.

 

2.  Manually create your domain design using XML and upload it.  This bypasses the domain designer with it's requirement of retrieving the schema. This will take more detailed knowledge of how a domain is put together. A starting point would be to download an existing domain as an example / starting point. This should work, although I haven't actually tried this on Sybase.