Author: sannegrinovero Date: 2010-04-11 08:04:56 -0400 (Sun, 11 Apr 2010) New Revision: 19211 Modified: search/trunk/hibernate-search/src/test/java/org/hibernate/search/test/jgroups/master/JGroupsMasterTest.java Log: HSEARCH-505 JGroupsMasterTest uses native SQL failing on DB2 and sybase Modified: search/trunk/hibernate-search/src/test/java/org/hibernate/search/test/jgroups/master/JGroupsMasterTest.java =================================================================== --- search/trunk/hibernate-search/src/test/java/org/hibernate/search/test/jgroups/master/JGroupsMasterTest.java 2010-04-11 11:39:28 UTC (rev 19210) +++ search/trunk/hibernate-search/src/test/java/org/hibernate/search/test/jgroups/master/JGroupsMasterTest.java 2010-04-11 12:04:56 UTC (rev 19211) @@ -25,8 +25,6 @@ package org.hibernate.search.test.jgroups.master; import java.io.Serializable; -import java.sql.SQLException; -import java.sql.Statement; import java.util.ArrayList; import java.util.List; @@ -128,23 +126,23 @@ } /** - * Create a test object without trigggering indexing. Use SQL directly. + * Create a test object and delete if from index. * * @return a <code>TShirt</code> test object. - * - * @throws java.sql.SQLException in case the inset fails. */ - @SuppressWarnings({ "deprecation" }) - private TShirt createObjectWithSQL() throws SQLException { + private TShirt createObjectWithSQL() { Session s = openSession(); s.getTransaction().begin(); - Statement statement = s.connection().createStatement(); - statement.executeUpdate( - "insert into TShirt_Master(id, logo, size_) values( '1', 'JBoss balls', 'large')" - ); - statement.close(); - TShirt ts = ( TShirt ) s.get( TShirt.class, 1 ); + TShirt ts = new TShirt(); + ts.setId( 1 ); + ts.setLogo( "JBoss balls" ); + ts.setSize( "large" ); + s.persist( ts ); s.getTransaction().commit(); + FullTextSession fullTextSession = Search.getFullTextSession( s ); + fullTextSession.beginTransaction(); + fullTextSession.purge( TShirt.class, 1 ); + fullTextSession.getTransaction().commit(); s.close(); return ts; }