hi!
i'm a real newby here. i'm coding java for a few years but my new project really kills me.
i need to write a forum with jsp, in a cocoon framework, with the forum data in mysql respectively postgreSQL.
but i'm really stuck in the beginning.. i dont get any reply from the db with this (and no error- nothing in fact *g*)
<?xml version="1.0" encoding="iso-8859-1" ?>
<html xmlns:c="http://java.sun.com/jsp/jstl/core"
xmlns:sql="http://java.sun.com/jsp/jstl/sql"
xmlns:fn="http://java.sun.com/jsp/jstl/functions" >
<head>
<title>Arschlochfickenseite</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
</head>
<body>
<sql:setDataSource dataSource='jdbc:mysql://localhost/eule,com.mysql.jdbc.Driver,root,test'
scope='session' var="books"/>
<!--
<sql:setDataSource dataSource='jdbc:mysql://localhost/eule,com.mysql.jdbc.Driver,root,test'
scope='session'/>
<sql:setDataSource
var = "books"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/eule"
user="root"
password="test"/>
<sql:query var="hurebabylons">
SELECT * FROM admin
</sql:query>
<sql:query>
<c:out value='SELECT * FROM admin'/>
</sql:query>
-->
<sql:transaction dataSource="books">
<!--
<sql:query var="books" >
<c:out value='SELECT * FROM admin'/>
</sql:query>
-->
<sql:update var="books">
<c:out value="INSERT into admin values ('user','pwd');"/>
</sql:update>
</sql:transaction>
<!--
<table width="200" border="1">
<th>Admin</th>
<th>Password</th>
<c:forEach items="${books.name}" var="row">
<tr>
<td> <c:out value=" ${row.name}"/> </td>
<td> <c:out value=" ${row.title}"/> </td>
</tr>
</c:forEach>
</table>
-->
<br></br>
<br></br>
</body>
</html>
i tried all the things commented but nothing worked..
thank u for your help.. i'm really kind of stuck..
thank u, bye
sylvia
technical university of vienna
jsp, mysql, cocoon and many other problems ;o)
