BO Universe designer connecting to Postgres

building semantic layer
1

Hi all,

I have Boxi 3.1 SP5 server and Postgre-9.6 DB server, both are under Linux environment.

I had copied jdbc driver under /opt/app/Enterprise/bobje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/jdbc/jdbc.sbo file.

and fill in the path,(for postgres and generic jdbc) :

/home/xxx/postgresql-8.3-606.jdbc3.jar

when I open the Universe designer from my laptop, it always failed. Kindly please help me to solve my problem.

Thanks

ardi1103 (BOB member since 2017-08-14)

2

Any error message?

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi Nick,

here is the error snapshot.
conf1.jpg
error1.jpg

ardi1103 (BOB member since 2017-08-14)

4

Universe designer is a client tool, it wont be able to work with the JDBC driver on your Linux server. Youd have to install a JDBC driver on your laptop. The JDBC on the server would only be used when you publish reports based on the Universe you create.

ABILtd :uk: (BOB member since 2006-02-08)

5

ohh… thanks for your information :slight_smile:

ok I had put the driver in my laptop and configure the jdbc.sbo file :

C:\jdbc\postgresql-8.3-606.jdbc3.jar define java class for JDBC driver $DATASOURCE$

but I still got an error “CS: Java Class not found in classpath : define java class for JDBC driver”. Do I need to define this parameter ? define java class for JDBC driver

how I should fill the parameter?

ardi1103 (BOB member since 2017-08-14)

6

trying to put JDBC parameter and update the jdbc driver for jre7(I’m using jre7) like these :




C:\jdbc\postgresql-42.1.4.jre7.jar

org.postgresql.Driver
$DATASOURCE$

but still got following error :
CS: Java Exception : java.lang.UnsupportedClassVersionError: Bad version number in .class file

any idea?

ardi1103 (BOB member since 2017-08-14)

7

How is this related to SAP Data Services?

ErikR :new_zealand: (BOB member since 2007-01-10)

8

Hi,

Apologize if I put my question in a wrong topic.
do I need to close this and open a new subject in the “DI: Installation, Administration, and Connectivities” ?

thanks

ardi1103 (BOB member since 2017-08-14)

9

I have moved this to the correct forum.

Bob Junior :uk: (BOB member since 2005-04-23)

10

Thanks Bob

ardi1103 (BOB member since 2017-08-14)