Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
Spring Data provide a class named RepositoryFactorySupport. Via this class we can access any repository, as in the following example: RepositoryFactorySupport factory = … // code that instantiate the factory;CustomerRepository
Use the CultureInfo class to format values based on a culture. See below for an example: public static void Main() { decimal inputValue = 233; CultureInfo currentCulture = new CultureInfo(“en-US”);
Moving away from the age old way of fixed arguments, Java supports variable arguments. The code sample below illustrates variable arguments. If the method has multiple arguments, it is mandatory
What types of indexes are there? Answer: Clustered Sort and store data based on key values Non-clustered Each key is a pointer to the data row
Java has a very powerful library for REGEX. A very basic usage of REGEX is being presented in the code snippet below and we can improve on this to develop
For disabling OSIV, we need to set up spring.jpa.open-in-view in application.properties as follows: spring.jpa.open-in-view=false
See how to use this function in C# to discover how many more days are left in a given countdown. DateTime startDate = DateTime.Now;DateTime endDate = DateTime.Now.AddDays(-1);TimeSpan t = startDate
MySQL supports AUTO_INCREMENT column types where the value of a particular column can be auto incremented as, and when, the records are inserted. Many instances would need the last value
The query below uses TOP to select the TOP 3 students: TOPSELECT TOP 3 *FROM Students; The code below uses LIMIT to only show three records: SELECT StudentName, StudentPercentageFROM StudentsLIMIT
StringWriter is similar to StringBuffer, which can collect a host of string values and work with the data. We will explore writing a porting of a given string. Code sample:
In Java, we can divide two positive integers and round up as follows: int result = (x + y – 1) / y Example: (4/3 = 1.33 and we want
Please see below for an example of how to convert a date time to ISO 8601 format. string isoFormatDateString = dateTimeObject.ToUniversalTime().ToString(“s”) + “Z”;
MySQL has abundant functions that support a multitude of application needs. Here, we shall use some Calendar functionality to find in which week a given date belongs. Samples: Considering the
Repository queries can be executed asynchronously using @Async annotation. The result can be a Future, CompletableFuture and ListenableFuture. The method will return immediately upon invocation: @asyncFuture findByName(String name);@asyncCompletableFuture findByName(String name);@asyncListenableFuture
There are many instances in which you might repeatedly use some functionality. It would be handy if you were allowed to create a function that could be used as, and
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided.
Avoid prefixing your Stored Procedure names with sp_. SQL Server first checks in the master database even when the Schema name is provided. ? Visit the DevX Tip Bank ?
A proof of concept can be seen below: @GetMapping(“…”)public MappingJacksonValue fooMethod(…) throws JsonProcessingException { List foos = …; MappingJacksonValue wrapper = new MappingJacksonValue(fooa); … return wrapper;}
Symbolic links are a useful entity, with which you can introduce some kind of encapsulation. The Symbolic link can be created in a secure environment (ex: DMZ) where users can
Explore how to convert a string to a byte array. String stringToBeConverted = ” ? ” ;int stringLength = stringToBeConverted.Length;byte[] bytes = new byte[stringLength / 2];for (int counter = 0;
When we need access to a Hibernate Session, we have to unwrap it from the current EntityManager via the unwrap() method as follows: // Spring and Java EE EntityManager em
Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead. When NOT IN is used in a query, SQL Server compares each result to null (even if no
Avoid using NOT IN whilst comparing nullable columns. Use NOT EXISTS instead. When NOT IN is used in a query, SQL Server compares each result to null (even if no
At times, when you want to compute the result of a mathematical formula, you can use MySQL to do the task. It is a great tool for this. Here are
See below for a short function that validates a given IP address: public static Boolean ValidateIP(string inputIP){var ipParts = inputIP.Split(‘.’);return Int32.Parse(ipParts [0]) < 256 &&Int32.Parse(ipParts [1]) < 256&Int32.Parse(ipParts [2]) <
Please understand that this USER named SRIDHAR is created without a password and is also dangerous. CREATE USER SRIDHAR Alternatively, you can use the code below to create with a
When a repository interface should not be instantiated at runtime, it should be marked with @NoRepositoryBean annotation as follows: @NoRepositoryBeaninterface BaseRepository extends Repository { // CRUD methods that will not
It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans through all column names and replaces the * operator with
It is best to avoid using the * operator in your queries, use explicit column names instead. SQL Server scans through all column names and replaces the * operator with
Here is how to split a concatenated string with a delimiter and remove empty entries. public static void Test() { string concatenatedString = “,ONE,,TWO,,,THREE,,”; char[] charSeparator = new char[] {‘,’};
