[Building Sakai] Quartz
Steve Swinsburg
steve.swinsburg at gmail.com
Wed Mar 27 05:23:35 PDT 2013
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.
>
> Cheers
> Steve
>
> 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/20130327/1eea9691/attachment.html
More information about the sakai-dev
mailing list