Is there a fixed CRDBJDBCServer.jar? SmartLink can't get table links

[Former Member]

I'm experimenting with a custom JDBC data provider, and using it with CR XI. CR is not able to smart link my tables. Debuging showed that there is a call from CRDBJDBC.jar to the JDBCDatabaseMetaData getCrossReference API. Unfortunately, it obviously has a bug (it calls that interface with wrong parameters, it should call it with catalog1,schema1,table1,catalog2,schema2,table2 but instead of table2 it passes catalog2). Databases without catalog work fine.

Anybody knows of a fix?

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

[Former Member]

There is a call from CRDBJDBCServer.jar to the JDBC API JdbcDatabaseMetaData.getCrossReference

- for the tables "tablespace.schema1.table1" and "tablespace.schema1.table2" the API is called with parameters "tablespace", "schema1", "table1", "tablespace", "tablespace", "table2" which is wrong

I use the H2 database JDBC driver. The CrystalReports CRDBJDBCServer.jar I have is from 2009-07-02 with a manifest dated 2009-06-15

[Former Member]

finally had the time to investigate on it again, sorry for the delay. I installed the latest updates. The problem still exists.

[former_member11696]

CR XI is past it's end of life, If after applying all of the latest patches from our download site it doesn't fix the issue then upgrade to XI R2 for free and test again.

Go to this link: http://www.sdn.sap.com/irj/boc and download the trial version of CR XI R2 and use your XI keycode, then apply the patches which you can get to by clicking on the BusinessObjects tab above, then Downloads.

Direct link to the Trial version: http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

Thank you

Don

[Former Member]

Sorry, I mistyped the version. I'm using CR 2008, version 12.1.0.892.

[former_member11696]

Hello, Download Service Pack 2 and test again. If it still fails then need more info on which JDBC driver you are using and the name?

Thank you

Don