My Query Reports portlet

 

+
Search Tips   |   Advanced Search

 

Overview

My Query Reports runs SQL queries submitted by the user. This portlet is used by SQL users to conveniently run SQL queries and used as a list of bookmarks for saved queries.

 

Using My Query Reports

This portlet displays a list of SQL queries the user previously defined using the portlet Edit mode. When the user clicks on a query, the portlet runs the query. The portlet then displays the results of the query in a table. The user can sort the result columns by clicking on the links in the table headers.

The user can update/create and test queries in the portlet Edit mode.

 

Test assumptions

There are no known test or usage assumptions.

 

Set up My Query Reports

 

Client requirements

This portlet supports browsers capable of rendering HTML markup. The following table provides detailed information.

 

Minimum requirements for HTML

Markup level HTML 4.01 Transitional
Java applet None
JavaScript None
<iframe> No
Style sheets Portal styles only
Software This portlet has been tested on the following browsers:
  • Internet Explorer V6.0
  • Netscape V4.72
Accessibility Yes

 

Server requirements

This portlet needs possible network access to Database for SQL queries. It also requires JDBC drivers for the SQL queries in the system classpath.

 

Deployment/Installation

For general information on installing portlets, go to the WebSphere Portal Information Center and browse to...

Administering | Administering your portal | Portal administration portlets | Installing portlets

This portlet is not supported as a remote WSRP service.

 

Configuration parameters

Ensure that you are using the MS SQL Server Drivers and not IBM's provided drivers.

  1. Get these drivers from the machine where SQL server is installed under...

    program files/sql server/2003 jdbc drivers

  2. put these three files under portalserver/shared/app
    msbase.jar
    mssqlserver.jar
    msutil.jar

  3. Restart portal.

  4. For the configuration parameters, use this driver, and a url of this format,

    com.microsoft.jdbc.sqlserver.SQLServerDriver
    jdbc:microsoft:sqlserver://test.hostname.com:1433;DatabaseName=dbname

  5. Make sure that the table name in MS SQL Server must be in all caps as in...

    select * from CUSTOMERS

Home

 

WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.

 

IBM is a trademark of the IBM Corporation in the United States, other countries, or both.