RE: using jdbc connection to as/400 in a mapping xml

[Rizwan Ahmed <rizwan@xxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Well, figured out myself,
Actually has to use entity for " as "

Like

<database url="jdbc:as400://129.50.1.222;naming=sql;errors=full&quot;,
                        &quot;user&quot;,
                        &quot;pasw"
driver="com.ibm.as400.access.AS400JDBCDriver">

</database>

and it worked,

regards
rizwan


-----Original Message-----
From: Rizwan Ahmed [mailto:rizwan@nscsa.com.sa]
Sent: Monday, April 08, 2002 3:15 PM
To: java400-l@midrange.com
Subject: using jdbc connection to as/400 in a mapping xml

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Hello all,

I am stuck connecting to as400 using jdbc driver using it in a xml mapping
file.

My mapping file goes like this,

<map>

  <!-- Connect to MySQL Database -->
  <!--
  <database
url="jdbc:mysql://localhost/database01?user=rizwan&amp;password=pasw"
             driver="org.gjt.mm.mysql.Driver">  -->

     <!-- Connect to AS/400 Database -->

     <database url="jdbc:as400://129.50.1.222; userid , pasw"

driver="com.ibm.as400.access.AS400JDBCDriver()">

....
....

I have to specify as400 system, user id and password together in the url
attribute in the database tag inside xml and making it to connect to the
as400.

Actually the idea is to specify the required database in the mapping XML so
as the parser program parses it accordingly.

TIA
Thanks for any help,
Rizwan

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.