Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to define the naming conventions for JSON field names in Java?
The FieldNamingPolicy can be used to define a few standard naming conventions for JSON field names and it can be used in conjunction with GsonBuilder to configure a Gson instance to properly translate Java field names into the desired JSON field names. We can use the setFieldNamingPolicy() method of GsonBuilder to configure a specific naming policy strategy to an object's field during serialization and deserialization.Gson supports various field naming requirements with following field naming policiesFieldNamingPolicy.IDENTITY: It uses the exact same naming as the Java model when it serializes an object.FieldNamingPolicy.LOWER_CASE_WITH_UNDERSCORES: It modifies a Java field name from its camel-cased form to a lower case field name where ...
Read MoreHow to create an array in PowerShell?
To create or declare an array in PowerShell, there are few methods.You can directly assign values to the variable and separate it by comma (, ) and that variable becomes the variable.For example, $a = "Apple", "Dog", "Cat", "Banana", "Camel"$a is now an array. To access the variable you can use the Indexing method. The first value will be stored at 0, second at 1 and so on.$a[0] will give the output “Apple”, $a[1] will give the output “Dog” and so on. Negative indexing also works in the array. -1 is the last index, -2 is the second last and ...
Read MoreWhy it shows 0 instead of empty string whenever I insert an empty string into a MySQL column which is declared as NOT NULL?
It is because inserting an empty string means that we are inserting some value and not NULL. The empty string apparently maps to zero as an integer. In other words, we can say that by inserting empty string we are providing a value to MySQL that has integer representation as INT 0. Consider the following example in which we inserted an empty string and it mapped to 0 by MySQL.mysql> create table test(id int NOT NULL, Name Varchar(10)); Query OK, 0 rows affected (0.19 sec) mysql> Insert into test(id, name) values('1', 'Gaurav'), ('0', 'Rahul'), ('', 'Aarav'); Query OK, 3 ...
Read MoreHow can we find out the current transaction mode in MySQL?
We can run “SELECT @@AUTOCOMMIT” command to check the current transaction mode.mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 1 | +--------------------+ 1 row in set (0.05 sec) mysql> SET AUTOCOMMIT = 0; Query OK, 0 rows affected (0.00 sec) mysql> Select @@AUTOCOMMIT; +--------------------+ | @@AUTOCOMMIT | +--------------------+ | 0 | +--------------------+ 1 row in set (0.00 sec)
Read MoreUsing ABAP Function module RSAQ_REMOTE_QUERY_CALL, NO_DATA_SELECTED exception using selection parameters
As SAP provides flexible options that allow selection parameters easy to use. As you are using multiple parameters please note the following:Set KIND to “s” only for using select option. If you are using parameters, it should be “P”Instead of using EN, try using internal language “E”RSAQ_REMOTE_QUERY_FIELDLIST- this function module can be used to find the types as below −Use T-code SE37 and enter the FM name → Display
Read MoreABAP dump while creating an entry in SAP system using SAP JCO
This seems to be a problem at ABAP side and not Java side. This is an ABAP dump and you need to useTransaction code: ST22 on ABAP backend to check functional module inSAP system.Once you get the exact details of ABAP dump you are getting, you need to edit the calling method to create an entry.
Read MoreExtracting data from SAP HANA database and load to ORACLE database
There is a number of ways you can achieve this. Here are few of the methods to do the same.a) There are many standard tools in SAP by use of which you can extract the data and also automate the whole process. With the use of an ETL tool, this can be achieved like SAP Data Services, OWB, etc.b) The other option is to write a code in ABAP to fetch the data from the database and the write into a format as per your requirement.c) You can also write a RFC or remote-enable function module which can be called ...
Read MoreReplacing multiple occurrence by a single occurrence in SAP HANA
The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL) FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.
Read MoreHandling Exception and use of CX_ROOT directly and subclasses
It is not advisable to use CX_ROOT directly and you would require using one of its direct subclasses. Also, the propagation depends upon the exception subclass hierarchy.Subclasses of CX_STATIC_CHECK – these do not propagate automatically. You will need to do the handling yourself or there will be a syntax error in the program.Subclasses of CX_DYNAMIC_CHECK – these do not require any handling. But the program that does not handle the exception will be aborted with these subclasses.Subclasses of CX_NO_CHECK – These will get propagated automatically if the exception is not handled.
Read MoreUsing Breakpoint in SAP system
There is a problem with your code. Here is the correct syntaxSyntaxBREAK username.If you want to implement it for all the users you can just codeBREAK-POINT.
Read More