Database Connection

Former Member · ‎07-03-2007

I have the following doubts regarding database connection.

1. how we can connect to the database.

2.What are the advantages and disadvantages of this method?

3.Can we connect to any other database which is not involved in the SAP system ,if possible tell me how?

please tell refer some tutorials ........

Former Member · ‎07-03-2007

Hai ,

to connect with Non-SAP backends. use the java bean model, if the database connection concerns Synchronization , securtiy aspects better to Go with EJB model.

To connect with database in java bean model , better to create a data source for data base , get the connection from data base. use the connection get the result set . to create a data source for a DB

http://help.sap.com/saphelp_nw2004s/helpdata/en/ab/082484173ae045ab8dad8a41d33da3/content.htm

Regards,

Naga

Former Member · ‎07-03-2007

<b>Hi

Check this URL

General

http://help.sap.com/saphelp_nw04/helpdata/en/a5/55ecf8fc6c11d28e610000e816c2ff/frameset.htm

For Oracle

http://help.sap.com/saphelp_nw04/helpdata/en/52/8271403017587ee10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/4c/5f70403590ca01e10000000a155106/frameset.htm

Regards

Chandran</b>

Former Member · ‎07-03-2007

Hi shanto,

connect to the database:

Advantages;

DB connection maintenance to maintain the SAP table DBCON. This table contains information about additional non-standard database connections (such as database system, password, and so on).

Disadvantage;

tRFC processes all LUWs independent of one another. Due to the amount of activated tRFC processes, this procedure can reduce performance significantly in both the send and the target systems.

In addition, the sequence of LUWs defined in the application cannot be kept. Therefore, there is no guarantee that the transactions are executed in the sequence dictated by the application. The only guarantee is that all LUWs are transferred sooner or later.

Regards,

vino

Former Member · ‎07-03-2007

Hi Shanto,

U can create datasource in visual admin->services->jdbc connection tab and can refer that datasource in webdynpro program to get db connection. At the time of creation of datasorce, u need to mention the driver for database also

Regards

Fahad Hamsa