DBCP: Why is the validation query not a prepared statement
Is there a reason for why the validation query is not a prepared statement? In the method PoolableConnectionFactory.validateConnection(Connection conn) the validation query is executed as a normal statement (conn.createStatement()). Would it be unsafe to use a prepared statement here instead? -- View this message in context: http://www.nabble.com/DBCP%3A-Why-is-the-validation-query-not-a-prepared-statement-tp22199341p22199341.html Sent from the Commons - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: [beanutils] converting HTTP params into an arbitrary object model
On Tue, Feb 24, 2009 at 3:09 PM, Matt Benson gudnabr...@yahoo.com wrote: --- On Tue, 2/24/09, Adam Hardy ahardy.str...@cyberspaceroad.com wrote: From: Adam Hardy ahardy.str...@cyberspaceroad.com Subject: Re: [beanutils] converting HTTP params into an arbitrary object model To: Commons Users List user@commons.apache.org Date: Tuesday, February 24, 2009, 3:19 AM Matt Benson on 23/02/09 16:23, wrote: --- On Sat, 2/21/09, Adam Hardy wrote: I have spent a day researching and prototyping with various open-source options available which facilitate converting an HTTP request's parameters into an object model of javabeans in a JPA persistence framework. You may want to check out Morph @ http://morph.sourceforge.net . OOTB, it can reflect ServletRequest parameters as bean properties and do a straight copy, as long as the servlet API is found on the classpath. I had a look at morph (following the link from the beanutils wiki) but their website didn't really enlighten me and what I did find didn't look very helpful, so I made a management decision not to pursue it. The problem is that there are that many little details to check for, e.g. can it handle sets, can it deduce the javabean items on generics, can it handle indexed lists of .0, .1, .2 notation etc Morph is not generics-enabled; it can handle most of your basic non-generic constructs (e.g. Sets) right out of the box and just about anything else you can throw at it if you want to implement its API here and there for custom transformations, and while I am 100% sure it can handle [n] index notation I am about 90% sure it also handles indices as property names as you have described (.n)--if not, that is pluggable. But this isn't the Morph list and, as you said, you made a management decision not to pursue it. As a Morph team member I will take your documentation didn't look very helpful criticism under advisement as well. Yeah its out-of-date http://tinyurl.com/dhsupb Niall Regards, Matt Regards Adam - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: Making BeanUtils.populate() fail on parse error?
Jason Cipriani on 23/02/09 17:16, wrote: Currently I am using BeanUtils.populate() to fill a bean with values from a map (specifically, with values from the parameter map of an HttpServletRequest). However, I noticed that when there is a parse error for a field, populate() sets some default value rather than failing. E.g. if there is a Long property but the corresponding string in the map is abc, the property is silently set to 0. What's the most convenient way to use the beanutils package to fill a bean from a parameter map but also be notified if a parse error occurs? Is there some way to configure populate() to throw an exception, or to otherwise check the conversion status afterwards? Is there something else in the library that does this? Hi Jason I use BeanUtils in this way too but I haven't come across this one. Sorry for the late reply, maybe you found a solution. I thought I would probably find one myself but got wrapped up in something else. At first glance it seems it could be that this is the default behaviour for the Long type converter. The type converters in BeanUtils are pretty simple and don't allow much flexibility. If this is the problem (and a quick look in the beanutils source code on the website will confirm it) then you'll have to code your own converter which doesn't do this. Converters are easy, the only pain is that you have to register them with ConvertUtils in code at some place in your app. I'd be interested to hear your progress. Regards Adam - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: Commons Net 2.0
On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, Does anyone use the above on OSX with Java 5. The code that was running with 1.4.1 version of the library seems to be failing with the following exception, Caused by: java.net.SocketException: Unconnected sockets not implemented at javax.net.SocketFactory.createSocket(SocketFactory.java:97) at org.apache.commons.net.SocketClient.connect(SocketClient.java:152) I've seen the same error message in JMeter, when moving from Java 1.4 to 1.6. That was due to a change in the way the Java uses socket factories. It now uses createSocket() rather than any of the createSocket(...) methods with parameters. Looks like this may be the problem here. I suggest you create a JIRA issue for this. Ta Meeraj - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: [beanutils] converting HTTP params into an arbitrary object model
Niall Pemberton on 25/02/09 10:54, wrote: On Tue, Feb 24, 2009 at 3:09 PM, Matt Benson gudnabr...@yahoo.com wrote: --- On Sat, 2/21/09, Adam Hardy wrote: The problem is that there are that many little details to check for, e.g. can it handle sets, can it deduce the javabean items on generics, can it handle indexed lists of .0, .1, .2 notation etc Morph is not generics-enabled; it can handle most of your basic non-generic etc etc [snipped] Yeah its out-of-date http://tinyurl.com/dhsupb Hi Niall, were you skiing? that's the only valid excuse I'll accept for your tardy response I'm afraid. Well ok i might let you off for anything involving hospitalisation, death or taxes ;) Is there any kind of roadmap for beanutils to bring in decent locale handling and more refined converter mapping? (mapping a converter to a property, not just a complete class) I like beanutils - some people say it's got a (inter-)face only a mother could love, but I think it's OK. regards Adam - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: Commons Net 2.0
k, thanks. Strange thing is I have seen this posted on a number of lists and has been attributed to Java 6. However, I am running this with Java 5 on OSX. Ta Meeraj On Wed, Feb 25, 2009 at 12:29 PM, sebb seb...@gmail.com wrote: On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, Does anyone use the above on OSX with Java 5. The code that was running with 1.4.1 version of the library seems to be failing with the following exception, Caused by: java.net.SocketException: Unconnected sockets not implemented at javax.net.SocketFactory.createSocket(SocketFactory.java:97) at org.apache.commons.net.SocketClient.connect(SocketClient.java:152) I've seen the same error message in JMeter, when moving from Java 1.4 to 1.6. That was due to a change in the way the Java uses socket factories. It now uses createSocket() rather than any of the createSocket(...) methods with parameters. Looks like this may be the problem here. I suggest you create a JIRA issue for this. Ta Meeraj - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: FTPClient Stalls on STOR
I have narrowed this down further. If the client (FTPClient) and server are on the same Solarix box it works and it also works across different Solaris boxes. However, if I put an F5 load balancer in the middle it consistently fails on 1.7 Gb. Ta Meeraj On Wed, Feb 25, 2009 at 4:48 AM, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, 1. Native Solaris FTP client and Solaris FTP server works 2. Commons Net FTPClient on OSX and OSX FTP server works 3. Commons Net FTPClient on Solaris and Solaris FTP server doesn't work Unfortunately, I can't get the OSX client connected to Solaris or the other way around. Many thanks Meeraj On Wed, Feb 25, 2009 at 4:11 AM, sebb seb...@gmail.com wrote: On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Just to add some more information, the same code with same configurations runs fine on OSX. Is that client OSX, server OSX or both? What happens if you run the client on Solaris and the server on OSX? What about another FTP Client (e.g. one that comes with the OS) - does that work OK? The error looks more like a server issue rather than a client issue - perhaps there is a TCP stack configuration problem on the server. On Wed, Feb 25, 2009 at 2:22 AM, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, I am trying to send a large file (2 gig) to a remote server using FTPClient. And the transfer consistently stalls at around 1.7 gig and throws the below exception subsequently. Interestingly, if I run five concurrent threads each with its own instance of FTPClient, all of then hang when the cumulative transfer gets to around 1.7 gig. Both my client and server are running on Solaris 10 X64 (64 bit AMD Optron). Any pointers would be of great help. org.osoa.sca.ServiceUnavailableException: java.net.SocketException: Broken pipe at org.sca4j.binding.ftp.runtime.FtpTargetInterceptor.invoke(FtpTargetInterceptor.java:117) at org.sca4j.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:168) at $Proxy30.receiveData(Unknown Source) at com.voca.bgc.gateway.router.FtpPassThroughRouter.receiveData(FtpPassThroughRouter.java:45) 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:585) at org.sca4j.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:162) at org.sca4j.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:130) at org.sca4j.binding.ftp.runtime.BindingFtpLet.onUpload(BindingFtpLet.java:91) at org.sca4j.ftp.server.handler.StorRequestHandler.transfer(StorRequestHandler.java:169) at org.sca4j.ftp.server.handler.StorRequestHandler.service(StorRequestHandler.java:107) at org.sca4j.ftp.server.host.FtpHandler.messageReceived(FtpHandler.java:99) at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:722) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802) at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:392) at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:228) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802) at org.apache.mina.core.filterchain.IoFilterEvent.fire(IoFilterEvent.java:59) at org.apache.mina.core.session.IoEvent.run(IoEvent.java:64) at org.sca4j.ftp.server.host.SCA4JExecutorService$1.execute(SCA4JExecutorService.java:47) at org.sca4j.host.work.DefaultPausableWork.run(DefaultPausableWork.java:103) at org.sca4j.threadpool.ThreadPoolWorkScheduler$DecoratingWork.run(ThreadPoolWorkScheduler.java:112) at
Re: Commons Net 2.0
On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: k, thanks. Strange thing is I have seen this posted on a number of lists and has been attributed to Java 6. However, I am running this with Java 5 on OSX. Maybe Java 5 on OSX is different. Ta Meeraj On Wed, Feb 25, 2009 at 12:29 PM, sebb seb...@gmail.com wrote: On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, Does anyone use the above on OSX with Java 5. The code that was running with 1.4.1 version of the library seems to be failing with the following exception, Caused by: java.net.SocketException: Unconnected sockets not implemented at javax.net.SocketFactory.createSocket(SocketFactory.java:97) at org.apache.commons.net.SocketClient.connect(SocketClient.java:152) I've seen the same error message in JMeter, when moving from Java 1.4 to 1.6. That was due to a change in the way the Java uses socket factories. It now uses createSocket() rather than any of the createSocket(...) methods with parameters. Looks like this may be the problem here. I suggest you create a JIRA issue for this. Ta Meeraj - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: FTPClient Stalls on STOR
On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: I have narrowed this down further. If the client (FTPClient) and server are on the same Solarix box it works and it also works across different Solaris boxes. However, if I put an F5 load balancer in the middle it consistently fails on 1.7 Gb. That suggest that F5 may be implicated. Does it fail with OS FTP client and F5 load balancer? Ta Meeraj On Wed, Feb 25, 2009 at 4:48 AM, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, 1. Native Solaris FTP client and Solaris FTP server works 2. Commons Net FTPClient on OSX and OSX FTP server works 3. Commons Net FTPClient on Solaris and Solaris FTP server doesn't work Unfortunately, I can't get the OSX client connected to Solaris or the other way around. Many thanks Meeraj On Wed, Feb 25, 2009 at 4:11 AM, sebb seb...@gmail.com wrote: On 25/02/2009, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Just to add some more information, the same code with same configurations runs fine on OSX. Is that client OSX, server OSX or both? What happens if you run the client on Solaris and the server on OSX? What about another FTP Client (e.g. one that comes with the OS) - does that work OK? The error looks more like a server issue rather than a client issue - perhaps there is a TCP stack configuration problem on the server. On Wed, Feb 25, 2009 at 2:22 AM, Meeraj Kunnumpurath mkunnumpur...@googlemail.com wrote: Hi, I am trying to send a large file (2 gig) to a remote server using FTPClient. And the transfer consistently stalls at around 1.7 gig and throws the below exception subsequently. Interestingly, if I run five concurrent threads each with its own instance of FTPClient, all of then hang when the cumulative transfer gets to around 1.7 gig. Both my client and server are running on Solaris 10 X64 (64 bit AMD Optron). Any pointers would be of great help. org.osoa.sca.ServiceUnavailableException: java.net.SocketException: Broken pipe at org.sca4j.binding.ftp.runtime.FtpTargetInterceptor.invoke(FtpTargetInterceptor.java:117) at org.sca4j.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:168) at $Proxy30.receiveData(Unknown Source) at com.voca.bgc.gateway.router.FtpPassThroughRouter.receiveData(FtpPassThroughRouter.java:45) 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:585) at org.sca4j.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:162) at org.sca4j.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:130) at org.sca4j.binding.ftp.runtime.BindingFtpLet.onUpload(BindingFtpLet.java:91) at org.sca4j.ftp.server.handler.StorRequestHandler.transfer(StorRequestHandler.java:169) at org.sca4j.ftp.server.handler.StorRequestHandler.service(StorRequestHandler.java:107) at org.sca4j.ftp.server.host.FtpHandler.messageReceived(FtpHandler.java:99) at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:722) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802) at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:392) at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:228) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:48) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:802) at
RE: DBCP: Why is the validation query not a prepared statement
This is just a guess, but perhaps some JDBC drivers hold the prepare and bundle it with the first execute. -Original Message- From: Gamnacke [mailto:gamna...@yahoo.se] Sent: Wednesday, February 25, 2009 1:39 AM To: user@commons.apache.org Subject: DBCP: Why is the validation query not a prepared statement Is there a reason for why the validation query is not a prepared statement? In the method PoolableConnectionFactory.validateConnection(Connection conn) the validation query is executed as a normal statement (conn.createStatement()). Would it be unsafe to use a prepared statement here instead? -- View this message in context: http://www.nabble.com/DBCP%3A-Why-is-the-validation-query-not-a-prepared -statement-tp22199341p22199341.html Sent from the Commons - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: [beanutils] converting HTTP params into an arbitrary object model
On Wed, Feb 25, 2009 at 12:53 PM, Adam Hardy ahardy.str...@cyberspaceroad.com wrote: Niall Pemberton on 25/02/09 10:54, wrote: On Tue, Feb 24, 2009 at 3:09 PM, Matt Benson gudnabr...@yahoo.com wrote: --- On Sat, 2/21/09, Adam Hardy wrote: The problem is that there are that many little details to check for, e.g. can it handle sets, can it deduce the javabean items on generics, can it handle indexed lists of .0, .1, .2 notation etc Morph is not generics-enabled; it can handle most of your basic non-generic etc etc [snipped] Yeah its out-of-date http://tinyurl.com/dhsupb Hi Niall, were you skiing? that's the only valid excuse I'll accept for your tardy response I'm afraid. Well ok i might let you off for anything involving hospitalisation, death or taxes ;) Yes all of those I'm afraid! Is there any kind of roadmap for beanutils to bring in decent locale handling and more refined converter mapping? (mapping a converter to a property, not just a complete class) None that I know of. I like beanutils - some people say it's got a (inter-)face only a mother could love, but I think it's OK. :) Niall regards Adam - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
[dbcp] poolPreparedStatements parameter
Hi All, I would like to ask why poolPreparedStatements is false by default. It seems that setting it to true could improve performances (I haven't tried it, but it seems useful) Is there any drawback or known issues ? thanks a lot ste - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
Re: [dbcp] poolPreparedStatements parameter
Just guessing, Probably because PreparedStatements are not used in many applications and thus by having the pooling option turned off by default it saves the overhead involved in maintaining the pools. Can a expert validate by guess and if it is not correct provide a sane explanation? :) Cheers Anurag -- Anurag Kapur Associate - Technology, Sapient Corporation India. http://www.linkedin.com/in/anuragkapur -- On Wed, Feb 25, 2009 at 9:49 PM, Stefano Nichele stefano.nich...@gmail.comwrote: Hi All, I would like to ask why poolPreparedStatements is false by default. It seems that setting it to true could improve performances (I haven't tried it, but it seems useful) Is there any drawback or known issues ? thanks a lot ste - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org
RE: [dbcp] poolPreparedStatements parameter
Another guess is that modern database do a pretty good job of caching queries at the server, so why not let the database server do the caching for you? -Original Message- From: Anurag Kapur [mailto:anuragka...@gmail.com] Sent: Wednesday, February 25, 2009 3:43 PM To: Commons Users List Subject: Re: [dbcp] poolPreparedStatements parameter Just guessing, Probably because PreparedStatements are not used in many applications and thus by having the pooling option turned off by default it saves the overhead involved in maintaining the pools. Can a expert validate by guess and if it is not correct provide a sane explanation? :) Cheers Anurag -- Anurag Kapur Associate - Technology, Sapient Corporation India. http://www.linkedin.com/in/anuragkapur -- On Wed, Feb 25, 2009 at 9:49 PM, Stefano Nichele stefano.nich...@gmail.comwrote: Hi All, I would like to ask why poolPreparedStatements is false by default. It seems that setting it to true could improve performances (I haven't tried it, but it seems useful) Is there any drawback or known issues ? thanks a lot ste - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org - To unsubscribe, e-mail: user-unsubscr...@commons.apache.org For additional commands, e-mail: user-h...@commons.apache.org