Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How to connect H2 Database server using Parasoft SOATest

swapna0707
swapna0707 Posts: 41 ✭
in SOAtest

DB screenshot:

SOATest Screenshot:

table is not yet created in H2 database which has been created using soatest.

Kindly help me on this.

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,309 ✭✭✭
    edited January 2018

    Your connection settings look reasonable based on this:
    http://www.h2database.com/html/cheatSheet.html

    Make sure you have also added the h2.jar under Parasoft > Preferences > JDBC Drivers. A restart of the tool may also be required after doing this.

    Can you clarify what isn't working? Are you getting a particular error? Please be specific.

    table is not yet created in H2 database which has been created using soatest

    What table? Are you trying to create a table from the DB Tool or query a table? Are you saying it is created or isn't created?

  • swapna0707
    swapna0707 Posts: 41 ✭
    edited January 2018

    Hi @benken_parasoft ,
    1) I have added the h2 jar file under the parasoft- preferences-jdbc drivers- h2.jar
    2)restarted the tool
    3) I am trying to create the customer table in the H2 database.
    4)so I have used soa test dbtool to connect the h2 database and written the create table query in it
    ‭
    5) written the insert query in soa test dB tool under sql query tab to insert the data.
    6)written the select query in dB tool to face the data
    7)I am able to see the customer database table with the inserted data.
    8) but I am not able to find the customer table in the h2 database.
    Note: I am trying to connect h2 database using server mode.(tcp)
    Kindly help me on this.

    Thanks,
    Swapna

  • benken_parasoft
    benken_parasoft Posts: 1,309 ✭✭✭
    edited January 2018

    7)I am able to see the customer database table with the inserted data.
    8) but I am not able to find the customer table in the h2 database.

    Can you please elaborate? How can you see data in the customer table but also not find the customer table. What exact steps are you taking in SOAtest in step 7 and step 8?

  • swapna0707
    swapna0707 Posts: 41 ✭
    edited January 2018

    7)I have written the query in the soa test under SQL Query tab. (select * from customer)

    Note: able to see the created table(customer)
    8)written the database query in the H2 database console

    Note: I am not able to find the customer table in the h2 database console

    Thanks
    Swapna

  • benken_parasoft
    benken_parasoft Posts: 1,309 ✭✭✭

    Are you sure you are really connecting to the same data base in SOAtest and in this other client you are using? I see you using a different JDBC Connection URL in this other client. Perhaps you should try using "tcp" connection URL for both?

    Also, perhaps you need to tell this other client to refresh? In your screenshot of this other client, I think I see a refresh button in the toolbar.

Categories