unable to connect to datasource:(database not running)

[Former Member]

I was running this example Car Application.

I downloaded SQL Studio and wanted to check if the db tables are created or not.

Tried to open through SQL studio but got the following exception as a pop-up:

<b>

[SAP-AG][SQLOD32 DLL][SAP DB]unable to connect to datasource:(database not running).return-code:SQL_ERROR(-709)</b><i></i>

I believe my J2EE engine is running fine with all the three boxes in green.

Does anyone went through this kind of situation?

Please help me in this regards.

Thanks

-Sudheer

[nitzanlevi]

from what it says it looks like the DB that the DataSource is connected to is not running, check in the application what is the DataSource(DS) being used and check on the J2EE engine (via visual admin) what are the properties for this DS. it looks like bad configuration at the DS level.

[Former Member]

Nitzan,

Thanks for the reply.

To be honest, I didnt understand what u meant.Iam a beginner trying to learn N/W though Iam in J2EE for a long while.

Here is what I have done so far:

Installled WAS with developer studio ran this Car rental application.While doing this I installed SQL studio to check if the tables r created or not.

I dont have any back end database like oracle or SQL server installed.The car application example documentation doesnt say so.

This is what I have given in persistant.xml:

Datasource Name:CAR_RENTAL_POOL

Database Vendor: SAPDB

I dont have visual admin installed.

Please let me know if this makes any sense.

And also there is another problem with car reservation application:

The application seems to running fine except withe the saving part:

when I tried to add a car reservation, there is no response , it's not getting added to the DB.There are no error messages on screen. The screen is same before and after.

Any help would be greatly greatly appreciated.

Thanks

[Former Member]

Never mind.I found the solution.

Those who have similar problem with SQL Studio here is the solution:

Do not follow the instructions given in rental Car Application example.

The details to follow while logging in with SQLStudio:

server: localhost

database: j2e(or which ever name u see in SAPMMC console)

Username: SAPJ2EDB

pwd: the password u given while installing the WAS.

THe solution was there in one of the previous threads.

Thanks to all those gurus.