Increase the memory for MyEclipse Blue IDE

1. Open this file:
C:\Program Files\Genuitec\MyEclipse Blue Edition 8.0 GA\myeclipse-blue.ini

2. Edit lines so it looks like this at the bottom:

-Xms1024m
-Xmx1024m

This will give you 1GB ram for MyEclipse Blue.

My complete ini file looks like this:

-install
C:/Program Files/Genuitec/MyEclipse Blue Edition 8.0 GA
-vm
C:/Program Files/Genuitec/Common/binary/com.sun.java.jdk.win32.x86_1.6.0.013/jre/bin/client/jvm.dll
-startup
../Common/plugins/org.eclipse.equinox.launcher_1.0.201.R35x_v20090715.jar
--launcher.library
../Common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519
-vmargs
-Xms1024m
-Xmx1024m
-XX:MaxPermSize=256m
-XX:ReservedCodeCacheSize=64m

Adding a datasource to the maven jetty plugin

In your pom.xml

           <plugin>
               <groupId>org.mortbay.jetty</groupId>
               <artifactId>maven-jetty-plugin</artifactId>
               <version>6.1.21</version>
               <configuration>
                    <!-- <jettyConfig>src/main/resources/devJetty.xml</jettyConfig>  -->
                    <webXml>${basedir}/src/main/resources/jetty-web.xml</webXml>
                    <jettyEnvXml>${basedir}/src/main/resources/jetty-env.xml</jettyEnvXml>
                   <contextPath>/OCM</contextPath>
                   <scanIntervalSeconds>3</scanIntervalSeconds>
                   <scanTargetPatterns>
                       <scanTargetPattern>
                           <directory>src/main/webapp/WEB-INF</directory>
                           <excludes>
                               <exclude>**/*.jsp</exclude>
                           </excludes>
                           <includes>
                               <include>**/*.properties</include>
                               <include>**/*.xml</include>
                           </includes>
                       </scanTargetPattern>
                   </scanTargetPatterns>
                   <stopKey>foo</stopKey>
                   <stopPort>9966</stopPort>
               </configuration>
           </plugin>
Key lines are
                    <webXml>${basedir}/src/main/resources/jetty-web.xml</webXml>
                    <jettyEnvXml>${basedir}/src/main/resources/jetty-env.xml</jettyEnvXml>

Define your jetty-env.xml like this:

<?xml version="1.0"?>
<!DOCTYPE Configure PUBLIC -//Mort Bay Consulting//DTD Configure//EN http://jetty.mortbay.org/configure.dtd>

<Configure class="org.mortbay.jetty.webapp.WebAppContext">

 <!-- an XADataSource                                                -->
 <New id="MAVENJETTYDS" class="org.mortbay.jetty.plus.naming.Resource">
   <Arg></Arg>
   <Arg>jdbc/datasource</Arg>
   <Arg>
         <New class="org.apache.commons.dbcp.BasicDataSource">
                     <Set name="driverClassName">[[jdbc driver class]]</Set> <!-- for example, com.ibm.db2.jcc.DB2Driver -->
                     <Set name="url">[[jdbc url]]</Set> <!-- for example, jdbc:db2://yourdbhostnameorip:[port]/yourdb -->
                     <Set name="username">[[username]]</Set><!-- for example, yourmom -->
                      <Set name="password">[[password]]</Set><!-- for example, correcthorsebatterystaple -->
                     <Set name="defaultCatalog">[[schema, if needed]]</Set>
         </New>
   </Arg>
  </New>
</Configure>

Then add the ref to your web.xml

<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" id="WebApp_1270163143862">
<pre>
   <!-- SNIP -->

<!-- Bug fix for editing locked CSS and JS running in Jetty -->
<servlet>
   <servlet-name>default</servlet-name>
   <servlet-class>org.mortbay.jetty.servlet.DefaultServlet</servlet-class>
   <init-param>
     <param-name>useFileMappedBuffer</param-name>
     <param-value>false</param-value>
   </init-param>
   <load-on-startup>0</load-on-startup>
</servlet>

       <resource-ref>
         <res-ref-name>jdbc/datasource</res-ref-name>
         <res-type>javax.sql.DataSource</res-type>
         <res-auth>Container</res-auth>
    </resource-ref>

</web-app>

Understanding Maven dependency scope

You can specify the scope for a dependency in the maven pom file, here are the scope values you can choose and what effect they have:

• compile: This dependency is needed for compilation of the main source
• test: This dependency is needed for compiling and running tests. It is not needed for compiling the main source or running the final artifact.
• runtime: This dependency is needed for running the final artifact. It is not needed for compiling the main source or compiling or running the tests.
• provided: This dependency is needed for compiling and/or running the artifact but is not necessary to include in the package, because it is provided by the runtime environment - for example, jsp-api.jar is provided by your web application container, so you don't include it in your WEB-INF/lib (for the example of a webapp); or a plugin or optional package that is a prerequisite for your application, but is not bundled with your application.
• system: don't use this one

source: http://docs.codehaus.org/display/MAVENUSER/Dependency+Scopes

JSP debug code

The following can be pasted into a JSP and then used to display (either in HTML source or in the browser window), the JSP Request, Session, Page, and Application settings for the environment and container the JSP is running within.

I have found this to be a quick useful way to get the lay of the land, when joining a project already in development.

<!-- 
 <%@ page import="java.util.*"%>
 <%
  Object eobj = request.getParameter("error");
  if (eobj != null) {
   Exception exception = null;
   Object obj = request.getAttribute("exception");
   if (obj != null && obj instanceof Exception) {
    exception = (Exception) obj;
   }
   if (exception == null) {
    obj = request.getAttribute("javax.servlet.error.exception");
    if (obj != null && obj instanceof Exception) {
     exception = (Exception) obj;
    }
   }
   if (exception != null) {
 %><pre>
  <%
   exception.printStackTrace(new java.io.PrintWriter(out));
  %>
 </pre>
 <%
  }
  }
  out.println("<h3>Request:</h3><ul>");
  Enumeration names = request.getHeaderNames();
  while (names.hasMoreElements()) {
   String name = (String) names.nextElement();
   out.println("<li>HEADER " + name + ": "
     + request.getHeader(name));
  }

  for (Enumeration e = request.getParameterNames(); e
    .hasMoreElements();) {
   String name = (String) e.nextElement();
   out.println("<li>PARAM " + name + "="
     + request.getParameter(name) + "</li>");
  }

  for (Enumeration e = request.getAttributeNames(); e
    .hasMoreElements();) {
   String name = (String) e.nextElement();
   out.println("<li>ATTRIB " + name + "="
     + request.getAttribute(name) + "</li>");
  }
  out.println("</ul><h3>Session:</h3><ul>");
  for (Enumeration e = session.getAttributeNames(); e
    .hasMoreElements();) {
   String name = (String) e.nextElement();
   out.println("<li>ATTRIB " + name + "="
     + session.getAttribute(name) + "</li>");
  }
  out.println("</ul><h3>Page Scope Attributes:</h3><ul>");
  for (Enumeration e = pageContext
    .getAttributeNamesInScope(pageContext.PAGE_SCOPE); e
    .hasMoreElements();) {
   String name = (String) e.nextElement();
   out.println("<li>ATTRIB "
     + name
     + "="
     + pageContext
       .getAttribute(name, pageContext.PAGE_SCOPE)
     + "</li>");
  }
  out.println("</ul><h3>Application Scope Attributes:</h3><ul>");
  for (Enumeration e = pageContext
    .getAttributeNamesInScope(pageContext.APPLICATION_SCOPE); e
    .hasMoreElements();) {
   String name = (String) e.nextElement();
   if (name.equals("com.sun.jsp.taglibraryCache")) {
    out.print("<li>ATTRIB " + name
      + "= <b>NULL POINTER!</b></li>");
    continue;
   }
   out.print("<li>ATTRIB " + name + "=");
   out.println(pageContext.getAttribute(name,
     pageContext.APPLICATION_SCOPE)
     + "</li>");
  }
  out.println("</ul>");
 %>
 -->

JSP for DataSource Connection Pool testing

If you need to test a datasource here is a JSP that will help you do it.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
   pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*,javax.naming.*,javax.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Test Data Source</title>
</head>
<body>
<h1>Test Data Source</h1>
<p>Hello</p>
<%
    DataSource ds = null;
    Connection con = null;
    Statement stmnt = null;
    ResultSet resultSet = null;
   try {
       InitialContext ctx = new InitialContext();
       ds = (DataSource)ctx.lookup("java:comp/env/jdbc/DataSource");
       con = ds.getConnection();
    stmnt = con.createStatement();
    resultSet = stmnt.executeQuery("select * from PERSON");
    if (resultSet != null) {
        %><table><tr><%
       ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
       int nOfColumns = resultSetMetaData.getColumnCount();
       for(int j = 0; j<nOfColumns; j++) {
           String columnLabel = resultSetMetaData.getColumnLabel(j+1);
           %><th><%=columnLabel %></th><%
       }
       %></tr><%
       if (resultSet.getType() != ResultSet.TYPE_FORWARD_ONLY) {
           resultSet.beforeFirst();
       }
       while (resultSet.next()) {
                %><tr><%
               for (int i = 1; i <= nOfColumns; ++i) {
                        %><td><%
                       Object  value = resultSet.getObject(i);
                       if (resultSet.wasNull()) {
                           %><b>null</b><%
                       } else {
                           %><%=value.toString() %><%
                       }
                       %></td><%
               }
               %></tr><%
       }
       %></table><%
    }
   } catch(NamingException e) {
       throw e;
   } catch(SQLException e) {
       throw e;
   } finally {
      try {
        if (resultSet != null) {
          resultSet.close();
        }
      } catch (SQLException e) {
      }
      resultSet = null;
      try {
        if (stmnt != null) {
          stmnt.close();
        }
      } catch (SQLException e) {
      }
      stmnt = null;
      try {
        if (con != null) {
          con.close();
        }
      } catch (SQLException e) {
      }
      con = null;
      ds = null;
   }
%>
</body>
</html>

Just change

java:comp/env/jdbc/DataSource

To what the name of your DataSource connection pool is.

Then change

select * from PERSON

To a test query from this table:

Cloudscape	#SQL SELECT 1
#DB2	#SQL SELECT COUNT(*) FROM SYSIBM.SYSTABLES
#Informix	#SQL SELECT COUNT(*) FROM SYSTABLES
#Microsoft SQL Server	#SQL SELECT COUNT(*) FROM SYSOBJECTS
#MySQL	#SQL SELECT 1
#Oracle	#SQL SELECT 1 FROM DUAL
#PointBase	#SQL SELECT COUNT(*) FROM SYSTABLES
#PostgreSQL	#SQL SELECT 1
#Progress	#SQL SELECT COUNT(*) FROM SYSTABLES
#Sybase	#SQL SELECT COUNT(*) FROM SYSOBJECTS

Do not use this code to interact with a datasource, this should only be used for figuring out what the name of a datasource you created in the J2ee container is and that it is working.