"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
Our computer monitoring software allows employees, field contractors, and freelancers to manually clock in when they begin working on an assignment. The application will take screenshots randomly or at set intervals, which allows employers to observe the work process. The application only tracks activity when the employee is clocked in. No spying, only transparency.
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>