Executing group of SQL Statements through a JAVA Map

[Former Member]

I want to Execute some SQL statements in one java map, can I use data base conection from JAVA Map? or is there any other way like.. calling a stored procedure via JDBC adapter?

The data I want to transact is going to operate in a write mode and volume of data is not much.

Thanks

Sugata B

[Former Member · Accepted solution]

Hi

If you have not already gone through this

http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

based on the processing mode, the format of data to be fed differs

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

Regards

Vishnu

[Former Member]

Hi Sugata,

You can check my blog...if you want to connect database thru mapping...

/people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios

I have used stored procedure for this.

However, this is not supported and not advised, because you are connection to the database if fails it wont be logged anywhere. Look into the side-effects of this method as suggested by the comments... If you can make sure that connection fail,errors are properly handled, then this approach may be taken.

Regards

Arpil

[former_member181985]

go ahead with stored procedure.

Call stored procedure using JDBC adapter.

Rgds,

- Gujjeti.