# Edge Database connection achieved

**URL:** <https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525>\
**Category:** Ignition\
**Created:** [June 4, 2019, 2:03am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525 "2019-06-04T02:03:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![renix](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@renix](https://forum.inductiveautomation.com/u/renix)\
**Post date:** [June 4, 2019, 2:03am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/1 "2019-06-04T02:03:20Z")

</div>

I’m able to connect to the database with edge using Jython scripting. But i would like to know the reason, why ignition is not allowing database connection? Can i go ahead with this scripting method?

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [June 4, 2019, 4:31am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/2 "2019-06-04T04:31:24Z")

</div>

Can you share the script/method?

---

<div class="post-metadata">

**Author:** ![renix](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@renix](https://forum.inductiveautomation.com/u/renix)\
**Post date:** [June 4, 2019, 4:57am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/3 "2019-06-04T04:57:52Z")

</div>

from java.util import Properties  
import org.postgresql.Driver as Driver

props = Properties()  
props.put(‘user’, ‘postgres’)  
props.put(‘password’, ‘pgpass’)  
conn = Driver().connect(‘jdbc:postgresql://127.0.0.1’, props)  
st = conn.createStatement();  
rs = st.executeQuery(‘SELECT “Score” FROM public.“Employee” WHERE “SlNo” = 1’)

if (rs.next()):  
print rs.getInt(1)

rs.close()  
st.close()

---

<div class="post-metadata">

**Author:** ![renix](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@renix](https://forum.inductiveautomation.com/u/renix)\
**Post date:** [June 4, 2019, 5:25am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/4 "2019-06-04T05:25:33Z")

</div>

@zxcslo shared

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [June 4, 2019, 1:54pm UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/5 "2019-06-04T13:54:35Z")

</div>

Congrats, you found a loophole 🙂

> [@renix](#):
>
> But i would like to know the reason, why ignition is not allowing database connection?

This is an intentional restriction of functionality for Edge.

We may or may not close this loophole, use it at your own risk.

---

<div class="post-metadata">

**Author:** ![renix](https://avatars.discourse-cdn.com/v4/letter/r/958977/32.png) [@renix](https://forum.inductiveautomation.com/u/renix)\
**Post date:** [June 5, 2019, 2:28am UTC](https://forum.inductiveautomation.com/t/edge-database-connection-achieved/25525/6 "2019-06-05T02:28:41Z")

</div>

@Kevin.Herron Thank you… 🙂