Hi to all,
today is my tests day :)
IN this page I make a query to mysql where the field "nick_name" is BINARY. With jstl I get this output: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED]
otherwise with jsp I get this: admin arnor nobody
My sql table: CREATE TABLE `user_comunity` ( `id_user` int(11) unsigned NOT NULL auto_increment, `nick_name` varchar(20) binary NOT NULL default '', PRIMARY KEY (`id_user`), UNIQUE KEY `nick_name` (`nick_name`) ) TYPE=MyIsam;
Follow the example page.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ taglib prefix="c" uri="/WEB-INF/tld/c.tld" %>
<%@ taglib prefix="sql" uri="/WEB-INF/tld/sql.tld" %>
<sql:query var="myQuery">
SELECT * FROM user_comunity
</sql:query><html xmlns="http://www.w3.org/1999/xhtml";> <head> <title>sql BINARY field wrong output</title> </head> <body> <!-- jstl output --> <c:forEach items="${myQuery.rows}" var="row"> <c:out value="${row.nick_name}"/><br /> </c:forEach> <!-- jsp output -->
<%
// init connection db
DataSource ds;
ResultSet rs = null;
Statement stmt = null;
String sql = "";
// search datasource
try {
Context context = new InitialContext();
ds = (DataSource) context.lookup("ds_croxit");
} catch (NamingException e) {
ds = null;
} Connection conn = ds.getConnection();
ResultSet m_rs = null;
PreparedStatement m_stmt = null; try{
// query
m_stmt = conn.prepareStatement("SELECT nick_name FROM user_comunity");
m_rs = m_stmt.executeQuery();
// print result set
while (m_rs.next() ) {
// Retrieve the BINARY field
String fieldValue = m_rs.getString("nick_name");
out.println(fieldValue +"<br/>");
}
// Close
m_rs.close();
m_stmt.close();
conn.close();
}catch (Exception ex){
response.getWriter().println(ex.toString());
ex.printStackTrace();
}
%>
</body>
</html>I use jrun4, jstl 1.0.5, mysql 4.0.x and sdk SunJava2-1.4.2
Can you confirm that?
regards Lorenzo Sicilia
-- KEMEN srl http://www.kemen.it
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
