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.









Komentar