jakarta-taglibs-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bay...@apache.org
Subject svn commit: r607682 - in /jakarta/taglibs/proper/standard/trunk/test: org/apache/taglibs/standard/tag/el/sql/Test43831.java web/org/apache/taglibs/standard/tag/el/sql/Test43831.jsp
Date Mon, 31 Dec 2007 06:09:31 GMT
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: taglibs-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-dev-help@jakarta.apache.org


Mime
View raw message