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

How to create datasource alias in EP project?

Hi,

I want to use SQLJ in a JSP Dynpro Portal Component, and have followed the example given in "Getting started with relational persistence". The problem is that the document does not explain about creating a data source (which is what I assume I need to create the context with java:comp/env/[datasource alias]).

When I try to create a datasource alias in NWDS, it looks for an Enterprise Application project in which to create it, but my project is obviously not applicable.

Please help.

Thanks,

Martin

P.S. I see in the online help that you can add a data-source-aliases.xml file to your META-INF folder (is this applicable to EP projects?). Also, in the data-source-aliases.xml file, you still need to add the name of the datasource - so what is the name of the Default datasource?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 24, 2005 at 01:14 PM

    Hi Martin,

    > you can add a data-source-aliases.xml file to your

    > META-INF folder

    > so what is the name of the Default datasource?

    See http://help.sap.com/saphelp_nw04/helpdata/en/c3/4f7770b21b9f459cb13424296726b1/frameset.htm - you can generically use a variable.

    > is this applicable to EP projects?

    I won't expect this (as a portal project isn't a J2EE application itself but part of another).

    Anyhow, the datasources (and with them their alias within the J2EE engine) are managed via VisualAdmin, see http://help.sap.com/saphelp_nw04/helpdata/en/11/4963a6cf52ad429b3b3b65e003f2d1/frameset.htm

    Hope it helps

    Detlev

    PS: Please consider to reward points if answers are helpful. Thanks in advance!

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      > no idea where such an XML file in a Portal project

      > would be deployed to, if at all

      The answer you gave by yourself:

      > to your META-INF folder

      Such a folder exists also in PAR files, but as said, I don't expect that PAR as non-J2EE-apps would consume this.

      > I have no admin access,

      > and no J2EE Visual Administrator.

      But you will have some process how people will do things on it, won't you?!

      I <i>think</i> (just looked at out installation, but it wasn't me who installed) that the standard alias is built by the convention "SAP" + <SYSTEMID> + "DB", so our portal DB alias is "SAPNPTDB".

      Hope it helps nevertheless

      Detlev

      PS: Even if someone cannot solve your problem, you maybe should be somewhat more generous and at least show that you appreciate any help... that's what the radio buttons are for...

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.