Eclipse Community Forums: EGL Development Tools » Tutorial: RUI with Database Lesson 8

Home » Archived » EGL Development Tools » Tutorial: RUI with Database Lesson 8(An exception occurred while calling a service.)

Show: Today's Messages :: Show Polls :: Message Navigator

Tutorial: RUI with Database Lesson 8 [message #850034]

Thu, 19 April 2012 17:45

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?

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850111 is a reply to message #850034]

Thu, 19 April 2012 19:24

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

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850334 is a reply to message #850111]

Fri, 20 April 2012 00:59

tt k

Messages: 6
Registered: April 2012

Junior Member

No Message Body

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850338 is a reply to message #850111]

Fri, 20 April 2012 01:03

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.

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850348 is a reply to message #850338]

Fri, 20 April 2012 01:18

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

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850382 is a reply to message #850338]

Fri, 20 April 2012 02:07

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.

Report message to a moderator

Re: Tutorial: RUI with Database Lesson 8 [message #850386 is a reply to message #850348]

Fri, 20 April 2012 02:10

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?

Report message to a moderator