I want to retrieve and store data into table, the table exists in the blackboard . How can i create jsp page for get and post data.
I'd suggest taking a look at the DAO sample that Scott Hurrey has put together and posted on Gitub - GitHub - blackboard/BBDN-Schema-Sample: Sample code illustrating how to use Schema.xml and Spring Annotations to interac…
I've used this model successfully for a few projects.
we would like to access to qti_asi_data and to load data value in this table.
Data is stored in BLOB format in Oracle. We are trying many type of object to get this field like byte, String, oracle.sql.BLOB, etc. but always when we try to load data an exception occured. Used type: Blob <==> Exception: exception Entry has an unsupported field type
Used type : String <==> Exception: Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
What adequate data type we can use in java?
Thanks for your reply.
I have table and schema which is created in blackboard when we install our building block. I want to know that is there is any way through which these table and schema get deleted from blackboard when we uninstall or delete the building block.
In my experience, no, the tables are not removed when you uninstall the building block. This is consistent with the fact that any props files are also not removed when you uninstall as well. You would need to manually drop those tables from the database.
You can use the bb-manifest provided mechanism:
<!-- These two JSPs are displayed when the "remove" and "properties" buttons -->
<!-- are pressed on the Building Blocks administration page. -->
it will execute the admin/remove.jsp when uninstalling the B2
Can i write code to delete table which will be execute before every time we uninstall the building block. is it possible ? If yes then how can i do it.
Retrieving data ...