[GERONIMO-5903] bank:DB Initialization Failure

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

Environment

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

• Patch Info: Patch Available
• Assignee: Shenghao Fang
• Reporter: Jacky Liu
• Created: 14/Apr/11 09:02
• Updated: 05/May/11 08:02
• Resolved: 19/Apr/11 07:16

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!