[palanikumark]

Is my code is correct for inserting database... This code does not work and insert data into database...
<?xml version="1.0" encoding="ISO-8859-1"?>
<students>
<student id="1">
<name>
<first>Joe</first>
<last>Y</last>
<middle>T</middle>
</name>
<grade>
<points>99</points>
<letter>A</letter>
</grade>
</student>
<student id="2">
<name>
<first>James</first>
<last>Todd</last>
<middle>K</middle>
</name>
<grade>
<points>92</points>
<letter>B</letter>
</grade>
</student>
<student id="3">
<name>
<first>Kate</first>
<last>Wang</last>
<middle>A</middle>
</name>
<grade>
<points>72</points>
<letter>C</letter>
</grade>
</student>

</students>

JSTL coding

<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbcdbc:db1" var="db1" />


<c:import var="students" url="students.xml" />

<xarse var="doc" xml="${students}" />

<x:set var="a" select="$doc/students/student/name/first" />

<x:set var="b"
select="$doc/students/student/name/last" />

<x:set var="c"
select="$doc/students/student/name/middle" />
<sql:update var="query1" dataSource="${db1}" sql="insert into studentDetails values('${a}','${b}')">
</sql:update>
<cut value="record added"/>
<c:forEach var="row" items="${query1.rowsByIndex}" >
<tr>
<td> <cut value="${row.first}" /></td>
<td> <cut value="${row.last}" /></td>
<td> <cut value="${row.middle}" /></td>
</tr>
</c:forEach>