1 files changed, 97 insertions, 0 deletions
diff --git a/branches/sca-java-1.1/samples/store/src/main/java/util/CreateDB.java b/branches/sca-java-1.1/samples/store/src/main/java/util/CreateDB.java
new file mode 100644
index 0000000000..b8177ee25b
--- /dev/null
+++ b/branches/sca-java-1.1/samples/store/src/main/java/util/CreateDB.java
@@ -0,0 +1,97 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ * 
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.    
+ */
+
+package util;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.SQLException;
+
+public class CreateDB {
+
+    public static void main(String[] args) {
+        System.out.println("Creating database ...");
+        
+        Connection connection = null;
+        PreparedStatement preparedStatement = null;
+        
+        try {
+            //initialize driver and register it with DriverManager
+            Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
+            
+            //connect and create the db if not present
+            connection = DriverManager.getConnection(
+                    "jdbc:derby:target/store_db;create=true",
+                    "",
+                    "");
+            
+            
+            try {
+                preparedStatement = connection.prepareStatement("DROP TABLE CATALOG");
+                preparedStatement.execute();
+            }catch(Exception e) {
+                //ignore to avoid erros when db is being created from scratch
+            }
+            
+            
+            preparedStatement = connection.prepareStatement("CREATE TABLE CATALOG("
+                                                            + "id             NUMERIC(5 , 0) NOT NULL,"
+                                                            + "product_name   VARCHAR(30),"
+                                                            + "currency_code  CHAR(3),"
+                                                            + "price          REAL,"
+                                                            + "primary key (id)"
+                                                            + ")");
+            preparedStatement.execute();
+
+            preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(0,'Apple', 'USD', 2.99)");
+            preparedStatement.execute();
+
+            preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(1,'Orange', 'USD', 3.55)");
+            preparedStatement.execute();
+
+            preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(2,'Pear', 'USD', 1.55)");
+            preparedStatement.execute();
+
+            System.out.println("Done !");
+            
+        } catch (SQLException ex) {         
+            ex.printStackTrace();
+        }catch (ClassNotFoundException ex) {
+            ex.printStackTrace();
+        } finally {
+            if (preparedStatement!=null) {
+                try {
+                    preparedStatement.close();
+                } catch (SQLException ex) {
+                    ex.printStackTrace();
+                }
+            }
+            
+            if (connection!=null) {
+                try {
+                    connection.close();
+                } catch (SQLException ex) {
+                    ex.printStackTrace();
+                }
+            }
+        }
+    }
+
+}