Package org.wso2.carbon.adminconsole.core.description

Examples of org.wso2.carbon.adminconsole.core.description.DatabaseInstanceInfo

210
211
212
213
214
215
216
217
218
219
220
        instances.addChild(newInstanceElement);
        this.writeDataToRegistry(instances.toString(), PATH_TO_INSTANCE_LIST);
    }

    public void removeDbInstance(String instanceName) throws Exception {
        DatabaseInstanceInfo tobeRemoved = null;
        List<DatabaseInstanceInfo> instanceList = this.getDatabaseInstanceList();
        for (DatabaseInstanceInfo databaseInstanceInfo : instanceList) {
            if (databaseInstanceInfo != null && instanceName.equals(
                    databaseInstanceInfo.getInstanceName())) {
                tobeRemoved = databaseInstanceInfo;
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
        try {
            if (log.isDebugEnabled()) {
                log.debug("Creating Database For The Tenant " + tenantDomain);
            }

            DatabaseInstanceInfo dbInstanceInfo = tenantData.getDatabaseInstanceInfo(
                    dbInfo.getInstanceName());
            String sqlQuery = "CREATE DATABASE " + fullyQualifiedDbName;
            ps = ConnectionHandler.getConnection(
                    dbInstanceInfo.getInstanceUrl(), dbInstanceInfo.getUsername(),
                    dbInstanceInfo.getPassword()).prepareStatement(sqlQuery);
            ps.execute();

            if (log.isDebugEnabled()) {
                log.debug("Database Created For The Tenant " + tenantDomain);
            }

            return dbInstanceInfo.getInstanceUrl() + "/" + dbName;
        } catch (SQLException e) {
            String msg = "Unable To Create Database For Tenant " + tenantDomain;
            throw new SQLException(msg, e);
        } catch (RegistryException e) {
            String msg = "Cannot Retrieve Instance List";
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
    public boolean createDatabaseUser(DatabaseUserInfo userInfo) throws Exception {
        try {
            if (log.isDebugEnabled()) {
                log.debug("Creating A Database User For The Tenant");
            }
            DatabaseInstanceInfo instanceInfo = tenantData.getDatabaseInstanceInfo(
                    userInfo.getInstanceName());
            if (instanceInfo != null) {
                String createUserQuery = "CREATE USER '" + userInfo.getUsername() + "'@'" +
                        this.extractHostName(instanceInfo.getInstanceUrl()) + "' IDENTIFIED BY '" +
                        userInfo.getPassword() + "'";

                String grantPrivilegesQuery = "GRANT ALL PRIVILEGES ON *.* TO '" +
                        userInfo.getUsername() + "'@'" +
                        this.extractHostName(instanceInfo.getInstanceUrl()) + "' IDENTIFIED BY '" +
                        userInfo.getPassword() + "'";

                String systemDbUrl = processJdbcUrl(instanceInfo.getInstanceUrl(), MYSQL_SYSTEM_DB);

                ps = ConnectionHandler.getConnection(
                        systemDbUrl,
                        instanceInfo.getUsername(),
                        instanceInfo.getPassword()).prepareStatement(createUserQuery);
                ps.execute();

                ps = ConnectionHandler.getConnection(
                        systemDbUrl,
                        instanceInfo.getUsername(),
                        instanceInfo.getPassword()).prepareStatement(grantPrivilegesQuery);
                ps.execute();

            }

            if (log.isDebugEnabled()) {
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
            XMLStreamException, ClassNotFoundException, RegistryException {
        try {
            if (log.isDebugEnabled()) {
                log.debug("Dropping Database" + dbName);
            }
            DatabaseInstanceInfo instanceInfo = tenantData.getDatabaseInstanceInfo(instanceName);
            DatabaseUserInfo userInfo = tenantData.getDatabaseUserInfo(instanceName, dbName);

            String dropDatabaseQuery = "DROP DATABASE " + dbName;
            String dropUserQuery = "DROP USER '" + userInfo.getUsername() + "'@'" +
                    this.extractHostName(instanceInfo.getInstanceUrl()) + "'";

            ps = ConnectionHandler.getConnection(
                    instanceInfo.getInstanceUrl(),
                    instanceInfo.getUsername(),
                    instanceInfo.getPassword()).prepareStatement(dropDatabaseQuery);
            ps.execute();

            if (log.isDebugEnabled()) {
                log.debug("Database " + dbName + "Dropped");
            }

            if (log.isDebugEnabled()) {
                log.debug("Dropping Database User " + userInfo.getUsername());
            }
            ps = ConnectionHandler.getConnection(
                    instanceInfo.getInstanceUrl(),
                    instanceInfo.getUsername(),
                    instanceInfo.getPassword()).prepareStatement(dropUserQuery);
            ps.execute();

            if (log.isDebugEnabled()) {
                log.debug("Database User " + userInfo.getUsername() + "Dropped");
            }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
    public List<DatabaseUserInfo> getUsers(String dbName) throws RegistryException, SQLException,
            XMLStreamException, ClassNotFoundException {
        List<DatabaseUserInfo> users = new ArrayList<DatabaseUserInfo>();
        try {
            DatabaseInstanceInfo instanceInfo = tenantData.getDatabaseInstanceInfo(dbName);
            String sqlQuery = "SELECT Host,User FROM db WHERE Db=?";

            String dbUrl = processJdbcUrl(instanceInfo.getInstanceUrl(), MYSQL_SYSTEM_DB);
            ps = ConnectionHandler.getConnection(dbUrl,
                    instanceInfo.getUsername(),
                    instanceInfo.getPassword()).prepareStatement(sqlQuery);
            ps.setString(1, dbName);

            ResultSet rs = ps.executeQuery();
            if (rs != null) {
                while (rs.next()) {
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
218
    public String addDatabaseInstance(String strDbInstance) throws AxisFault {
        if (log.isDebugEnabled()) {
            log.debug("Adding Database Instance");
        }
        try {
            DatabaseInstanceInfo databaseInstance = AdminConsoleUtil.createDbInstanceObj(
                    AXIOMUtil.stringToOM(strDbInstance));
            if (isValidInstanceName(databaseInstance.getInstanceName())) {
                tenantData.addDatabaseInstance(databaseInstance);
                return "Database instance has been successfully added";
            } else {
                return "A database instance with the same name already exists";
            }
View Full Code Here
362
363
364
365
366
367
368
369
370
371
372
373
374
    public String editDatabaseInstanceInfo (String strDbInstance) throws AxisFault {
        if (log.isDebugEnabled()) {
            log.debug("Editing Database Instance Info");
        }
        try {
            DatabaseInstanceInfo databaseInstance = AdminConsoleUtil.createDbInstanceObj(
                    AXIOMUtil.stringToOM(strDbInstance));
            if (!isValidInstanceName(databaseInstance.getInstanceName())) {
                tenantData.editDatabaseInstanceInfo(databaseInstance);
                return "Database instance has been successfully edited";
            } else {
                return "Database instance does not exist";
            }
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
        }
    }

    public String getDatabaseInstanceInfo (String instanceName) throws AxisFault {
        try {
            DatabaseInstanceInfo instanceInfo = tenantData.getDatabaseInstanceInfo(instanceName);
            return ObjSerializer.serializeDbInstanceData(
                    ADMIN_CONSOLE_OM_NAMESPACE, instanceInfo).toString();
        } catch (RegistryException e) {
            throw new AxisFault("", e);
        } catch (XMLStreamException e) {
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
     * @return The end line number, or -1 if could not be determined
     */
    public int getEndLineNumber() {
      int ret=-1;
     
      ActivityInterface parent=getParent();
     
      if (parent != null) {
        int index=parent.getSubActivities().indexOf(this);
       
        if (index != -1) {
          if (index < (parent.getSubActivities().size()-1)) {
            ActivityInterface other=parent.getSubActivities().get(index+1);
           
            ret = other.getStartLineNumber()-1;
          } else {
            ret = parent.getEndLineNumber();
          }
        }
      }
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
     *
     * @param lineNumber The line number
     * @return The activity, or null if not found
     */
    public ActivityInterface getActivityAtLineNumber(int lineNumber) {
      ActivityInterface ret=null;
     
      int endline=getEndLineNumber();
     
      if (getStartLineNumber() <= lineNumber && (endline == -1 || endline >= lineNumber)) {
       
View Full Code Here
TOP

Related Classes of org.wso2.carbon.adminconsole.core.description.DatabaseInstanceInfo

  • com.hazelcast.config.Config
  • com.hazelcast.config.GroupConfig
  • com.hazelcast.config.NetworkConfig
  • com.icegreen.greenmail.util.GreenMail
  • org.apache.axiom.om.OMElement
  • org.apache.axis2.client.Options
  • org.apache.axis2.client.ServiceClient
  • org.apache.axis2.clustering.ClusteringFault
  • org.apache.axis2.context.ConfigurationContext
  • org.apache.axis2.description.Parameter
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.