# Error occurred checking if resource \[our\_table\] exists

**URL:** <https://discourse.hibernate.org/t/error-occurred-checking-if-resource-our-table-exists/1120>\
**Category:** Hibernate ORM\
**Created:** [July 26, 2018, 1:52pm UTC](https://discourse.hibernate.org/t/error-occurred-checking-if-resource-our-table-exists/1120 "2018-07-26T13:52:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tharpa](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@tharpa](https://discourse.hibernate.org/u/tharpa)\
**Post date:** [July 26, 2018, 1:52pm UTC](https://discourse.hibernate.org/t/error-occurred-checking-if-resource-our-table-exists/1120/1 "2018-07-26T13:52:48Z")

</div>

I have a two-part question. Answers to either part would be helpful.

I am getting an error

```auto
  SchemaManager: Error occurred checking if resource [cluster_lock] exists
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection

```

at the line

```auto
List<?> queryResult = txTemplate
                .execute(new TransactionCallback<List<?>>() {
                    @Override
                    public List<?> doInTransaction(TransactionStatus status) {
                        String replaced = COLONS.matcher(sql)
                                .replaceAll(COLON_REPLACEMENT);
                        SQLQuery query = getCurrentSession()
                                .createSQLQuery(replaced);
                        addParamsToQuery(query, paramMap);
                        query.setMaxResults(maxRowCount);
                        return query.list();
                    }

```

So my questions are:

1. How do I find the information that is normally in the connect string: Host, etc.

2. Otherwise, how do I find the cause of the problem?

The same code is working fine for others here.

---

<div class="post-metadata">

**Author:** ![vlad](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/vlad/32/658_2.png) [@vlad](https://discourse.hibernate.org/u/vlad)\
**Post date:** [July 26, 2018, 2:28pm UTC](https://discourse.hibernate.org/t/error-occurred-checking-if-resource-our-table-exists/1120/2 "2018-07-26T14:28:34Z")

</div>

Just debug the execution and inspect the SQLException. There is going to be a cause or a more detailed info there.

If it works for others, maybe you have network connectivity issues due to either faulty drivers or hardware or due to VPN, Proxies, Anti Virus, etc