Index: code/chartbeans_line.xaction
===================================================================
--- code/chartbeans_line.xaction	(revision 7693)
+++ code/chartbeans_line.xaction	(revision 7693)
@@ -0,0 +1,99 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<action-sequence>
+  <name>Simple Line Chart Example</name>
+  <title>Chartbeans Line Chart</title>
+  <version>1</version>
+  <logging-level>debug</logging-level>
+  <documentation> 
+    <author>Gretchen Moran</author>  
+    <description/>  
+    <help/>
+  </documentation>
+
+  <inputs>
+    <series-column type="string">
+      <sources>
+        <request>series-column</request>
+      </sources>
+      <default-value>YEAR</default-value>
+    </series-column>
+    <category-column type="string">
+      <sources>
+        <request>category-column</request>
+      </sources>
+      <default-value>LINE</default-value>
+    </category-column>
+    <value-column type="string">
+      <sources>
+        <request>value-column</request>
+      </sources>
+      <default-value>PRICE</default-value>
+    </value-column>
+  </inputs>
+
+  <outputs>
+    <outputstream type="string"> 
+      <destinations> 
+        <response>content</response> 
+      </destinations> 
+    </outputstream> 
+  </outputs>
+
+  <resources> 
+    <line> 
+      <solution-file> 
+        <location>chartbeans_linechart.xml</location>  
+        <mime-type>text/xml</mime-type> 
+      </solution-file> 
+    </line>  
+  </resources> 
+
+
+  <actions> 
+
+    <action-definition> 
+      <component-name>SQLLookupRule</component-name>
+      <action-type>New Chart Data Query</action-type>
+      <action-outputs> 
+        <query-result type="result-set" mapping="new_result"/> 
+      </action-outputs>
+      <component-definition> 
+        <live><![CDATA[true]]></live>  
+        <driver><![CDATA[com.mysql.jdbc.Driver]]></driver>
+        <connection><![CDATA[jdbc:mysql://localhost:3306/database]]></connection>
+        <user-id><![CDATA[username]]></user-id>
+        <password><![CDATA[wachtwoord]]></password>
+        <query><![CDATA[SELECT start AS LINE,
+				roomID AS "YEAR",
+                        MAX(value) AS "PRICE"
+                        FROM
+     				dennis_test.tuples 
+     				WHERE end IS NULL
+     				GROUP BY LINE, YEAR
+     				ORDER BY LINE ASC
+     				LIMIT 50]]></query> 
+      </component-definition> 
+    </action-definition>
+
+    
+    <action-definition>
+      <component-name>ChartBeansComponent</component-name>
+      <action-inputs>
+	  <value-column type="string"/> 
+	  <category-column type="string"/> 
+	  <series-column type="string"/> 
+          <chartdata type="result-set" mapping="new_result"/>
+      </action-inputs>
+      <action-resources> 
+        <chart-model-xml type="resource" mapping="line"/>
+      </action-resources>
+      <action-outputs>
+        <outputstream/>
+      </action-outputs>
+      <component-definition/> 
+      <action-name>ChartBeans Line Chart</action-name>  
+      <logging-level>DEBUG</logging-level> 
+    </action-definition>
+
+  </actions> 
+</action-sequence>
Index: code/chartbeans_linechart.xml
===================================================================
--- code/chartbeans_linechart.xml	(revision 7693)
+++ code/chartbeans_linechart.xml	(revision 7693)
@@ -0,0 +1,26 @@
+<chartModel chartEngine="OpenFlashChart" style="border-top-width: 5; border-top-color: #987654; background-color: #ffffff;">
+  <title style="font-family: courier; color: #ffaa00; font-size: 20px; font-weight: bold; text-align: center;">Test chart</title>
+  <legend style="font-family: verdana; font-size: 18px; font-weight: bold; border-top-width: 10; border-top-color: #880a0f; font-style: italic;"/>
+  <linePlot orientation="VERTICAL" style="border-top-width: 5; opacity: 0.75; background-color: #fffff0;" flavor="THREED">
+    <palette>
+      <paint style="color: #880a0f;"/>
+      <paint style="color: #b09a6b;"/>
+      <paint style="color: #772200;"/>
+      <paint style="color: #c52f0d;"/>
+      <paint style="color: #123d82;"/>
+      <paint style="color: #4a0866;"/>
+      <paint style="color: #ffaa00;"/>
+      <paint style="color: #1e8ad3;"/>
+      <paint style="color: #aa6611;"/>
+      <paint style="color: #772200;"/>
+      <paint style="color: #8b2834;"/>
+      <paint style="color: #333333;"/>
+    </palette>
+    <verticalAxis class="org.pentaho.chart.model.NumericAxis">
+      <legend style="font-family: san-serif; color: #772200; font-size: 12px; font-weight: bold;">yAxis</legend>
+    </verticalAxis>
+    <horizontalAxis labelOrientation="DIAGONAL">
+      <legend style="font-family: san-serif; color: #772200; font-size: 10px;">xAxis</legend>
+    </horizontalAxis>
+  </linePlot>
+</chartModel>
