Unable to connect to pet store

Hi ,

Since you are using the 3rd party JDBC drivers, first you need to register

that driver using the jdbcsetup.exe. There you need to give the the driver class

name (like, classes12.zip) and the classpath. Then your job is done and you can

use that driver for database connectivity. Verify it with admintool, this dirver

should appear in the "External JDBC Drivers" folders.

For petstore, actually you need to register two XML files:

1) EstoreDB-ora-type4.xml

2) InventoryDB-ora-type4.xml

EstoreDB-ora-type4.xml

<ias-resource>

<resource>

<jndi-name>jdbc/estore/EstoreDB</jndi-name>

<jdbc>

<driver-type>ora-type4</driver-type>

<database-url>jdbc:oracle:thin:@<HOST>:1521:TNS name</database-url>

<username>estore</username>

<password>estore</password>

</jdbc>

</resource>

</ias-resource>

InventoryDB-ora-type4.xml

<ias-resource>

<resource>

<jndi-name>jdbc/estore/InventoryDB</jndi-name>

<jdbc>

<driver-type>ora-type4</driver-type>

<database-url>jdbc:oracle:thin:@<HOST>:1521:TNS name</database-url>

<username>estore</username>

<password>estore</password>

</jdbc>

</resource>

</ias-resource>

Modify these two files according to your settings. After modifying the

datasource XML files to suit your database connection requirements, run the

iasdeploy command against

each file to register the datasource in the application server.

For example,

iasdeploy regdatasource EstoreDB-ora-type4.xml

iasdeploy regdatasource InventoryDB-ora-type4.xml

Then run the appliaction: http://<HOST NAME>/NASApp/estore/index.html

Thanks

Rakesh

Ariel Shmorak wrote:

> I have installed the Test Drive version Phase II on W2K.

> I was able to see the fortune application running,

> but when I tried to connect to the pet store it gives

> database connection failure.

> I am using Oracle 8.1.6 and have registered the datasource

> using the

> EstoreDB-ora-type4.xml file.

>

> <ias-resource>

> <resource>

><jndi-name>jdbc/estore/EstoreDB</jndi-name>

><jdbc>

><driver-type>ora-type-4</driver-type>

><database-url>jdbc:oracle:thin:@<dbserver name>:1521:<dbinstance

> name></database-url>

><username>estore</username>

><password>estore</password>

></jdbc>

> </resource>

> </ias-resource>

>

> Also am able to connect to the database using the oracle

> client and have created the user estore, pwd estore

> as indicated in the

> http://localhost:81/ias-samples/jps1.1.2/docs/index.html

> procedure.

>

> It goes to this page and asks to check for the database to be already

> running, which I confirmed it is.

> http://localhost:81/NASApp/estore/populate?command=checkTables&redirect=/co n

> trol/language?language=English

>

> Any help or tips would be appreciated,

> Thanks

at 2007-6-29 8:54:34 >