| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| |
| <title>DBUtil (Net4j DB Framework Documentation)</title> |
| <meta name="date" content=""> |
| <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style"> |
| <script type="text/javascript" src="../../../../script.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="DBUtil (Net4j DB Framework Documentation)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var methods = {"i0":9,"i1":9,"i2":9,"i3":9,"i4":9,"i5":9,"i6":9,"i7":9,"i8":9,"i9":9,"i10":9,"i11":9,"i12":9,"i13":9,"i14":9,"i15":9,"i16":9,"i17":9,"i18":9,"i19":9,"i20":9,"i21":9,"i22":9,"i23":9,"i24":9,"i25":9,"i26":9,"i27":41,"i28":41,"i29":9,"i30":9,"i31":9,"i32":9,"i33":9,"i34":9,"i35":9,"i36":9,"i37":9,"i38":9,"i39":9,"i40":9,"i41":9,"i42":9,"i43":9,"i44":9,"i45":9,"i46":9,"i47":9,"i48":9,"i49":9,"i50":9,"i51":9,"i52":41,"i53":41,"i54":9,"i55":9,"i56":9}; |
| var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],8:["t4","Concrete Methods"],32:["t6","Deprecated Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a name="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/DBUtil.html">Use</a></li> |
| <li><a href="../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../org/eclipse/net4j/db/DBType.html" title="enum in org.eclipse.net4j.db"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html" title="interface in org.eclipse.net4j.db"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../index.html?org/eclipse/net4j/db/DBUtil.html" target="_top">Frames</a></li> |
| <li><a href="DBUtil.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_top"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li><a href="#nested.class.summary">Nested</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <div class="header"> |
| <div class="subTitle">org.eclipse.net4j.db</div> |
| <h2 title="Class DBUtil" class="title">Class DBUtil</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li>java.lang.Object</li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.eclipse.net4j.db.DBUtil</li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <hr> |
| <br> |
| <pre>public final class <span class="typeNameLabel">DBUtil</span> |
| extends java.lang.Object</pre> |
| <div class="block">A utility class with various static factory and convenience methods.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Author:</span></dt> |
| <dd>Eike Stepper</dd> |
| </dl> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ======== NESTED CLASS SUMMARY ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="nested.class.summary"> |
| <!-- --> |
| </a> |
| <h3>Nested Class Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Nested Class Summary table, listing nested classes, and an explanation"> |
| <caption><span>Nested Classes</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Class and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static interface </code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.DeserializeRowHandler</a></span></code> |
| <div class="block">A <a href="../../../../org/eclipse/net4j/db/DBUtil.RowHandler.html" title="interface in org.eclipse.net4j.db"><code>row handler</code></a> with a <a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html#handleRow-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField:A-java.lang.Object:A-"><code>method</code></a> |
| that is called once per row deserialized within <a href="../../../../org/eclipse/net4j/db/DBUtil.html#deserializeTable-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-org.eclipse.net4j.util.om.monitor.OMMonitor-org.eclipse.net4j.db.DBUtil.DeserializeRowHandler-"><code>DBUtil.deserializeTable()</code></a>.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static interface </code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.RowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.RowHandler</a></span></code> |
| <div class="block">Call-back interface with a <a href="../../../../org/eclipse/net4j/db/DBUtil.RowHandler.html#done-boolean-"><code>method</code></a> that is called <i>after</i> |
| a number of table rows have been handled by one of the subtypes of this interface.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static interface </code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.RunnableWithConnection.html" title="interface in org.eclipse.net4j.db">DBUtil.RunnableWithConnection</a><<a href="../../../../org/eclipse/net4j/db/DBUtil.RunnableWithConnection.html" title="type parameter in DBUtil.RunnableWithConnection">T</a>></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static interface </code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.SerializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.SerializeRowHandler</a></span></code> |
| <div class="block">A <a href="../../../../org/eclipse/net4j/db/DBUtil.RowHandler.html" title="interface in org.eclipse.net4j.db"><code>row handler</code></a> with a <a href="../../../../org/eclipse/net4j/db/DBUtil.SerializeRowHandler.html#handleRow-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField:A-java.lang.Object:A-"><code>method</code></a> |
| that is called once per row serialized within <a href="../../../../org/eclipse/net4j/db/DBUtil.html#serializeTable-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-java.lang.String-java.lang.String-org.eclipse.net4j.db.DBUtil.SerializeRowHandler-"><code>DBUtil.serializeTable()</code></a>.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Field and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#MAX_BATCH_SIZE">MAX_BATCH_SIZE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static java.lang.String</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#PROP_ENABLE_NOISY_CLOSE">PROP_ENABLE_NOISY_CLOSE</a></span></code> |
| <div class="block">A system property to enable noisy close, i.e.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span><span id="t6" class="tableTab"><span><a href="javascript:show(32);">Deprecated Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Method and Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#asInt-java.lang.Object-">asInt</a></span>(java.lang.Object value)</code> </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code>static long</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#asLong-java.lang.Object-">asLong</a></span>(java.lang.Object value)</code> </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/BatchedStatement.html" title="interface in org.eclipse.net4j.db">BatchedStatement</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#batched-java.sql.PreparedStatement-int-">batched</a></span>(java.sql.PreparedStatement delegate, |
| int batchSize)</code> </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#clearTable-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-">clearTable</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table)</code> </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#clearTable-java.sql.Connection-java.lang.String-">clearTable</a></span>(java.sql.Connection connection, |
| java.lang.String tableName)</code> </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code>static java.lang.Exception</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#close-java.sql.Connection-">close</a></span>(java.sql.Connection connection)</code> </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code>static java.lang.Exception</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#close-java.sql.ResultSet-">close</a></span>(java.sql.ResultSet resultSet)</code> </td> |
| </tr> |
| <tr id="i7" class="rowColor"> |
| <td class="colFirst"><code>static java.lang.Exception</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#close-java.sql.Statement-">close</a></span>(java.sql.Statement statement)</code> </td> |
| </tr> |
| <tr id="i8" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#copySchema-org.eclipse.net4j.db.ddl.IDBSchema-">copySchema</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> source)</code> </td> |
| </tr> |
| <tr id="i9" class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createConnectionProvider-javax.sql.DataSource-">createConnectionProvider</a></span>(javax.sql.DataSource dataSource)</code> </td> |
| </tr> |
| <tr id="i10" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider2.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider2</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createConnectionProvider-javax.sql.DataSource-java.lang.String-">createConnectionProvider</a></span>(javax.sql.DataSource dataSource, |
| java.lang.String user)</code> </td> |
| </tr> |
| <tr id="i11" class="rowColor"> |
| <td class="colFirst"><code>static javax.sql.DataSource</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createDataSource-java.util.Map-">createDataSource</a></span>(java.util.Map<java.lang.Object,java.lang.Object> properties)</code> </td> |
| </tr> |
| <tr id="i12" class="altColor"> |
| <td class="colFirst"><code>static javax.sql.DataSource</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createDataSource-java.util.Map-java.lang.String-">createDataSource</a></span>(java.util.Map<java.lang.Object,java.lang.Object> properties, |
| java.lang.String namespace)</code> </td> |
| </tr> |
| <tr id="i13" class="rowColor"> |
| <td class="colFirst"><code>static javax.sql.DataSource</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createDataSource-java.util.Map-java.lang.String-java.lang.String-">createDataSource</a></span>(java.util.Map<java.lang.Object,java.lang.Object> properties, |
| java.lang.String namespace, |
| java.lang.String driverClassKey)</code> </td> |
| </tr> |
| <tr id="i14" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#createSchema-java.lang.String-">createSchema</a></span>(java.lang.String name)</code> </td> |
| </tr> |
| <tr id="i15" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#deserializeTable-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-org.eclipse.net4j.util.om.monitor.OMMonitor-">deserializeTable</a></span>(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataInput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataInput</a> in, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| <a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/om/monitor/OMMonitor.html?is-external=true" title="class or interface in org.eclipse.net4j.util.om.monitor">OMMonitor</a> monitor)</code> </td> |
| </tr> |
| <tr id="i16" class="altColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#deserializeTable-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-org.eclipse.net4j.util.om.monitor.OMMonitor-org.eclipse.net4j.db.DBUtil.DeserializeRowHandler-">deserializeTable</a></span>(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataInput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataInput</a> in, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| <a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/om/monitor/OMMonitor.html?is-external=true" title="class or interface in org.eclipse.net4j.util.om.monitor">OMMonitor</a> monitor, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.DeserializeRowHandler</a> handler)</code> </td> |
| </tr> |
| <tr id="i17" class="rowColor"> |
| <td class="colFirst"><code>static java.util.List<java.lang.Exception></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#dropAllTables-java.sql.Connection-java.lang.String-">dropAllTables</a></span>(java.sql.Connection connection, |
| java.lang.String dbName)</code> </td> |
| </tr> |
| <tr id="i18" class="altColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#dump-org.eclipse.net4j.db.ddl.IDBNamedElement-">dump</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement)</code> </td> |
| </tr> |
| <tr id="i19" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#dump-org.eclipse.net4j.db.ddl.IDBNamedElement-java.io.Writer-">dump</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement, |
| java.io.Writer writer)</code> </td> |
| </tr> |
| <tr id="i20" class="altColor"> |
| <td class="colFirst"><code>static java.lang.String</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#dumpToString-org.eclipse.net4j.db.ddl.IDBNamedElement-">dumpToString</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement)</code> </td> |
| </tr> |
| <tr id="i21" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#execute-java.sql.Connection-java.lang.CharSequence-">execute</a></span>(java.sql.Connection connection, |
| java.lang.CharSequence sql)</code> </td> |
| </tr> |
| <tr id="i22" class="altColor"> |
| <td class="colFirst"><code>static <T> T</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#execute-org.eclipse.net4j.db.IDBConnectionProvider-org.eclipse.net4j.db.DBUtil.RunnableWithConnection-">execute</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.RunnableWithConnection.html" title="interface in org.eclipse.net4j.db">DBUtil.RunnableWithConnection</a><T> runnable)</code> </td> |
| </tr> |
| <tr id="i23" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#executeBatch-java.sql.PreparedStatement-int-">executeBatch</a></span>(java.sql.PreparedStatement stmt, |
| int counter)</code> </td> |
| </tr> |
| <tr id="i24" class="altColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#executeBatch-java.sql.PreparedStatement-int-boolean-">executeBatch</a></span>(java.sql.PreparedStatement stmt, |
| int counter, |
| boolean checkExactlyOne)</code> </td> |
| </tr> |
| <tr id="i25" class="rowColor"> |
| <td class="colFirst"><code>static java.util.List<java.lang.String></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.Connection-">getAllSchemaNames</a></span>(java.sql.Connection connection)</code> </td> |
| </tr> |
| <tr id="i26" class="altColor"> |
| <td class="colFirst"><code>static java.util.Set<java.lang.String></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.DatabaseMetaData-">getAllSchemaNames</a></span>(java.sql.DatabaseMetaData metaData)</code> </td> |
| </tr> |
| <tr id="i27" class="rowColor"> |
| <td class="colFirst"><code>static java.util.List<java.lang.String></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaTableNames-java.sql.Connection-">getAllSchemaTableNames</a></span>(java.sql.Connection connection)</code> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="block"><span class="deprecationComment">As of 4.2 use <a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.Connection-"><code>getAllSchemaNames(Connection)</code></a>.</span></div> |
| </div> |
| </td> |
| </tr> |
| <tr id="i28" class="altColor"> |
| <td class="colFirst"><code>static java.util.List<java.lang.String></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaTableNames-java.sql.DatabaseMetaData-">getAllSchemaTableNames</a></span>(java.sql.DatabaseMetaData metaData)</code> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="block"><span class="deprecationComment">As of 4.2 use <a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.DatabaseMetaData-"><code>getAllSchemaNames(DatabaseMetaData)</code></a>.</span></div> |
| </div> |
| </td> |
| </tr> |
| <tr id="i29" class="rowColor"> |
| <td class="colFirst"><code>static java.util.List<java.lang.String></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllTableNames-java.sql.Connection-java.lang.String-">getAllTableNames</a></span>(java.sql.Connection connection, |
| java.lang.String dbName)</code> </td> |
| </tr> |
| <tr id="i30" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getDBAdapter-java.lang.String-">getDBAdapter</a></span>(java.lang.String adapterName)</code> |
| <div class="block">Retrieves an <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db"><code>adapter</code></a> from the <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html#REGISTRY"><code>adapter registry</code></a>.</div> |
| </td> |
| </tr> |
| <tr id="i31" class="rowColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getRowCount-java.sql.Connection-java.lang.String-">getRowCount</a></span>(java.sql.Connection connection, |
| java.lang.String tableName)</code> |
| <div class="block">Returns the number of rows contained in the given table.</div> |
| </td> |
| </tr> |
| <tr id="i32" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#getRowCount-java.sql.ResultSet-">getRowCount</a></span>(java.sql.ResultSet resultSet)</code> |
| <div class="block">Returns the number of rows contained in the given result set.</div> |
| </td> |
| </tr> |
| <tr id="i33" class="rowColor"> |
| <td class="colFirst"><code>static boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#isOptional-org.eclipse.net4j.db.ddl.IDBElement-">isOptional</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBElement</a> element)</code> </td> |
| </tr> |
| <tr id="i34" class="altColor"> |
| <td class="colFirst"><code>static boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#isTracerEnabled--">isTracerEnabled</a></span>()</code> </td> |
| </tr> |
| <tr id="i35" class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/IDBDatabase.html" title="interface in org.eclipse.net4j.db">IDBDatabase</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#openDatabase-org.eclipse.net4j.db.IDBAdapter-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-">openDatabase</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String schemaName)</code> </td> |
| </tr> |
| <tr id="i36" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/IDBDatabase.html" title="interface in org.eclipse.net4j.db">IDBDatabase</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#openDatabase-org.eclipse.net4j.db.IDBAdapter-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-boolean-">openDatabase</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String schemaName, |
| boolean fixNullableIndexColumns)</code> </td> |
| </tr> |
| <tr id="i37" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBSchema-">readSchema</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> schema)</code> </td> |
| </tr> |
| <tr id="i38" class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-java.lang.String-">readSchema</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| java.lang.String name)</code> </td> |
| </tr> |
| <tr id="i39" class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-java.lang.String-boolean-">readSchema</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| java.lang.String name, |
| boolean fixNullableIndexColumns)</code> </td> |
| </tr> |
| <tr id="i40" class="altColor"> |
| <td class="colFirst"><code>static java.lang.Exception</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#rollbackSilently-java.sql.Connection-">rollbackSilently</a></span>(java.sql.Connection connection)</code> </td> |
| </tr> |
| <tr id="i41" class="rowColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#select-java.sql.Connection-org.eclipse.net4j.db.IDBRowHandler-org.eclipse.net4j.db.ddl.IDBField...-">select</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/IDBRowHandler.html" title="interface in org.eclipse.net4j.db">IDBRowHandler</a> rowHandler, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields)</code> </td> |
| </tr> |
| <tr id="i42" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#select-java.sql.Connection-org.eclipse.net4j.db.IDBRowHandler-java.lang.String-org.eclipse.net4j.db.ddl.IDBField...-">select</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/IDBRowHandler.html" title="interface in org.eclipse.net4j.db">IDBRowHandler</a> rowHandler, |
| java.lang.String where, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields)</code> </td> |
| </tr> |
| <tr id="i43" class="rowColor"> |
| <td class="colFirst"><code>static java.lang.Object[]</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#select-java.sql.Connection-java.lang.String-org.eclipse.net4j.db.ddl.IDBField...-">select</a></span>(java.sql.Connection connection, |
| java.lang.String where, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields)</code> </td> |
| </tr> |
| <tr id="i44" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#selectMaximumInt-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-">selectMaximumInt</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where)</code> </td> |
| </tr> |
| <tr id="i45" class="rowColor"> |
| <td class="colFirst"><code>static long</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#selectMaximumLong-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-">selectMaximumLong</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where)</code> </td> |
| </tr> |
| <tr id="i46" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#selectMinimumInt-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-">selectMinimumInt</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where)</code> </td> |
| </tr> |
| <tr id="i47" class="rowColor"> |
| <td class="colFirst"><code>static long</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#selectMinimumLong-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-">selectMinimumLong</a></span>(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where)</code> </td> |
| </tr> |
| <tr id="i48" class="altColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#serializeTable-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-java.lang.String-java.lang.String-">serializeTable</a></span>(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataOutput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataOutput</a> out, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| java.lang.String tableAlias, |
| java.lang.String sqlSuffix)</code> </td> |
| </tr> |
| <tr id="i49" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#serializeTable-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-java.lang.String-java.lang.String-org.eclipse.net4j.db.DBUtil.SerializeRowHandler-">serializeTable</a></span>(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataOutput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataOutput</a> out, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| java.lang.String tableAlias, |
| java.lang.String sqlSuffix, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.SerializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.SerializeRowHandler</a> handler)</code> </td> |
| </tr> |
| <tr id="i50" class="altColor"> |
| <td class="colFirst"><code>static boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#setAutoCommit-java.sql.Connection-boolean-">setAutoCommit</a></span>(java.sql.Connection connection, |
| boolean autoCommit)</code> </td> |
| </tr> |
| <tr id="i51" class="rowColor"> |
| <td class="colFirst"><code>static boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#setOptional-org.eclipse.net4j.db.ddl.IDBElement-boolean-">setOptional</a></span>(<a href="../../../../org/eclipse/net4j/db/ddl/IDBElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBElement</a> element, |
| boolean optional)</code> </td> |
| </tr> |
| <tr id="i52" class="altColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#sqlDump-java.sql.Connection-java.lang.String-">sqlDump</a></span>(java.sql.Connection conn, |
| java.lang.String sql)</code> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="block"><span class="deprecationComment">Should only be used when debugging.</span></div> |
| </div> |
| </td> |
| </tr> |
| <tr id="i53" class="rowColor"> |
| <td class="colFirst"><code>static void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#sqlDump-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-">sqlDump</a></span>(<a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String sql)</code> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="block"><span class="deprecationComment">Should only be used when debugging.</span></div> |
| </div> |
| </td> |
| </tr> |
| <tr id="i54" class="altColor"> |
| <td class="colFirst"><code>static java.lang.String</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#trace-java.lang.String-">trace</a></span>(java.lang.String sql)</code> </td> |
| </tr> |
| <tr id="i55" class="rowColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#update-java.sql.Connection-java.lang.String-">update</a></span>(java.sql.Connection connection, |
| java.lang.String sql)</code> </td> |
| </tr> |
| <tr id="i56" class="altColor"> |
| <td class="colFirst"><code>static int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/eclipse/net4j/db/DBUtil.html#update-java.sql.PreparedStatement-boolean-">update</a></span>(java.sql.PreparedStatement stmt, |
| boolean exactlyOne)</code> |
| <div class="block">Execute update on the given prepared statement and handle common cases of return values.</div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.Object</h3> |
| <code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.detail"> |
| <!-- --> |
| </a> |
| <h3>Field Detail</h3> |
| <a name="MAX_BATCH_SIZE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MAX_BATCH_SIZE</h4> |
| <pre>public static final int MAX_BATCH_SIZE</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="PROP_ENABLE_NOISY_CLOSE"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>PROP_ENABLE_NOISY_CLOSE</h4> |
| <pre>public static final java.lang.String PROP_ENABLE_NOISY_CLOSE</pre> |
| <div class="block">A system property to enable noisy close, i.e. exception catch in close methods are thrown as <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db"><code>DBException</code></a> exception.</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.4</dd> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="../../../../constant-values.html#org.eclipse.net4j.db.DBUtil.PROP_ENABLE_NOISY_CLOSE">Constant Field Values</a></dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ============ METHOD DETAIL ========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a name="sqlDump-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sqlDump</h4> |
| <pre>@Deprecated |
| public static void sqlDump(java.sql.Connection conn, |
| java.lang.String sql)</pre> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> <span class="deprecationComment">Should only be used when debugging.</span></div> |
| <div class="block">For debugging purposes ONLY!</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="sqlDump-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sqlDump</h4> |
| <pre>@Deprecated |
| public static void sqlDump(<a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String sql)</pre> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> <span class="deprecationComment">Should only be used when debugging.</span></div> |
| <div class="block">For debugging purposes ONLY!</div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="dumpToString-org.eclipse.net4j.db.ddl.IDBNamedElement-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dumpToString</h4> |
| <pre>public static java.lang.String dumpToString(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="dump-org.eclipse.net4j.db.ddl.IDBNamedElement-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dump</h4> |
| <pre>public static void dump(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="dump-org.eclipse.net4j.db.ddl.IDBNamedElement-java.io.Writer-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dump</h4> |
| <pre>public static void dump(<a href="../../../../org/eclipse/net4j/db/ddl/IDBNamedElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBNamedElement</a> namedElement, |
| java.io.Writer writer) |
| throws java.io.IOException</pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code>java.io.IOException</code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="openDatabase-org.eclipse.net4j.db.IDBAdapter-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>openDatabase</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/IDBDatabase.html" title="interface in org.eclipse.net4j.db">IDBDatabase</a> openDatabase(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String schemaName)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="openDatabase-org.eclipse.net4j.db.IDBAdapter-org.eclipse.net4j.db.IDBConnectionProvider-java.lang.String-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>openDatabase</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/IDBDatabase.html" title="interface in org.eclipse.net4j.db">IDBDatabase</a> openDatabase(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| java.lang.String schemaName, |
| boolean fixNullableIndexColumns)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="createSchema-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createSchema</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> createSchema(java.lang.String name)</pre> |
| </li> |
| </ul> |
| <a name="readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBSchema-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>readSchema</h4> |
| <pre>public static void readSchema(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> schema)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>readSchema</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> readSchema(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| java.lang.String name)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="readSchema-org.eclipse.net4j.db.IDBAdapter-java.sql.Connection-java.lang.String-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>readSchema</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> readSchema(<a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> adapter, |
| java.sql.Connection connection, |
| java.lang.String name, |
| boolean fixNullableIndexColumns)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="copySchema-org.eclipse.net4j.db.ddl.IDBSchema-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>copySchema</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> copySchema(<a href="../../../../org/eclipse/net4j/db/ddl/IDBSchema.html" title="interface in org.eclipse.net4j.db.ddl">IDBSchema</a> source)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="createDataSource-java.util.Map-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createDataSource</h4> |
| <pre>public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties)</pre> |
| </li> |
| </ul> |
| <a name="createDataSource-java.util.Map-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createDataSource</h4> |
| <pre>public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties, |
| java.lang.String namespace)</pre> |
| </li> |
| </ul> |
| <a name="createDataSource-java.util.Map-java.lang.String-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createDataSource</h4> |
| <pre>public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties, |
| java.lang.String namespace, |
| java.lang.String driverClassKey)</pre> |
| </li> |
| </ul> |
| <a name="createConnectionProvider-javax.sql.DataSource-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createConnectionProvider</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> createConnectionProvider(javax.sql.DataSource dataSource)</pre> |
| </li> |
| </ul> |
| <a name="createConnectionProvider-javax.sql.DataSource-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createConnectionProvider</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider2.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider2</a> createConnectionProvider(javax.sql.DataSource dataSource, |
| java.lang.String user)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.3</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getDBAdapter-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getDBAdapter</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db">IDBAdapter</a> getDBAdapter(java.lang.String adapterName)</pre> |
| <div class="block">Retrieves an <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html" title="interface in org.eclipse.net4j.db"><code>adapter</code></a> from the <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html#REGISTRY"><code>adapter registry</code></a>. |
| <p> |
| If Eclipse is running adapters are automatically created from descriptors that are contributed to the extension point <code>org.eclipse.net4j.db.dbAdapters</code>. |
| <p> |
| In standalone scenarios the needed adapter instances must be registered with the <a href="../../../../org/eclipse/net4j/db/IDBAdapter.html#REGISTRY"><code>adapter registry</code></a> manually.</div> |
| </li> |
| </ul> |
| <a name="batched-java.sql.PreparedStatement-int-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>batched</h4> |
| <pre>public static <a href="../../../../org/eclipse/net4j/db/BatchedStatement.html" title="interface in org.eclipse.net4j.db">BatchedStatement</a> batched(java.sql.PreparedStatement delegate, |
| int batchSize) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.5</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="close-java.sql.ResultSet-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>close</h4> |
| <pre>public static java.lang.Exception close(java.sql.ResultSet resultSet)</pre> |
| </li> |
| </ul> |
| <a name="close-java.sql.Statement-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>close</h4> |
| <pre>public static java.lang.Exception close(java.sql.Statement statement)</pre> |
| </li> |
| </ul> |
| <a name="close-java.sql.Connection-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>close</h4> |
| <pre>public static java.lang.Exception close(java.sql.Connection connection)</pre> |
| </li> |
| </ul> |
| <a name="isOptional-org.eclipse.net4j.db.ddl.IDBElement-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isOptional</h4> |
| <pre>public static boolean isOptional(<a href="../../../../org/eclipse/net4j/db/ddl/IDBElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBElement</a> element)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.6</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="setOptional-org.eclipse.net4j.db.ddl.IDBElement-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>setOptional</h4> |
| <pre>public static boolean setOptional(<a href="../../../../org/eclipse/net4j/db/ddl/IDBElement.html" title="interface in org.eclipse.net4j.db.ddl">IDBElement</a> element, |
| boolean optional)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.6</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="setAutoCommit-java.sql.Connection-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>setAutoCommit</h4> |
| <pre>public static boolean setAutoCommit(java.sql.Connection connection, |
| boolean autoCommit)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="rollbackSilently-java.sql.Connection-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>rollbackSilently</h4> |
| <pre>public static java.lang.Exception rollbackSilently(java.sql.Connection connection)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getAllSchemaTableNames-java.sql.Connection-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAllSchemaTableNames</h4> |
| <pre>@Deprecated |
| public static java.util.List<java.lang.String> getAllSchemaTableNames(java.sql.Connection connection)</pre> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> <span class="deprecationComment">As of 4.2 use <a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.Connection-"><code>getAllSchemaNames(Connection)</code></a>.</span></div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getAllSchemaTableNames-java.sql.DatabaseMetaData-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAllSchemaTableNames</h4> |
| <pre>@Deprecated |
| public static java.util.List<java.lang.String> getAllSchemaTableNames(java.sql.DatabaseMetaData metaData)</pre> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> <span class="deprecationComment">As of 4.2 use <a href="../../../../org/eclipse/net4j/db/DBUtil.html#getAllSchemaNames-java.sql.DatabaseMetaData-"><code>getAllSchemaNames(DatabaseMetaData)</code></a>.</span></div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getAllSchemaNames-java.sql.Connection-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAllSchemaNames</h4> |
| <pre>public static java.util.List<java.lang.String> getAllSchemaNames(java.sql.Connection connection)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getAllSchemaNames-java.sql.DatabaseMetaData-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAllSchemaNames</h4> |
| <pre>public static java.util.Set<java.lang.String> getAllSchemaNames(java.sql.DatabaseMetaData metaData)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getAllTableNames-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAllTableNames</h4> |
| <pre>public static java.util.List<java.lang.String> getAllTableNames(java.sql.Connection connection, |
| java.lang.String dbName)</pre> |
| </li> |
| </ul> |
| <a name="dropAllTables-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dropAllTables</h4> |
| <pre>public static java.util.List<java.lang.Exception> dropAllTables(java.sql.Connection connection, |
| java.lang.String dbName)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="asInt-java.lang.Object-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>asInt</h4> |
| <pre>public static int asInt(java.lang.Object value)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="asLong-java.lang.Object-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>asLong</h4> |
| <pre>public static long asLong(java.lang.Object value)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="selectMinimumInt-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectMinimumInt</h4> |
| <pre>public static int selectMinimumInt(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="selectMinimumLong-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectMinimumLong</h4> |
| <pre>public static long selectMinimumLong(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="selectMaximumInt-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectMaximumInt</h4> |
| <pre>public static int selectMaximumInt(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="selectMaximumLong-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBField-java.lang.String...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>selectMaximumLong</h4> |
| <pre>public static long selectMaximumLong(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a> field, |
| java.lang.String... where) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="execute-org.eclipse.net4j.db.IDBConnectionProvider-org.eclipse.net4j.db.DBUtil.RunnableWithConnection-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>execute</h4> |
| <pre>public static <T> T execute(<a href="../../../../org/eclipse/net4j/db/IDBConnectionProvider.html" title="interface in org.eclipse.net4j.db">IDBConnectionProvider</a> connectionProvider, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.RunnableWithConnection.html" title="interface in org.eclipse.net4j.db">DBUtil.RunnableWithConnection</a><T> runnable)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="execute-java.sql.Connection-java.lang.CharSequence-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>execute</h4> |
| <pre>public static void execute(java.sql.Connection connection, |
| java.lang.CharSequence sql)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="executeBatch-java.sql.PreparedStatement-int-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>executeBatch</h4> |
| <pre>public static void executeBatch(java.sql.PreparedStatement stmt, |
| int counter)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="executeBatch-java.sql.PreparedStatement-int-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>executeBatch</h4> |
| <pre>public static void executeBatch(java.sql.PreparedStatement stmt, |
| int counter, |
| boolean checkExactlyOne)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="update-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>update</h4> |
| <pre>public static int update(java.sql.Connection connection, |
| java.lang.String sql)</pre> |
| </li> |
| </ul> |
| <a name="update-java.sql.PreparedStatement-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>update</h4> |
| <pre>public static int update(java.sql.PreparedStatement stmt, |
| boolean exactlyOne) |
| throws java.sql.SQLException</pre> |
| <div class="block">Execute update on the given prepared statement and handle common cases of return values.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>stmt</code> - the prepared statement</dd> |
| <dd><code>exactlyOne</code> - if <code>true</code>, the update count is checked to be <code>1</code>. Else the update result is only |
| checked so that the update was successful (i.e. result code != Statement.EXECUTE_FAILED).</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>the update count / execution result as returned by <code>PreparedStatement.executeUpdate()</code>. Can be used |
| by the caller to perform more advanced checks.</dd> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code>java.sql.SQLException</code> - if <code>PreparedStatement.executeUpdate()</code> throws it.</dd> |
| <dd><code>java.lang.IllegalStateException</code> - if the check indicated by <code>excatlyOne</code> indicates an error.</dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="clearTable-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>clearTable</h4> |
| <pre>public static int clearTable(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="clearTable-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>clearTable</h4> |
| <pre>public static int clearTable(java.sql.Connection connection, |
| java.lang.String tableName)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="select-java.sql.Connection-org.eclipse.net4j.db.IDBRowHandler-java.lang.String-org.eclipse.net4j.db.ddl.IDBField...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>select</h4> |
| <pre>public static int select(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/IDBRowHandler.html" title="interface in org.eclipse.net4j.db">IDBRowHandler</a> rowHandler, |
| java.lang.String where, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="select-java.sql.Connection-org.eclipse.net4j.db.IDBRowHandler-org.eclipse.net4j.db.ddl.IDBField...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>select</h4> |
| <pre>public static int select(java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/IDBRowHandler.html" title="interface in org.eclipse.net4j.db">IDBRowHandler</a> rowHandler, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="select-java.sql.Connection-java.lang.String-org.eclipse.net4j.db.ddl.IDBField...-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>select</h4> |
| <pre>public static java.lang.Object[] select(java.sql.Connection connection, |
| java.lang.String where, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBField.html" title="interface in org.eclipse.net4j.db.ddl">IDBField</a>... fields) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getRowCount-java.sql.ResultSet-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getRowCount</h4> |
| <pre>public static int getRowCount(java.sql.ResultSet resultSet) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <div class="block">Returns the number of rows contained in the given result set. |
| <p> |
| The <code>statement</code> of the result set must have been created with |
| <code>TYPE_SCROLL_INSENSITIVE</code>.</div> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getRowCount-java.sql.Connection-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getRowCount</h4> |
| <pre>public static int getRowCount(java.sql.Connection connection, |
| java.lang.String tableName) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></pre> |
| <div class="block">Returns the number of rows contained in the given table.</div> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.5</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="serializeTable-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-java.lang.String-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>serializeTable</h4> |
| <pre>public static void serializeTable(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataOutput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataOutput</a> out, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| java.lang.String tableAlias, |
| java.lang.String sqlSuffix) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a>, |
| java.io.IOException</pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dd><code>java.io.IOException</code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="serializeTable-org.eclipse.net4j.util.io.ExtendedDataOutput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-java.lang.String-java.lang.String-org.eclipse.net4j.db.DBUtil.SerializeRowHandler-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>serializeTable</h4> |
| <pre>public static void serializeTable(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataOutput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataOutput</a> out, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| java.lang.String tableAlias, |
| java.lang.String sqlSuffix, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.SerializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.SerializeRowHandler</a> handler) |
| throws <a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a>, |
| java.io.IOException</pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="../../../../org/eclipse/net4j/db/DBException.html" title="class in org.eclipse.net4j.db">DBException</a></code></dd> |
| <dd><code>java.io.IOException</code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="deserializeTable-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-org.eclipse.net4j.util.om.monitor.OMMonitor-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>deserializeTable</h4> |
| <pre>public static void deserializeTable(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataInput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataInput</a> in, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| <a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/om/monitor/OMMonitor.html?is-external=true" title="class or interface in org.eclipse.net4j.util.om.monitor">OMMonitor</a> monitor) |
| throws java.io.IOException</pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code>java.io.IOException</code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="deserializeTable-org.eclipse.net4j.util.io.ExtendedDataInput-java.sql.Connection-org.eclipse.net4j.db.ddl.IDBTable-org.eclipse.net4j.util.om.monitor.OMMonitor-org.eclipse.net4j.db.DBUtil.DeserializeRowHandler-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>deserializeTable</h4> |
| <pre>public static void deserializeTable(<a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/io/ExtendedDataInput.html?is-external=true" title="class or interface in org.eclipse.net4j.util.io">ExtendedDataInput</a> in, |
| java.sql.Connection connection, |
| <a href="../../../../org/eclipse/net4j/db/ddl/IDBTable.html" title="interface in org.eclipse.net4j.db.ddl">IDBTable</a> table, |
| <a href="../../../../../../org.eclipse.net4j.util.doc/javadoc/org/eclipse/net4j/util/om/monitor/OMMonitor.html?is-external=true" title="class or interface in org.eclipse.net4j.util.om.monitor">OMMonitor</a> monitor, |
| <a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html" title="interface in org.eclipse.net4j.db">DBUtil.DeserializeRowHandler</a> handler) |
| throws java.io.IOException</pre> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code>java.io.IOException</code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.1</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="trace-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>trace</h4> |
| <pre>public static java.lang.String trace(java.lang.String sql)</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>3.0</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="isTracerEnabled--"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>isTracerEnabled</h4> |
| <pre>public static boolean isTracerEnabled()</pre> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| </div> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a name="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/DBUtil.html">Use</a></li> |
| <li><a href="../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../org/eclipse/net4j/db/DBType.html" title="enum in org.eclipse.net4j.db"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../org/eclipse/net4j/db/DBUtil.DeserializeRowHandler.html" title="interface in org.eclipse.net4j.db"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../index.html?org/eclipse/net4j/db/DBUtil.html" target="_top">Frames</a></li> |
| <li><a href="DBUtil.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_bottom"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li><a href="#nested.class.summary">Nested</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| <p class="legalCopy"><small><i class="copyright">Copyright (c) 2004-2019 Eike Stepper (Loehne, Germany) and others.<br>All rights reserved. This program and the accompanying materials are made available under the terms of the Eclipse Public License v1.0 which accompanies this distribution, and is available at http://www.eclipse.org/legal/epl-v10.html</i></small></p> |
| </body> |
| </html> |