blob: 43903b3a11513475203c19796f826e3646d8e04c (
plain)
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;
}
}
|