Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Not a Problem
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: sample apps
    • Security Level: public (Regular issues)
    • Labels:
    • Environment:

      Windows XP SP3 x86
      sun jdk 1.6.0_23
      Geronimo build on 20110411

    • Patch Info:
      Patch Available

      Description

      1. start Geronimo v3.0 server
      2. input "deploy deploy ..\repo\org\tranql\tranql-connector-derby-embed-xa\1.7\tranql-connector-derby-embed-xa-1.7.rar ..\WASCE-sample-datasource\src\main\plan\plan.xml" in cmd
      3. input "deploy deploy ..\bank\bank-ear\target\bank-ear-2.1.1.5.ear" in cmd
      4. go to "http://localhost:8080/bank/" and click on "View Exchange Rates"
      5. Error Occured !!!

      That means database hasn't been set up.

      And,

      a. Create DB: BankDB use Geronimo console
      b. Use DB: BankDB and Run SQL commands use Geronimo console. SQL commands can be found in patchs
      c. go to "http://localhost:8080/bank/" and click on "View Exchange Rates"
      d. Exchange Rates CAN BE FOUND

      Steps a~d mean View Exchange Rates works well.

      I think something may be wrong with at least one of the following sections:

      1. tranql-connector-ra-1.6.rar
      2. bank-ear\..\BankPool.xml:
      <dep:groupId>console.dbpool</dep:groupId>
      <dep:artifactId>BankPool</dep:artifactId>
      <dep:version>1.0</dep:version>
      <dep:type>rar</dep:type>

      <config-property-setting name="ConnectionURL">jdbc:derby:BankDB</config-property-setting>
      3. dd\BankDB.sql
      4. bank-ejb\..\persistence.xml

      That's all I know and I hope it will be helpful!

      1. bank.rar
        334 kB
        Jacky Liu
      2. WASCE-sample-datasource.rar
        132 kB
        Jacky Liu
      3. BankDB.sql
        0.9 kB
        Jacky Liu

        Activity

        Hide
        Tina Li added a comment -

        verified on build 2011.05.04-22:24:47.468+0800-3.0-SNAPSHOT.
        Still no url diplayed on the console,depends on GERONIMO-5302.

        Show
        Tina Li added a comment - verified on build 2011.05.04-22:24:47.468+0800-3.0-SNAPSHOT. Still no url diplayed on the console,depends on GERONIMO-5302 .
        Hide
        Shenghao Fang added a comment -

        The database should be created by BankDB.sql before running the application.

        Show
        Shenghao Fang added a comment - The database should be created by BankDB.sql before running the application.

          People

          • Assignee:
            Shenghao Fang
            Reporter:
            Jacky Liu
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development