From f21ed5242ed195c2bfc082765c9a5ec95a26348c Mon Sep 17 00:00:00 2001 From: lresende Date: Sat, 9 Aug 2008 22:58:07 +0000 Subject: TUSCANY-2525 - Investigating data access integration issues - Initial scenario based on user application git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@684376 13f79535-47bb-0310-9956-ffa450edef68 --- .../src/main/java/util/ConnectionHelper.java | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java (limited to 'sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java') diff --git a/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java b/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java new file mode 100644 index 0000000000..43903b3a11 --- /dev/null +++ b/sandbox/lresende/sca/samples/organization-das/src/main/java/util/ConnectionHelper.java @@ -0,0 +1,28 @@ +package util; + +import java.sql.Connection; +import java.sql.DriverManager; + +import org.soa.types.SchemaInfoType; + +public class ConnectionHelper { + public static java.sql.Connection getConnection(SchemaInfoType schemaInfo) + { + Connection conn = null; + + // schemaInfo should be your SID. Something like xe (for Oracle Personal Edition) + String url = "jdbc:derby:target/organization_db; create = true"; + String driver = "org.apache.derby.jdbc.EmbeddedDriver"; + + try { + Class.forName(driver); + conn = DriverManager.getConnection(url, schemaInfo.getUSERNAME(), schemaInfo.getPASSWORD()); + conn.setAutoCommit(false); + } + catch (Exception e) { + e.printStackTrace(); + } + + return conn; + } +} -- cgit v1.2.3