# can't access to database from IDE eclipse

**URL:** <https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, NaturalONE, Adabas-Natural-Community-Edition, Adabas-Natural-Cloud\
**Created:** [June 12, 2020, 7:33am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329 "2020-06-12T07:33:33Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![eric\_saradin](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@eric\_saradin](https://techcommunity.softwareag.com/u/eric_saradin)\
**Post date:** [June 12, 2020, 7:33am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/1 "2020-06-12T07:33:33Z")

</div>

Hi

I installed Docker Natural Community Edition , i see the database with AdabasManager and it’s running . But , when i lauch exemple program using employees DDM , i get the error as you can see on screen copy.

I changed the DBID of the DDM from 0 to 12 as described in an anoher topic but no change .

Thanks for your anwser .

 ![Capture d’écran du 2020-06-11 22-06-11.png](https://global.discourse-cdn.com/techcommunity/original/2X/8/88640e6e2395a4a4997a89d0ecc8b572a565ab92.png)  
 ![Capture d’écran du 2020-06-11 22-04-22.png](https://global.discourse-cdn.com/techcommunity/original/2X/5/5555d1360f1684c1570f39bebb3678749f0c4cfa.png)

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [June 12, 2020, 4:31pm UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/2 "2020-06-12T16:31:04Z")

</div>

The error message identifies database 12, so we know that you correctly stowed/built the DDM and program.

Error number 3148 tells us that Natural cannot communicate with DB 12, despite Adabas Manager reporting the database is active.

I have no experience with the Docker installation procedure. Were ONE and Adabas installed at the same time, on the same machine?

---

<div class="post-metadata">

**Author:** ![George\_Cooper](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/george_cooper/32/7831_2.png) [@George\_Cooper](https://techcommunity.softwareag.com/u/George_Cooper)\
**Post date:** [June 13, 2020, 12:27am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/3 "2020-06-13T00:27:25Z")

</div>

I’m glad to see the Docker CE editions have been updated to 9.1.2 and a refreshed license expire date. Maybe this weekend I’ll finally get around to trying to download and install them, if my old spare PC supports the Docker virtualization.

A thought, make sure your Docker command to start the Natural Development server specifies the correct IP address where Adabas is installed.  
7. 2 Starting Natural in a Docker Container  
The following command starts the Natural container. You have to replace “” in the command with the IP address that you have determined, to have access to the Adabas database.

docker run -d -p 2700:2700 --add-host adabas-db: -e ACCEPT\_EULA=Y store/softwareag/natural-ce:9.1.2

Meanwhile, reading through the Adabas & Natural CE for Docker guide, I found this suggested 3148 problem solution on the last page:

12.2 Natural runtime cannot connect to Adabas running in a container  
You can connect to the Natural container on port 2700,but Natural applications running in the container cannot connect to the Adabas database,and you are getting error code 3148.  
Check first if you have a firewall running on your host machine that is blocking port 60001. Ensure that this port can be reached in your environment.  
If this is not the case,it is possible that you have a loopback address access problem in your configuration so that Natural cannot access the Adabas network on port 60001 through the external IP address.

You could fix this problem using a Docker network while starting your containers. To do so, first stop and remove the already started Adabas and Natural Docker containers.

Change your Quickstart commands to the following three commands:

docker network create adabas\_natural

docker run -d -e ACCEPT\_EULA=Y -e ADADBID=12 -e “ADA\_DB\_CREATION=demodb” --network adabas\_natural --name ADABAS-DBstore/softwareag/adabas-ce:6.7.1

docker run -d -p 2700:2700 --network adabas\_natural -e ACCEPT\_EULA=Y store/softwareag/natural-ce:9.1.2

Hope that helps. Please let us know.  
Thanks,  
George

---

<div class="post-metadata">

**Author:** ![eric\_saradin](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@eric\_saradin](https://techcommunity.softwareag.com/u/eric_saradin)\
**Post date:** [June 14, 2020, 3:11pm UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/4 "2020-06-14T15:11:52Z")

</div>

Hi

I followed your instructions creating a docker network but without success and always the same error . I read carefully the install doc and found that i’ve to create a mapping file inside the container docker adabas , so i do that and restart the container but during the adabas’s container startup , i get the message " mapping file found but database unreachable by TCP/IP and at the end , the database becomes inactive . if i remove the mapping file and restart the container , database gets active.

Very strange.

So , for now , I’m stuck but I’m going to get on .

Thanks for answer .

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [June 13, 2020, 1:20am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/5 "2020-06-13T01:20:26Z")

</div>

do you have a dbmapping.txt file? Adabas TCP needs this to map the dbid to a TCP/IP address and port.

The file is located in the AdabasClient/config directory (/Adabas/Client/config/dbmapping.txt). You need a line in there with  
 = adatcp://:  
If Adabas and Natural are running in the same container, then this line in dbmapping.txt might be:  
012 = adatcp://localhost:60001

---

<div class="post-metadata">

**Author:** ![eric\_saradin](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@eric\_saradin](https://techcommunity.softwareag.com/u/eric_saradin)\
**Post date:** [June 14, 2020, 3:11pm UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/6 "2020-06-14T15:11:52Z")

</div>

Hi

yes i add a dbmapping file as the getting started guide describe it but it failed with the same error .But i see in the adabas manager some access to the database 12 open command and close command .

So i’m going to stop to spend time to get it work .

Thanks for help

BR

---

<div class="post-metadata">

**Author:** ![eric\_saradin](https://avatars.discourse-cdn.com/v4/letter/e/58f4c7/32.png) [@eric\_saradin](https://techcommunity.softwareag.com/u/eric_saradin)\
**Post date:** [June 14, 2020, 3:11pm UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/7 "2020-06-14T15:11:52Z")

</div>

HI

After a last try , it works !!! . As we can read in lot’s of reply in forums , solution was to RTFM . So , i don’t know if it’s important , but the guide tells to install docker-ce and I installed docker from repository stable debian buster . Following guide instructions , I remove my docker version and install docker-ce and it’s all .

BR

---

<div class="post-metadata">

**Author:** ![George\_Cooper](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/george_cooper/32/7831_2.png) [@George\_Cooper](https://techcommunity.softwareag.com/u/George_Cooper)\
**Post date:** [June 15, 2020, 6:00pm UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/8 "2020-06-15T18:00:11Z")

</div>

Hi Eric,

Congratulations for finding the solution to your problem. I’m glad to hear you got it working, and what the problem was. Thanks for updating us with your solution.

Cheers,  
George

---

<div class="post-metadata">

**Author:** ![Dariusz\_Sznura1](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@Dariusz\_Sznura1](https://techcommunity.softwareag.com/u/Dariusz_Sznura1)\
**Post date:** [January 22, 2021, 6:43am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/9 "2021-01-22T06:43:31Z")

</div>

Hi  
i have the same problem , ‘database 12 not active…’  
in my cd /opt/softwareag/AdabasClient/config/ there are not file dbmapping.txt , but dbmapping.tmpl.  
Can you write more details , how to create that file .

i run on docker  
C:\WINDOWS\system32\>docker ps  
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES  
ced7fa83d4a1 store/softwareag/natural-ce:9.1.2 “/bin/sh -c $NAT\_HOM…” 12 hours ago Up 30 seconds 0.0.0.0:2700-\>2700/tcp natural-ce

9a4e17e9fb76 store/softwareag/adabas-ce:6.7.1 “startAdabas” 12 hours ago Up 29 seconds (healthy) 0.0.0.0:8190-\>8190/tcp, 8191/tcp, 0.0.0.0:60001-\>60001/tcp, 60002/tcp adabas-db

After docker exec -it 9a4e17e9fb76 bash

[sagadmin@9a4e17e9fb76 ~]$ cd /opt/softwareag/AdabasClient/config/  
[sagadmin@9a4e17e9fb76 config]$ ls  
dbmapping.tmpl  
[sagadmin@9a4e17e9fb76 config]$ whoami  
sagadmin  
[sagadmin@9a4e17e9fb76 config]$ cp dbmapping.tmpl dbmapping.txt  
cp: cannot create regular file ‘dbmapping.txt’: Permission denied

Regards

---

<div class="post-metadata">

**Author:** ![Dariusz\_Sznura1](https://avatars.discourse-cdn.com/v4/letter/d/d2c977/32.png) [@Dariusz\_Sznura1](https://techcommunity.softwareag.com/u/Dariusz_Sznura1)\
**Post date:** [January 22, 2021, 7:59am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/10 "2021-01-22T07:59:49Z")

</div>

Hi  
In the meantime, I continued to drill down on the problem,  
and found

- in NATURAL-CE container 2 files: dbmapping.tmpl ,dbmapping.txt
- in ADABAS-CE container 1 file dbmapping.tmpl

Please read [Bash-output.txt](https://techcommunity.softwareag.com/uploads/short-url/6JEmuy8JHyNVdTN9xJ65BFlBl15.txt) (5.8 KB) Bash-output.txt  
Is this Ok , or Not

Regards

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 22, 2021, 7:59am UTC](https://techcommunity.softwareag.com/t/cant-access-to-database-from-ide-eclipse/227329/11 "2021-04-22T07:59:59Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
