flowertang
Programmer
I want to connect to my Database using XML api. I want to map my database tables, rows columns as xml elements(insert xml elements to db /get the record from db to xml). Have any java api can do this? THX....
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Have any api can connect between xml and database??
- Thread starter flowertang
- Start date
- Status
Actually there is...DataML (The Data Markup Language) is what we use to run our reporting applications...best of all it is free. Build web applications faster with a few lines of XML Code using DataML[tm]
Flowertang -
You should know that using XML to connect with the database will increase the CPU load on the server by quite a bit, since XML is not the native language of the (relational) database, it has to be converted by the database engine before it can do any real work.
Such a load is probably better placed on an application server, that translates your XML into your database's native language (OCI for Oracle, TDI for MS SQLServer, etc).
Chip H.
You should know that using XML to connect with the database will increase the CPU load on the server by quite a bit, since XML is not the native language of the (relational) database, it has to be converted by the database engine before it can do any real work.
Such a load is probably better placed on an application server, that translates your XML into your database's native language (OCI for Oracle, TDI for MS SQLServer, etc).
Chip H.
- Status