You are viewing a plain text version of this content. The canonical link for it is here.
Posted to scm@geronimo.apache.org by pr...@apache.org on 2007/06/12 22:12:59 UTC
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...
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%"> </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%">
+
+ </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%"> </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%">
+
+ </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>