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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
public class ManagedBeanO {
private String valeur;
private Connection connectedUser;
private String host;
private String port;
private String baseName, user, mdp, driver, url;
private Connection connection=null;
private final static Logger logger = Logger.getLogger(ManagedBeanO.class.getName());
public String getHost() {
return host;
}
public void setHost(String host) {
this.host = host;
}
public String getPort() {
return port;
}
public void setPort(String port) {
this.port = port;
}
public String getBaseName() {
return baseName;
}
public void setBaseName(String baseName) {
this.baseName = baseName;
}
public String getUser() {
return user;
}
public void setUser(String user) {
this.user = user;
}
public String getMdp() {
return mdp;
}
public void setMdp(String mdp) {
this.mdp = mdp;
}
public String getDriver() {
return driver;
}
public void setDriver(String driver) {
this.driver = driver;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public Connection getConnection() {
return connection;
}
public void setConnection(Connection connection) {
this.connection = connection;
}
public String getValeur() {
return this.valeur;
}
public void setValeur(String valeur) {
this.valeur= valeur;
}
public Connection getConnectedUser() throws TechnicalException {
if(connectedUser == null) {
connectedUser = getConnection(host,port,baseName,user,mdp );
}
return connectedUser ;
}
public void setConnectedUser(Connection connectedUser) {
this.connectedUser = connectedUser;
}
/**
* Gets connection
* @param host host
* @param port port number
* @param baseName base name
* @param user user name
* @param password password
* @return connection
* @throws TechnicalException
*/
private Connection getConnection(String host, String port, String baseName, String user, String password) throws TechnicalException {
// Driver Oracle
driver = "oracle.jdbc.driver.OracleDriver";
// URL de la connexion
url = "jdbc:oracle:thin:@"+host+":"+port+":"+baseName;
try {
Class.forName(driver);
// On obtient la connexion
connection = DriverManager.getConnection(url, user, password);
logger.info("Connection obtenue");
// On retourne la connexion
return connection;
} catch (SQLException e) {
logger.warning("Incorrect Connection Data.");
throw new TechnicalException("No-Connexion-Established-003");
}
catch (ClassNotFoundException e) {
// logger).fatal("Inexistent or Incorrect Driver.");
throw new TechnicalException("Driver-Not-Exist-004");
}
}
} |
Problème de connexion à une base Oracle
Répondre avec citation
)
))
Partager