WAS v8.5 > Reference > Command-line utilities

wsdbgen command

The command supports utilization of the pureQuery feature in JPA applications.

This command has been renamed wsdbgen for Feature Pack for OSGi Applications and JPA 2.0 and later releases. The command is used in the same way as the wsdb2gen command. The command, wsdb2gen, which implies for DB2 only, works only for DB2 database in WebSphere Application Server V7.0. In this release, the command can be used for DB2, Informix and Oracle databases. Because of that, a synonym, wsdbgen command, is introduced.

The JPA commands (.bat on Windows or .sh on UNIX) are run from the profile_root/bin directory, rather than from the app_server_root/bin directory to verify we have the latest version of the commands for the release.


Syntax

The command syntax is as follows:

Before running the command, your persistence.xml file must be in the META-INF directory and the META-INF directory must be in the class path.


Parameters


Usage

The persistence.xml file must be included in the application JAR file and is also used as input in the DB2 bind to create the DB2 package. The command requires a connection to a database to validate generated SQL. The database does not have to be the same as the run time database, but it should be at the same version and release level.

Ensure the following JAR files are on the class path:

If the database URL specifies a DB2 for z/OS database, then the following JAR file must also be on the class path: db2jcc_licence_cisuz.jar

Read more about the DB2 JAR level compliance for IBM Optimâ„¢ PureQuery Runtime at the IBM Support website: System requirements for IBM Optim PureQuery Runtime for Linux, UNIX, and Windows.

We can review information about pureQuery StaticBinder in the Data Studio Information Center by reading the topic, "The pureQuery StaticBinder utility."


Examples

DB2

    wsdbgen.sh -pu payroll -collection prod1 -url jdbc:db2://myhostname:50000/proddb -user produser -pw secret

    wsdbgen.bat -pu payroll -collection prod1 -url jdbc:db2:\\myhostname:50000\proddb -user produser -pw secret

Informix

    wsdbgen.sh -pu payroll -collection prod1 -url jdbc:ids://myhostname:9089/proddb -user produser -pw secret

    wsdbgen.bat -pu payroll -collection prod1 -url jdbc:ids:\\myhostname:9089\proddb -user produser -pw secret


Subtopics


Related


Configure JDBC providers to use pureQuery to access DB2
Configure data source JDBC providers to use pureQuery in a Java SE environment


Related information:

System requirements for IBM Optim pureQuery Runtime for Linux, UNIX, and Windows

The pureQuery StaticBinder utility


+

Search Tips   |   Advanced Search