> I am using JavaReporting Component (Crystal Reports 10) and seems
> that it does not work with JayBird. Any data access gets an error
> "com.crystaldecisions.report.web.viewer.CrystalReportViewer: String
> index out of range: XX" (XX number depends on query). I have replaced
> JayBird with Sun's JDBC-ODBC over Firebird ODBC v1.2 and all works
> fine with any error. I have tested JayBird 1.0.1,1.5.1 and 1.5.2
> today - any difference, problem is in JayBird (maybe in tomcat's
> dbcp + JayBird combo). Running on J2SDK 1.4.2_05, Tomcat 5.0.18,
> Firebird 1.5.1. Stacktrace from logs:
>
> 11.10.2004 10:38:34 [http80-Processor22] ERROR
> com.crystaldecisions.reports.reportengineinterface - Exception
> occured while processing getPage request
> java.lang.StringIndexOutOfBoundsException: String index out of range: 11
> at java.lang.String.substring(String.java:1441)
> at com.crystaldecisions.reports.queryengine.a.h.g.a(Unknown
> Source)

I do not agree with you that problem is in JayBird, it might also be in
CrystalReports. StringIndexOutOfBoundsException is a RuntimeException and
any runtime exeption means that developer wrote a buggy code - under normal
conditions they do not happen. But to be sure that it does not happen in
JayBird, please use -DFBLog4j=true and enable DEBUG level for
org.firebirdsql package in log4j.

The reason that CrystalReports works differently for JayBird and JDBC-ODBC
bridge might be the difference in capabilities of the driver.

It would be great, if you can create a reproducable test case with
CrystalReports and send it to me (either with your version CrystalReports or
with a link to download exactly that version).

Roman