XI3.1 & Postgresql 8.4 connectivity [SOLVED !]

building semantic layer
1

Hi,

I have a fresh install of XI 3.1 SP3 and I’m astonished that connectivity doesn’t not work out of the box.

I want to create a universe to Postgresql 8.4 (JDBC). When testing the new connection, BO cannot find the driver (CS: Java Class not found in classpath : org.postgresql.Driver). So I’ve added postgresql-8.4-702.jdbc3.jar to C:\Program Files\Business Objects\common\4.0\java\lib\external and added the path in CRConfig.xml. No luck. Tried with the 9.0 driver too without success.

I’ve tried the generic JDBC driver, I got “CS: Java Class not found in classpath : define java class for JDBC driver”. It seems that jdbc.sbo must be changed : I have added the ClassPath for postgresql. Not better.

I cannot find documentation on all this, only some advices in forums.

I’m wondering if I have not missed something simple… Has someone a clue on this?

KFonMurphi :fr: (BOB member since 2007-10-16)

2

Answering to myself :

  • it works with the postgresql-8.3-606.jdbc3.jar driver from the postgresql website.

  • it does NOT work with 8.4 or jdbc2 drivers!

  • the driver must be installed in :
    \BusinessObjectsEnterprise\common\4.0\java\lib\MetadataEngineTestslib
    (I dont think the exact path will matter)

  • The jdbc.sbo file must be modified :
    ( it’s in BusinessObjectsEnterprise\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc\jdbc.sbo )
    by adding the following clause in the postgresql section :

<ClassPath>
<Path>C:\BusinessObjectsEnterprise\common\4.0\java\lib\MetadataEngineTestslib\postgresql-8.3-606.jdbc3.jar</Path>
<Path>C:\BusinessObjectsEnterprise\javasdk\bin</Path>
</ClassPath>

(I suppose that the third line about javasdk is useless)

=> I could create a connection after restarting Designer.

I did not try to modify postgresql*.prm files, it works for my simple queries.

I suppose that the setup must be replicated on any computer with Designer or the Rich Client installed…

See note 1541028.

KFonMurphi :fr: (BOB member since 2007-10-16)