Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2012-05-15T08:08:53Z by B5N4_Wing_Lee
SumitSinghTCS13
SumitSinghTCS13
2 Posts
ACCEPTED ANSWER

Pinned topic Not able to create a SQL Call builder using EmployeeDatasource in IBM WASCE

‏2010-06-07T20:15:54Z |
Hi! ,

I am new to the portlet factory designer. I have very good knowledge on IBM portal but very less in portlet factory.

I am trying to do all the getting started kind of projects.
I am able to run the sample project
http://127.0.0.1:1346/help/index.jsp?topic=/com.bowstreet.designer.doc/tutorials/TutorialBasics_Quick_Start_WASCE.htm

like :
Tutorial – Creating a Web Application Project
Tutorial – Creating a Simple Portlet

but not able to create a SQL Call Builder to create some interactions with the database.

I tried the EmployeeDatasource keyword (entering into the builder fields) but the builder don't sense it and says its wrong. I am running Portlet factory designer onto the WAS CE. I have checked into WAS CE console the EmployeeDatasource but when i try to enter into the builder it says wrong.

Do we have simple link of tuorial or some hint to make it work. I am going crazy.

Pls help !
Updated on 2012-05-15T08:08:53Z at 2012-05-15T08:08:53Z by B5N4_Wing_Lee
  • DGawron
    DGawron
    251 Posts
    ACCEPTED ANSWER

    Re: Not able to create a SQL Call builder using EmployeeDatasource in IBM WASCE

    ‏2010-06-16T20:05:48Z  in response to SumitSinghTCS13
    It sounds like you are manually entering the value "EmployeeDatasource" into the DataSource input of the builder. Depending upon the app server valid dataSource names typically begin with "java:comp/env/" or "jdbc/". That's probably the issue here. Try pressing "Fetch DataSource Names" then see what names are listed in the DataSource input drop down. The listed names are those visible to WPF. If no names are displayed, then your deployed WAR does not have access to any datasources.
    • SumitSinghTCS13
      SumitSinghTCS13
      2 Posts
      ACCEPTED ANSWER

      Re: Not able to create a SQL Call builder using EmployeeDatasource in IBM W

      ‏2010-06-17T10:58:40Z  in response to DGawron
      Thanks Dave ! But when i am creating the portlet factory project WAR - a basic one and deploying onto the IBM WAACE the fetch data source is not generating the any enteries in the list. Now after drilling a lot I found I have to uncomment some stuff as per followign instructions:

      "You will need to uncomment these references and modify them for your environment. The files you will be editing are the project's: WEB-INF/bin/deployment/wasce.web.xml and WEB-INF/geronimo-web.xml Be sure to "uncomment" the sample resource references, but leave the basic structure of these files in tact. "

      Now I am able to get the EmployeeDataSource (out of box datasource that comes with the WASCE installtion) after clicking the fectch datasource.

      I will be trying to do the same for the seperate ORACLE DB instance. Will it work ?

      Overall - Do we have to make the manual changes and entries in these two xml files for this button to work (Fetch Datasource) ? Is this what I should keep in mind always ?

      Appreciate your technical expertise on this area !

      Thanks,
      Sumit
      • SystemAdmin
        SystemAdmin
        532 Posts
        ACCEPTED ANSWER

        Re: Not able to create a SQL Call builder using EmployeeDatasource in IBM W

        ‏2010-06-21T17:33:51Z  in response to SumitSinghTCS13
        You are correct: When using WAS CE, you will need to modify both files.

        Here's an overview of one way:

        Download and install a JDBC Driver
        Download a JDBC driver for your database.
        Log in to WAS CE Admin console.
        Select "Repository" from the navigation. On the page that follows, upload the jdbc jar for the jdbc driver you downloaded. This makes it available to the appserver.

        Configure the a Database Pool
        Select "Database Pool" from navigation
        Select "Using the Geronimo Database Pool Wizard"
        Follow the wizard instructions. You'll be asked for uname/pw, jdbc connection url, db server hostname, etc.
        When prompted, test the service to verify connectivity.

        Modify WEB-INF/bin/deployment/wasce.web.xml and WEB-INF/geronimo-web.xml in your project
        In the WAS CE Admin Console, click "Usage" for the datasouce you just created. This will give you the <dependency> and <resource-ref> sections you'll need when modifying these two files. Read closely. Also, you should change the <res-ref-name> to something more meaningful. For example, instead of <res-ref-name>jdbc/MyDataSource</res-ref-name>, you could choose <res-ref-name>jdbc/MyOracleDataSource</res-ref-name>

        Re-deploy your project.

        If there are no errors in your xml files, then your new DAtasource will show up in the builder's "SQL Datasource" input when you click Fetch Datasource Names

        Sam
        • B5N4_Wing_Lee
          B5N4_Wing_Lee
          1 Post
          ACCEPTED ANSWER

          Re: Not able to create a SQL Call builder using EmployeeDatasource in IBM W

          ‏2012-05-15T08:08:53Z  in response to SystemAdmin
          Hi Sam,
          I have the same problem(upon clicking "create table", it complains the datasource is not valid), even if I modified web.xml and geronimo-web.xml, the problem still exists. I also tried to modify wasce.web.xml under /WEB-INF/bin/deployment/, but the project cannot be deployed-the deploying process exited and didn't display any error message.

          Any advise? Looking forward.

          Lee
      • DGawron
        DGawron
        251 Posts
        ACCEPTED ANSWER

        Re: Not able to create a SQL Call builder using EmployeeDatasource in IBM W

        ‏2010-06-22T14:00:41Z  in response to SumitSinghTCS13
        You only need to modify these 2 files when you use WASCE as the dev server. WebSphere datasources are automatically made visible to the WPF WAR if you define them in a general enough scope to cover where WPF runs.

        You must be using a release earlier than 6.1.5. As I recall, in 6.1.5 the sample WASCE datasource is automatically defined and available without needing to edit the deployment descriptors.