Red Hat NETSCAPE ENTREPRISE SERVER 6.1 - INSTALLATION AND MIGRATION GUIDE Manual de usuario Pagina 29

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 120
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 28
29
To create and populate the PLANTSBY database in DB2:
1. Locate the batch file,
db2createplantsby_db.bat
, in the
install
subdirectory
created after unzipping the
plantsbyDB2.zip
file. Enter the following at a command
prompt
db2createplantsby_db [db2admin] [pw]
, where db2admin is your DB2
user ID and pw is your DB2 password.
This batch file connects to DB2 using the Java Database Connectivity (JDBC) API
and creates the PLANTSBY database. To see the commands that are called, view the
db2creatplantsby_db.bat file with a text editor.
2. Locate the Plants by WebSphere image files in the following directory:
install_root\samples\src\PlantsByWebSphere\PlantsByWebSphereWAR\imag
es\archive
where:
install_root
is the location of your Application Server (ex.
C:\WebSphere\AppServer
)
Copy all of the images into the
install
subdirectory that you created after unzipping
the
plantsbyDB2.zip
file. Make sure that the images are in the same folder as the
Populate.class
file so that it can access these images and insert them into the
PLANTSBY DB2 database.
3. Locate the Java class file,
Populate.class
, in the
install
subdirectory. Add the
current directory and the path of the
db2java.zip
file (typicaly
DB2_install_root\SQLLIB\java12\
) to your CLASSPATH.
4. To populate the PLANTSBY tables, enter the following at a command prompt:
java
Populate [db2admin] [pw]
, where db2admin is your DB2 user ID and pw is your
DB2 password.
This file connects to the PLANTSBY database using the JDBC API and creates the
following tables:
o
CUSTOMER
o
INVENTORY
o
ORDERINFO
o
ORDERITEMS
The file then inserts all of the data for each item into the INVENTORY table,
including the image files. You can view the Populate.java source file located in the
install subdirectory for details.
Vista de pagina 28
1 2 ... 24 25 26 27 28 29 30 31 32 33 34 ... 119 120

Comentarios a estos manuales

Sin comentarios