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 by Srinivas Gorla
Page 3 of 5
Integrate node.js with SAP HANA system
You can insert data into HANA database using node.js. You can also connect to SAP HANA database via JDBC driver.To connect via JDBC, you need to install JDBC driver ngdbc.jar. This driver is installed as part of SAP HANA client installation. Ngdbc.jar file is available at this location −C:\Program Files\sap\hdbclient\ on Windows platforms /usr/sap/hdbclient/ on Linux and UNIX platformsNext is to add ngdb.jar to the classpath and write a Java program to connect to a database and execute SQL command.jdbc:sap://myServer:30015/?autocommit=falseYou can also add one or more failover servers by adding additional hosts.ExampleFollowing is an example of connecting SAP HANA Server ...
Read MoreHow to style multi-line conditions in 'if' statements in Python?
There are many ways you can style multiple if conditions. You don't need to use 4 spaces on your second conditional line. So you can use something like &minusl;if (cond1 == 'val1' and cond2 == 'val2' and cond3 == 'val3' and cond4 == 'val4'):# Actual codeYou can also start the conditions from the next line −if ( cond1 == 'val1' and cond2 == 'val2' and cond3 == 'val3' and cond4 == 'val4' ):# Actual codeOr you can provide enough space between if and ( to accomodate the conditions in the same vertical column.if (cond1 == 'val1' ...
Read MoreHow to specify the kind of text track in HTML?
Use the kind attribute in HTML to specify the kind of text track in HTML. For example, you can set the kind as subtitles for subtitle files.ExampleYou can try to run the following code to implement the kind attribute − Your browser does not support the video element.
Read MoreHow to build an ant file for a Java Eclipse project?
Follow the steps given below, to integrate Ant into Eclipse.Make sure that the build.xml is a part of your java project, and does not reside at a location that is external to the project.Enable Ant View by following Window > Show View > Other > Ant > Ant.Open Project Explorer, drag the build.xml into the Ant View.Your Ant view looks similar to –Clicking on the targets, build / clean / usage will run Ant with the target. Clicking "fax" will execute the default target - usage.The Ant Eclipse plugin also comes with a good editor for editing build.xml files. The ...
Read MoreWhat does the method removeRange(int fromIndex, int toIndex) do in java?
The removeRange() method of the ArrayList class removes all of the elements from this List whose index is between fromIndex and toIndex.Exampleimport java.util.*; public class ArrayListDemo extends ArrayList{ public static void main(String[] args) { ArrayListDemo arrlist = new ArrayListDemo(); arrlist.add(10); arrlist.add(12); arrlist.add(31); System.out.println("The list:" + arrlist); arrlist.removeRange(0,2); System.out.println("The list after using removeRange:" + arrlist); } }OutputThe list:[10, 12, 31] The list after using removeRange:[31]
Read MoreHow to convert an object to byte array in java?
To convert an object to byte arrayMake the required object serializable by implementing the Serializable interface.Create a ByteArrayOutputStream object.Create an ObjectOutputStream object by passing the ByteArrayOutputStream object created in the previous step.Write the contents of the object to the output stream using the writeObject() method of the ObjectOutputStream class.Flush the contents to the stream using the flush() method.Finally, convert the contents of the ByteArrayOutputStream to a byte array using the toByteArray() method.Exampleimport java.io.ByteArrayOutputStream; import java.io.ObjectOutputStream; import java.io.Serializable; class Sample implements Serializable { public void display() { System.out.println("This is a sample class"); } } public ...
Read MoreWhile using SAP .NET connector, I am an getting error: Could not load file or assembly 'sapnco' or one of its dependencies.
You can try any of the below fixes −Go to Run > RegeditOpen “HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\1X.0\WebProjects” and change Use64BitIISExpress from 0 → 1Next is to restart Visual Studio and IISExpress.Other solution would be to try configuring IIS service, and set appPool .Net 4.0. You can try this to fix sapnco dll issue.Go to IIS Manager → Application PoolsOther fix would be to navigate to Project/Properties → Set platform target from “any” to “x86”.
Read MoreIs it possible to delete the actives while you are running a loop over an internal table in SAP ABAP?
DELETE command will have a result. You should make sure that once you delete the row, there should not be any reference or use of row subsequently in the loop. The best is to use CONTINUE as soon as you perform deletion. I will suggest avoiding “DELETE lt_itab INDEX sy-tabix” because it will change the sy-tabix i.e. table index. In case if you just want to delete the current row in the loop then you can simply use.“DELETE lt_itab”One more thing if you are using statement “DELETE lt_itab FROM ls_wa” then whether knowingly or unknowingly, you are deleting the same lines ...
Read MoreHow can we create MySQL stored procedure to calculate the factorial?
mysql> DELIMITER // mysql> CREATE PROCEDURE get_factorial(IN N INT) -> BEGIN -> SET @@GLOBAL.max_sp_recursion_depth = 255; -> SET @@session.max_sp_recursion_depth = 255; -> -> CALL factorial_recursive (N, @factorial); -> -> SELECT @factorial; -> END // Query OK, 0 rows affected (0.00 sec) mysql> DELIMITER // mysql> CREATE PROCEDURE factorial_recursive(IN N INT, OUT factorial INT) -> BEGIN -> IF N = 1 THEN -> SET factorial := 1; -> ...
Read MoreWhile running MySQL statements in batch mode, how can we print, along with output, which statements are getting executed?
By using –v option in batch mode, the MySQL statements can be printed along with output. For example, after running the same query in batch mode with –v option we will get the statement printed along with output.C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql -v Enter password: ***** -------------- select * from hh -------------- id 1 2It is showing the statement select * from hh which is written in the file hh.sql.
Read More