<= Previous | Next => | Table of Contents | DataVision User's Manual |
To create a new report, either start DataVision without specifying a report XML file or select
from the menu.When you first create a new report, a dialog box will appear asking you how to connect to the database. Either copy this information from an existing report (everything but the password, which is not stored with a report) or specify the information directly. In either case, you will be asked to supply a database password each time you open a report.
To copy the database connection information, click the
button. An "Open File" dialog box will let you choose a report XML file from which the settings will be copied.There are five pieces of information you need to supply: the JDBC driver class name, the connection info string, the database name, your database user name, and your database password. When saving a report, all but the password are stored in the report XML file.
JDBC driver class name You should be able to find the JDBC driver class name from your database driver documentation. There are examples for some databases below.
Connection info string You should be able to find the JDBC connection info string from your database driver documentation. It will probably contain either the name of the database schema or the "sid". Sometimes it is the same as the database name. As an example, to connect to my PostgreSQL database named "jobs" I use the driver class name org.postgresql.Driver and the connection info string "jdbc:postgresql:jobs" (without the quotes).
Database name Sometimes called the schema name, the database name refers to a set of database tables. (This isn't the name "Oracle" or "PostgreSQL".) When DataVision asks the database for the list of table names, it uses the database name to specify which tables to return.
Database user name This is the user name you use to connect to the database. It is not necessarily the same as your computer login name.
Database password You must enter the database password each time you open a report.
The document PostgreSQL JDBC Documentation describes the format of the connection string.
If left out, host defaults to localhost (not 127.0.0.1) and port to PostgreSQL's default port number (normally 5432, but configurable at build time).
If you use either the mm.mysql-2.0.X-bin.jar or mysql_comp.jar drivers, the driver class name should be "org.gjt.mm.mysql.Driver".
The format of the connection string must be "jdbc:mysql://host/database". The host name is not optional. If the MySQL database is on the same machine as DataVision, use the host name "localhost".
One user reported trouble with the MySQL JDBC drivers until he switched to version 2.0.11. The latest version of the MySQL JDBC driver is available on its SourceForge project page.
Try the driver class name "oracle.jdbc.driver.OracleDriver".
The connection info string will depend upon the type of JDBC driver you are using. For the thin driver, try "jdbc:oracle:thin:@host:1521:sid". host can be "localhost" or "127.0.0.1" if the Oracle database is running on the same computer. 1521 is the default port number; that will only be different if the Oracle database was configured to use a different one. The "sid" is a string that identifies where to find the database. It is not necessarily the same as the database name.
The vanilla JDBC-ODBC bridge should work just fine.
From a post on the Usenet news group comp.lang.java.databases:
The Sun driver list contains all the SQLServer JDBC drivers. You might want to have a look at the Merant DataDirect JDBC drivers. Free eval type 3 and 4 drivers are available at www.merant.com/datadirect.
I have read that Microsoft is developing a type-4 JDBC driver. It is in beta now (February 2002), and is available for download from their SQL Server pages.
One user reports that his Informix JDBC driver does not implement the optional driver features upon which DataVision currently relies. He is using the latest version, but I don't know where he found the driver.
Another user reports success with a jar file named ifxjdbc.jar. This jar file is available from www.informix.com/evaluate, though you must be registered.
This section is no longer valid. It has been kept for historical interest only. DataVision no longer uses any of the newer JDBC commands. These error messages should not appear.
Unfortunately, some drivers do not support the optional driver features upon which DataVision currently relies. Eventually, I hope that DataVision can stop relying upon these features, but I'm not sure.
If you see an error message something like this when running DataVision from the command line (the line numbers wil probably be different):
Exception occurred during event dispatching: java.lang.AbstractMethodError at jimm.datavision.Report.run(Report.java:763) at jimm.datavision.gui.ReportRunner.run(ReportRunner.java:37) at jimm.datavision.gui.DesignWin.runReport(DesignWin.java:709) at jimm.datavision.gui.DesignWin.actionPerformed(DesignWin.java:618)
then your driver does not support one of the new driver calls used by DataVision. Try to upgrade to a newer version of your driver. For example, one user saw this message until he upgraded to version from MM.MySQL 2.0.4 to 2.0.11.
To add database fields to a report, select
from the menu. The Field Picker window will open. Notice that the first item in the window is "Database Fields" and the last item is "All Database Fields". In a newly created report, the first "Database Fields" item will be empty, because it displays database columns that are already in the report.Double-click "All Database Fields". A list of all of the database's tables will appear. Double-click on a table to reveal the columns within that table.
Drag a column name from the Field Picker window into the report. As an added bonus, when you drag a database column into a "Detail" section, the name of the column will automagically appear in the "Page Header" section.
To add text to a report, select
from the menu. The cursor will change to a text cursor. Click anywhere on the report, and a new empty text field will appear. Start typing the text.To finish entering text, click anywhere outside of the text field.
<= Previous | Next => | Table of Contents |
|