geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pra...@apache.org
Subject svn commit: r546621 - in /geronimo/samples/trunk/samples: ./ dbtester/ dbtester/dbtester-ear/ dbtester/dbtester-ear/src/ dbtester/dbtester-ear/src/main/ dbtester/dbtester-ear/src/main/resources/ dbtester/dbtester-ear/src/main/resources/META-INF/ dbtest...
Date Tue, 12 Jun 2007 20:12:59 GMT
Author: prasad
Date: Tue Jun 12 13:12:57 2007
New Revision: 546621

URL: http://svn.apache.org/viewvc?view=rev&rev=546621
Log:
* adding dbtester sample app

Added:
    geronimo/samples/trunk/samples/dbtester/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/
    geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_javadoc_off_116x19.gif   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_src_off_116x19.gif   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp   (with props)
    geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp   (with props)
    geronimo/samples/trunk/samples/dbtester/install-sample.html   (with props)
    geronimo/samples/trunk/samples/dbtester/pom.xml   (with props)
    geronimo/samples/trunk/samples/dbtester/src/
    geronimo/samples/trunk/samples/dbtester/src/main/
    geronimo/samples/trunk/samples/dbtester/src/main/resources/
Modified:
    geronimo/samples/trunk/samples/pom.xml

Added: geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml Tue Jun 12 13:12:57 2007
@@ -0,0 +1,86 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+    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.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+
+    <modelVersion>4.0.0</modelVersion>
+
+    <parent>
+        <groupId>org.apache.geronimo.samples</groupId>
+        <artifactId>dbtester</artifactId>
+        <version>2.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+
+    <artifactId>dbtester-ear</artifactId>
+    <name>Geronimo Samples :: dbtester :: EAR</name>
+    <packaging>ear</packaging>
+
+    <description>Geronimo Samples. EAR Module</description>
+
+    <dependencies>
+      <dependency>
+            <groupId>org.apache.geronimo.samples</groupId>
+            <artifactId>dbtester-war</artifactId>
+            <version>2.0-SNAPSHOT</version>
+            <type>war</type>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <artifactId>maven-ear-plugin</artifactId>
+                <configuration>
+                    <displayName>Geronimo Sample EAR for Testing DB</displayName>
+                    <description>Geronimo Sample EAR for Testing DB</description>
+                    <version>5</version>
+                    <modules>
+                        <webModule>
+                            <groupId>org.apache.geronimo.samples</groupId>
+                            <artifactId>dbtester-war</artifactId>
+                            <contextRoot>/dbtester</contextRoot>
+                            <bundleFileName>dbtester-war-2.0-SNAPSHOT.war</bundleFileName>
+                        </webModule>
+                    </modules>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+
+    <profiles>
+        <profile>
+            <id>user</id>
+            <build>
+                <plugins>
+                    <plugin>
+                        <groupId>org.apache.geronimo.plugins</groupId>
+                        <artifactId>geronimo-maven-plugin</artifactId>
+                    </plugin>
+                </plugins>
+            </build>
+        </profile>
+    </profiles>
+
+
+</project>
+

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/pom.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Added: geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml Tue Jun 12 13:12:57 2007
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+    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.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<application xmlns="http://geronimo.apache.org/xml/ns/j2ee/application-1.2">
+
+    <environment xmlns="http://geronimo.apache.org/xml/ns/deployment-1.2">
+        <moduleId>
+            <groupId>${pom.groupId}</groupId>
+            <artifactId>${pom.artifactId}</artifactId>
+            <version>2.0-SNAPSHOT</version>
+            <type>ear</type>
+        </moduleId>
+    </environment>
+
+</application>

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-ear/src/main/resources/META-INF/geronimo-application.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml Tue Jun 12 13:12:57 2007
@@ -0,0 +1,98 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+    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.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+
+    <modelVersion>4.0.0</modelVersion>
+
+    <parent>
+        <groupId>org.apache.geronimo.samples</groupId>
+        <artifactId>dbtester</artifactId>
+        <version>2.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+
+    <artifactId>dbtester-war</artifactId>
+    <name>Geronimo Samples :: dbtester :: WAR</name>
+    <packaging>war</packaging>
+
+    <description>Geronimo Samples. WEB Module</description>
+
+    <dependencies>
+        <dependency>
+            <groupId>org.apache.geronimo.specs</groupId>
+            <artifactId>geronimo-j2ee_1.4_spec</artifactId>
+            <version>1.1</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>geronimo</groupId>
+            <artifactId>geronimo-kernel</artifactId>
+            <version>1.1</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>geronimo</groupId>
+            <artifactId>geronimo-connector</artifactId>
+            <version>1.1</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>geronimo</groupId>
+            <artifactId>geronimo-management</artifactId>
+            <version>1.1</version>
+            <scope>provided</scope>
+        </dependency>
+        <dependency>
+            <groupId>mx4j</groupId>
+            <artifactId>mx4j</artifactId>
+            <version>3.0.1</version>
+            <scope>provided</scope>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-antrun-plugin</artifactId>
+                <executions>
+                    <execution>
+                        <phase>process-resources</phase>
+                        <id>copy-parent-site</id>
+                        <goals>
+                            <goal>run</goal>
+                        </goals>
+                        <configuration>
+                            <tasks>
+                                <echo>Copying site directory from parent</echo>
+                                <copy todir="${project.build.directory}/${pom.artifactId}-2.0-SNAPSHOT" failonerror="false" overwrite="true">
+                                    <fileset dir="${pom.basedir}/../target/site"/>
+                                </copy>
+                            </tasks>
+                        </configuration>
+                    </execution>
+                </executions>
+            </plugin>
+        </plugins>
+    </build>
+</project>

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/pom.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java Tue Jun 12 13:12:57 2007
@@ -0,0 +1,154 @@
+package org.apache.geronimo.samples.dbtester.beans;
+
+import java.sql.Connection;
+import java.sql.DatabaseMetaData;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+
+import javax.sql.DataSource;
+
+import org.apache.geronimo.connector.outbound.ConnectionFactorySource;
+import org.apache.geronimo.gbean.AbstractName;
+import org.apache.geronimo.gbean.AbstractNameQuery;
+import org.apache.geronimo.kernel.GBeanNotFoundException;
+import org.apache.geronimo.kernel.InternalKernelException;
+import org.apache.geronimo.kernel.Kernel;
+import org.apache.geronimo.kernel.KernelRegistry;
+import org.apache.geronimo.kernel.NoSuchOperationException;
+
+public class DBManagerBean {
+	
+	private Map poolMap;
+	private Map tableMap;
+	
+	public DBManagerBean(){
+		poolMap = new HashMap();
+		init();
+	}
+	
+	private void init(){
+		Kernel kernel = KernelRegistry.getSingleKernel();
+		Set cfList = kernel.listGBeans(new AbstractNameQuery(ConnectionFactorySource.class.getName()));
+		
+		for(Iterator iterator = cfList.iterator();iterator.hasNext();){
+
+			AbstractName name = (AbstractName)iterator.next();
+			try {
+				Object rs = kernel.invoke(name, "$getResource", new Object[]{}, new String[]{});
+				
+				if(rs instanceof javax.sql.DataSource){
+					DataSource ds = (DataSource)rs;	
+					poolMap.put(name.getArtifact().getArtifactId(), ds);
+				}
+			} catch (GBeanNotFoundException e) {
+				e.printStackTrace();
+			} catch (NoSuchOperationException e) {
+				e.printStackTrace();
+			} catch (InternalKernelException e) {
+				e.printStackTrace();
+			} catch (Exception e) {
+				e.printStackTrace();
+			}
+		}
+	}
+	
+	public Map getDeployedPools(){
+		return poolMap;
+	}
+	
+	public Map getTableList(String poolName) throws SQLException {
+		
+		tableMap = new HashMap();
+		
+		if(poolMap.containsKey(poolName)){
+			DataSource ds = (DataSource)poolMap.get(poolName);
+			Connection con = null;
+			try {
+				
+				con = ds.getConnection();
+				
+				DatabaseMetaData metaData = con.getMetaData();
+				String[] tableTypes = {"TABLE"};
+				ResultSet rs = metaData.getTables(null, null, null, tableTypes);
+				
+				while(rs.next()){
+					String schemaName = rs.getString("TABLE_SCHEM");
+					String tableName = rs.getString("TABLE_NAME"); 
+					ArrayList tableList = null;
+					
+					if(tableMap.containsKey(schemaName)){
+						tableList = (ArrayList)tableMap.get(schemaName);
+						tableList.add(tableName);
+					}else {
+						tableList = new ArrayList();
+						tableList.add(tableName);
+					}
+					tableMap.put(schemaName, tableList);
+				}
+			} catch (SQLException e) {
+				throw e;
+			}finally {
+				if(con != null){
+					try {
+						con.close();
+					} catch (SQLException e) {
+						e.printStackTrace();
+					}
+				}
+			}
+		}
+		
+		return tableMap;
+	}
+	
+	public List getTableContents(String poolName, String schemaName, String tableName) throws SQLException {
+		
+		ArrayList matrix = new ArrayList();
+		
+		DataSource ds = (DataSource)poolMap.get(poolName);
+		Connection con = null;
+			
+		con = ds.getConnection();
+			
+		String SQL = "SELECT * FROM ";
+		
+		if(schemaName == null || schemaName.equals("null")){
+			SQL+= tableName; //Problem comes with MySQL 
+		}else {
+			SQL+= (schemaName+"."+tableName);
+		}
+			
+		PreparedStatement pStmt = con.prepareStatement(SQL);
+		ResultSet rs = pStmt.executeQuery();
+			
+		ResultSetMetaData metaData = rs.getMetaData();
+		int columns = metaData.getColumnCount();
+			
+		ArrayList header = new ArrayList();
+		for(int i=1; i<= columns; i++){
+			String colName = metaData.getColumnLabel(i);
+			header.add(colName);
+		}
+		matrix.add(header);
+			
+		while(rs.next()){				
+			ArrayList row = new ArrayList();
+				
+			for(int i=1; i<= columns;i++){
+				row.add(rs.getString(i));
+			}
+				matrix.add(row);
+		}
+		
+		return matrix;
+	}
+	
+}

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/beans/DBManagerBean.java
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java Tue Jun 12 13:12:57 2007
@@ -0,0 +1,53 @@
+package org.apache.geronimo.samples.dbtester.web;
+
+import java.io.IOException;
+import java.sql.SQLException;
+import java.util.List;
+
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServlet;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.apache.geronimo.samples.dbtester.beans.DBManagerBean;
+
+
+public class ContentTableServlet extends HttpServlet {
+	
+	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		getContent(request, response);
+	}
+	
+	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		doGet(request,response);
+	}
+	
+	private void getContent(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		
+		String poolName = request.getParameter("poolName");
+		String schemaName = request.getParameter("schemaName");
+		String tableName = request.getParameter("tableName");
+		
+		
+		String path = "/jsp/common_error.jsp";
+		
+		try {
+			DBManagerBean dbManager = (DBManagerBean)request.getSession().getAttribute("dbManager");
+			List tableContent = dbManager.getTableContents(poolName, schemaName, tableName);
+			
+			request.setAttribute("poolName", poolName);
+			request.setAttribute("tableName", tableName);
+			request.setAttribute("tableContent", tableContent);
+			
+			path = "/jsp/table_content.jsp";
+			
+		} catch (SQLException e) {
+			e.printStackTrace();
+			request.setAttribute("error", e);
+		}
+		
+		request.setAttribute("poolName", poolName);
+		getServletContext().getRequestDispatcher(path).forward(request,response);
+	}
+	
+}
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ContentTableServlet.java
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java Tue Jun 12 13:12:57 2007
@@ -0,0 +1,45 @@
+package org.apache.geronimo.samples.dbtester.web;
+
+import java.io.IOException;
+import java.sql.SQLException;
+import java.util.Map;
+
+import javax.servlet.ServletException;
+import javax.servlet.http.HttpServlet;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.apache.geronimo.samples.dbtester.beans.DBManagerBean;
+
+public class ListTablesServlet extends HttpServlet{
+	
+	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		listTables(request, response);
+	}
+	
+	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		doGet(request,response);
+	}
+	
+	private void listTables(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
+		
+		String poolName = request.getParameter("poolname");
+		
+		String path = "/jsp/common_error.jsp";
+		
+		try {
+			DBManagerBean dbManager = (DBManagerBean)request.getSession().getAttribute("dbManager");
+			Map tableMap = dbManager.getTableList(poolName);
+			
+			request.setAttribute("tableMap", tableMap);
+			
+			path = "/jsp/table_list.jsp";
+			
+		} catch (SQLException e) {
+			e.printStackTrace();
+			request.setAttribute("error", e);
+		}
+		request.setAttribute("poolName", poolName);
+		getServletContext().getRequestDispatcher(path).forward(request,response);
+	}
+}

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/java/org/apache/geronimo/samples/dbtester/web/ListTablesServlet.java
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml Tue Jun 12 13:12:57 2007
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+    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.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
+
+    <description>dbtester Servlet Sample</description>
+    <servlet>
+	    <display-name>ContentTableServlet</display-name>
+	    <servlet-name>ContentTableServlet</servlet-name>
+		<servlet-class>org.apache.geronimo.samples.dbtester.web.ContentTableServlet</servlet-class>
+  	</servlet>
+	
+	<servlet>
+	    <display-name>ListTablesServlet</display-name>
+	    <servlet-name>ListTablesServlet</servlet-name>
+		<servlet-class>org.apache.geronimo.samples.dbtester.web.ListTablesServlet</servlet-class>
+  	</servlet>
+  	
+    <servlet-mapping>
+	    <servlet-name>ContentTableServlet</servlet-name>
+	    <url-pattern>/listContent</url-pattern>
+    </servlet-mapping>
+	
+	<servlet-mapping>
+	    <servlet-name>ListTablesServlet</servlet-name>
+	    <url-pattern>/listTables</url-pattern>
+    </servlet-mapping>
+
+    <welcome-file-list>
+        <welcome-file>index.html</welcome-file>
+    </welcome-file-list>
+
+</web-app>

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/WEB-INF/web.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css Tue Jun 12 13:12:57 2007
@@ -0,0 +1,494 @@
+body 
+{
+	/*background-color: #FFFFFF;*/
+}
+
+.BrightTitle
+{
+	color: #FFFFFF;
+	background-color: #5FA3D6;
+	font-size: 11px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+}
+
+.BrightTitle a:hover
+{
+	color: #5FA3D6;
+}
+
+.BrightBox
+{
+	border: thin solid #5FA3D6;
+}
+
+td
+{
+	font-size: 11px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+}
+
+a:link, a:visited
+{
+	color: #204486;
+}
+
+a:hover 
+{
+	/*color: #5FA3D6;*/
+	color: #CF820A;
+}
+
+.Logo
+{
+	background-image:url("images/head_left_754x86.gif");
+	background-repeat: no-repeat;
+	width: 570px;
+	height: 86px;
+	font-size: 35px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	text-align: right;
+	vertical-align: bottom; 
+	line-height: 30px;
+	font-weight: bold;
+}
+
+.LoginLogo
+{
+	background-image:url("images/head_left_login_586x86.gif");
+	background-repeat: no-repeat;
+	width: 570px;
+	height: 86px;
+	font-size: 35px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	text-align: right;
+	vertical-align: bottom; 
+	line-height: 30px;
+	font-weight: bold;
+}
+
+.Top
+{
+	background-image:url("images/head_bgstretch_1x86.gif");
+	background-repeat: repeat-x;
+	height: 86px;
+	font-size: 11px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	text-align: right;
+	vertical-align: bottom;
+	font-weight: bold;
+}
+
+.Top a:link, .Top a:visited, .Top a:hover
+{
+        color: #FFFFFF;
+        font-size: 11px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+        text-decoration: underline;
+        text-align: left;
+        vertical-align: bottom;
+        line-height: 30px;
+        font-weight: bold;
+}
+
+.TopSpacer
+{
+	height: 20px;
+}
+
+.Hidden
+{
+	visibility: hidden;
+	height: 0px;
+	line-height: 0px;
+	display: none;
+}
+
+.Menu .Selection
+{
+        background-color: #F2F2F2;
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+}
+
+.Menu .Selection .CollapsedLeft
+{
+	width: 12px;
+	height: 12px;
+	color: #000000;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .Indent
+{
+	width: 2px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .CollapsedRight
+{
+	width: 8px;
+	height: 12px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .TopLeft
+{
+	width: 8px;
+	height: 16px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .TopMiddle
+{
+	color: #000000;
+	text-decoration: none;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .TopMiddle a:link, 
+.Menu .Selection .TopMiddle a:visited, 
+{
+	color: #000000;
+	line-height: 20px;
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .TopMiddle a:hover
+{
+	color: #5FA3D6;
+}
+
+.Menu .Selection .TopRight
+{
+	width: 8px;
+	height: 16px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Selection .Spacer
+{
+	height: 5px;
+}
+
+.Menu .Hidden
+{
+	visibility: hidden;
+	height: 0px;
+	display: none;
+}
+
+.Menu .Subselection .Left
+{
+	width: 12px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Subselection .Indent
+{
+	width: 2px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Subselection .Middle
+{
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+        background-color: #F2F2F2;
+	color:#000000;
+}
+
+.Menu .Subselection .Middle a:link, 
+.Menu .Subselection .Middle a:visited, 
+{
+	line-height: 20px;
+	color: #000000;
+}
+
+.Menu .Subselection .Middle a:hover
+{
+	color: #5FA3D6;
+}
+
+.Menu .Subselection .Right
+{
+	width: 8px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Subselection .BottomLeft
+{
+	width: 8px;
+	height: 8px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Subselection .BottomMiddle
+{
+	height: 8px;
+        background-color: #F2F2F2;
+}
+
+.Menu .Subselection .BottomRight
+{
+	width: 8px;
+	height: 8px;
+        background-color: #F2F2F2;
+}
+
+.Menu .SelectedSubselection .Middle a{
+    color: #000;
+    text-decoration: none;
+}
+
+.Menu .SelectedSubselection .Middle a:hover{
+    color: #000;
+    text-decoration: underline;
+}
+
+.Gutter
+{
+	width: 5px;
+}
+
+.Content .TopLeft
+{
+	width: 18px;
+	height: 18px;
+	line-height: 18px;
+        background-color: #000000;
+}
+
+.Content .Title
+{
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	background-color: #000000;
+	color: #FFFFFF;
+	height: 18px;
+	line-height: 18px;
+}
+
+.Content .Title a:link, .Content .Title a:hover, .Content .Title a:visited
+{
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	background-color: #000000;
+	color: #FFFFFF;
+	height: 18px;
+	line-height: 18px;
+}
+
+.Content .Title .Indent
+{
+	width: 20px;
+}
+
+.Content .TopRight
+{
+	width: 18px;
+	height: 18px;
+        background-color:#000000;
+}
+
+.Content .CollapsedLeft
+{
+	width: 18px;
+	height: 18px;
+        background-color:#000000;
+}
+
+.Content .CollapsedRight
+{
+	width: 18px;
+	height: 18px;
+        background-color:#000000;
+}
+
+.Content .Left
+{
+	width: 18px;
+	background-color: #FFFFFF;
+}
+
+.Content .Body, .Content .Body td
+{
+	font-size: 12px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	background-color: #FFFFFF;
+	color: #1E1E52;
+}
+
+.Content .Body strong
+{
+	font-weight: bold;  
+	font-size: 12px;
+}
+
+.Content .Body th
+{
+	font-weight: bold;  
+	font-size: 12px;
+}
+
+.Content .Body .LightBackground
+{
+        background-color: #FFFFFF;
+	color:#000000;
+}
+
+.Content .Body .LightBackground .InputField
+{
+  width: 150px;
+}
+
+.Content .Body .MediumBackground
+{
+	background-color: #F2F2F2;
+	color:#000000;
+}
+
+.Content .Body .DarkBackground, 
+.Content .Body .DarkBackground a:link, 
+.Content .Body .DarkBackground a:visited,
+.Content .Body .DarkBackground a:hover
+{
+	background-color: #2581C7;
+	color:#FFFFFF;
+	font-size: 15px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+}
+
+.Content .Body .reallyDarkBackground,
+.Content .ReallyDarkBackground,
+.ReallyDarkBackground
+{
+	color: #FFFFFF;
+	background-color: #000000;
+	font-size: 15px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+}
+
+.Content .Body .IndentedTitle
+{
+	background-color: #919FBC;
+	color:#FFFFFF;
+}
+
+.Content .Body .LightIndentedBG
+{
+	background-color: #FFFFFF;
+	color:#000000;
+}
+
+.Content .Body .MediumIndentedBG
+{
+	background-color: #DDDDDD;
+	color:#000000;
+}
+
+
+.Content .Body a:link,
+.Content .Body a:visited,
+{
+	font-size: 10px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	text-decoration: underline;
+	color: #546BC7;
+	font-weight: bold;
+}
+
+.Content .Body a:hover
+{
+	color: #5FA3D6;
+}
+
+.Content .Buttons {
+	border-top-width: thin;
+	border-right-width: thin;
+	border-bottom-width: thin;
+	border-left-width: thin;
+	border-top-style: solid;
+	border-right-style: solid;
+	border-bottom-style: solid;
+	border-left-style: solid;
+	border-top-color: #7B7BAE;
+	border-right-color: #7B7BAE;
+	border-bottom-color: #141336;
+	border-left-color: #141336;
+	background-color: #23224C;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	font-size: 12px;
+  text-decoration: underline;
+	color: #5FA3D6;
+}
+
+.Content .Right
+{
+	width: 18px;
+	background-color: #FFFFFF;
+}
+
+.Content .BottomLeft
+{
+	width: 18px;
+	height: 12px;
+	line-height: 12px;
+	background-color:#333366;
+}
+
+.Content .Footer
+{
+	line-height: 12px;
+	height: 12px;
+	font-size: 9px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	background-color:#333366;
+	color:#000000;
+}
+
+.Content .Footer a:link,
+.Content .Footer a:visited,
+.Content .Footer a:hover
+{
+	color: #5FA3D6;
+}
+
+.Content .BottomRight
+{
+	width: 18px;
+	line-height: 12px;
+	height: 12px;
+	background-color:#333366;
+}
+
+.Content .Spacer
+{
+	height: 10px;
+}
+
+.BottomSpacer
+{
+}
+
+.Footer
+{
+	font-size: 9px;
+	font-family: Verdana, Tahoma, Arial, Helvetica, sans-serif;
+	height: 20px;
+	background-color: #5FA3D6;
+}
+
+.Footer a:link, 
+.Footer a:visited, 
+.Footer a:hover
+{
+	color: #5FA3D6;
+	text-decoration: underline;	
+}
+
+.Box
+{
+	border: thin solid #000000;
+}

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/css/main.css
------------------------------------------------------------------------------
    svn:mime-type = text/css

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp Tue Jun 12 13:12:57 2007
@@ -0,0 +1,90 @@
+<%@ page import="java.util.Map" %>
+<%@ page import="java.util.Iterator" %>
+<jsp:useBean id="dbManager" scope="session" class="org.apache.geronimo.samples.dbtester.beans.DBManagerBean" /> 
+<SCRIPT TYPE="text/javascript">
+<!--
+function popup(mylink, windowname)
+{
+leftVal = (screen.width - 400) / 2;
+topVal = (screen.height - 200) / 2;
+if (! window.focus)return true;
+var href;
+if (typeof(mylink) == 'string')
+   href=mylink;
+else
+   href=mylink.href;
+window.open(href, windowname, 'width=400,height=200,left='+leftVal+',top='+topVal);
+return false;
+}
+//-->
+</SCRIPT>
+<html>
+<head>
+<title>Database Testing Application</title>
+<link rel="stylesheet" href="css/main.css" type="text/css">
+</head>
+<body>
+<br>
+<div class="Content" align="center">
+<table>
+	<tr>
+		<td class="Title"><strong>Database Testing Application</strong></td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">
+		<p>
+		This sample application lists all the database connection pools defined in Geronimo. 
+		You can select any of these connection pools and test connectivity against the database as 
+		well as listing existing schemas and tables.
+		</p>
+		<p>
+		The list of database pools deployed in your Geronimo application server are given below. 
+		</p>
+		<p>
+		To test one of these pools, click the <strong>test</strong> link corresponding to that pool. 
+		If tested successfully, then a list of the schemas and databases found in that particular pool will be displayed.
+		</p>
+		</td>
+	<tr>
+	<table>
+		<tr>
+			<td class="Body">
+			<table width="100%">				
+				<%
+				Map poolMap = dbManager.getDeployedPools();
+				if(poolMap.keySet().size() > 0){
+				%>
+				<tr>
+					<td class="DarkBackground">Pool Name</td>
+					<td class="DarkBackground">Action</td>
+				</tr>
+				<%
+					int counter = 1;
+					for(Iterator iterator = poolMap.keySet().iterator();iterator.hasNext();counter++){	
+				%>
+				<tr>	
+				<%	
+					String poolName = (String)iterator.next();
+					String rowColor = "LightBackground";					
+					if(counter%2 == 0){
+						rowColor = "MediumBackground";
+					}
+				%>
+				<td class="<%=rowColor%>"><%=poolName%></td>
+				<td class="<%=rowColor%>"><a href="listTables?poolname=<%=poolName%>">test</a></td>
+				</tr>
+				<%	
+					}	
+				} 
+				%>
+			</table>
+			</td>
+		<tr>
+	</table>
+</table>
+</div>
+<br>
+<br>
+</body>
+</html>
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/dbtester.jsp
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html Tue Jun 12 13:12:57 2007
@@ -0,0 +1,69 @@
+<!--
+   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.
+-->
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd class="cell"">
+<html>
+<head>
+  <title>A Sample</title>
+  <meta content="text/html; CHARSET=iso-8859-1" http-equiv="Content-Type">
+</head>
+<body leftmargin="0" topmargin="0" bgcolor="#ffffff" marginwidth="0" marginheight="0" text="#000000" link="#000000" vlink="#666666">
+<table valign="top" border="0" cellspacing="0" cellpadding="0" width="100%" background="http://geronimo.apache.org/images/header_bg_1x86.gif">
+  <tr>
+    <td class="cell" valing="top" align="left"><img src="http://geronimo.apache.org/images/topleft_logo_437x64.gif" border="0"></td>
+    <td class="cell" width="100%">&nbsp;</td>
+    <td class="cell" valign="top" align="right"><img src="http://geronimo.apache.org/images/subnav_angle_15x18.gif" width="15" height="18" alt="" border="0"></td>
+    <td class="cell" valign="top" align="right"><a href="http://mail-archives.apache.org/mod_mbox/geronimo-user/">
+      <img src="http://geronimo.apache.org/images/subnav_userlist_55x18.gif" width="55" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://mail-archives.apache.org/mod_mbox/geronimo-dev/">
+      <img src="http://geronimo.apache.org/images/subnav_devlist_59x18.gif" width="59" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://cwiki.apache.org/geronimo">
+      <img src="http://geronimo.apache.org/images/subnav_wiki_39x18.gif" width="39" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://issues.apache.org/jira/browse/GERONIMO">
+      <img src="http://geronimo.apache.org/images/subnav_issue_83x18.gif" width="83" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://www.epiqtech.com"><img src="http://geronimo.apache.org/images/subnav_graph_95x18.gif" width="95" height="18" alt="" border="0"></a></td>
+  </tr>
+</table>
+<table valign="top" border="0" cellspacing="0" cellpadding="0" width="100%" background="http://geronimo.apache.org/images/menu_bgstretch_1x22.gif">
+    <tr align="left">
+        <td valign="top">
+            <a href="index.html"><img src="http://geronimo.apache.org/images/menu_home_off_63x19.gif" width="63" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="documentation.html"><img src="http://geronimo.apache.org/images/menu_doc_off_116x19.gif" width="116" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="downloads.html"><img src="http://geronimo.apache.org/images/menu_download_off_85x19.gif" width="85" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="get-involved.html"><img src="http://geronimo.apache.org/images/menu_comm_off_96x19.gif" width="96" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="development.html"><img src="http://geronimo.apache.org/images/menu_dev_off_104x19.gif" width="104" height="19" border="0"></a>
+        </td>
+        <td width="95%">
+                &nbsp;
+        </td>
+        <td valign="top" align="right">
+            <a href="xref/index.html" target="source_window"><img src="./images/menu_src_off_116x19.gif" width="116" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="right">
+            <a href="apidocs/index.html" target="source_window"><img src="./images/menu_javadoc_off_116x19.gif" width="116" height="19" border="0"></a>
+        </td>
+    </tr>
+</table>
+</BODY>
+</HTML>

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/header.html
------------------------------------------------------------------------------
    svn:mime-type = text/html

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_javadoc_off_116x19.gif
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_javadoc_off_116x19.gif?view=auto&rev=546621
==============================================================================
Binary file - no diff available.

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_javadoc_off_116x19.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_src_off_116x19.gif
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_src_off_116x19.gif?view=auto&rev=546621
==============================================================================
Binary file - no diff available.

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/images/menu_src_off_116x19.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html Tue Jun 12 13:12:57 2007
@@ -0,0 +1,29 @@
+<!--
+   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.
+-->
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd class="cell"">
+<html>
+<head>
+  <title>A Sample</title>
+  <meta content="text/html; CHARSET=iso-8859-1" http-equiv="Content-Type">
+</head>
+
+<FRAMESET rows="12%,90%" title="" frameborder="no">
+    <FRAME src="./header.html" name="headerFrame" title="Header">
+    <FRAME src="./dbtester.jsp" name="sampleDocumentFrame" title="Sample Document Description">
+</FRAMESET>
+  
+</html>

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/index.html
------------------------------------------------------------------------------
    svn:mime-type = text/html

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp Tue Jun 12 13:12:57 2007
@@ -0,0 +1,46 @@
+<%@ page import="java.sql.SQLException" %>
+<%@ page import="java.io.StringWriter" %>
+<%@ page import="java.io.PrintWriter" %>
+
+<html>
+<head>
+<title>Error Occurs</title>
+<link rel="stylesheet" href="css/main.css" type="text/css">
+</head>
+<body>
+<br>
+<div class="Content" align="center">
+	<table>
+	<tr>
+		<td class="Title">Error Occurs !!!</td>
+	</tr>
+	<tr></tr>
+	<%
+		String poolName = (String)request.getAttribute("poolName");
+		SQLException error = (SQLException)request.getAttribute("error");
+	%>
+	<tr>
+		<td class="Body">
+			<strong>Following error occurs in executing your operation in <%=poolName%> pool.</strong>
+		</td>
+	</tr>
+	<tr></tr>
+	<%
+	  if(error != null){
+		  StringWriter sw = new StringWriter(2000);
+		  PrintWriter pw = new PrintWriter(sw);
+	  	  error.printStackTrace(pw);
+	%>
+	<tr>
+		<td class="Body">
+		<%=sw.toString()%>
+		</td>
+	</tr>
+	<%  	  
+	  }
+	%>
+	</table>
+</div>
+</body>
+</head>
+</html>
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/common_error.jsp
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp Tue Jun 12 13:12:57 2007
@@ -0,0 +1,68 @@
+<SCRIPT TYPE="text/javascript">
+<!--
+function testConnection()
+{	
+	username = document.getElementById('entry_form').username.value;
+	password = document.getElementById('entry_form').password.value;
+	poolname = document.getElementById('entry_form').pool.value;
+	
+	if(username == ""){
+		username = "null";
+	}
+	
+	if(password == ""){
+		password = "null";
+	}
+	
+	window.opener.location="../listTables?poolname="+poolname+"&username="+username+"&password="+password;
+	window.close();	
+}
+//-->
+</SCRIPT>
+<html> 
+<head>
+<title>Database Pool Credentials</title>
+<link rel="stylesheet" href="../css/main.css" type="text/css">
+</head>
+<body>
+<form action="" id="entry_form">
+<%
+	String poolName = (String)request.getParameter("poolname");
+%>
+<input type="hidden" name="pool" value="<%=poolName%>">
+<div class="Content" align="center">
+<table>
+	<tr>
+		<td class="Title"><strong>Database Pool Credentials</strong></td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">
+		This tests used all the values defined in the database connection pool.
+		If you want to specify a different user name and password you may enter these values now to override the values in the pool.
+		Otherwise just click <strong>Test Pool</strong>.
+		</td>
+	</tr>
+	<tr>
+		<td class="MediumBackground">
+			<table>
+			<tr>
+				<td align="right" class="MediumBackground"><strong>Username:</strong></td>
+				<td><input type="text" name="username" class="InputField"></td>
+			</tr>
+			<tr>
+				<td align="right" class="MediumBackground"><strong>Password:</strong></td>
+				<td><input type="password" name="password" class="InputField"></td>
+			</tr>
+  			<tr>
+  				<td></td>
+				<td><input type="button" value="Test Pool" onClick="testConnection()"></td>
+			<tr>
+		</td>
+	</tr>
+</table>
+</div>
+</form>
+</body>
+</head>
+</html>
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/popup.jsp
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp Tue Jun 12 13:12:57 2007
@@ -0,0 +1,78 @@
+<%@ page import="java.util.ArrayList" %>
+<%@ page import="java.util.HashMap" %>
+<%@ page import="java.util.Iterator" %>
+<html>
+<head>
+<title>Table Content</title>
+<link rel="stylesheet" href="css/main.css" type="text/css">
+</head>
+<body>
+<center>
+<br>
+<div class="Content">
+<%
+	String poolName = (String)request.getAttribute("poolName");
+	String tableName = (String)request.getAttribute("tableName");
+	ArrayList content = (ArrayList)request.getAttribute("tableContent");	
+%>
+<table>
+	<tr>
+		<td class="Title"><strong>Contents of <%=tableName%> Table</strong></td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">	
+			<p>
+				The content of <%=tableName%> Table from your <%=poolName%> pool.
+			</p>
+		</td>
+	<tr>
+	<td class="Body">
+		<table align="center">
+		<tr>
+		 <%
+		 	ArrayList header = (ArrayList)content.get(0);
+		 	for(int i=0; i<header.size(); i++){
+		 		String headerName = (String)header.get(i);
+		 	%>
+		 	<td class="DarkBackground"><%=headerName%></td>
+		 	<%	
+		 	}
+		 %>
+		 </tr>
+		  <%
+		  	for(int i=1; i<content.size(); i++){
+		  		ArrayList row = (ArrayList)content.get(i);
+		  		String rowColor = "LightBackground";
+		  		if(i%2 == 0){
+		  			rowColor = "MediumBackground";
+		  		}
+		  	%>
+		  	<tr>
+		  	<%	
+		  		for(int j=0; j<row.size(); j++){
+		  			String element = (String)row.get(j);
+		  			%>
+		  			<td class="<%=rowColor%>"><%=element%></td>
+		  			<%
+		  		}
+		  	}
+		  %>
+		 </table>
+	</td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">
+		<center>
+		<div> 
+		<a href="../dbtester/dbtester.jsp" target="sampleDocumentFrame"><strong>Test Another Pool</strong></a>
+		</div>
+		</center>
+		</td>
+	</tr>
+</table>
+</div>			
+</center>
+</body>
+</html>
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_content.jsp
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp (added)
+++ geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp Tue Jun 12 13:12:57 2007
@@ -0,0 +1,89 @@
+<%@ page import="java.util.ArrayList" %>
+<%@ page import="java.util.HashMap" %>
+<%@ page import="java.util.Iterator" %>
+<html>
+<head>
+<title>Schemas and Tables</title>
+<link rel="stylesheet" href="css/main.css" type="text/css">
+</head>
+<body>
+<center>
+<br>
+<div class="Content">
+<table>
+	<tr>
+		<td class="Title"><strong>Schemas and Tables</strong></td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">	
+			<p>
+				Displayed below are the list of Schemas and their Tables, from your database. 
+				To view the content of each table click on <strong>list</strong> link.
+			</p>
+		</td>
+	<tr>
+	<td class="Body">
+		<table align="center">
+		 <%
+		 String poolName = (String)request.getAttribute("poolName");
+		 String userName = (String)request.getAttribute("username");
+		 String password = (String)request.getAttribute("password");
+		 
+		 HashMap tableMap = (HashMap)request.getAttribute("tableMap"); 
+		 for(Iterator iterator1 = tableMap.keySet().iterator(); iterator1.hasNext();){
+		 	String schemaName = (String)iterator1.next();
+		 %>
+		 
+		 <%
+		 	String displayName = "    ";
+		 	if(schemaName != null){
+		 		displayName = schemaName;// since MySQL returns it as null and it's ugly :)
+		 	}
+		 %>
+		 
+			 <tr>
+			 	<td class="DarkBackground">Schema:</td>
+			 	<td class="DarkBackground"><%=displayName%></td>
+			 </tr>
+			 
+			 <%
+			 	ArrayList tableList = (ArrayList)tableMap.get(schemaName);
+			 	int counter = 1;
+			 	for(Iterator iterator2 = tableList.iterator(); iterator2.hasNext();counter++){
+			 		String tableName = (String)iterator2.next();
+			 		String rowColor = "LightBackground";
+			 		if(counter%2 == 0){
+			 			rowColor = "MediumBackground";
+			 		}
+			 		%>
+			 		<tr>
+			 			<td class="<%=rowColor%>"><%=tableName%></td>
+			 			<td class="<%=rowColor%>"><a href="listContent?poolName=<%=poolName%>&schemaName=<%=schemaName%>&tableName=<%=tableName%>&username=<%=userName%>&password=<%=password%>">list</a></td>
+			 		</tr>
+			  		<%
+			 	}
+			 %>
+			 <%	
+			 }
+			  %>
+			 <tr>
+			 </tr>
+		</table>
+	</td>
+	</tr>
+	<tr></tr>
+	<tr>
+		<td class="Body">
+		<center>
+		<div> 
+		<a href="../dbtester/dbtester.jsp" target="sampleDocumentFrame"><strong>Test Another Pool</strong></a>
+		</div>
+		</center>
+		</td>
+	</tr>
+</table>
+</div>			
+</center>
+</body>
+</html>
\ No newline at end of file

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/dbtester-war/src/main/webapp/jsp/table_list.jsp
------------------------------------------------------------------------------
    svn:mime-type = text/plain

Added: geronimo/samples/trunk/samples/dbtester/install-sample.html
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/install-sample.html?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/install-sample.html (added)
+++ geronimo/samples/trunk/samples/dbtester/install-sample.html Tue Jun 12 13:12:57 2007
@@ -0,0 +1,127 @@
+<!--
+   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.
+-->
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd class="cell"">
+<html>
+<head>
+  <title>Installing a Geronimo sample</title>
+  <meta content="text/html; CHARSET=iso-8859-1" http-equiv="Content-Type">
+  </style>
+</head>
+
+<body leftmargin="0" topmargin="0" bgcolor="#ffffff" marginwidth="0" marginheight="0" text="#000000" link="#000000" vlink="#666666">
+<table valign="top" border="0" cellspacing="0" cellpadding="0" width="100%" background="http://geronimo.apache.org/images/header_bg_1x86.gif">
+  <tr>
+    <td class="cell" valing="top" align="left"><img src="http://geronimo.apache.org/images/topleft_logo_437x64.gif" border="0"></td>
+    <td class="cell" width="100%">&nbsp;</td>
+    <td class="cell" valign="top" align="right"><img src="http://geronimo.apache.org/images/subnav_angle_15x18.gif" width="15" height="18" alt="" border="0"></td>
+    <td class="cell" valign="top" align="right"><a href="http://mail-archives.apache.org/mod_mbox/geronimo-user/">
+      <img src="http://geronimo.apache.org/images/subnav_userlist_55x18.gif" width="55" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://mail-archives.apache.org/mod_mbox/geronimo-dev/">
+      <img src="http://geronimo.apache.org/images/subnav_devlist_59x18.gif" width="59" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://cwiki.apache.org/geronimo">
+      <img src="http://geronimo.apache.org/images/subnav_wiki_39x18.gif" width="39" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://issues.apache.org/jira/browse/GERONIMO">
+      <img src="http://geronimo.apache.org/images/subnav_issue_83x18.gif" width="83" height="18" alt="" border="0"></a></td>
+    <td class="cell" valign="top" align="right"><a href="http://www.epiqtech.com"><img src="http://geronimo.apache.org/images/subnav_graph_95x18.gif" width="95" height="18" alt="" border="0"></a></td>
+  </tr>
+</table>
+<table valign="top" border="0" cellspacing="0" cellpadding="0" width="100%" background="http://geronimo.apache.org/images/menu_bgstretch_1x22.gif">
+    <tr align="left">
+        <td valign="top">
+            <a href="index.html"><img src="http://geronimo.apache.org/images/menu_home_off_63x19.gif" width="63" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="documentation.html"><img src="http://geronimo.apache.org/images/menu_doc_off_116x19.gif" width="116" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="downloads.html"><img src="http://geronimo.apache.org/images/menu_download_off_85x19.gif" width="85" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="get-involved.html"><img src="http://geronimo.apache.org/images/menu_comm_off_96x19.gif" width="96" height="19" border="0"></a>
+        </td>
+        <td valign="top" align="left">
+            <a href="development.html"><img src="http://geronimo.apache.org/images/menu_dev_off_104x19.gif" width="104" height="19" border="0"></a>
+        </td>
+        <td width="100%">
+                &nbsp;
+        </td>
+    </tr>
+</table>
+
+  <font face="Verdana, Helvetica, Arial">
+<H2>Installing a Geronimo sample</H2>
+
+  <font style="font-size:12px">
+  There are 2 ways to play with a Geronimo sample.
+  <UL>
+    <LI>install a readily available sample binary. This requires a Geronimo server to be running.
+    <LI>build the sample and install it. This requires Maven v2.0.5. 
+    The sample thus built will be deployed for you on an already running server or on a server that will be downloaded.
+  </UL>
+  </FONT>
+
+  <H3>1. Installing an available sample binary</H3>
+  <font style="font-size:12px">
+  <OL>Steps:
+  <LI>Download the sample binary
+  <LI>go to the ${geronimoHome}/bin directory. It is the directory where you have the Geronimo server unpacked.
+  <LI>start the server using <CODE>startServer.bat</CODE> or <CODE>startServer.sh</CODE>
+  <LI>deploy the downloaded sample binary using <CODE>deploy.bat --user system --password manager deploy /path/to/sample/binary/sample.ear</CODE>
+  <LI>open a browser and go to the sample's context root.
+  </OL>
+  </FONT>
+
+  
+  <H3>2. Building a sample from source</H3>
+  <font style="font-size:12px">
+    This will give you an opportunity to play with the source code. The build will also deploy the sample application into a Geronimo server.
+    You may choose an already unpacked and/or running server to deploy this sample application.
+    <p>
+    Alternatively, you may let the build download the latest Geronimo binary and unpack it.
+    By default, a downloaded server binary will be unpacked into the sample project's <CODE>target</CODE> directory.
+    Or you may choose a different installation directory.
+    <p> 
+    You may let the build download the geronimo binary from a remote repository or point it to an already downloaded binary.
+    <P>
+    By default, it will download a Geronimo binary with the jetty webcontainer. You may however choose the Geronimo binary with the tomcat webcontainer.
+  
+  <OL>Steps:
+  <LI>if you don't have Maven v2.0.5 already, download that from <A HREF="http://maven.apache.org/download.html">Apache's maven</A> site. Add maven's bin directory to your path.
+  <LI>Download the sample source zip and unpack it. 
+    <I>If your platform is Windows, it is recommended that you unpack the zip in a directory quite close to the root to prevent a Windows restriction on long path name.</I>
+  <LI>go to the directory where the sample source code has been unpacked
+  <LI>execute the command <B><CODE>mvn -Puser install site</CODE></B>
+      <UL>Some optional arguments:
+          <LI>-Puser: The <I>user</I> profile will deploy your sample app to Geronimo server. Without this, it will just build the sample. You will have to deploy it yourself.
+          <LI>-DgeronimoHome: path to directory where a server has already been unpacked.
+          <p><LI>-DinstallDirectory: path to directory where a server has to be unpacked. If a server already exists there, a more recent one, if available, will be downloaded and installed.
+          If a later binary isn't available, the existing server is started.  If one doesn't exist, then the downloaded one will be unpacked here.
+          <p><LI>-DassemblyId: [jetty | tomcat] By default, Geronimo with the <I>jetty</I> webcontainer will be downloaded and started. Set the value of this to <I>tomcat</I> for the tomcat webcontainer.
+          <p><LI>-DassemblyArchive: path to an assembly archive (zip binary) already downloaded.<P>
+      </UL>
+
+      <I><CODE>Example: mvn -Puser install site -DinstallDirectory=c:\Geronimo </CODE></I><p>
+  <LI>start the server using <CODE>startServer.bat</CODE> or <CODE>startServer.sh</CODE>
+  <LI>open a browser and go to the sample's context root.
+  </OL>
+  </FONT>
+
+
+  </FONT>
+
+</body>
+</html>

Propchange: geronimo/samples/trunk/samples/dbtester/install-sample.html
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/install-sample.html
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/install-sample.html
------------------------------------------------------------------------------
    svn:mime-type = text/html

Added: geronimo/samples/trunk/samples/dbtester/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/dbtester/pom.xml?view=auto&rev=546621
==============================================================================
--- geronimo/samples/trunk/samples/dbtester/pom.xml (added)
+++ geronimo/samples/trunk/samples/dbtester/pom.xml Tue Jun 12 13:12:57 2007
@@ -0,0 +1,64 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+    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.
+-->
+
+<!-- $Rev$ $Date$ -->
+
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+    
+    <modelVersion>4.0.0</modelVersion>
+    
+    <parent>
+        <groupId>org.apache.geronimo.samples</groupId>
+        <artifactId>samples</artifactId>
+        <version>2.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+    
+    <artifactId>dbtester</artifactId>
+    <name>Geronimo Samples :: dbtester</name>
+    <packaging>pom</packaging>
+    
+    <description>
+        Geronimo dbtester sample created from an archetype.
+    </description>
+    
+   <modules>
+        <module>dbtester-war</module>
+        <module>dbtester-ear</module>
+    </modules>
+
+    <repositories>
+        <repository>
+            <id>apache-snapshots</id>
+            <name>Apache Snapshots Repository</name>
+            <url>http://people.apache.org/repo/m2-snapshot-repository</url>
+            <layout>default</layout>
+            <snapshots>
+                <enabled>true</enabled>
+                <updatePolicy>daily</updatePolicy>
+                <checksumPolicy>ignore</checksumPolicy>
+            </snapshots>
+            <releases>
+                <enabled>false</enabled>
+            </releases>
+        </repository>
+    </repositories> 
+
+</project>

Propchange: geronimo/samples/trunk/samples/dbtester/pom.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Propchange: geronimo/samples/trunk/samples/dbtester/pom.xml
------------------------------------------------------------------------------
    svn:keywords = Date Revision

Propchange: geronimo/samples/trunk/samples/dbtester/pom.xml
------------------------------------------------------------------------------
    svn:mime-type = text/xml

Modified: geronimo/samples/trunk/samples/pom.xml
URL: http://svn.apache.org/viewvc/geronimo/samples/trunk/samples/pom.xml?view=diff&rev=546621&r1=546620&r2=546621
==============================================================================
--- geronimo/samples/trunk/samples/pom.xml (original)
+++ geronimo/samples/trunk/samples/pom.xml Tue Jun 12 13:12:57 2007
@@ -16,8 +16,7 @@
     KIND, either express or implied.  See the License for the
     specific language governing permissions and limitations
     under the License.
---><!-- $Rev$ $Date$ -->
-<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+--><!-- $Rev$ $Date$ --><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
     <modelVersion>4.0.0</modelVersion>
     <parent>
         <groupId>org.apache.geronimo.samples</groupId>
@@ -33,7 +32,8 @@
     </description>
     <modules>
         <module>calculator-stateless-pojo</module>
-    </modules>
+        <module>dbtester</module>
+  </modules>
     <dependencies>
         <dependency>
             <groupId>org.apache.geronimo.specs</groupId>



Mime
View raw message