dbsql2xml

beta
Add a Review
10 Downloads (This Week)
Last Update:
Download dbsql2xml_0.22.zip
Browse All Files
Windows Mac Linux

Screenshots

Description

"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.

dbsql2xml Web Site

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
0
0
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
Write a Review

User Reviews

  • indranilnag
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    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 Sukanta 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>

    Posted 02/17/2014
Read more reviews

Additional Project Details

Intended Audience

Advanced End Users, Developers

User Interface

Command-line, Web-based

Programming Language

Java, XSL (XSLT/XPath/XSL-FO)

Registered

2005-04-27
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.