Author: lresende
Date: Wed Oct 24 16:14:32 2007
New Revision: 588076
URL: http://svn.apache.org/viewvc?rev=588076&view=rev
Log:
Removing the derby database, and using maven and a simple createDB to create
the store database
Added:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
(with props)
incubator/tuscany/java/sca/tutorial/store-catalog-database/store.sql
Removed:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/resources/derbydb/
Modified:
incubator/tuscany/java/sca/tutorial/store-catalog-database/pom.xml
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/services/CatalogImpl.java
Modified: incubator/tuscany/java/sca/tutorial/store-catalog-database/pom.xml
URL:
http://svn.apache.org/viewvc/incubator/tuscany/java/sca/tutorial/store-catalog-database/pom.xml?rev=588076&r1=588075&r2=588076&view=diff
==============================================================================
--- incubator/tuscany/java/sca/tutorial/store-catalog-database/pom.xml
(original)
+++ incubator/tuscany/java/sca/tutorial/store-catalog-database/pom.xml Wed Oct
24 16:14:32 2007
@@ -109,6 +109,41 @@
</execution>
</executions>
</plugin>
+
+ <plugin>
+ <groupId>org.codehaus.mojo</groupId>
+ <artifactId>sql-maven-plugin</artifactId>
+ <version>1.0</version>
+
+ <dependencies>
+ <dependency>
+ <groupId>org.apache.derby</groupId>
+ <artifactId>derby</artifactId>
+ <version>10.1.2.1</version>
+ </dependency>
+ </dependencies>
+
+ <executions>
+ <execution>
+ <id>create-db</id>
+ <phase>generate-resources</phase>
+ <goals>
+ <goal>execute</goal>
+ </goals>
+ <configuration>
+
<driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
+ <url>jdbc:derby:target/store_db;create=true</url>
+ <autocommit>true</autocommit>
+ <onError>continue</onError>
+ <delimiter>;</delimiter>
+ <srcFiles>
+ <srcFile>${pom.basedir}/store.sql</srcFile>
+ </srcFiles>
+ </configuration>
+ </execution>
+ </executions>
+ </plugin>
+
</plugins>
</build>
Modified:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/services/CatalogImpl.java
URL:
http://svn.apache.org/viewvc/incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/services/CatalogImpl.java?rev=588076&r1=588075&r2=588076&view=diff
==============================================================================
---
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/services/CatalogImpl.java
(original)
+++
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/services/CatalogImpl.java
Wed Oct 24 16:14:32 2007
@@ -56,7 +56,7 @@
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
conn = DriverManager.getConnection(
- "jdbc:derby:target/classes/derbydb",
+ "jdbc:derby:target/store_db",
"",
"");
Added:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
URL:
http://svn.apache.org/viewvc/incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java?rev=588076&view=auto
==============================================================================
---
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
(added)
+++
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
Wed Oct 24 16:14:32 2007
@@ -0,0 +1,77 @@
+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) {
+ 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();
+
+
+
+ } 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();
+ }
+ }
+ }
+ }
+
+}
Propchange:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange:
incubator/tuscany/java/sca/tutorial/store-catalog-database/src/main/java/util/CreateDB.java
------------------------------------------------------------------------------
svn:keywords = Rev Date
Added: incubator/tuscany/java/sca/tutorial/store-catalog-database/store.sql
URL:
http://svn.apache.org/viewvc/incubator/tuscany/java/sca/tutorial/store-catalog-database/store.sql?rev=588076&view=auto
==============================================================================
--- incubator/tuscany/java/sca/tutorial/store-catalog-database/store.sql (added)
+++ incubator/tuscany/java/sca/tutorial/store-catalog-database/store.sql Wed
Oct 24 16:14:32 2007
@@ -0,0 +1,18 @@
+DROP TABLE CATALOG;
+
+CREATE TABLE CATALOG(
+ id NUMERIC(5 , 0) NOT NULL,
+ product_name VARCHAR(30),
+ currency_code CHAR(3),
+ price REAL,
+ primary key (id)
+);
+
+
+
+INSERT INTO CATALOG
+ VALUES(0,'Apple', 'USD', 2.99);
+INSERT INTO CATALOG
+ VALUES(1,'Orange', 'USD', 3.55);
+INSERT INTO CATALOG
+ VALUES(2,'Pear', 'USD', 1.55);
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
