Page 1 of 1

A new "Sample" directory item: SQL

Posted: Wed Jan 20, 2016 5:44 pm
by boater
The samples directory is full of very helpful material. Thank you for that.

I suggest adding another folder: a scenario that transforms an XML into a connected SQL database.

It could contain:
[*]readme file that says in general terms what environment is needed (JDBC, classpath etc. )
[*]minmal SQLite file
[*]minimal XML file
[*]xslt transform
[*]configuration file

I've been working on a project like this and I'm having a difficult time. Information regarding xslt/sql transforms is hard to find.

Re: A new "Sample" directory item: SQL

Posted: Fri Jan 29, 2016 7:23 pm
by adrian
Hi,

I've logged your request. This will be analyzed and if found appropriate, it will be added in a future version of Oxygen.

I do have to mention that what you want is less of an XML sample and more of a JDBC/SQL sample (used from within XSL). There's also the matter that JDBC tends to have implementation specific peculiarities. So what might work for SQLite, might not be best for MS SQL.
Anyway, my point is a sample needs to be generic and what you want seems to be more specific.

Regards,
Adrian