"David Browne" wrote:

>
> "Ronan Maddock" <Ronan Madd***@discussions.microsoft.com> wrote in message
> news:5BAF811D-15FB-4BAB-A70D-295575EC698E@microsoft.com...
> > Hello, I'm currently studying SQL Server in college and have been asked to
> > find out how SQL Server uses JSP, JDBC, SQLJ & XML in the context of
> > database
> > applications.  Try as I might,  I cannot seem to get any info on this.  I
> > would be greatly obliged if anyone here could shed a little light on the
> > subjetct.
>
>
> Well.  These acronyms are a mostly Java-related application development
> technologies.
>
> JSP is a Java web application framework.
>
> JDBC is a Java API for connecting to, reading from and writing to relational
> databases.
>
> SQLJ - Allows embedding of static SQL statements in Java.  This is really
> just a pre-compiler which transforms static-embedded SQL into JDBC calls.
>
> XML is a standard format for representing, storing and interchanging data.
>
> So SQL Server doesn't use JSP, JDBC or SQLJ.  Java applications using these
> technologies might read from and write to SQL Server.  But these are
> application-tier technologies, not database-tier.
>
> SQL Server has deep support for XML.  SQL Server can store, update, index,
> read and transmit XML.  SQL Server can publish SOAP webservice endpoints,
> which are a standard mechanism for clients on all platforms to interact with
> the databse by transfering XML documents back and forth.  So instead of
> using JDBC, or ODBC or some other client database API library, clients can
> simply use XML over HTTP to communicate to the database server.
>
> David
>
>
>