I was trying to use declared database pool in Jar file through JNDI. Is there an easy way to decalre db pool in Global JNDI?
Please help. djencks wrote: > > java:comp/env only works in javaee components. To use a datasource > in jndi in something like quartz you need to bind into global jndi. > I think the best instructions are in this thread > > http://www.nabble.com/How-to-register-a-Datasource-in-GlobalJNDI- > Namespace--tf4521379s134.html#a12902470 > > we need to get this class and some docs into geronimo 2.l... > > > hope this helps > > david jencks > > On Jan 20, 2008, at 6:34 PM, Qaiser Mehmood wrote: > >> >> I am using Geronimo 2.0.I want to use quartz in my Jar file and I >> am using >> quartz.properties to configure Quartz. In the properties file, I am >> using >> database pool through JNDI. I am getting this error: >> >> org.quartz.JobPersistenceException: Failed to obtain DB connection >> from data >> source 'myDS': java.sql.SQLException: Could not retrieve datasource >> via JNDI >> url 'java:comp/env/QuartzDS' java.lang.NullPointerException: null [See >> nested exception: java.sql.SQLException: Could not retrieve >> datasource via >> JNDI url 'java:comp/env/QuartzDS' java.lang.NullPointerException: >> null] >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection >> (JobStoreSupport.java:636) >> at >> org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection >> (JobStoreTX.java:72) >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin >> (JobStoreSupport.java:3070) >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage >> (JobStoreSupport.java:3713) >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport >> $ClusterManager.initialize(JobStoreSupport.java:3700) >> at >> org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted >> (JobStoreSupport.java:570) >> at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:449) >> at org.quartz.impl.StdScheduler.start(StdScheduler.java:146) >> at >> com.pervasive.phaip.services.scheduler.PhaipScheduler.doStart >> (PhaipScheduler.java:31) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstance.createInstance >> (GBeanInstance.java:996) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstanceState.attemptFullStart( >> GBeanInstanceState.java:268) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstanceState.start >> (GBeanInstanceState.java:102) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstanceState.startRecursive >> (GBeanInstanceState.java:124) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstance.startRecursive >> (GBeanInstance.java:553) >> at >> org.apache.geronimo.kernel.basic.BasicKernel.startRecursiveGBean >> (BasicKernel.java:379) >> at >> org.apache.geronimo.kernel.config.ConfigurationUtil.startConfiguration >> GBeans(ConfigurationUtil.java:448) >> at >> org.apache.geronimo.kernel.config.KernelConfigurationManager.start >> (KernelConfigurationManager.java:187) >> at >> org.apache.geronimo.kernel.config.SimpleConfigurationManager.startConf >> iguration(SimpleConfigurationManager.java:530) >> at >> org.apache.geronimo.kernel.config.SimpleConfigurationManager$ >> $FastClassByCGLIB$$ce77a924.invoke(<generated>) >> at net.sf.cglib.reflect.FastMethod.invoke(FastMethod.java:53) >> at >> org.apache.geronimo.gbean.runtime.FastMethodInvoker.invoke >> (FastMethodInvoker.java:38) >> at >> org.apache.geronimo.gbean.runtime.GBeanOperation.invoke >> (GBeanOperation.java:124) >> at >> org.apache.geronimo.gbean.runtime.GBeanInstance.invoke >> (GBeanInstance.java:830) >> at org.apache.geronimo.gbean.runtime.RawInvoker.invoke >> (RawInvoker.java:57) >> at >> org.apache.geronimo.kernel.basic.RawOperationInvoker.invoke >> (RawOperationInvoker.java:35) >> at >> org.apache.geronimo.kernel.basic.ProxyMethodInterceptor.intercept >> (ProxyMethodInterceptor.java:96) >> at >> org.apache.geronimo.gbean.GBeanLifecycle$$EnhancerByCGLIB$ >> $b023c139.startConfiguration(<generated>) >> >> >> >> JNDI URL in my quartz.properties file is: >> >> org.quartz.dataSource.myDS.jndiURL=java:comp/env/jdbc/MyDataSource >> >> >> And my geronimo-service.xml : >> >> <?xml version="1.0" encoding="UTF-8"?> >> <module xmlns="http://geronimo.apache.org/xml/ns/deployment-1.1";> >> <environment> >> <moduleId> >> <groupId>phaip-core</groupId> >> <artifactId>phaip-core</artifactId> >> <version>1.1</version> >> </moduleId> >> <dependencies> >> >> <dependency> >> <groupId>org.apache.activemq</groupId> >> <artifactId>activemq-core</artifactId> >> <version>4.1.1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>dbunit</groupId> >> <artifactId>dbunit</artifactId> >> <version>2.2</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>dj800ec</groupId> >> <artifactId>dj800ec</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>postgresql</groupId> >> <artifactId>postgresql-8.2</artifactId> >> <version>506.jdbc4</version> >> <type>jar</type> >> </dependency> >> >> >> <dependency> >> <groupId>spring</groupId> >> <artifactId>spring</artifactId> >> <version>2.5.1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>commons-collections</groupId> >> <artifactId>commons-collections</artifactId> >> <version>3.1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>commons-digester</groupId> >> <artifactId>commons-digester</artifactId> >> <version>1.8</version> >> <type>jar</type> >> </dependency> >> >> >> <dependency> >> <groupId>commons-logging</groupId> >> <artifactId>commons-logging</artifactId> >> <version>1.0.4</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>commons-beanutils</groupId> >> <artifactId>commons-beanutils</artifactId> >> <version>1.6.1</version> >> <type>jar</type> >> </dependency> >> >> >> <dependency> >> <groupId>jmx</groupId> >> <artifactId>jmx</artifactId> >> <version>5.0_r16</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>commons-logging-api</groupId> >> <artifactId>commons-logging-api</artifactId> >> <version>1.0.4</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>jdbc2_0-stdext</groupId> >> <artifactId>jdbc2_0-stdext</artifactId> >> <version>2.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>log4j</groupId> >> <artifactId>log4j</artifactId> >> <version>1.2.15</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>org.apache.geronimo.configs</groupId> >> <artifactId>openjpa</artifactId> >> <version>2.0.2</version> >> <type>car</type> >> </dependency> >> >> >> <dependency> >> <groupId>quartz</groupId> >> <artifactId>quartz-all</artifactId> >> <version>1.6.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>org.apache.geronimo.specs</groupId> >> <artifactId>geronimo-servlet_2.5_spec</artifactId> >> <version>1.1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>j2ee</groupId> >> <artifactId>javaee</artifactId> >> <version>9.1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>geronimo</groupId> >> <artifactId>geronimo-kernel</artifactId> >> <version>2.0.2</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>org.apache.geronimo.modules</groupId> >> <artifactId>geronimo-activation</artifactId> >> <version>2.0.2</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>org.apache.geronimo.specs</groupId> >> <artifactId>geronimo-ejb_3.0_spec</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> >> <dependency> >> <groupId>org.apache.ws.scout</groupId> >> <artifactId>scout</artifactId> >> <version>1.0rc1</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>ejb</groupId> >> <artifactId>ejb</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>jms</groupId> >> <artifactId>jms</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>jta</groupId> >> <artifactId>jta</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>junit</groupId> >> <artifactId>junit</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>mail</groupId> >> <artifactId>mail</artifactId> >> <version>1.3.3</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>derby</groupId> >> <artifactId>derby</artifactId> >> <version>10.3.2000001.599110</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>phaip</groupId> >> <artifactId>phaip-core</artifactId> >> <version>1.0</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>org.apache.geronimo.configs</groupId> >> <artifactId>xmlbeans</artifactId> >> <version>2.0.2</version> >> <type>car</type> >> </dependency> >> >> <dependency> >> <groupId>juddi</groupId> >> <artifactId>juddi-client</artifactId> >> <version>2.0rc5</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>juddi</groupId> >> <artifactId>juddi</artifactId> >> <version>2.0rc5</version> >> <type>jar</type> >> </dependency> >> >> <dependency> >> <groupId>console.dbpool</groupId> >> <artifactId>QuartzDS</artifactId> >> </dependency> >> >> </dependencies> >> >> <resource-ref> >> <ref-name>jdbc/MyDataSource</ref-name> >> <resource-link>QuartzDS</resource-link> >> </resource-ref> >> >> </environment> >> >> </module> >> >> >> >> I have created database pool through Geronimo Console and using name >> "QuartzDS".Please help. >> >> Qaiser Mehmood >> >> -- >> View this message in context: http://www.nabble.com/Adding-DB-pool- >> JNDI-in-Jar-tp14990200s134p14990200.html >> Sent from the Apache Geronimo - Users mailing list archive at >> Nabble.com. >> > > > -- View this message in context: http://www.nabble.com/Adding-DB-pool-JNDI-in-Jar-tp14990200s134p15032817.html Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.
