Revision: 21524
Author:   baranowb
Date:     Mon Jan 16 03:53:24 2012
Log:      Add drop statement to avoid exception on startup.
http://code.google.com/p/mobicents/source/detail?r=21524

Modified:
/trunk/servers/jain-slee/examples/sip-jdbc-registrar/sbb/src/main/java/org/mobicents/slee/example/sjr/data/jdbc/DataSourceChildSbb.java

=======================================
--- /trunk/servers/jain-slee/examples/sip-jdbc-registrar/sbb/src/main/java/org/mobicents/slee/example/sjr/data/jdbc/DataSourceChildSbb.java Wed Nov 2 05:52:00 2011 +++ /trunk/servers/jain-slee/examples/sip-jdbc-registrar/sbb/src/main/java/org/mobicents/slee/example/sjr/data/jdbc/DataSourceChildSbb.java Mon Jan 16 03:53:24 2012
@@ -24,6 +24,7 @@

 import java.sql.Connection;
 import java.sql.SQLException;
+import java.sql.Statement;
 import java.util.List;

 import javax.sip.header.ContactHeader;
@@ -76,6 +77,10 @@
                Connection connection = null;
                try {
                        connection = jdbcRA.getConnection();
+
+                       connection.createStatement().execute(
+                                       DataSourceSchemaInfo._QUERY_DROP);
+
                        connection.createStatement().execute(
                                        DataSourceSchemaInfo._QUERY_CREATE);
                } catch (SQLException e) {

Reply via email to