Skip to Content

Java + Open SQL sample code..

Hi All,

I want to use Open SQL in our project, Can any one send me a Stand alone sample example of Java and Open SQL.

also point me, from where i can get informations regardig the same..

We have SAP J2EE 6.20.

Also pls let me know the supporting jar,zip files, and from where can i download the same.

I googled, but i couldnt get any sample examples..

1. Does SAP J2EE 6.20 support Java & Open SQL.

2. What all supporting jar files, do i need and from where can i get the same..

Regards,

Shridhar..

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 02, 2005 at 02:23 PM

    Hi Shridhar,

    You can find the sample code for Open SQL under your Developer Studio installation directory i.e. under program files/sap/jdt/eclipse/examples.

    or you can download from the following URL also.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/web dynpro tutorial and sample applications.faq

    Regards,

    Bhavik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 02, 2005 at 03:21 PM

    Hi,

    As far as I know, OpenSQL is not supported on the J2EE Engine 6.20. Support for it starts with J2EE Engine 6.40. To learn more about the OpenSQL framework and how to use it, see the following" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/2d/23b32e8c0152469edf07909703fe03/frameset.htm">following documentation.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2005 at 03:38 AM

    Hi Sridhar,

    To use open sql in particular project in Netweaver Studio,you should have WAS 6.40.SO the current version which you had mentioned WAS 6.20 doesn't support open sql.

    Secondly to use open sql you should place the driver .jar file in the lib folder of your respective perspective.you can download the same .jar file from the vendor's website(eg:- oracle).Then you need to conect to the DB,have youe executable statement and iterate thro' your resultset similarly what you in an ordinary JDBC program.

    Hope this helps.

    Regards,

    Guru

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.