[Building Sakai] Quartz
Antonio muñoz alonso
antoniovalenciaspain at hotmail.com
Sun Mar 31 15:02:26 PDT 2013
Get compile this project: https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.8.x/quartz/
compiled and executed correctly.
After, I added Impl and Api (for SakaiProxy and Spring JDBC).compiled when restart Tomcat this error:- Stopping Hibernate Cache Cache ------------------------------- 2013-03-31 23:58:47,056 INFO main org.sakaiproject.db.impl.BasicSqlService - destroy()2013-03-31 23:58:47,171 INFO main org.sakaiproject.log.impl.Log4jConfigurationManager - destroy()2013-03-31 23:58:47,171 INFO main org.sakaiproject.component.impl.BasicConfigurationService - destroy()
I just recompiled the basic project(https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.8.x/quartz/) but still the same error.I can not find the application to delete in /opt/tomcat/webapps.
any ideas??
Subject: Re: Quartz
From: steve.swinsburg at gmail.com
Date: Wed, 27 Mar 2013 23:23:35 +1100
CC: sakai-dev at collab.sakaiproject.org
To: antoniovalenciaspain at hotmail.com
Have a look at one of the modules in your Sakai 2.8 release, and change the parent in this module to suit that one.
This was a custom module for ANU so you need to change it for your build.
cheers,Steve
On 27/03/2013, at 11:14 PM, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:original Parent:
<parent>
<groupId>org.sakaiproject.msub</groupId>
<artifactId>alliance-quartz</artifactId>
<version>2.8-SNAPSHOT</version>
</parent>
Change for <version>2.8.1</version>,same mistake, ¿?
From: steve.swinsburg at gmail.com
Subject: Re: Spring JDBC in Maven Archetype Sakai
Date: Wed, 27 Mar 2013 21:53:08 +1100
To: antoniovalenciaspain at hotmail.com
Yeah you gotta change that parent.
On 27/03/2013, at 9:51 PM, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:OK.
I use Sakai 2.8.1, problem when compile.
Trace:
[INFO] Trace
org.apache.maven.reactor.MavenExecutionException: Cannot find parent: org.sakaiproject.msub:alliance for project: org.sakaiproject.msub:alliance-quartz:pom:null for project org.sakaiproject.msub:alliance-quartz:pom:null
at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:404)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:272)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: org.apache.maven.project.ProjectBuildingException: Cannot find parent: org.sakaiproject.msub:alliance for project: org.sakaiproject.msub:alliance-quartz:pom:null for project org.sakaiproject.msub:alliance-quartz:pom:null
at org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1396)
at org.apache.maven.project.DefaultMavenProjectBuilder.buildInternal(DefaultMavenProjectBuilder.java:823)
at org.apache.maven.project.DefaultMavenProjectBuilder.buildFromSourceFileInternal(DefaultMavenProjectBuilder.java:508)
at org.apache.maven.project.DefaultMavenProjectBuilder.build(DefaultMavenProjectBuilder.java:200)
at org.apache.maven.DefaultMaven.getProject(DefaultMaven.java:604)
at org.apache.maven.DefaultMaven.collectProjects(DefaultMaven.java:487)
at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:391)
... 12 more
Caused by: org.apache.maven.project.ProjectBuildingException: POM 'org.sakaiproject.msub:alliance' not found in repository: Unable to download the artifact from any repository
org.sakaiproject.msub:alliance:pom:2.8-SNAPSHOT
from the specified remote repositories:
central (http://repo1.maven.org/maven2)
for project org.sakaiproject.msub:alliance
at org.apache.maven.project.DefaultMavenProjectBuilder.findModelFromRepository(DefaultMavenProjectBuilder.java:605)
at org.apache.maven.project.DefaultMavenProjectBuilder.assembleLineage(DefaultMavenProjectBuilder.java:1392)
... 18 more
Caused by: org.apache.maven.artifact.resolver.ArtifactNotFoundException: Unable to download the artifact from any repository
org.sakaiproject.msub:alliance:pom:2.8-SNAPSHOT
from the specified remote repositories:
central (http://repo1.maven.org/maven2)
at org.apache.maven.artifact.resolver.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:228)
at org.apache.maven.artifact.resolver.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:90)
at org.apache.maven.project.DefaultMavenProjectBuilder.findModelFromRepository(DefaultMavenProjectBuilder.java:558)
... 19 more
Caused by: org.apache.maven.wagon.ResourceDoesNotExistException: Unable to download the artifact from any repository
at org.apache.maven.artifact.manager.DefaultWagonManager.getArtifact(DefaultWagonManager.java:404)
at org.apache.maven.artifact.resolver.DefaultArtifactResolver.resolve(DefaultArtifactResolver.java:216)
... 21 more
[INFO] ------------------------------------------------------------------------
[INFO] Total time: < 1 second
[INFO] Finished at: Wed Mar 27 10:50:48 CET 2013
[INFO] Final Memory: 1M/508M
[INFO] ------------------------------------------------------------------------
root at pc-System-Product-Name:/home/pc/quartz#
Date: Wed, 27 Mar 2013 11:35:06 +1100
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
To: antoniovalenciaspain at hotmail.com
Use this as a base. its better:https://source.sakaiproject.org/svn//msub/anu.edu.au/alliance/2.8.x/quartz/
You need to adjust parent to be your sakai version.
You then need to create classes that do what you need. And if they are outside of this quartz bundle, you need to inject them in. I would recommend you look at the Sakai programmers manual to figure out what you need to do. And post on the dev list.\
On Wed, Mar 27, 2013 at 10:12 AM, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com>wrote:
I have to create SakaiProxy and ProjectLogic, as in Sakai Maven Archetype, no??.
Error when mvn clean install sakai:deploy
org.apache.maven.reactor.MavenExecutionException: Cannot find parent: org.sakaiproject:base for project: uk.ac.lancs.e_science:example-scheduler-base:pom:1.0 for project uk.ac.lancs.e_science:example-scheduler-base:pom:1.0
at org.apache.maven.DefaultMaven.getProjects(DefaultMaven.java:404)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:272)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
Date: Wed, 27 Mar 2013 07:14:12 +1100
To: antoniovalenciaspain at hotmail.com
You need to inject beans into your quartz app.
Sent from my iPhone
On 27/03/2013, at 5:31, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
I created this project:
svn cohttps://source.sakaiproject.org/contrib/swinsburg/quartz-example/
I need to get all the notes and then insert or update the table.
Do I have to export the code(Function in SakaiProxy) I have for the project quartz?
Do I have to export Spring JDBC to this new project?
I totally lost :( , You should come to Spain :)
Thanks.
From: steve.swinsburg at gmail.com
Subject: Re: Spring JDBC in Maven Archetype Sakai
Date: Tue, 26 Mar 2013 22:27:06 +1100
To: antoniovalenciaspain at hotmail.com
Yes you can do it with quartz.
On 26/03/2013, at 10:03 PM, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
I have watched this tutorial,https://confluence.sakaiproject.org/display/DOC/Quartz+in+Sakai , but do not understand.
In SakaiProxy, there is work to get the notes of all assignment.
I want to run this function periodically,
Should I do it with quartz?.
thanks
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
Date: Fri, 22 Mar 2013 23:39:01 +1100
To: antoniovalenciaspain at hotmail.com
Ok then you can use quartz. Google quartz in Sakai and you'll find a page about how to set it up.
Sent from my iPhone
On 22/03/2013, at 22:09, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
I've managed to fill the notes to a table, and then read from the table.
But I want to create a process that updates the table at a certain frequency
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
Date: Fri, 22 Mar 2013 19:32:32 +1100
To: antoniovalenciaspain at hotmail.com
Quartz and cron? Start with the basics, learn spring jdbc then add other things into the application.
Sent from my iPhone
On 22/03/2013, at 10:16, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
Ok,
@SpringBean(name="org.sakaiproject.logic.ProjectLogic")
ProjectLogic ProjectLogic;
I want to populate a table with notes of tasks.
As seen, should use quartz and cron.
I have little idea of who they are.
How should I do?
thanks for help.
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
Date: Thu, 21 Mar 2013 21:51:12 +1100
To: antoniovalenciaspain at hotmail.com
Ps the dao is injected into the logic layer it's not designed to be accessed from the tool. You need to create logic methods to call from the tool to access the dao.
Sent from my iPhone
On 21/03/2013, at 20:52, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
Yes, auto.ddl= true, the table PROJECT_THINGS is created.
I manually inserted a row to the table. ('1','Hello World');
I try to access row:
---------------------------------------------------------------------------------------------------------
import org.sakaiproject.dao.ProjectDao;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
--------------------------------------------------------------------------------------------------------
ApplicationContext context =
new ClassPathXmlApplicationContext("components.xml");
ProjectDao dao = (ProjectDao)context.getBean("ProjectDao");
System.out.println(dao.getThing(1).getName()");
I try code in FirstPage and MyAplicacion, but not compile
but when compiling:
ERROR] COMPILATION ERROR :
[INFO] -------------------------------------------------------------
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[88,5] cannot find symbol
symbol : class ApplicationContext
location: class org.sakaiproject.tool.pages.FirstPage
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[89,11] cannot find symbol
symbol : class ClassPathXmlApplicationContext
location: class org.sakaiproject.tool.pages.FirstPage
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[90,2] cannot find symbol
symbol : class ProjectDao
location: class org.sakaiproject.tool.pages.FirstPage
[ERROR] /opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[90,20] cannot find symbol
symbol : class ProjectDao
location: class org.sakaiproject.tool.pages.FirstPage
[INFO] 13 errors
[INFO] -------------------------------------------------------------
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Compilation failure
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[45,27] package org.sakaiproject.dao does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[46,34] package org.springframework.context does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[47,42] package org.springframework.context.support does not exist
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[88,5] cannot find symbol
symbol : class ApplicationContext
location: class org.sakaiproject.tool.pages.FirstPage
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[89,11] cannot find symbol
symbol : class ClassPathXmlApplicationContext
location: class org.sakaiproject.tool.pages.FirstPage
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[90,2] cannot find symbol
symbol : class ProjectDao
location: class org.sakaiproject.tool.pages.FirstPage
/opt/sakai/app/tool/src/java/org/sakaiproject/tool/pages/FirstPage.java:[90,20] cannot find symbol
symbol : class ProjectDao
location: class org.sakaiproject.tool.pages.FirstPage
Date: Thu, 21 Mar 2013 10:21:14 +1100
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
To: antoniovalenciaspain at hotmail.com
Yep I think thats what its called. is auto.ddl=true in sakai properties?
On Thu, Mar 21, 2013 at 8:41 AM, Antonio muñoz alonso<antoniovalenciaspain at hotmail.com> wrote:
ok,
In my sakai.properties:
# MySQL settings
vendor at org.sakaiproject.db.api.SqlService=mysql
driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
Should there be a table PROJECT_THINGS?
Subject: Re: Spring JDBC in Maven Archetype Sakai
From: steve.swinsburg at gmail.com
Date: Thu, 21 Mar 2013 07:29:34 +1100
To: antoniovalenciaspain at hotmail.com
The values come from Sakai.properties. If you build the tool and deploy it, it works, it connects to the database and has tables created etc.
Sent from my iPad
On 21/03/2013, at 7:08, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
But the example that leads the project,is used?.
In components.xml,
But that database is connected?
Example: beans.xml
<!-- Initialization for data source -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/TEST"/>
<property name="username" value="root"/>
<property name="password" value="password"/>
</bean>
From: steve.swinsburg at gmail.com
Subject: Re: Spring JDBC in Maven Archetype Sakai
Date: Thu, 21 Mar 2013 06:09:04 +1100
To: antoniovalenciaspain at hotmail.com
Look in components.xml. Its injected from there (the DataSource) into the DAO class.
On 20/03/2013, at 11:53 PM, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
I have reviewed this example:
http://www.mkyong.com/spring/maven-spring-jdbc-example/
archetype but does not appear spring configuration bean.
Can you help?
Subject: Re: Spring JDBC in Maven Archetype Sakai
From:steve.swinsburg at gmail.com
Date: Wed, 20 Mar 2013 22:35:49 +1100
To:antoniovalenciaspain at hotmail.com
You might want to review some docs on spring jdbc, the connection is there , it's an injected bean provided by Sakai kernel.
CheersSteve
Sent from my iPhone
On 20/03/2013, at 21:25, Antonio muñoz alonso <antoniovalenciaspain at hotmail.com> wrote:
Hi Steve,
I have seen an example of Spring JDBC,
how I can use?.
Missing file to use it?, Eg connection to the DB.
I have no idea how to use it.
thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130401/3bb99645/attachment.html
More information about the sakai-dev
mailing list