Author: bayard
Date: Sun Dec 30 22:09:31 2007
New Revision: 607682
URL: http://svn.apache.org/viewvc?rev=607682&view=rev
Log:
Unit test to show this bug - if it were run against mysql. Derby does not
exhibit the JDBC change that MySQL has
Added:
jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java
(with props)
jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
(with props)
Added:
jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java
URL:
http://svn.apache.org/viewvc/jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java?rev=607682&view=auto
==============================================================================
---
jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java
(added)
+++
jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java
Sun Dec 30 22:09:31 2007
@@ -0,0 +1,71 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.taglibs.standard.tag.el.sql;
+
+import java.sql.*;
+import javax.servlet.jsp.*;
+import org.apache.cactus.*;
+import org.apache.taglibs.standard.testutil.TestUtil;
+
+public class Test43831 extends JspTestCase {
+
+ public Test43831(String name) {
+ super(name);
+ }
+
+ protected void setUp() throws Exception {
+ super.setUp();
+ Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
+ Connection conn =
DriverManager.getConnection("jdbc:derby:cactustest;create=true");
+ Statement stmt = conn.createStatement();
+ try { stmt.execute("DROP TABLE Bug43831"); } catch(SQLException sqle)
{ } // ignore
+ stmt.execute("CREATE TABLE Bug43831 ( id int primary key, name
varchar(80) )");
+ stmt.execute("INSERT INTO Bug43831 VALUES(1, 'a')");
+
+ ResultSet rs = stmt.executeQuery("SELECT * FROM Bug43831");
+ rs.next();
+ assertEquals( 1, rs.getInt(1) );
+ assertEquals( "a", rs.getString(2) );
+
+ rs.close();
+ stmt.close();
+ conn.close();
+ }
+
+ protected void tearDown() throws Exception {
+ super.tearDown();
+ Connection conn = DriverManager.getConnection("jdbc:derby:cactustest");
+ Statement stmt = conn.createStatement();
+ stmt.execute("DROP TABLE Bug43831");
+ stmt.close();
+ conn.close();
+ }
+
+ public void test43831() throws Exception {
+ String toInclude = TestUtil.getTestJsp(this);
+ pageContext.include(toInclude);
+
+ String label = (String) pageContext.getAttribute("bug43831Label",
PageContext.APPLICATION_SCOPE);
+ String name = (String) pageContext.getAttribute("bug43831Name",
PageContext.APPLICATION_SCOPE);
+ String column = (String) pageContext.getAttribute("bug43831",
PageContext.APPLICATION_SCOPE);
+
+ assertEquals( "Failed to find 'label'", "a", label);
+ assertNull( "Failed to not find 'name'", name);
+ assertEquals( "Failed to find label as column name", "wonka",
column.toLowerCase());
+ }
+}
Propchange:
jakarta/taglibs/proper/standard/trunk/test/org/apache/taglibs/standard/tag/el/sql/Test43831.java
------------------------------------------------------------------------------
svn:eol-style = native
Added:
jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
URL:
http://svn.apache.org/viewvc/jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp?rev=607682&view=auto
==============================================================================
---
jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
(added)
+++
jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
Sun Dec 30 22:09:31 2007
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="ISO-8859-1"?>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"; %>
+<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"; %>
+
+
+ <sql:setDataSource url="jdbc:derby:cactustest"
driver="org.apache.derby.jdbc.EmbeddedDriver"/>
+
+ <sql:query var="db">
+ SELECT name as wonka FROM Bug43831
+ </sql:query>
+
+ <c:set var="bug43831Label" value="" scope="application"/>
+ <c:set var="bug43831Name" value="" scope="application"/>
+ <c:forEach var="row" items="${db.rows}">
+ <c:set var="bug43831Label" value="${row.wonka}" scope="application"/>
+ <c:set var="bug43831Name" value="${row.name}" scope="application"/>
+ </c:forEach>
+
+ <c:forEach var="columnName" items="${db.columnNames}">
+ <c:set var="bug43831" value="${columnName}" scope="application"/>
+ </c:forEach>
Propchange:
jakarta/taglibs/proper/standard/trunk/test/web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
------------------------------------------------------------------------------
svn:eol-style = native
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
