From: <jma...@rh...> - 2009-05-27 21:13:51
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head><style type="text/css"><!-- #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } --></style> <title>[rhq-project.org rhq] [3993] RHQ-2116 - add H2 support for getting the nextvalSql, which is used when inserting events and calltime data</title> </head> <body> <div id="msg"> <dl> <dt>Revision</dt> <dd>3993</dd> <dt>Author</dt> <dd>jmarques</dd> <dt>Date</dt> <dd>2009-05-27 16:13:10 -0500 (Wed, 27 May 2009)</dd> </dl> <h3>Log Message</h3> <pre>RHQ-2116 - add H2 support for getting the nextvalSql, which is used when inserting events and calltime data</pre> <h3>Modified Paths</h3> <ul> <li><a href="#rhqtrunkmodulescoreutilsrcmainjavaorgrhqcoreutiljdbcJDBCUtiljava">rhq/trunk/modules/core/util/src/main/java/org/rhq/core/util/jdbc/JDBCUtil.java</a></li> </ul> </div> <div id="patch"> <h3>Diff</h3> <a id="rhqtrunkmodulescoreutilsrcmainjavaorgrhqcoreutiljdbcJDBCUtiljava"></a> <div class="modfile"><h4>Modified: rhq/trunk/modules/core/util/src/main/java/org/rhq/core/util/jdbc/JDBCUtil.java (3992 => 3993)</h4> <pre class="diff"> <span class="info">--- rhq/trunk/modules/core/util/src/main/java/org/rhq/core/util/jdbc/JDBCUtil.java 2009-05-27 20:21:06 UTC (rev 3992) +++ rhq/trunk/modules/core/util/src/main/java/org/rhq/core/util/jdbc/JDBCUtil.java 2009-05-27 21:13:10 UTC (rev 3993) </span><span class="lines">@@ -52,6 +52,7 @@ </span><span class="cx"> */ private static final String POSTGRES_NEXTVAL_SQL = "(SELECT nextval('%s_id_seq'::text))"; private static final String ORACLE_NEXTVAL_SQL = "%s_id_seq.nextval"; </span><span class="add">+ private static final String H2_NEXTVAL_SQL = "(SELECT nextval('%s_id_seq'))"; </span><span class="cx"> public static void safeClose(Statement stm, ResultSet rs) { safeClose(rs); </span><span class="lines">@@ -156,6 +157,8 @@ </span><span class="cx"> nextvalSql = POSTGRES_NEXTVAL_SQL; } else if (name.contains("oracle")) { nextvalSql = ORACLE_NEXTVAL_SQL; </span><span class="add">+ } else if (name.contains("h2")) { + nextvalSql = H2_NEXTVAL_SQL; </span><span class="cx"> } else { JDBCUtil.safeClose(conn); throw new IllegalStateException("Unsupported database type: " + name); </span> </pre> </div> </div> </body> </html> |