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. BankDB.sql
        0.9 kB
        Jacky Liu
      2. WASCE-sample-datasource.rar
        132 kB
        Jacky Liu
      3. bank.rar
        334 kB
        Jacky Liu

        Activity

        Tina Li made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Shenghao Fang made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Not A Problem [ 8 ]
        Shenghao Fang made changes -
        Assignee Shenghao Fang [ michael_fang ]
        Jacky Liu made changes -
        Field Original Value New Value
        Attachment bank.rar [ 12476304 ]
        Attachment WASCE-sample-datasource.rar [ 12476305 ]
        Attachment BankDB.sql [ 12476306 ]
        Jacky Liu created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development