Testing Oracle DB table structure with Spring-Java

Question

Im connecting to an external database wich im not able to populate with testdata to do a proper integration test suite for my DAO on. As an alternative I would like to test the structure of the tables. For example that the tables im using has columns with certain names and types. How is this possible with Java/Spring?

In Oracle SQL Developer I can use desc <tableName>; to get what I want, is there someting smilar i can do from Spring?

lance-java · Accepted Answer · 2015-06-17 08:58:47Z

1

You can use the DatabaseMetaData, see here for some inspiration (and test case here)

edited Jun 17, 2015 at 8:58

answered Jun 17, 2015 at 8:39

lance-java

29.4k6 gold badges73 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ibre5041 · Accepted Answer · 2015-06-17 08:45:58Z

0

You can also use dbms_metadata package(unless you're on XE release). This will either return DDL for a database object either as SQL script or as XML formatted string.

It's a way how SQLDeveloper reverse engineers object definitions. AFAIK you have to use database dependent approach for this.

answered Jun 17, 2015 at 8:45

ibre5041

5,3261 gold badge24 silver badges40 bronze badges

Collectives™ on Stack Overflow

Testing Oracle DB table structure with Spring-Java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related