databaseName in DB2 connection on AS400

, ,
1

Hi

I am trying to connect to AS400 using DataSource Class com.ibm.as400.access.AS400JDBCDataSource.

I am able to establish a connection and have specified the databasename in the connection.

When i run the adapter service using ..

it returns an error *FILE not found.

When i select the Server, Schema, table it works fine. Specifying a database name for SQL server DB again works fine.

I would like to know how to use the database name in the connection.

Regards

Sreedhar

2

When you are able to successfully create the JDBCAdapter AS400 connection and trying to create AdapterService using the above connection then why you need the database name setting the AS??

Can you elaborate more on your problem??

HTH,
RMG

3

Hi RMG

The connection is not taking the database name and the database name, schema, table has to be given manually for e.g. hmtest.hmtstdta.F1234
hmtest - server
hmtstdta - schema
F1234 - table name

When i move the code to production i have to manually reset everything again.

I want to avoid this.

If the database name is successful then i can give as .. where in the Current catalog would be prod server, current schema would be prod database.

Regards

Sreedhar

4

Sreedhar,
In the JDBC - Other Properties, you can give the following property to default it to a library.

libraries=;

eg. in your case
libraries=hmtstdta;

Try it and see if it works for your case.

5

Thanks a lot sekay this worked