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.)

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

Thu, 19 April 2012 13:45

Eclipse User

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

Eclipse User

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

Eclipse User

No Message Body

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

Thu, 19 April 2012 21:03

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Mon Jun 09 17:14:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter