Varshini Priya

Ranch Hand
+ Follow
since Feb 17, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
In last 30 days
0
Forums and Threads

Recent posts by Varshini Priya

I have a table TableA with 6 columns(col1,col2,col3,col4,col5,col6) and there is an other table TableB with 5 columns (colA, ColB(typeID), ColC, ColD, ColE). I need to fetch the col2 ...Col6 from tableA by joining with TableB. I would have to

  • join col2 from TableA with colB from TableB and again

    join col3 from TableA with colB from TableB

    join col4 from TableA with colB from TableB

    join col5 from TableA with colB from TableB


  • Each of the column from TableA needs to be joined with same column (colB) in TableB.Here the typeid value will be different for each of the col types in TableAe The colB is a type id and hence col2, col3,col4, col5 are different types, hence they are kind being joined with colb. I need a query which will fetch all the values of col2, col3,col4, col5 and the colc value based on each type in the same query. I tried writing the query. But could not fetch all the values in a single query.I need to fetch the values for all the field in TableA using a single Query.



    To fetch the associated value for col3, i need to write the below query

    similarly for col4 the below query

    Is there a way I can use a single query to fetch all the 3 col values. I know we can use union function and join the above three queries. But I wanted to know if there is a single query that I can use i.e


    In the above case, joining the fields seems to be an issue.

    Any help on this is much appreciated.
    I have a table TableA with 6 columns(col1,col2,col3,col4,col5,col6) and there is an other table TableB with 5 columns (colA, ColB(typeID), ColC, ColD, ColE). I need to fetch the col2 ...Col6 from tableA by joining with TableB. I would have to

  • join col2 from TableA with colB from TableB and again

    join col3 from TableA with colB from TableB

    join col4 from TableA with colB from TableB

    join col5 from TableA with colB from TableB


  • Each of the column from TableA needs to be joined with same column (colB) in TableB.Here the typeid value will be different for each of the col types in TableAe The colB is a type id and hence col2, col3,col4, col5 are different types, hence they are kind being joined with colb. I need a query which will fetch all the values of col2, col3,col4, col5 and the colc value based on each type in the same query. I tried writing the query. But could not fetch all the values in a single query.I need to fetch the values for all the field in TableA using a single Query.



    To fetch the associated value for col3, i need to write the below query

    similarly for col4 the below query

    Is there a way I can use a single query to fetch all the 3 col values. I know we can use union function and join the above three queries. But I wanted to know if there is a single query that I can use i.e


    In the above case, joining the fields seems to be an issue.

    Any help on this is much appreciated.
    In our project, we have close to around 200 spring boot microservices. We are in the process of fixing the Open source vulnerabilities for these microservices. Our microservices are spring boot based and the version that is currently available is 2.3.X. While upgrading the spring boot parent version, I have the below queries

  • When upgrading the spring boot version, Is there any guiding principle based on which we need to select the version of spring boot. Currently when I checked the mvn repository for spring boot parent, the latest version available is 3.0. Can I directly update to the latest version ? or is there any parameters to be considered while selecting the latest version
  • In our project, We also have the spring cloud dependencies, I checked the spring site(https://spring.io/projects/spring-cloud) and was able to get the spring cloud version compatible with Spring boot version. I could get this only for spring cloud. Is there any site available which provides the compatibility details for the other jars like spring core etc.

  • Any inputs on the above is really appreciated
    1 year ago
    Thanks Tim, for the below response.  Im in the process of performing tomcat hardening and as part of it.  I do not want our application to display tomcat version details etc at the time of error.  Hence wanted the application to pick up the custom error pages. Even after including the  initial '/' in the resource path, Im unable to get the desired output. The application is not navigating to the error page.html.  In other words, where do I need to place the resource i.e. the error.html  page once I provided the path in the web.xml.

    Can you also let me know the path in tomcat where the default error page exists ?

    3 years ago
    Hi All,

    We were trying to incorporate custom error pages for tomcat since server error exposes version details. We have followed some online article and tried to create a general error page and configured in the web.xml. Below is the code that I have included in the tomcat web.xml file


    I placed the errorPage.htm inside $tomcat/webapps/$application. When deploying the above, tomcat is unable to display the errorPage.htm configured above in case of 404 exception.

    Im able to access the errorPage.htm by navigating to http://localhost:8080/$application/errorPage.htm. But when there is 404 error, it does not return the custom error page configured in the web.xml. I even changed the above configuration to

    But still nothing worked. Can you please let me know to fix the same.
    Can you help to identify where are the default error pages located in tomcat and how can we fix the above.
    Any help on this is much appreciated
    3 years ago
    Hi - Yes I want the request object to be available in the DB.  Even if there is any failure of microservice before processing the response.
    5 years ago
    Need some clarifications on the best practises that needs to be followed while updating data into the DB in a spring microservices based webapplication

    Scenario

    We have a webapplication, in which when the user sends request from the UI, for processing the request, at the backend the request goes to a microservice and we have to update the request and response objects in a particular table in the database. I wanted to know the right approach for updating the data in the databse. Below are my queries.
  • Should we insert the request Object as soon as we receive it in the microservices or
  • Should we process the request and after the processing, once we receive the response, should we do a single insert to the database with both request and response Object to avoid multiple DB calls.


  • Please Advise.
    Any help on this is much appreciated. Thanks in Advance.
    5 years ago
    Hi Team,

    Im trying to run a jUnit test case and I get the below Spring error message. Error loading the application context.
    Though the application works fine. Only execution of jUnit test case shows issues.



    The project is a maven project and it works fine. I have issue while executing the test case.From the excepetion I have got, it looks likes there is an issue in loading the entityManagerFactory bean, in the spring-jpa.xml. Below is the Spring-jpa.xml file that is being used.

    Spring-jpa.xml


    Im not sure about the reason for the error any help on this issue is much appreciated. Thanks in advance
    8 years ago
    Hi Team,

    I have deployed a war file in tomcat and trying to login to the application. When I try to login to the application,I have updated the database details and the application is able to connect to the db fine. Once the user click on the login button, the control is taken to the LoginValidate.java servlet page. The request from the servlet does not contain the details specified by the user(i.e username/password). The request data is not being passed to the servlet and it throws the below NullPointer Error. The application got deployed fine and all the files/folders are generated fine. Im getting the below error.



    When I try to debug the code via eclipse, Im getting the below error



    Im not sure on the reason for the above error. Any help on this is much appreciated.
    9 years ago
    Hi

    We have an issue in setting up the svn. Our svn machine got crashed and we have got the backup of our svn. We have a new machine now and installed svn server. I would like to know how to go about in integerating my old svn contents with the new one. In the new machine, I have set up the svn server and have created a sample repository to test the same. It seems to be working fine. I have copied the old repository data to the new machine and once i start the svn server, Im able to view the contents of the old svn as well. However, I would require help in the following things

    1. How to integerate the old svn contents with the new one.I tried to copy the contents of the old svn to the svn repository, but im unable to view the contents of the same.
    2. I would like to know how to create the url for others to access from other machine. The old svn repository has got certain user permission set up and I would like to know how to setup/integerate the same in the new svn.

    We are using Collabnet subversion server(1.8 in the new m/c. the older m/c had was running on collabnet server 1.5) and tortoise svn client to view the contents of the server. This is installed in a windows machine.

    Any help on this is much appreciated. Thanks
    Thanks for the response all. The emails are like always like this



    In the above case, the delimiter is 'AND'. I tried using pattern matcher. But this also dosent seem to work
    10 years ago
    I need help in splitting two email address which are seperated by a Delimiter 'AND'. I have issue when splitting, when the email address has got the characters'AND' in the email id. For eg, if the email address that needs to be split is something like the below.

    'anandc@AND.comANDxyz@yahoo.co.in', and the delimiter is'AND'

    There are no whitespaces between the two email address and the delimiter 'AND'.In the above case, there seems to be three items extracted instead of two. Can someone please help me solve this. Thanks in Advance
    10 years ago
    Hi Jasper,

    Thanks for the detailed response. I have two queries


    1. Can you please let me know how to increase the max Perm gen size without knowing the max perm Gen size being used by the running application. Is there any command that I need to execute to see what is the current max Perm Gen size that is actually used by my application. Before inserting a new value ?

    2. As I specified earlier, the application which Im trying to run is an eclipse base application and I tried to include the below value in the myapplication.INI file included " --launcher.XXMaxPermSize = 512m" . But it doesn't seem to help much. Since my application hangs.. and gets closed abruptly .

    Can you please let me know the way as how to execute my application via command prompt after by changing the max perm gen size.
    10 years ago
    Hi

    Im currently doing dynamic memory analysis, for our eclipse based application using jprobe.After starting the eclipse application and jprobe, when I try to profile the eclipse application by integerating it with jprobe, the eclipse application gets closed abruptly causing a Fatal error. A fatal error log file is generated. In the Fatal error log file, I could see that the PermGen space seems to be full. Below is a sample Heap summary which I got in the log file


    I tried to increase the permGen space, using the command -XX:MaxPermSize=512m. But that doesnt seem to work. I would like to know how to increase the PermGen size via command prompt. I would like to know if I have to go to the java location in my computer and execute the above command or should I increase the PermGen space specifically for the eclipse application or Jprobe ? Please advise.

    Any help on this is much appreciated.
    10 years ago
    Im using jprobe to profile my java application.The java application that Im trying to profile is an eclipse based application. we have created multiple projects for the application to deliver various features. When we build the application, the application is exported as a product and we receive a .exe file. I would like to know how to profile a .exe file using jprobe. Since from the help documents, I could see that the jar file will be used for profiling the application. But in our case the application is an exe file.

    Any help on this is much appreciated
    11 years ago