[
https://issues.apache.org/jira/browse/OOZIE-2136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17365300#comment-17365300
]
Dénes Bodó commented on OOZIE-2136:
-----------------------------------
I think the solution can be around OOZIE-2574 where the JDBC URL which contains
comma (,) is surrounded with quotation marks (").
Let me test against some databases if using quotation marks always around the
JDBC URL breaks something or not.
> Oozie server startup error when JDBC URL for a MySql DB with HA is used
> -------------------------------------------------------------------------
>
> Key: OOZIE-2136
> URL: https://issues.apache.org/jira/browse/OOZIE-2136
> Project: Oozie
> Issue Type: Bug
> Components: core
> Reporter: Biju Nair
> Assignee: Dénes Bodó
> Priority: Major
> Labels: oozie
>
> Two instances of MySql DB is set-up on two nodes with HA. When tried to use
> the value {{jdbc:mysql://bcpc-vm1,bcpc-vm2:3306/oozie}} for the property
> {{oozie.service.JPAService.jdbc.url}} Oozie start-up fails. The URL format is
> as per MySql
> [specification|http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html].The
> following is the error entry in the Oozie log.
> 2015-02-10 10:48:14,811 INFO HadoopAccessorService:543 - USER[-] GROUP[-]
> TOKEN[-] APP[-] JOB[-] ACTION[-] final password is xHGotFJ3c6WxgojAGKZP
> 2015-02-10 10:48:15,525 FATAL Services:537 - Runtime Exception during
> Services Load. Check your list of 'oozie.services' or 'oozie.services.ext'
> 2015-02-10 10:48:15,531 FATAL Services:537 - USER[-] GROUP[-] TOKEN[-] APP[-]
> JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create
> PoolableConnectionFactory (No database selected)
> org.apache.oozie.service.ServiceException: E0103: Could not load service
> classes, Cannot create PoolableConnectionFactory (No database selected)
> at org.apache.oozie.service.Services.loadServices(Services.java:306)
> at org.apache.oozie.service.Services.init(Services.java:210)
> at
> org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:45)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4709)
> 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:583)
> at
> org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943)
> at
> org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
> 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:1065)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
> 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:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Cannot create
> PoolableConnectionFactory (No database selected)
> at
> org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102)
> at
> org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603)
> at
> org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1518)
> at
> org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:531)
> at
> org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:456)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
