Update of /cvsroot/csvtosql/csvtosql_jdk50/examples/test.simple.loadjar
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14241/test.simple.loadjar
Added Files:
descriptor.xml users.txt
Log Message:
no message
--- NEW FILE: users.txt ---
1, John,Doe,120 jefferson st.,Riverside, NJ, 08075, 23/8/1980
0, Jack,McGinnis,220 hobo Av.,Phila, PA,09119, 14/1/1984
1, John Da Man,Repici,120 Jefferson St.,Riverside, NJ, 08075 , 19/10/1979
0, Stephen,Tyler,7452 Terrace At the Plaza road,SomeTown,SD, 91234, 25/11/1999
--- NEW FILE: descriptor.xml ---
<?xml version="1.0" encoding="UTF-8"?>
<root>
<!-- CONFIGURATOR DATA -->
<descriptor version="3"/>
<!-- DEFINE HERE TABLE STRUCTURE -->
<structure tablename="tab_users">
<field name="ID" type="NUMBER"/>
<field name="name" type="VARCHAR"/>
<field name="surname" type="VARCHAR"/>
<field name="address" type="VARCHAR"/>
<field name="city" type="VARCHAR"/>
<field name="state" type="VARCHAR"/>
<field name="cap" type="VARCHAR"/>
<field name="borndate" type="DATE">
<param name="inputformat" value="dd/MM/yy"/>
<param name="outputformat" value="yyyy-MM-dd"/>
</field>
</structure>
<!-- WHAT GRAMMAR USE -->
<grammar class="net.sf.csv2sql.grammars.oracle.GrammarFactory"/>
<!-- TEMPORARY STORAGE -->
<storage class="net.sf.csv2sql.storage.Memory"/>
<!-- RENDERER CONFIGURATION -->
<render class="net.sf.csv2sql.renders.SqlInsertRenderer">
<param name="inputfile" value="users.txt"/>
<param name="separator" value=","/>
<!--optional-->
<param name="trimdata" value="true"/>
<param name="suppressheader" value="false"/>
<param name="removedoublequotes" value="false"/>
<!-- decomment for add id autogeneated field -->
<!--<param name="idGenerator" value="net.sf.csv2sql.idgenerators.Incremental"/>-->
</render>
<!-- WRITER CONFIGURATION -->
<output>
<!-- change parameters and activate it -->
<writerAppender active="false"
class="net.sf.csv2sql.writers.JdbcWriter">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost/test"/>
<param name="username" value="root"/>
<!--optional-->
<!--<param name="password" value="secret"/>-->
<!--<param name="commit" value="false"/>-->
<param name="jdbcjar" value="/root/myJdbcDriver.jar"/>
</writerAppender>
<!-- change parameters and activate it -->
<writerAppender active="false"
class="net.sf.csv2sql.writers.JdbcBatchWriter">
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost/test"/>
<param name="username" value="root"/>
<param name="batchcount" value="10"/>
<!--optional-->
<!--<param name="password" value="secret"/>-->
<!--<param name="commitbatchcount" value="0"/>-->
<param name="jdbcjar" value="/root/myJdbcDriver.jar"/>
</writerAppender>
</output>
</root>
|
