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