tag:blogger.com,1999:blog-6527688743456205256.post3495539251587146116..comments2024-03-29T22:58:35.913+11:00Comments on The Blas from Pas: Tomcat 6.0 / UCP Data Source SetupPas Apicellahttp://www.blogger.com/profile/09389663166398991762noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6527688743456205256.post-75771514346198435152010-08-12T20:37:19.094+10:002010-08-12T20:37:19.094+10:00Also would be curious to know what your data sourc...Also would be curious to know what your data source config looked like on jetty and what you did to set it up on that. I have never used Jetty but would be worth knowing.<br /><br />1. Where does ucp.jar and ojdbc5.jar go? I assume some LIB dir<br />2. Where to define data source and what does it look like?<br />3. What is the JNDI look up code to find the DS?<br />4. Can all web apps use the same DS?<br /><br />Thanks..Pas Apicellahttps://www.blogger.com/profile/09389663166398991762noreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-60743275696009738212010-08-12T09:47:39.630+10:002010-08-12T09:47:39.630+10:00Would need the full stack trace to see why it coul...Would need the full stack trace to see why it couldn't create a Pool. It may indicate why not.Pas Apicellahttps://www.blogger.com/profile/09389663166398991762noreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-80778509271172498962010-08-12T08:06:59.225+10:002010-08-12T08:06:59.225+10:00About my last comment, the UPC works some times, a...About my last comment, the UPC works some times, and some times throws the exception (Tomcat and jetty)<br /><br />oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource<br /><br />Any Idea?<br /><br />EmacAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-28582428296044016802010-08-10T03:32:27.526+10:002010-08-10T03:32:27.526+10:00With this configuration I am getting this error in...With this configuration I am getting this error in tomcat 6<br /><br />Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource<br /><br />But is working in Jetty:(<br /><br />Thanks.<br /><br />EmacAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-2257656757901180112010-07-05T20:04:47.813+10:002010-07-05T20:04:47.813+10:00Thanks for pointing that out..Thanks for pointing that out..Pas Apicellahttps://www.blogger.com/profile/09389663166398991762noreply@blogger.comtag:blogger.com,1999:blog-6527688743456205256.post-91873336658296875712010-07-05T06:16:40.840+10:002010-07-05T06:16:40.840+10:00You set the setSQLForValidateConnection but those ...You set the <i>setSQLForValidateConnection</i> but those were the old days. The Oracle UCP Developer's Guide says: <br /><br />The <i>setSQLForValidateConnection</i> property is not<br />recommended when using an Oracle JDBC driver. UCP for JDBC<br />performs an internal ping when using an Oracle JDBC driver. The<br />mechanism is faster than executing an SQL statement and is<br />overridden if this property is set. Instead, set the<br /><i>setValidateConnectionOnBorrow</i> property to true and do not<br />include the <i>setSQLForValidateConnection</i> property.Anonymousnoreply@blogger.com