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`;