Changing default workspace in Eclipse

Default workspace configuration will be available in config.ini file.


To locate the file, follow this path
*directory where eclipse is installed*\Eclipse\configuration
here you will find config.ini file.

Change following parameter:
osgi.instance.area.default=@user.home/workspace
to
osgi.instance.area.default=C\:\\your project directory path\\workspace

Calling function module from new task in SAP ABAP

clear: f_flag.
call function 'CLOI_CHANGES_UPL_31'
starting new task 'CLOI_TEST'
performing receive_res on end of task
exporting
cloi_if_par = ls_cloi_if_par_v2
tables
cloi_ordi_imp = lt_cloi_ordi
cloi_method_log_exp = lt_cloi_methods_exp
cloi_message_log_exp = t_cloi_messages_exp
cloi_msg_obj_log_exp = lt_cloi_msg_obj_log_exp
cloi_ord_exp = t_cloi_ord_exp.

* wait till the global variable will be set by our form
wait until f_flag = 'X'.

This is the form that is used to receive results and signalize
the end of processing:

form receive_res using taskname.

data: lt_cloi_msg_obj_log_exp type standard table of cloimoblog,
lt_cloi_methods_exp type standard table of cloimetlog.

receive results from function 'CLOI_CHANGES_UPL_31'
tables
cloi_method_log_exp = lt_cloi_methods_exp
cloi_message_log_exp = t_cloi_messages_exp
cloi_msg_obj_log_exp = lt_cloi_msg_obj_log_exp
cloi_ord_exp = t_cloi_ord_exp.

f_flag = 'X'.

endform.

Note: 'importing' function module is not possible here.

victim of software counterfeiting windows did not pass genuine windows validation

Error message
you may be a victim of software counterfeiting, this copy of windows did not pass genuine windows validation.

Causes
windows\system32\WgaLogon.dll
windows\system32\WgaTray.exe
windows\system32\LegitCheckControl.dll

Steps to perform

1) Start windows in safe mode.
2) Open command prompt (start->run->cmd)
3) delete file LegitCheckControl.dll. Command is "del LegitCheckControl.dll /F"
4) change properties of WgaLogon.dll.

The wgatray.exe process makes the check for genuine windows software. You can disable WGA by removing the execute bit on WgaLogon.dll. That way, winlogon can't call it as a notification package at boot, and since WgaLogon is responsible for running and maintaining WgaTray.exe, no more tray popups either.

To change the execute bit of WgaLogon.dll, first turn off Simple File Sharing. Now right click the file in Windows Explorer and open the Security Tab. Hit the Advanced button, uncheck the Inherit box at the bottom, hit the Copy button, then hit OK. Go through each listed user/group and remove the "Read & Execute" permission for that file, leaving the "Read" permission as-is.

Hit OK to apply the permission changes and close the file properties dialog. Restart the machine. You can now turn "Use simple file sharing" back on, if you want.
Note: Sometimes no need to worry about "Use simple file sharing". Without turning off simple file sharing

5) Restart pc in safe mode.

6) delete files WgaLogon.dll and WgaTray.exe
Commands are as follows:

delete WgaLogon.dll /F
delete WgaTray.exe /F

7) Now start pc in normal mode

ITS DONE! :)

Oracle to_date and mysql STR_TO_DATE

Hi All,
If we exported tables from Oracle in insert query format then query statements contains to_date(DATE, PATTERN) for date values.
If we want to execute these query statements in MySql then this statement will not work.
There is fixed date format in MySql and that is 'yyyy-mm-dd'.
To store data from given format to MySql format STR_TO_DATE(DATE, PATTERN) can be used.
Oracle to_date is equivalent to STR_TO_DATE in mysql

STR_TO_DATE(str,format)
Ex:
In Oracle table date in dd-MMM-yy format
to_date('10-JAN-06','DD-MON-RR')
Equivalent in MySql is
STR_TO_DATE('10-JAN-06','%d-%M-%y')
will store date in yyyy-mm-dd format that is 2006-01-10

msvcr71.dll not found, reinstalling application may solve this problem

Problem Description:
I got 'msvcr71.dll not found, reinstalling application may solve this problem' error while installing webMethods on windows 2003 R2 server.
After completing installation of webMethods on this server I configured it for SAP Adapter and wmDB.
But when I started webMethods, while starting SAP Adapter service, this error popup message is thrown twice.
This popup was suggesting for reinstallation of webMethods due to improper installation.
wmSAP package was partially loaded.
I tried twice to reinstall webMethods but each time it was not deleting all files from c:\webmethods7\ directory.


SOLUTION:
May be due to some registry entries this problem was occurring again and again.
What I did, I uninstalled webMethods. Then from c: drive I deleted webmethods7 directory and its contains.
After this I simply restarted server physically.
Again installed webMethods and checked for msvcr71.dll in system 32 folder.
It was there!
My webMethods server is now working properly.

WebMethods configuration for mysql

Following configuration at webmethods end for mysql:

• Before configuring mysql in webmethods download java-mysql connector from MySql Connectors Link
• Downloaded file will be mysql-connector-java-5.1.7-bin.jar (depending on MySql version support).
• Place this file in directory path as shown below
  
• 'webmethods_dir_path\IntegrationServer\lib\jars\mysql-connector-java-5.1.7-bin.jar'
• Go to administrator page of webMethods and click on about link.
• You must see in above jar file in 'Server Classpath' list.

Configuring JDBC adapter:
To use JDBC adapter in webMethods for MySql do following configuration.

• Transaction Type : LOCAL_TRANSACTION
• DataSource Class : com.mysql.jdbc.jdbc2.optional.MysqlDataSource
  
• server name : here you specify server ip
• user : user name of MySql database
• password : password for above user
• Retype password : Retype above password again.
• database name : Name of the database in MySql.
• portNumber : Port on which MySql database is accessible remotely.

Save above configuration.
Now you are able to use MySql JDBC connection.

Configuration for WmDB:

• Alias : Give any name to MySql alias of your choice.
• DB URL : jdbc:mysql://SERVER_IP:3306/test

Most of the times port is 3306 which is default for MySql, kindly check for port address. Change SERVER_IP to server ip address.

• DB Username : user name of MySql database
• DB Password : password for above user
• DB Driver : com.mysql.jdbc.Driver

All other settings keep as appered as default seetings.

Launch MySql:

from command prompt:

• Goto Start->All Programs->MySql->MySql server 5.1->MySql Command Line Client.
• It will open MySql prompt(mysql> ).
• Enter password and proceed.

MySql basic commands are as follows:

• To list databases:

show databases;

• To select database:

use database_name;
Ex: use test;

• To list tables in database:

show tables;

• To see table schema:

describe table_name;
Ex: describe emptable;

• To create table:

Ex:
create table if not exists `EMP_MASTER`
(
`EMP_ID` varchar(10) NOT NULL, `NAME` varchar(20), `ADDRESS` varchar(50), `SALARY` NUMERIC(10,2),
constraint SYS_C2516 unique (EMP_ID),
primary key (EMP_ID)
);

• To insert records in table:

Ex:
insert into `EMP_MASTER` (`EMP_ID`, `NAME`, `SALARY`) values ('1000053003',`JOHN CENA`, 35000.00);

• To delete all records from table:

truncate table `table_name`;
Ex: truncate table `EMP_MASTER`;

• To delete table:

drop table table_name;
Ex: drop table `EMP_MASTER`;