oracle 向mysql迁移

[url]http://www.convert-in.com/ora2sql.htm[/url]

set SQL_SAFE_UPDATES=0

手动进行脚本调试时要注意以下几点：
1.varchar2 -->varchar
2.number -->numeric
3.clob --> text
4.双引号的问题
5.保留字的问题，加``


str_to_date('21-10-2012 22:30:20', '%d-%m-%Y %H:%i:%s')

create table XRS.B_TAG_BOOK
(
`id` INT NOT NULL AUTO_INCREMENT ,
TAG_ID int(6),
BOOK_ID int(6),
primary key (ID)
)ENGINE = MyISAM;


#oracle
#jdbc.oralce.driverClassName=oracle.jdbc.driver.OracleDriver
#jdbc.oralce.url=jdbc:oracle:thin:@127.0.0.1:1521:ORCL
#jdbc.oralce.username=zxqy
#jdbc.oralce.password=zxqy

#mysql
jdbc.mysql.driverClassName=com.mysql.jdbc.Driver
jdbc.mysql.url=jdbc:mysql://localhost:3306/zxqy?useUnicode=true&characterEncoding=latin1
jdbc.mysql.username=tianbao2000
jdbc.mysql.password=tianbao2000

<!--dataSource-->
<!--<bean id="dataSourceOracle" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">-->
<!--<property name="driverClassName">-->
<!--<value>${jdbc.oralce.driverClassName}</value>-->
<!--</property>-->
<!--<property name="url">-->
<!--<value>${jdbc.oralce.url}</value>-->
<!--</property>-->
<!--<property name="username">-->
<!--<value>${jdbc.oralce.username}</value>-->
<!--</property>-->
<!--<property name="password">-->
<!--<value>${jdbc.oralce.password}</value>-->
<!--</property>-->
<!--<property name="initialSize" value="5"/>-->
<!--<property name="maxIdle" value="20"/>-->
<!--<property name="maxActive" value="50"/>-->
<!--<property name="maxWait" value="60000"/>-->
<!--<property name="removeAbandoned" value="true"/>-->
<!--<property name="removeAbandonedTimeout" value="10"/>-->
<!--<property name="poolPreparedStatements" value="true"/>-->
<!--<property name="logAbandoned" value="true"/>-->
<!--<property name="validationQuery" value="select * from dual"/>-->
<!--</bean>-->

<bean id="dataSourceMysql" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.mysql.driverClassName}"/>
<property name="url" value="${jdbc.mysql.url}"/>
<property name="username" value="${jdbc.mysql.username}"/>
<property name="password" value="${jdbc.mysql.password}"/>
<property name="initialSize" value="5" />
<property name="maxActive" value="100" />
<property name="maxIdle" value="30" />
<property name="maxWait" value="1000" />
<property name="poolPreparedStatements" value="true" />
<property name="defaultAutoCommit" value="false" />
</bean>