Connection Pools + Special Characters + JDBC-ODBC
I have 3 questions:
1) Do you know any good JDBC connection pooling libraries? Maybe one that doesn't need much setup? Something free that I can bundle with my .WARs ?
2) What characters I need to intercept in a user's input before I can put them in a database? (besides ' and %)
3) Is connection pooling efficient when it comes to JDBC-ODBC?
[377 byte] By [
SPasmofiT] at [2007-9-26 6:33:49]
2) depends on which database, if for Oracle may be _ other than those two, if it is for search filtering.
3) Connection Pooling is efficient whether jdbc-odbc or anything else, because basically u are trying to pool the connections and reuse them rather than making them everytime, efficiency also depends on your initial configuration of how many connections in your pool initial size maximum size , system size and also your database connection settings like timeout settings ect
If a user enters "my name is 'something' % too" in a search box, for example, the SQL SLECT will look like this:SELECT * FROM files WHERE field LIKE 'my name is 'something' % too'Do you now see the problem ?
So. How can you handle such kind of problem? I experience when transfer "double" charactersto hex code (by java.net.URLEncode.encode()), then save it in MS-SQL through JDBC-ODBC. MS-SQL transforms some combination of characters (%nn, +) to else characters.
c3k at 2007-7-1 15:45:52 >
