java.beans.IntrospectionException: Method not found: setUrl

[afany firdaus]

Hi there masters,

It's the first time I use HikariCP, and I have a little problem.

I set my context.xml like this :

<?xml version='1.0' encoding='utf-8'?>

<!--<Context antiJARLocking="true" path=""/>-->

<Context antiJARLocking="true" path="">

    <!-- Default set of monitored resources -->

    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <Resource name="name" auth="Container"

              factory="com.zaxxer.hikari.HikariJNDIFactory"

              type="javax.sql.DataSource"

              minimumIdle="4"

              maximumPoolSize="8"

              connectionTimeout="3000"

              autoCommit="false"

              dataSourceClassName="org.postgresql.ds.PGSimpleDataSource"

              dataSource.user="username"

              dataSource.password="password"

              dataSource.url="jdbc:postgresql://localhost:5432/databaseName"/>

</Context>

And when I run my project, it has an error like this:

[http-nio-4044-exec-33] ERROR com.zaxxer.hikari.util.PropertyBeanSetter - Property url is does not exist on target class class org.postgresql.ds.PGSimpleDataSource

22-Apr-2015 09:48:15.312 WARNING [http-nio-4044-exec-33] org.apache.naming.NamingContext.lookup Unexpected exception resolving reference

 java.lang.RuntimeException: java.beans.IntrospectionException: Method not found: setUrl

at com.zaxxer.hikari.util.PropertyBeanSetter.setProperty(PropertyBeanSetter.java:134)

at com.zaxxer.hikari.util.PropertyBeanSetter.setTargetFromProperties(PropertyBeanSetter.java:63)

at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:154)

at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)

at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)

at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)

at com.zaxxer.hikari.HikariJNDIFactory.createDataSource(HikariJNDIFactory.java:82)

at com.zaxxer.hikari.HikariJNDIFactory.getObjectInstance(HikariJNDIFactory.java:73)

at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:141)

at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)

at org.apache.naming.NamingContext.lookup(NamingContext.java:841)

at org.apache.naming.NamingContext.lookup(NamingContext.java:166)

at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1070)

at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:649)

at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:248)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)

at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)

at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5057)

at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:702)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:697)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:579)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:455)

at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1554)

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.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:300)

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)

at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)

at org.apache.catalina.manager.ManagerServlet.check(ManagerServlet.java:1428)

at org.apache.catalina.manager.ManagerServlet.deploy(ManagerServlet.java:885)

at org.apache.catalina.manager.ManagerServlet.doGet(ManagerServlet.java:343)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:618)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:301)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:615)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:136)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:74)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1015)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:652)

at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1575)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1533)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)

Caused by: java.beans.IntrospectionException: Method not found: setUrl

at java.beans.PropertyDescriptor.<init>(PropertyDescriptor.java:110)

at com.zaxxer.hikari.util.PropertyBeanSetter.setProperty(PropertyBeanSetter.java:125)

... 63 more

FYI, I am using activeWeb.

Please help me to solve this. Thank You.

[Brett Wooldridge]

Probably the JNDI example in the wiki is somewhat misleading.  The "url" property of the "dataSource.url" configuration in the wiki is specific to Oracle.  The OracleDataSource has a setUrl() method.  However, PGSimpleDataSource does not have such a method.

What you probably want, instead of "dataSource.url", in this case is:

dataSource.serverName=localhost

dataSource.portNumber=5432

dataSource.databaseName=<your_database_name_here>

-Brett