JDBC Sender adapter - can VIEW be used in Query statement

[Former Member]

Hi,

In JDBC Sender adapter, can we use a VIEW sql query in the "Query SQL Statement" placeholder?

For eg:

CREATE VIEW <view name> as SELECT * from <table name> WHERE <condition>

instead of the usual:

SELECT * from <table name> WHERE <condition>

Thanks,

Vishak

[Former Member · Accepted solution]

Hi,

If the view already exists in the Database then we can call that view from here, according to my knowledge we can't create the view from here.

[Former Member · Accepted solution]

I wanted to populate this view with the SELECT statement and then update the view with the UPDATE statement so that the actual table gets updated. This would avoid problems of more records getting updated than the actual no: of records getting selected when an INSERT step happens in the milli second between the SELECT and UPDATE statements (especially in a heavily overloaded DB).

[Former Member · Accepted solution]

Hi,

Yes you can populate the view with the SELECT statement and then update the view with the UPDATE statement so that the actual table gets updated in the Database.

[former_member193376]

Hi

What exactly is your use of creating a view, if you are going to fetch data from different tables, then you can use the view through stored procedures.

Hope this clears your doubts

Thanks

Saiyog

[Former Member]

I am not fetching data from different tables nor do I want to use a stored procedure.

I just wanted to know whether JDBC Sender adapter would allow us to use a CREATE VIEW statement instead of the usual SELECT statement.