Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] DBWS output format

I've just put the finishing touches on a new feature that auto-generates the schema/OR/OX files
from JDBC metadata by running at design-time a slightly-modified version of the SQL
.
Can you download the M1 milestone of EclipseLink 2.1.2 and see if it meets your needs?

Any feedback would be greatly appreciated,
---
Oracle
Mike Norman | Principal Software Designer
Phone: +6132884638 | | Fax: +6132382818 |
Oracle Oracle Server Technologies, EclipseLink Product
ORACLE Canada | 45 O'Connor Street, Suite 400, Ottawa, Ontario | K1P 1A4

Green Oracle Oracle is committed to developing practices and products that help protect the environment

On 07/10/2010 4:43 AM, todhunter wrote:
Hello
I want to use EclipseLink DBWS and have a question. When I create WS from
procedure or table the result is in format retrived from db metadata, this
is OK.
When I use sql insteed it returns in simple-xml-format. I want to return in
some schema. I can set returnType parameter in builder file but when I
deploy this app I recieve error:

Exception Description: Result type [{urn:testSQL}twpkType] for operation
[twpk] has no O-X mapping

OK I understand that, I need to create eclipselink-dbws-or.xml and
eclipselink-dbws-ox.xml files.
How can I do that when I know select sql and I know column types?
I can create simple xsd file but how to create from  that xo an or files?
Maybe is another, simpler, method to generate WS from sql with returns in
some schema?
Is there any method to convert simple-xml-format to ox, or files with no
type declared? (for example all columns ar strings)
  

Back to the top