Discussion:
[Middlegen-user] DB2/AS400 : com.ibm.as400.access.AS400JDBCDriver : tested
Stéphan Mestach
2004-04-13 10:56:32 UTC
Permalink
<html><div style='background-color:'><DIV class=RTE>concerning : <A href="http://boss.bekk.no/boss/middlegen/platforms/database.html">http://boss.bekk.no/boss/middlegen/platforms/database.html</A></DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE>i'have sucessfully tested&nbsp;the <!--StartFragment -->&nbsp;com.ibm.as400.access.AS400JDBCDriver driver.</DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE>the more difficult part is to find the correct schema/catalog properties.</DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE> <DIV class=RTE>St�phan Mestach.</DIV></DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE>______________________________________________________________________________</DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE>the properties used : </DIV> <DIV class=RTE>&nbsp;</DIV> <DIV class=RTE>&nbsp;&nbsp; &lt;property name="database.script.file"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="${src.dir}/sql/${name}-db2.sql"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.driver.file"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="${lib.dir}/jt400.jar"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.driver.classpath"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="${database.driver.file};${basedir}"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.driver"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="com.ibm.as400.access.AS400JDBCDriver"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.url"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="jdbc:as400://myAS400;dateFormat=iso;librairies=*LIBL;dataTruncation=false"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.userid"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="xxx"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.password"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="xxx"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.schema"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="libraryName"/&gt;<BR>&nbsp;&nbsp; &lt;property name="database.catalog"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value="DBName"/&gt;</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>&nbsp;</DIV></div><br clear=all><hr>MSN Immo ... <a href="http://g.msn.com/8HMBFRBE/2740??PS=">Vous rêvez d’une maison bien à vous ?</a> </html>
Eivind Waaler
2004-04-15 10:06:02 UTC
Permalink
Thanks, I've added the info + a new driver config file.

Cheers
=2Eeivind
concerning : http://boss.bekk.no/boss/middlegen/platforms/database.html
=A0
i'have sucessfully tested=A0the =A0com.ibm.as400.access.AS400JDBCDriver
driver.
=A0
the more difficult part is to find the correct schema/catalog properties.
=A0
St=E9phan Mestach.
=A0
_________________________________________________________________________=
_____
=A0
=A0
=A0=A0 <property name=3D"database.script.file"=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0
value=3D"${src.dir}/sql/${name}-db2.sql"/>
=A0=A0 <property name=3D"database.driver.file"=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0
value=3D"${lib.dir}/jt400.jar"/>
=A0=A0 <property name=3D"database.driver.classpath"=A0=A0=A0=A0=A0
value=3D"${database.driver.file};${basedir}"/>
=A0=A0 <property name=3D"database.driver"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0
value=3D"com.ibm.as400.access.AS400JDBCDriver"/>
=A0=A0 <property name=3D"database.url"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0value=3D"jdbc:as400://myAS400;dateFormat=3Diso;librair=
ies=3D*LIBL;dataTruncation=3Dfalse
"/>
=A0=A0 <property name=3D"database.userid"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 value=3D"xxx"/>
=A0=A0 <property name=3D"database.password"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 value=3D"xxx"/>
=A0=A0 <property name=3D"database.schema"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0 value=3D"libraryName"/>
=A0=A0 <property name=3D"database.catalog"=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0 value=3D"DBName"/>
=A0
=A0
_________________________________________________________________________=
_______
MSN Immo ... Vous r=EAvez d=92une maison bien =E0 vous ?
------------------------------------------------------- This SF.Net email
is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by
Daniel Robbins, President and CEO of GenToo technologies. Learn
everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
_______________________________________________ middlegen-user mailing
https://lists.sourceforge.net/lists/listinfo/middlegen-user
Loading...