This is my code... This is not inserting values into database... Whts wrong in my code... Pls help me..
<?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>
<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/xml" prefix="x" %>
<html>
<head>
<title>Set Examples</title>
<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:db1" var="db1" />
</head>
<body>
<c:import var="students" url="students.xml" />
<x:parse 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" />
<table border="1">
<tr>
<td>$doc/students/student/name/first</td>
<td>
<x:out select="$a" />
</td>
</tr>
<tr>
<td>$doc/students/student/name/last</td>
<td>
<x:out select="$b" />
</td>
</tr>
<tr>
<td>$doc/students/student/name/middle</td>
<td>
<x:out select="$c" />
</td>
</tr>
</table>
<sql:update var="query1" dataSource="${db1}" sql="insert into studentDetails
values('${a}','${b}')">
</sql:update>
<c:out value="record added"/>
<c:forEach var="row" items="${query1.rowsByIndex}" >
<tr>
<td> <c:out value="${row.first}" /></td>
<td> <c:out value="${row.last}" /></td>
<td> <c:out value="${row.middle}" /></td>
</tr>
</c:forEach>
</table>
</body>
</html>
[ May 30, 2008: Message edited by: Palani Kumar ]
