(Josh Robinson) I’m starting to dig into Entity Framework 4 as part of a project that I am working on. It is great, much easier than the old school data access methods in terms of getting up and running (it takes about 3 minutes). There are a lot of articles out there, but I have still had to figu
Other News
Dividing ASP.NET MVC Components in Separate Projects
(Nandip Makwana) Whenever we create new ASP.NET MVC 3 project, it follow pre defined directory convention and adds few files and directory to the project. However it is not compulsory to follow this default directory structure, but it help us to keep application clean & maintainable by grouping appl
How to use the DB2 Governor to force off long idle connections
(Ember Crooks) Ok, so the DB2 Governor is deprecated with 9.7. But it’s only replacement is a pay-for-use tool – the workload manager. So I imagine I’ll be writing a script to do the very basic things that I do with the DB2 Governor when it’s gone.
Prompted SQL DDL Creation
(Sam Lennon) IBM i developers are becoming more comfortable exploiting the power of SQL to retrieve and manipulate data. We regularly use the workhorse SELECT, UPDATE, and DELETE statements and can bang them out quickly with minimal syntax errors. Defining tables, indexes, constraints, and the like
Using Jython servlets with WebSphere Application Server for more than system administration
(Brian S Paskin) It is common for developers to use Jython scripting in IBM WebSphere Application Server to perform system management tasks, but with some simple additions, it is easy to add Jython processing to supplement your servlet and JSP application programming.
How to Delete Data from Database Using XML Web Service
(Akshay Teotia) In this article I am going to make a XML Web service that updates data into a Default table of the application. For the basics of XML Web Service read my last article.
Reader Interaction
Reader Interaction In the editorial today we have interesting responses from our readers on the topics of Cloud Integration and Accidental DBA. Cloud Integration Frank: first thanks for your ongoing insights via SSWUG. Last was about cloud integration. One solution to integrate SQL (and other on premise applications) with the cloud is data replication. What do you think about this […]
Semantic Information – Part 1
(Prakash B) Roslyn provides a mechanism by which you can get semantic information that the compiler has about the source code. This blog post explains how you can get the semantic information for certain kinds of syntax nodes and what types of semantic information is provided by Roslyn.
LOAD DATA INFILE to resolve locks
(Jonathan Levin) In relation to this MPB post, there is a command to output data into a file and then to load it back into MySQL to resolve locks. (An example of a really big reporting query that could be quite heavy, can be found here.)
How to call af:query search button programmatically
(Rodrigues, Raphael) First of all, I have to describe my use case: