/explore
|
You are here 
|
www.greenstechnologys.com | ||
| | | | |
www.craigpardey.com
I came across an interesting problem recently in some JDBC code that was inserting rows into a Netezza database. The Java code was doing something like this: Statement stmt ... for( SomeObject o : listOfObjects) { String sql = "INSERT INTO tbl(col1, col2) values (?,?)"; ... stmt.addBatch(sql); } stmt.executeBatch(); On the "executeBatch()", a SQLException was being thrown that said "failed to create external table for bulk load". What? But it wasn't a bulk load. There were no external tables involved - it was a batch of vanilla inserts. |
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with... |
|
| | | | | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
noop.nl
The world is more complex than people like it to be. I regularly see blog posts of software experts providing us with values, principles, guidelines and practices to live our lives by. And all of them are good, and all of them are incomplete. I've seen improvements on the agile manifesto (Glen Alleman), additions to the agile manifesto (Jason Yip), conflicts over principles (Bob Martin vs. Joel Spolsky), controversy over practices (Ron Jeffries vs. me), and lots of other heated debates. Each discussion is valuable, and each is only half the story. We're all seeking simple truths where there aren't any. I believe it is time for a new manifesto. A manifesto of complexity. With this manifesto we must recognize that it is human to prefer simple solutions, but al... |
|
| | | |||
