The PostgreSQL JDBC driver is located in the postgresql-8.1dev-00.jdbc3.jar file.
The following steps describe how to copy the Postgres driver.
- 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
- 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
- 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
- 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
- Restart the TBSM Dashboard Server.
- 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
- Restart the BIRT Designer tool.
- 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.
Mengapa Microsoft harus memakai angka 7 sebagai nama keluaran dari versi windows tahun 2009 ini. mengapa tidak Windows Gate aja ato Windows Bill aja, seperti keluarannya yang sebelumnya seperti Windows Milenium, Windows XP, dan Windows Vista.








