Jolly good. Yes, as you discovered, the "simple" archetype is already setup to persist to an RDBMS, using our JDO ObjectStore which integrates with JDO/DataNucleus. In the properties files (persistor.properties) we strip off "isis.persistor.datanucleus.impl" prefix and pass the rest through to DataNucleus.
The SQL ObjectStore you started off with has been retired (you'll notice the version in Maven is very old, with a "-incubating" version), and is not compatible with the latest version of Isis. Any more problems, please mail here. Cheers Dan On 10 December 2013 22:06, Satyendra Singh <[email protected]>wrote: > Ok, please ignore, I got it working. > > All I had to do was to add driver jar to maven and persister.properties > commented HSQLDB in-memory section and added below. > > > isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionDriverName=net.sourceforge.jtds.jdbc.Driver > isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionURL=** > isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionUserName=* > isis.persistor.datanucleus.impl.javax.jdo.option.ConnectionPassword=* > > Thanks > > -----Original Message----- > From: Satyendra Singh > Sent: Tuesday, December 10, 2013 3:56 PM > To: [email protected] > Subject: RE: isis quickstart with SQL error > > I also added below to isis.properties > > isis.persistor=sql > isis.persistor.sql.jdbc.driver=net.sourceforge.jtds.jdbc.Driver > isis.persistor.sql.jdbc.connection=jdbc:jtds:sqlserver://**** > isis.persistor.sql.jdbc.user=** > isis.persistor.sql.jdbc.password=** > > and removed isis.persistor=datanucleus > > Am I making right changes? > > > -----Original Message----- > From: Satyendra Singh [mailto:[email protected]] > Sent: Tuesday, December 10, 2013 3:49 PM > To: [email protected] > Subject: isis quickstart with SQL error > > Finally, I am getting back to work on my POC (myISISApp) using isis. The > quick start works fine with 'simpleobject'. > I need to move this to DB based (sql server to be specific), so I am > following below, not sure if this is most recent instructions. Any help > would be appreciated. > > > http://isis.apache.org/components/objectstores/sql/configuring-the-sql-os-objectstore-with-the-quickstart-archetype.html > > > 1. Added below to myISISApp/POM.XML > > <dependency> > <groupId>org.apache.isis.runtimes.dflt.objectstores</groupId> > <artifactId>sql-impl</artifactId> > <version>0.2.0-incubating</version> > </dependency> > > <dependency> > <groupId>net.sourceforge.jtds</groupId> > <artifactId>jtds</artifactId> > <version>1.3.0</version> > </dependency> > > > 2. Added below to myISISApp-webapp/POM.XML > > > <dependency> > <groupId>org.apache.isis.runtimes.dflt.objectstores</groupId> > <artifactId>sql-impl</artifactId> > </dependency> > <dependency> > <groupId>net.sourceforge.jtds</groupId> > <artifactId>jtds</artifactId> > </dependency> > > > I am currently getting below error when starting the application: > > INFO - ResteasyDeployment - Deploying > javax.ws.rs.core.Application: class > org.apache.isis.viewer.restfulobjects.server.RestfulObjectsApplication > INFO - WebXmlFile - web.xml: url mapping found for filter > with name WicketFilter: [/wicket/*] > INFO - IsisWicketApplication - Config override location: No override > location configured! > 2013-12-10 15:40:17.855:WARN::failed WicketFilter: > java.lang.NoSuchMethodError: > org.apache.isis.core.commons.config.IsisConfigurationBuilder.addDefaultConfigurationResources()V > 2013-12-10 15:40:17.855:WARN::failed > org.mortbay.jetty.plugin.Jetty6PluginWebAppContext@3b6e6fa3{/myIsisApp-webapp,C:\Users\ssingh\workspace_apacheisis\myIsisApp\webapp\src\main\webapp}: > java.lang.NoSuchMethodError: > org.apache.isis.core.commons.config.IsisConfigurationBuilder.addDefaultConfigurationResources()V > 2013-12-10 15:40:17.855:WARN::failed ContextHandlerCollection@2e2e5524: > java.lang.NoSuchMethodError: > org.apache.isis.core.commons.config.IsisConfigurationBuilder.addDefaultConfigurationResources()V > 2013-12-10 15:40:17.855:WARN::failed HandlerCollection@63d7c62b: > java.lang.NoSuchMethodError: > org.apache.isis.core.commons.config.IsisConfigurationBuilder.addDefaultConfigurationResources()V > 2013-12-10 15:40:17.856:WARN::Error starting handlers > java.lang.NoSuchMethodError: > org.apache.isis.core.commons.config.IsisConfigurationBuilder.addDefaultConfigurationResources()V > at > org.apache.isis.viewer.wicket.viewer.IsisWicketApplication.createConfigBuilder(IsisWicketApplication.java:322) > at > org.apache.isis.viewer.wicket.viewer.IsisWicketApplication.createConfigBuilder(IsisWicketApplication.java:301) > at > org.apache.isis.viewer.wicket.viewer.IsisWicketApplication.determineDeploymentTypeIfRequired(IsisWicketApplication.java:242) > at > org.apache.isis.viewer.wicket.viewer.IsisWicketApplication.getConfigurationType(IsisWicketApplication.java:276) > at > org.apache.wicket.protocol.http.WebApplication.internalInit(WebApplication.java:642) > at > org.apache.wicket.Application.initApplication(Application.java:816) > at > org.apache.wicket.protocol.http.WicketFilter.init(WicketFilter.java:424) > at > org.apache.wicket.protocol.http.WicketFilter.init(WicketFilter.java:351) > at > org.mortbay.jetty.servlet.FilterHolder.doStart(FilterHolder.java:97) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > at > org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:662) > at org.mortbay.jetty.servlet.Context.startContext(Context.java:140) > at > org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1272) > at > org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517) > at > org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:489) > at > org.mortbay.jetty.plugin.Jetty6PluginWebAppContext.doStart(Jetty6PluginWebAppContext.java:115) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > at > org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) > at > org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > at > org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > at > org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130) > at org.mortbay.jetty.Server.doStart(Server.java:224) > at > org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50) > at > org.mortbay.jetty.plugin.Jetty6PluginServer.start(Jetty6PluginServer.java:132) > at > org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:441) > at > org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:383) > at > org.mortbay.jetty.plugin.AbstractJettyRunMojo.execute(AbstractJettyRunMojo.java:210) > at > org.mortbay.jetty.plugin.Jetty6RunMojo.execute(Jetty6RunMojo.java:184) > at > org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101) > at > org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209) > at > org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153) > at > org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84) > at > org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59) > at > org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183) > at > org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161) > at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320) > at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156) > at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537) > at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196) > at org.apache.maven.cli.MavenCli.main(MavenCli.java:141) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at > org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290) > at > org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230) > at > org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409) > at > org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352) > 2013-12-10 15:40:17.900:INFO::Started [email protected]:8080 > [INFO] Started Jetty Server > > > Thanks > > > > This email and any files transmitted with it are confidential and intended > solely for the person or entity to whom they are addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon > this information by persons or entities other than the intended recipient > is prohibited. If you have received this email in error please contact the > sender and delete the material from any computer. > > Apollo Global Management, LLC > > > > > > This email and any files transmitted with it are confidential > and intended solely for the person or entity to whom they are > addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or > other use of, or taking of any action in reliance upon this > information by persons or entities other than the intended > recipient is prohibited. If you have received this email in > error please contact the sender and delete the material from > any computer. > > Apollo Global Management, LLC > > > > >
