BIRT jdbc url driver for postgresql

Standar

The PostgreSQL JDBC driver is located in the postgresql-8.1dev-00.jdbc3.jar file.

About this task

The following steps describe how to copy the Postgres driver.

  1. Copy thepostgresql-8.1dev-400.jdbc3.jar file on the TBSM Data Server machine from the following locations:
    • Windows: %TBSM_DATA_SERVER_HOME%\WEB-INF\lib
    • UNIX:$TBSM_DATA_SERVER_HOME/WEB-INF/lib
  2. Copy the file to a location that can be accessed by the TBSM Dashboard Server machine and the BIRT Designer machine. For example:
    • Windows: copy %TBSM_DATA_SERVER_HOME%\WEB-INF\lib\postgresql-8.1dev-400.jdbc3.jar to c:\temp.
    • UNIX: cp $TBSM_DATA_SERVER_HOME/WEB-INF/lib/postgresql-8.1dev-400.jdbc3.jar to /tmp
  3. On the TBSM Dashboard Server machine, copy the PostgreSQL JDBC driver to the Tivoli® Integrated PortalCharts directory. For example:
    • Windows: copy c:\temp\postgresql-8.1dev-400.jdbc3.jar to %TIP_HOME%\systemApps\isclite.ear\TIPChartPortlet.war\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919\drivers
    • UNIX: cp/tmp/postgresql-8.1dev-400.jdbc3.jar to $TIP_HOME/systemApps\isclite.ear/TIPChartPortlet.war/WEB-INF/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919/drivers
  4. On the TBSM Dashboard Server machine, copy the PostgreSQL JDBC driver to the Tivoli Crystal Reports directory. For example:
    • Windows: copy c:\temp\postgresql-8.1dev-400.jdbc3.jar to%TIP_HOME%\products\tcr\lib\birt-runtime-2_2_1\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919\drivers
    • UNIX: cp/tmp/postgresql-8.1dev-400.jdbc3.jar $TIP_HOME/products/tcr/lib/birt-runtime- to2_2_1/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919/drivers
  5. Restart the TBSM Dashboard Server.
  6. On the machine where the BIRT Designer tool is installed, copy the PostgreSQL JDBC driver. For example:
    • Windows: copyc:\temp\postgresql-8.1dev-400.jdbc3.jar to \<birt_designer_home>\birt-designer\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919\drivers
    • UNIX: cp /tmp/postgresql-8.1dev-400.jdbc3.jar to /<birt_designer_home>/birt-designer/plugins/org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919/drivers
  7. Restart the BIRT Designer tool.
  8. In the BIRT Designer tool, when creating a new Postgres data source, use the following parameters in the New JDBC Data Source Profile dialog:
    • Driver class = org.postgresql.Driver (8.1)
    • Database URL = jdbc:postgresql://<tbsm_data_server>:5435/radWhere <tbsm_data_server> is the TBSM Data Server hostname where the Postgres database resides.

One response »

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s