Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 363162

Summary: Can not access the DB when binding the DB connection in dd file and deploy the RUI handler
Product: z_Archived Reporter: Yu Hao <yuhaodl>
Component: EDTAssignee: Yun Feng Ma <mayunf>
Status: CLOSED INVALID QA Contact:
Severity: normal    
Priority: P1 CC: chenzhh, jspadea
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
PI for DB testing none

Description Yu Hao CLA 2011-11-08 07:01:38 EST 
Build Identifier: 201111032101

If hard code the DB resource in the egl file the DB can be accessed successfully after deploy. But if we bind the DB connection information in the dd file, the bind this DB resource in egl file. The DB can NOT be accessed after deploy. I attached the PI for your refernence

Reproducible: Always
Comment 1 Yu Hao CLA 2011-11-08 07:03:44 EST 
Created attachment 206583 [details]
PI for DB testing
Comment 2 Yun Feng Ma CLA 2011-11-09 21:21:03 EST 
The DB app deployment works fine, three things you need correct in your test application:
1) in Resource Bindings, the URI should be something like "http://localhost:8080/MyWeb1/restservices/dbService", instead of "workspace://xxx"
2) Below line :
  MySQL SQLDataSource?{@resource{bindingkey = "MySQL"}};
Should be:
  MySQL SQLDataSource?{@resource{propertyFileName = "testdb", bindingkey = "MySQL"}};
 
3) remove MySQL1 variable.
Comment 3 Yu Hao CLA 2011-11-15 20:04:31 EST 
Verified in 201111140901