Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EGL Development Tools » Tutorial: RUI with Database Lesson 8(An exception occurred while calling a service.)
Tutorial: RUI with Database Lesson 8 [message #850034] Thu, 19 April 2012 13:45 Go to next message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
Had completed the codes following Tutorial: RUI with Database Lesson 8 (using EDT 0.8.0).

When preview, encountered failure "An exception occurred while calling a service." and "Detail 3: The URL used to invoke the service is blank. Specify a URL that points to the service."

The only abnormal code is that the "using dedicatedServiceBinding" is not recognized by Eclipse IDE. The followings are complete codes given by Tutorial for EDIT 0.8.0:

function readFromTable()
call dbService.getAllPayments()
using dedicatedServiceBinding
returning to updateAll
onException serviceExceptionHandler;
end

What went wrong? Anyone?
Re: Tutorial: RUI with Database Lesson 8 [message #850111 is a reply to message #850034] Thu, 19 April 2012 15:24 Go to previous messageGo to next message
Theresa Ramsey is currently offline Theresa Ramsey
Messages: 62
Registered: July 2009
Location: research triangle park, n...
Member
Hi,
The tutorial has steps for EDT 0.7 and EDT 0.8. Since you are using EDT 0.8, and the syntax has changed to no longer use @dedicatedService, you should use:

for service binding:
  dbService SQLService? ;
  dbServiceBinding HTTPProxy ;


and call statement:
function readFromTable()
     call dbService.getAllPayments() 
        using dedicatedServiceBinding
        returning to updateAll
        onException serviceExceptionHandler;
  end


Re: Tutorial: RUI with Database Lesson 8 [message #850334 is a reply to message #850111] Thu, 19 April 2012 20:59 Go to previous messageGo to next message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
No Message Body
Re: Tutorial: RUI with Database Lesson 8 [message #850338 is a reply to message #850111] Thu, 19 April 2012 21:03 Go to previous messageGo to next message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
Yes, Theresa. I have followed EDT 0.8 codes exactly as you said.

But Eclipse IDE doesn't accept "dedicatedServiceBinding" in readFromTable() function.

If I remark "using dedicatedServiceBinding" statement, errors mentioned above appear.

Re: Tutorial: RUI with Database Lesson 8 [message #850348 is a reply to message #850338] Thu, 19 April 2012 21:18 Go to previous messageGo to next message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
By the way, how should I change the following to use Mysql database instead of Derby?


package services;

service SQLService
ds SQLDataSource? { @Resource { uri="binding:Derby" } } ; // EDT 0.8.O syntax
end
Re: Tutorial: RUI with Database Lesson 8 [message #850382 is a reply to message #850338] Thu, 19 April 2012 22:07 Go to previous messageGo to next message
Theresa Ramsey is currently offline Theresa Ramsey
Messages: 62
Registered: July 2009
Location: research triangle park, n...
Member
ah I think it's a typo...
should be
using dbServiceBinding (which you defined earlier, not using dedicatedServiceBinding)

We'll update the tutorial.
Re: Tutorial: RUI with Database Lesson 8 [message #850386 is a reply to message #850348] Thu, 19 April 2012 22:10 Go to previous messageGo to next message
Theresa Ramsey is currently offline Theresa Ramsey
Messages: 62
Registered: July 2009
Location: research triangle park, n...
Member
as for the database, I haven't tried MySQL but here's some info on defining SQL resources:

http://wiki.eclipse.org/EDT:Resource_Binding_Databases

Maybe someone else has used MySQL can comment?
Re: Tutorial: RUI with Database Lesson 8 [message #851632 is a reply to message #850386] Sat, 21 April 2012 02:01 Go to previous messageGo to next message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
Yes, it is typo.

However using MySQL as database is still not successful. Appreciate anyone can help.

Thanks.
Re: Tutorial: RUI with Database Lesson 8 [message #852053 is a reply to message #851632] Sat, 21 April 2012 12:16 Go to previous message
tt k is currently offline tt k
Messages: 6
Registered: April 2012
Junior Member
Errors removed and MySQL connection resolved. Thanks.
Previous Topic:Installing war file in IWS
Next Topic:New blog - What's cooking in the EDT kitchen
Goto Forum:
  


Current Time: Sun Apr 20 23:04:06 EDT 2014

Powered by FUDForum. Page generated in 0.14932 seconds