StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I got in touch with one of the engineers at Sybase and they provided me a code sample. So, I get to answer my own question.</p> <p>Basically here is a rundown, as the code sample is pretty large... This assumes a lot of pre initialized variables, but otherwise it would be a few hundred lines. Anyone interested should get the idea. This can yield up to 22K insertions a second in a perfect world (as per Sybase anyway).</p> <pre><code>SybDriver sybDriver = (SybDriver) Class.forName("com.sybase.jdbc3.jdbc.SybDriver").newInstance(); sybDriver.setVersion(com.sybase.jdbcx.SybDriver.VERSION_6); DriverManager.registerDriver(sybDriver); //DBProps (after including normal login/password etc. props.put("ENABLE_BULK_LOAD","true"); //open connection here for sybDriver dbConn.setAutoCommit(false); String SQLString = "insert into batch_inserts (row_id, colname1, colname2)\n values (?,?,?) \n"; PreparedStatement pstmt; try { pstmt = dbConn.prepareStatement(SQLString); } catch (SQLException sqle) { displaySQLEx("Couldn't prepare statement",sqle); return; } for (String[] val : valuesToInsert) { pstmt.setString(1, val[0]); //row_id varchar(30) pstmt.setString(2, val[1]);//logical_server varchar(30) pstmt.setString(3, val[2]); //client_host varchar(30) try { pstmt.addBatch(); } catch (SQLException sqle) { displaySQLEx("Failed to build batch",sqle); break; } } try { pstmt.executeBatch(); dbConn.commit(); pstmt.close(); } catch (SQLException sqle) { //handle } try { if (dbConn != null) dbConn.close(); } catch (Exception e) { //handle } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload