I have a array of Strings "String[]" with certain values. I want to pass that array dynamically to SQL "IN" clause something like:  Select * from Employee where emp_name in (?);   Here "?" has to replaced with String Array. I want to do this in Java Class. I tried with   Array array = conn.createArrayOf("VARCHAR", new Object[]{"1", "2","3"}); pstmt.setArray(1, array);   But it is not working and getting exception "SQLFeatureException".  Thanks!!!
What are the best workarounds for using a SQL IN clause with instances of java.sql.PreparedStatement, which is not supported for multiple values due to SQL injection attack security issues: One ? placeholder represents one value, rather than a list of values.  Consider the following SQL statement:  SELECT my_column FROM my_table where search_column IN (?)   Using preparedStatement.setString( 1, "'A', 'B', 'C'" ); is essentially a non-working attempt at a workaround of the reasons for using ? in the first place.    What workarounds are available?
Interpretation of the t.test and Wilcox.test in R Why are springs shaped the way they are? Why are springs coiled the way they are? Why not some other shape? Is the shape due to its elasticity or something? As an example, consider the two sentences:     There don't seem to be any doctors here.   and     There doesn't seem to be any doctors here.   To my ear, the first sounds great, and the second is painfully awkward.  So which is correct, grammatically? I've found lots of disagreement on this around the Web, with various sources citing different ways of treating the word "any" (as singular, always, or as either depending on to what it refers). No consensus, however, could I locate. I recently bought myself a pack of four YN560 IV's and a YN560-TX for my Canon camera, and apparently I got ahead of myself and didn't realise I should make sure the flashes support HSS.  I tried them out yesterday at home, and even on 1/128 and 1/250s on the camera, they were overexposing here and there. Unfortunately, I don't really have the space to move the flashes much further from my subject, so I was wondering if there is any way to trick them into HSS? I should mention that I also own a Canon 580ex II, which does support HSS. I was thinking I could perhaps use that mounted on the camera to trigger the Yongnuo's, but as far as I can tell that would render the 560-TX useless as the flashes can't be controlled wirelessly when in S1 or S2.  I guess I could buy an ND filter, but as I have lenses with differing sizes, this feels like more of a pain in the ass.  Is there any hack I can pull off here that you guys know of?  Thanks! Is the sign of principal components meaningless? If I create just a basic hello.tex file an compile it using   pdflatex hello.tex   The pdflatex program is creating a plethora of file which is a little annoying. Currently it writes all those files about which I really don't care:  hello.aux, hello.log, hello.nav, hello.out, hello.snm, hello.toc   Is there a way to tell pdflatex to only write hello.pdf if the build is successful ? If not, can I specify the output directory of those files ? Maybe I could just write them in /tmp. Empty drives show 2 GB used, Explorer shows nothing I have 4 drives in Windows: C:, D:, E: and F:. Except C:, all of them are empty.    Suddenly it shows up to 2 GB space used – even when there are no files.     [  When I format the drives, it's fine for a while until it shows used space again.  I use Windows 8.1 Pro 64 Bit. Headers and font in KOMA-script I am setting up the layout for my bachelor thesis using scrbook as basis for a self-made documentclass with twosided print. I want a header containing the current part number and name on the outer side (left on even pages, right on odd pages), the current chapter number and name on the center of the head and the same for section on the inner side. I found this example in the KOMA-Script documentation:  \usepackage{scrlayer-scrpage} \pagestyle{scrheadings} \automark[chapter]{chapter} \automark*[section]{}   It puts the chapter on the outer side on even pages and the section on the outer side on odd pages. Sadly, I was not able to modify this to fit my needs because I do not really understand the way KOMA-Script works here. If a part starts but there is still no chapter in it, the place for the chapter shall remain empty (same for chapter and section). Can anyone help?  Furthermore, I would like to change all fonts that KOMA-Script changes (e.g. toc, section, chapter...) back to the default computer modern as I do not like the font KOMA-Script uses here. Is there a better way than changing all the fonts manually like this:  \addtokomafont{section}{\fontfamily{cmr}\selectfont} Are there 'stack' sites for Mac or Windows? Why was Enterprise on a five-year mission in TOS? There is a small difference between intro texts in TOS:     Space: the final frontier. These are the voyages of the starship Enterprise. Its five-year mission: to explore strange new worlds, to seek out new life and new civilizations, to boldly go where no man has gone before.   and in TNG:     Space: the final frontier. These are the voyages of the starship Enterprise. Its continuing mission: to explore strange new worlds, to seek out new life and new civilizations, to boldly go where no one has gone before.   (emphasis mine)  It's pretty obvious that no man was changed to no one to include women. But, is there any explanation why was five-year changed to continuing? Also, why was it a five-year mission at all?  My only assumptions are:   Gene Roddenberry hoped to get funding to run the show for 5 seasons. Gene Roddenberry just made up a number without any special meaning. Gene Roddenberry was a .   Is there any official explanation, in universe or not? Problem with literate and breaklines=true in listings package As the title says, the option breaklines=true seems to have an undesired interaction when using literate; in the following example the closing parenthesis doesn't get colorized   \documentclass{article} \usepackage{xcolor} \usepackage{listings}  \lstset{   literate=     {)}{{\textcolor{red}{)}}}{1}     {(}{{\textcolor{red}{(}}}{1},   breaklines=true, }  \begin{document}  \begin{lstlisting} () \end{lstlisting}  \end{document}     Commenting out the breaklines=true option produces the desired result. What is producing this odd behaviour and how can it be prevented? network manager says "device not managed" Solder does not stick to tip of soldering iron? Basic question here, but it's driving me insane!  The solder does not seem to stick to the tip of my soldering iron. After the iron heats up, the tip appears black (sometimes on all sides and sometimes on one side), then either it doesn't melt the solder at all, or it I fiddle around with it for a while; it melts the solder, but the solder rolls into itself into a ball and doesn't stick to the tip.  I've seen this many times while soldering before and usually it's solved by cleaning the tip on a soldering sponge or cooling it down and scraping the tip off with a blade, but I have scraped this particular one many times and still it's the same problem: it heats up and gets black, then the solder doesn't stick to it.  It doesn't help that this soldering iron has a very fine tip and I have to use it to solder very tiny chips and wires under a microscope (I'm just starting to learn soldering under microscopes).  Any ideas on what I can do?    PS: Is scraping the tip a bad idea? I have been doing it with my other bigger soldering irons and it seemed to work (at least in most cases) but I am not sure whether it is a good solution or not. How common is "thrice"? Redefining nodata value into zero in QGIS I have an image which I clipped with an AOI polygon. The contour area was set to pixel value = 0 and I have a nodata value of -32768. I want to redefine the nodata value into zero. I used to do this with ArcMap easily in the raster calculator, but in QGIS I don't see how I could do it. Any ideas? What is the most popular open source password manager which I can use on a Ubuntu machine or preferably across Ubuntu/Windows machines with some form of data compatibility. If there is a free web based version, that would be even more preferable. How do I remap the keys on my keyboard? I broke my laptop and had to buy a new one with a new keyboard that I am struggling to get familiar with, especially with the keys like home, page-up, page-down and end, which aren't standardized at all.  I found myself doing this for like the 5th time in the last several years, and I think it is really annoying.   Is there an app that can reliably map one key to another?  By reliably I mean that key mapping works with Shift, Alt, and other modifiers.  UPDATE  Windows 7, Samsung Chronos 7 TP-LINK TL-WN823N Unable to connect to network Print floating point values without leading zero Cold fusion is being mentioned a lot lately because of some new setup that apparently works. This is an unverified claim.  See for example:         ( of that last link in the Wayback Machine, given frequent  from that page.)   While we should give the scientific community time to evaluate the set up and eventually replicate the results, there is undoubtedly some skepticism that cold fusion would work at all, because the claim is quite extraordinary.  In the past, after Fleischmann and Pons announced their cold fusion results, in perfectly good faith, they were proven wrong by subsequent experiments.  What are the experimental realities that make Fleischmann and Pons style cold fusions experiments easy to get wrong?  Would the same risks apply to this new set up?