Good morning Isomorphic,
I am having a datasource related issue. See below for details.
Version
GWT v2.4
SmartGWT 3.1d EE, (full version is SNAPSHOT_v8.3d_2012-07-23/PowerEdition Deployment (built 2012-07-23) )
Browser: IE9
Environment: Eclipse Indigo
Java 1.7
Informix v11.50
Problem
I have to call a sequence of stored procedures, one of which writes to my_temp_table.
I then need to fetch the data from my_temp_table.
However, I am not able to do any fetches from my_temp_table.
The error that appears is the following:
"The specified table (my_temp_table) is not in the database."
There is another application that is being used (not a webapp). By using POJC (Plain Old Java Code) I am able to use a java.sql.connection to the database and using this connection I can do the following:
Execute java.sql.CallableStatements which will cause the sequence of stored procedures in our database to execute.
Fetch from my_temp_table which is now visible to me in this scenario because all of the database interaction, calling the stored procedures and fetching from my_temp_table are done on the same connection.
DS in Question
There are two operations that are being used in the DS.
Add1
This calls a stored procedure (myProcedure()), which does the same thing as add2 below.
Add2
This uses CDATA to create a temporary table (my_temp_table), and then selects data from my_temp_table
Both operations throw the same exception:
“The specified table (my_temp_table) is not in the database.”
My Questions are:
1) How can I do the same thing that the POJC does using a SmartGwt datasource?
2) Why can’t the SmartGwt DS that I have defined above, fetch data from the my_temp_table?
The datasource (myTestDS) is included below as follows:
Any feedback would be greatly appreciated in this matter. Thank you for your assistance.
I am having a datasource related issue. See below for details.
Version
GWT v2.4
SmartGWT 3.1d EE, (full version is SNAPSHOT_v8.3d_2012-07-23/PowerEdition Deployment (built 2012-07-23) )
Browser: IE9
Environment: Eclipse Indigo
Java 1.7
Informix v11.50
Problem
I have to call a sequence of stored procedures, one of which writes to my_temp_table.
I then need to fetch the data from my_temp_table.
However, I am not able to do any fetches from my_temp_table.
The error that appears is the following:
"The specified table (my_temp_table) is not in the database."
There is another application that is being used (not a webapp). By using POJC (Plain Old Java Code) I am able to use a java.sql.connection to the database and using this connection I can do the following:
Execute java.sql.CallableStatements which will cause the sequence of stored procedures in our database to execute.
Fetch from my_temp_table which is now visible to me in this scenario because all of the database interaction, calling the stored procedures and fetching from my_temp_table are done on the same connection.
DS in Question
There are two operations that are being used in the DS.
Add1
This calls a stored procedure (myProcedure()), which does the same thing as add2 below.
Add2
This uses CDATA to create a temporary table (my_temp_table), and then selects data from my_temp_table
Both operations throw the same exception:
“The specified table (my_temp_table) is not in the database.”
My Questions are:
1) How can I do the same thing that the POJC does using a SmartGwt datasource?
2) Why can’t the SmartGwt DS that I have defined above, fetch data from the my_temp_table?
The datasource (myTestDS) is included below as follows:
Code:
<DataSource ID="myTestDS"
serverType="sql"
tableName="myTable">
<fields>
<field name="myNumber" nativeName="my_nbr" type="long" hidden="true" primaryKey="true" >
<customSelectExpression>
myTable.my_nbr
</customSelectExpression>
</field>
</fields>
<operationBindings>
<operationBinding operationType="add" operationId="add1"
<customSQL>
<![CDATA[
execute procedure myProcedure();
]]>
<!-- call myProcedure(); -->
<!-- execute procedure myProcedure(); -->
</customSQL>
</operationBinding>
<operationBinding operationType="add" operationId="add2"
<customSQL>
<![CDATA[
SELECT myTable.my_nbr FROM myTable
INTO TEMP my_temp_table;
SELECT * FROM my_temp_table;
]]>
</customSQL>
</operationBinding>
</operationBindings>
</DataSource>
Comment