Re: System Name for JDBC connection. etc.

["Bruce Jin" <brucej@xxxxxxxxxxxxxxxxxxxx>]

thanks. I will ask my system administrator to take care of host table set
up.

Someone suggested use IP instead of system name in Toolbox jdbc driver. I
tried and it works. Now without worrying system name/host table setup, I can
access any as400 from my PC and access one as400 from another as400, using
code like this:

String sys = "jdbc:as400://123.122.112.150";
conn = DriverManager.getConnection(sys,userid,passwd);

Bruce

-----Original Message-----
From: Bennion, Dick <Dick_Bennion@AFCC.com>
To: 'JAVA400-L@midrange.com' <JAVA400-L@midrange.com>
Date: Tuesday, November 21, 2000 6:28 PM
Subject: RE: System Name for JDBC connection. etc.


>Your DNS Server needs to be aware of the AS/400.
>A quick fix is to define the AS/400 in your hosts file.  The hosts file for
>NT is located in WINNT/SYSTEM32/DRIVERS/ETC.  There is a file lmhosts there
>as well.  If you approach it this way you will need to change the hosts
file
>on each machine that you are going to use to access the AS400.
>
>Dick Bennion
>
>> -----Original Message-----
>> From: Dave Wall [SMTP:dawall@us.ibm.com]
>> Sent: Tuesday, November 21, 2000 2:35 PM
>> To: JAVA400-L@midrange.com
>> Subject: Re: System Name for JDBC connection. etc.
>>
>>
>> I hope someone else on this forum can help you out here.  I am lucky
>> enough
>> to have a system operator that does all our comm and network setup.  Is
>> there a chance we are working too hard at this?  Do you already have TCP
>> set up in your environment and can ping your AS/400 from your PC?  If yes
>> then the name you use on ping is the name you give the JDBC driver.
>>
>> David Wall
>> AS/400 Toolbox for Java
>>
>>
>> "Bruce Jin" <brucej@MRC-PRODUCTIVITY.COM>@midrange.com on 11/21/2000
>> 12:52:09 PM
>>
>> Please respond to JAVA400-L@midrange.com
>>
>> Sent by:  owner-java400-l@midrange.com
>>
>>
>> To:   <JAVA400-L@midrange.com>
>> cc:
>> Subject:  Re: System Name for JDBC connection. etc.
>>
>>
>>
>> How do I set up the system name so that my as400 is know to the network
>> and
>> thus I can use Toolbox driver to access my as400?
>>
>> TIA
>> Bruce
>>
>> -----Original Message-----
>> From: Dave Wall <dawall@us.ibm.com>
>> To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
>> Date: Tuesday, November 21, 2000 10:23 AM
>> Subject: Re: System Name for JDBC connection. etc.
>>
>>
>> >
>> >With the Toolbox driver the name is the AS/400's name as it is known to
>> the
>> >network.  The Toolbox uses sockets support built into Java to exchange
>> data
>> >between the client and server.  That name given to the Toolbox driver is
>> >passed on to the JVM when a socket connection is created.  The JVM
and/or
>> >network does normal name resolution activities (go to the DNS to resolve
>> >the name, for example) to figure out the target of the connection.
>> >
>> >David Wall
>> >AS/400 Toolbox for Java
>> >
>> >
>> >"Bruce Jin" <brucej@MRC-PRODUCTIVITY.COM>@midrange.com on 11/21/2000
>> >08:28:34 AM
>> >
>> >Please respond to JAVA400-L@midrange.com
>> >
>> >Sent by:  owner-java400-l@midrange.com
>> >
>> >
>> >To:   <JAVA400-L@midrange.com>
>> >cc:
>> >Subject:  System Name for JDBC connection. etc.
>> >
>> >
>> >
>> >Hello,
>> >
>> >Where I can find the system name for DriverManager.getConnection()?
>> >Do I have to add this name using WRKRDBDIRE?
>> >If I use non-native driver com.ibm.as400.access.AS400JDBCDriver() to
>> access
>> >AS400 from PC, how the AS400 is located and connected through this name?
>> >
>> >TIA
>> >
>> >Bruce
>> >
>> >
>> >
>>
>>
>> +---
>> | This is the JAVA/400 Mailing List!
>> | To submit a new message, send your mail to JAVA400-L@midrange.com.
>> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>> | To unsubscribe from this list send email to
>> JAVA400-L-UNSUB@midrange.com.
>> | Questions should be directed to the list owner: joe@zappie.net
>> +---
>
>+---
>| This is the JAVA/400 Mailing List!
>| To submit a new message, send your mail to JAVA400-L@midrange.com.
>| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: joe@zappie.net
>+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---