In addition, currently Oozie supports derby/mysql/postgres/oracle DBs, it does not support ms sqlserver.
It will require modifying the persistence.xml file and creating a custom ORM file for ms sqlserver. I'd suggest opening a JIRA, I'll be glad to help adding support for another DB. Thx On Sat, Dec 1, 2012 at 7:48 AM, Harsh J <[email protected]> wrote: > I don't think dropping the file into the extracted WAR directory (as > you have done), would be the right approach to do this. Instead, could > you regenerate your WAR file by running oozie-setup.sh after having > made your changes, and then work off of this newly generated oozie.war > file? > > On Sat, Dec 1, 2012 at 6:37 AM, Robert Towne <[email protected]> > wrote: > > A little more information, I went back to the original unpacked tar, and > added the file to the source prior to running "mkdistro.sh -DskipTests ", > and then used that updated distro. > > Now, I get past the original error and I am getting: > > > > ERROR: Oozie could not be started > > > > REASON: org.apache.oozie.service.ServiceException: E0103: Could not load > service classes, > > No persistence providers available for "oozie-sqlserver" after trying > the following discovered implementations: > org.apache.openjpa.persistence.PersistenceProviderImpl > > > > Stacktrace: > > ----------------------------------------------------------------- > > org.apache.oozie.service.ServiceException: E0103: Could not load service > classes, No persistence providers available for "oozie-sqlserver" after > trying the following discovered implementations: org.apache.$ > > at > org.apache.oozie.service.Services.loadServices(Services.java:281) > > at org.apache.oozie.service.Services.init(Services.java:202) > > at > org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:39) > > at > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) > > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) > > at > org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) > > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) > > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) > > at > org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) > > at > org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) > > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) > > at > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315) > > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) > > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) > > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) > > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:840) > > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) > > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) > > at > org.apache.catalina.core.StandardService.start(StandardService.java:525) > > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:754) > > at org.apache.catalina.startup.Catalina.start(Catalina.java:595) > > 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) > > Caused by: javax.persistence.PersistenceException: No persistence > providers available for "oozie-sqlserver" after trying the following > discovered implementations: org.apache.openjpa.persistence.Persistence$ > > at > javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:182) > > at org.apache.oozie.service.JPAService.init(JPAService.java:156) > > at > org.apache.oozie.service.Services.setServiceInternal(Services.java:358) > > at > org.apache.oozie.service.Services.setService(Services.java:344) > > at > org.apache.oozie.service.Services.loadServices(Services.java:278) > > ... 26 more > > ----------------------------------------------------------------- > > > > -- > Harsh J > -- Alejandro
