Changeset 365 for gssim_ui/branches/vine/gssimstudio/src/web/ui/flex/java

Timestamp:

08/08/12 14:53:41 (13 years ago)

Author:

mcichenski

Message:

moved application properties to database

Location:

gssim_ui/branches/vine/gssimstudio/src/web/ui/flex/java/gssim/gssimstudio/flex/app/editor

Files:

• DatabaseHelper.java (added)
• GSSimStudio.java (modified) (6 diffs)

gssim_ui/branches/vine/gssimstudio/src/web/ui/flex/java/gssim/gssimstudio/flex/app/editor/GSSimStudio.java

@@ -105 +105 @@
 @BlazeDsDestination(swfHeight = "800", locales = {"en_US","pl_PL"}, names = {"GSSim Studio","GSSim Studio"}, descriptions = {"Application for GSSim job description","Aplikacja do generowania zadaￜ dla symulatora GSSim"})
 @PortletDisplayName(locales = {"en", "pl"}, values = {"GSSimStudio Application", "Aplikacja GSSimStudio"})
-public class GSSimStudio implements ModelInitialization , FileUploadAccepter {
-
-        /**
-         * The location of database source
-         */
-        private String dbAddress = "localhost:3306/gssim_results";
-        /**
-         * Username to access database
-         */
-        private String dbUser = "gssim";
-        /**
-         * Password to database [is it safe?]
-         */
-        private String dbPassword = "gssimstudiodb";
+public class GSSimStudio implements ModelInitialization , FileUploadAccepter extends DatabaseHelper {
         
         private Boolean developement = true;
@@ -151 +138 @@
     
     @BlazeDsMethod()
-        public GSSimStudioModel uploadAndSubmitExperiment(String destFileName, String fileContent, String grmsURL, String grmsDN, String jobDescription) throws IOException {
+        public GSSimStudioModel uploadAndSubmitExperiment(String destFileName, String fileContent) throws IOException {
                 String expName = destFileName.split("_")[1].split(".properties")[0];
                 String metaexpName = destFileName.split("_")[0];
@@ -157 +144 @@
                 fileContent += "experiment.id="+expId.toString();
                 uploadPropertyFile(destFileName, fileContent);
+                
+                String grmsURL = null;
+                String grmsDN = null;
+                String jobDescription = null;
+                
+                try {
+                        connection = factory().createDBConnection(dbAddress, dbUser,
+                                        dbPassword);
+                        ApplicationPropertyDAO applicationPropertyDAO = factory.createApplicationProperty();
+                        Finder finder = Finder.getApplicationPropertyFinder(apServiceURL);
+                        List<ApplicationProperty> list = applicationPropertyDAO.find(finder);
+                        if (list.isEmpty()) ;
+                        else
+                                grmsURL = list.get(0).getValue();
+                        
+                        finder = Finder.getApplicationPropertyFinder(apServiceDN);
+                        list = applicationPropertyDAO.find(finder);
+                        if (list.isEmpty()) ;
+                        else
+                                grmsDN = list.get(0).getValue();
+                        
+                        finder = Finder.getApplicationPropertyFinder(apJobDescription);
+                        list = applicationPropertyDAO.find(finder);
+                        if (list.isEmpty()) ;
+                        else {
+                                jobDescription = list.get(0).getValue();
+                                //replace tokens
+                                jobDescription.replace(jdPropertyFile, "input/" + destFileName);
+                        }
+                } catch (SQLException e) {
+                        ;
+                } catch (InstantiationException e) {
+                        ;               
+                } catch (IllegalAccessException e) {
+                        ;       
+                } catch (ClassNotFoundException e) {
+                        ;       
+                } catch (Exception e) {
+                        ;       
+                } finally {
+                        closeConnection(connection, null);
+                }       
                 
                 return doSubmitApplication(grmsURL, grmsDN, jobDescription);
@@ -1433 +1462 @@
         
         private void closeConnection(Connection connection, GSSimStudioModel model) {
-                String error = model.getError();
+                String error = null;
+                if (model != null)
+                        error = model.getError();
                 
                 if (connection != null)
@@ -1439 +1470 @@
                                 connection.close();
                         } catch (SQLException e) {
-                                error = model.getError();
                                 if (error == null || error.equals("")) {
                                         error = "Error while trying to close the SQL connection";
@@ -1448 +1478 @@
                         }
 
-                model.setError(error);
+                if (model != null)
+                        model.setError(error);
         }