Kepler: Issueshttps://projects.ecoinformatics.org/ecoinfo/https://projects.ecoinformatics.org/ecoinfo/ecoinfo/favicon.ico?14691340362009-06-01T08:03:00ZEcoinformatics Redmine
Redmine Bug #4120 (Resolved): Bug in OpenDBConnector actorhttps://projects.ecoinformatics.org/ecoinfo/issues/41202009-06-01T08:03:00ZJamie Vleeshouwerjamie.vleeshouwer@csiro.au
<p>It also appears that the OpenDBConnector needs to be updated too. The previous version of the driver class required a connection string which was prefixed with jdbc:microsoft:sqlserver, however the new driver requires jdbc:sqlserver. The OpenDBConnector actor automatically appends this prefix when trying to connect to a SQL server database, however it still uses the old connection string which currently makes it impossible to connect to a SQL Server database.</p>
<hr />
<p>Hi Peter,</p>
<p>I have updated the actor to use the driver class<br />com.microsoft.sqlserver.jdbc.SQLServerDriver.</p>
<p>However, the MS SQL Server JDBC jars included in Kepler appear to<br />be from "MS SQL Server 2000 Driver for JDBC", which does not<br />support Java 1.5. I have removed these jars since Kepler requires<br />Java 1.5.</p>
<p>The license for "MS SQL Server 2005 JDBC Driver 1.2" (which does<br />support Java 1.5) does not permit redistribution. You will need to<br />download the jars and place them in $KEPLER/lib/jar/. The Kepler<br />loader will automatically add them to the classpath. If you are<br />using Eclipse, you might need to add them to the .classpath file.</p>
<p>Let me know if you have questions,</p>
<pre><code>--dan</code></pre>
<p>Peter.Fitch at csiro.au wrote:</p>
<blockquote>
<p>Hi Kepler users,</p>
<p>I have found a problem with using the open database connector actor with MS SQL Server. When you set the database format to MS SQL Server you get an exception class not found com.microsoft.jdbc.sqlserver.SQLServerDriver.</p>
<p>Unfortunately the class is correct for Java 1.4 but not for 1.5 which is the current recommended version. In Java 1.5 the driver class is com.microsoft.sqlserver.jdbc.SQLServerDriver.</p>
<p>Anyone else found this?</p>
<p>Cheers<br />Peter</p>
<p>_<em><i></em></i>__<em>_</em>___________________________________<br />Kepler-users mailing list<br />Kepler-users at ecoinformatics.org<br /><a class="external" href="http://mercury.nceas.ucsb.edu/ecoinformatics/mailman/listinfo/kepler-users">http://mercury.nceas.ucsb.edu/ecoinformatics/mailman/listinfo/kepler-users</a></p>
</blockquote>
<p>Cheers</p>
<p>Jamie</p> Bug #3247 (Resolved): Documentation intro screen typohttps://projects.ecoinformatics.org/ecoinfo/issues/32472008-04-29T23:59:02ZChad Berkleyberkley@nceas.ucsb.edu
<p>Still says "Release Candidate"</p> Bug #2755 (Resolved): generateDocs replaces & with & erroneouslyhttps://projects.ecoinformatics.org/ecoinfo/issues/27552007-02-01T17:34:45ZChad Berkleyberkley@nceas.ucsb.edu
<p>When i have an entity reference like < in the documentation for an actor, after I run 'ant generateDoc', < is transformed to &lt; which is wrong. The doc system needs to be a bit smarter about translating ampersands.</p> Bug #2144 (Resolved): fix functionality and GUI issues with query builderhttps://projects.ecoinformatics.org/ecoinfo/issues/21442005-07-05T21:46:16ZChad Berkleyberkley@nceas.ucsb.edu
<p>The query builder needs to be evaluated for broken functionality and the UI<br />needs to be looked at and evaluated by laura. jing and efrat agreed to look at<br />this at the june 05 kepler meeting.</p> Bug #1900 (Resolved): Documentation systemhttps://projects.ecoinformatics.org/ecoinfo/issues/19002005-01-21T19:04:49ZIlkay Altintasaltintas@sdsc.edu
<ol>
<li> Ilkay: Documentation system (Chad helps from SEEK side)
<ul>
<li>Includes way to serialize docs for atomic and composite actors (and<br />directors, and utilities, etc)<br /> o Possible way to put this documentation as linked annotations right<br />on the canvas</li>
</ul></li>
</ol> Bug #1829 (Resolved): saving workflow invalidates eml datahttps://projects.ecoinformatics.org/ecoinfo/issues/18292004-12-15T17:23:43ZChad Berkleyberkley@nceas.ucsb.edu
<p>Intermittently, when you save a workflow with data that's been dragged from the<br />data tab, when you close then reopen the workflow, you get an NPE which is<br />source in the EML200DataSource.initialize() line 316. This might be a bug in<br />caching.</p> Bug #1826 (Resolved): keyboard binding to enter key on quick search brokenhttps://projects.ecoinformatics.org/ecoinfo/issues/18262004-12-10T23:07:45ZChad Berkleyberkley@nceas.ucsb.edu
<p>When you are typing in the quick search field, if you hit the delete (or<br />backspace key) anything that is selected on the canvas is deleted. I think the<br />key binding is being incorrectly assigned to the whole application instead of<br />just to the quick search field and "go" button.</p> Bug #1660 (Resolved): Add QueryBuilder to the Data Actorshttps://projects.ecoinformatics.org/ecoinfo/issues/16602004-08-23T18:38:08ZRod Spearsrods@ku.edu
<p>Need to add a query object to the Data Actors and be able to invoke the Query<br />Builder to make changes to it</p> Bug #1595 (Resolved): Create Advance Query Builder UIhttps://projects.ecoinformatics.org/ecoinfo/issues/15952004-06-08T11:56:05ZRod Spearsrods@ku.edu
<p>Create a UI to enabled a user to specifiy a query for an access actor (Query<br />Builder)</p>
<p>The QB will take as input:<br />1) Nothing<br />2) A kepler\src\org\ecoinformatics\seek\datasource object</p>
<p>The ouput:<br />A composite query object representing the query (with joins and where clause)</p>
<p>Rough Sketch:<br />The UI contain two panes:</p>
<p>1) The upper pane <br /> a) Shows all the tables defined in the database.<br /> b) The user will be able to D&D fields from one table to another to define<br /> foreign keys and/or table joins.</p>
<p>2) The lower pane will contain a tab control with two tabs<br /> a) The less advanced tab will enable a user to enter the defeinition of a<br /> where clause and all the items and their conditions will be grouped <br /> by either an "and" or an "or". The text will read "Must meet all of <br /> the conditions" or "Must meet at least one of the conditions" </p>
<pre><code>b) The advanced tab will enable a a user specify a much more complex, <br /> nested version of "ands" and "ors" This UI will look very close to the<br /> the Query Builder UI for the Ecogrid (See below)</code></pre>
<p>Description of UI for Advanced UI of the lower tab:<br /><AND><br /> <the condition goes here><br /> <OR><br /> <another condition goes here><br /> <another condition goes here><br /> </OR><br /></AND></p> Bug #1592 (Resolved): describe Sparrow toolkit interfacehttps://projects.ecoinformatics.org/ecoinfo/issues/15922004-06-07T18:12:29ZChad Berkleyberkley@nceas.ucsb.edu
<p>Need to work out an interface for the Sparrow toolkit. Sparrow should be<br />implement the ontological cross products needed for bug 1546.</p> Bug #1589 (Resolved): actor testing systemhttps://projects.ecoinformatics.org/ecoinfo/issues/15892004-06-07T17:48:36ZChad Berkleyberkley@nceas.ucsb.edu
<p>we need a unit test system for actors. need to look into whether ptolemy<br />already has this functionality. could possibly use a test workflow with the<br />actor embedded and ptexectute. It would be nice if this system could work with<br />the junit system.</p> Bug #1588 (Resolved): create nightly build systemhttps://projects.ecoinformatics.org/ecoinfo/issues/15882004-06-07T17:39:12ZChad Berkleyberkley@nceas.ucsb.edu
<p>need to create a nightly build system along with junit tests to be run every<br />night . The results of the tests and the build should be presented to the<br />kepler members, possibly by email or web interface or both. The possibilities<br />for build systems are:</p>
<p>1) GUMP - apache project<br />2) Tinderbox - mozilla<br />3) Home grown scripted version, ala Jalama</p> Bug #1586 (Resolved): Query engine implementation for data query in keplerhttps://projects.ecoinformatics.org/ecoinfo/issues/15862004-06-04T15:40:03ZJing Taotao@nceas.ucsb.edu
<p>This task is for query data object locally (in Kepler). After loading data<br />object into db system (See bug 1584), we need a engine to excute the query which<br />user specifies in UI. This engine will connect db, excute the query and return<br />the data object.</p> Bug #1584 (Resolved): Load data into relational dbhttps://projects.ecoinformatics.org/ecoinfo/issues/15842004-06-04T15:31:54ZJing Taotao@nceas.ucsb.edu
<p>This task is part of query data feature.<br />The new feature means people can get part of data object by specifying a sql<br />query. If the data object is in a relational db, the sql query can be excuted<br />directly. Unfortunately, data object is not in a relational db in some<br />systems(e.g. Metacat, kepler local data). So we need load data object into a db.<br />The first step, we need to write a parser to parse metadata and get DDL for data<br />object. Then we use the DDL to load the data inot (SAS, DB, R).</p> Bug #1579 (Resolved): need sub-sampling actorhttps://projects.ecoinformatics.org/ecoinfo/issues/15792004-05-25T16:36:07ZMatt Jonesjones@nceas.ucsb.edu
<p>We need an actor that can perform various sub-sampling functions such as<br />jackknife and bootstrapping operations. Most ecologists use R and similar<br />systems for this type of work. We specifically need to do some<br />spatially-explicit sub-sampling for the GARP pipeline. In addition, we could<br />probably create a sub-sampling actor as a composite actor that uses the ptolemy<br />signal processing actors.</p>