[QPID-7974] JdbcUtils.TableExists is very slow on big databases such as Oracle

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: qpid-java-6.1.4
• Fix Version/s: qpid-java-broker-7.0.0, qpid-java-6.1.5
• Component/s: Broker-J
• Assignee: Robert Godfrey
• Reporter: Adel Boutros
• Created: 18/Oct/17 10:29
• Updated: 14/Nov/17 21:59
• Resolved: 19/Oct/17 13:15

Description

The problem is that JdbcUtils.tableExists will actually load all tables and then iterate to find the correct one. On Oracle, this can be around 40 000 tables. So it will take 12 minutes for the broker to start.

Issue Links

• links to: GitHub Pull Request #3