Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 363162 - Can not access the DB when binding the DB connection in dd file and deploy the RUI handler
Summary: Can not access the DB when binding the DB connection in dd file and deploy th...
Status: CLOSED INVALID
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P1 normal (vote)
Target Milestone: ---   Edit
Assignee: Yun Feng Ma CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-08 07:01 EST by Yu Hao CLA
Modified: 2017-02-23 14:18 EST (History)
2 users (show)

See Also:


Attachments
PI for DB testing (40.07 KB, application/octet-stream)
2011-11-08 07:03 EST, Yu Hao CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
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