Skip to Content
author's profile photo Former Member
Former Member

WebDynpro vs Oracle

Greetings to all!

We had been two weeks trying to develop a simple application with Web Dynpro that brings data from an Oracle database. We have defined a table in the Java Dictionary with such fields and names that in the data base. We have created a project J2EE with a EJB Entity with properties and methods for the fields of the table. For the tableView model in Web Dynpro we had to use a Java conventional Bean since it did not accept the EJB import directly. Also we have defined a system with the connection properties, user, password... of the Database. Everything seems to work fine, but sometimes we obtain the java.lang.NoClassDefFoundError exception: com/sap/tc/webdynpro/progmodel/gci/IGCIComponentDelegate and the others just an empty tableView. Can somebody help us? It would be to us of much utility a simple project of this kind with all the properties, detailed references...

Thank you very much in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Sep 28, 2005 at 03:02 AM

    Hi,

    The reason for this being you are not including the driver files from Vendor (oracle in this case) in your class path.

    Right click your project in ur studio -> select properties ->select your driver files from ur local system -> apply it.

    Once the classpath is set through the driver file you will not get that exception.

    Hope it helps.

    Regards,

    Guru

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2005 at 04:48 AM

    Hi Bernardo,

    One more point.

    After including these Driver files correctly in your project, you need to specify sharing reference of your EJB in webdynpro application. Webdynpro application uses this sharing reference to get EJB from server at runtime.

    Goto properties of your webdynpro project and there select webdynpro references-> sharing references.

    Add following reference there.

    sap.com/ project name>

    Regards,

    Bhavik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 08:31 AM

    Thanks for the replies. I included the EJB in the Sharing References of the WebDynpro project and also included the vendor driver libs of my external database in the J2EE project but I still don´t see data in the TableView. This is the message I get when I execute the WebDynpro application:

    Caused by: com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Application sap.com/accesoMaxDB cannot be started. Reason: it has hard reference to resource jdbc/Oracle with type javax.sql.DataSource, which is not active on the server.

    Any idea please? Thanks in advance.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bernardo,

      This problem comes because, J2ee applcation cannot take driver file with it on server at deployment time.

      So, do one thing. Make one library project and then add your required libraries for oracle in this.

      Now, deploy this project on server.And provide reference of this library project in your EAR project under applicatio-j2ee-engine.xml file.

      Regards,

      Bhavik

      Don't forget to award points if it was helpful.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2005 at 08:58 AM

    Hi Bernardo,

    i hope i can help you a little bit. I had the same error. I had to map the database-instance manually somewhere in a configuration-tool. Unfortunately i cant remember which tool it was (I am sure it was not the SLD, perhaps the Visual Admin? or one of the others?)

    Good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2005 at 09:35 AM

    I did it, but it still doesn´t work. Any more ideas? Thanx.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 05, 2005 at 10:42 AM

    Hi Bernardo,

    I solved this problem by creating a Session-EJB which calls the Entity-Bean. I created a Web-Service and imported it as a Web-Service Model into my Web Dynpro Application. It works fine.

    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.