"dbsql2xml" is Java tool (class) for transformation (export, convert) relational database into hierarchical XML. It requires JRE 5.0, JDBC and SQL DBMS. "dbsql2xml" uses XML document for mapping database tables and columns into elements of tree XML.
License
GNU Library or Lesser General Public License version 2.0 (LGPLv2)Follow dbsql2xml
You Might Also Like
ConnectWise SIEM (formerly Perch) offers threat detection and response backed by an in-house Security Operations Center (SOC). Defend against business email compromise, account takeovers, and see beyond your network traffic. Our team of threat analysts does all the tedium for you, eliminating the noise and sending only identified and verified treats to action on. Built with multi-tenancy, ConnectWise SIEM helps you keep clients safe with the best threat intel on the market.
Rate This Project
Login To Rate This Project
User Reviews
-
No table creation script for oracle following is the example create table invoice( id number, customerId number, total number(5,2) ) create table customer( id number, firstName varchar2(30), lastName varchar2(30), street varchar2(100), city varchar2(30) ); create table item( invoiceId number, item varchar2(30), productId number, quantity number, cost number(5,2) ) create table product( id number, name varchar2(100), price number(5,2) ); insert into invoice (id,customerId,total)values('10','1',20.09); insert into customer values('1','test','test','irving ','Dallas'); insert into item (invoiceId,item ,productId,quantity,cost)values(10,1,1,20,200); insert into product values('1','1',20.09); select invoice.id as "invoice.id", invoice.customerid as "invoice.customerid", invoice.total as "invoice.total", item.invoiceid as "item.invoiceid", item.item as "item.item", item.productid as "item.productid", item.quantity as "item.quantity", item.cost as "item.cost", product.id as "product.id", product.name as "product.name", product.price as "product.price", customer.id as "customer.id", customer.firstname as "customer.firstname", customer.lastname as "customer.lastname", customer.street as "customer.street", customer.city as "customer.city" from invoice, item, product, customer where invoice.id=item.invoiceid and item.productid=product.id and invoice.customerid=customer.id and invoice.id = 10 <?xml version="1.0" encoding="UTF-8" standalone="no"?><dbsql2xml><invoice><id>10</id><customerId>1</customerId><total>20.09</total><customer><id>1</id><firstName>Indranil</firstName><lastName>Nag</lastName><street>21A S***nta Pally</street><city>Barrackpore</city></customer><item><invoiceId>10</invoiceId><item>1</item><productId>1</productId><quantity>20</quantity><cost>200</cost><product><id>1</id><name>1</name><price>20.09</price></product></item></invoice></dbsql2xml>