sandbox/lresende/backup/organization-das/src/main/java/util/ConnectionHelper.java


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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;
	}
}