Tag Archives: oracle

OutSystems – Java / WebLogic related bugs

      No Comments on OutSystems – Java / WebLogic related bugs

Installing, configuring and working with the OutSystems platform on an Oracle stack (Orcle linux, Oracle WebLogic and Oracle database) made me run into some bugs. This posts lists some of the problems/bugs I ran into. #1 – Using non-suggested installation paths and users To install the OutSystems platform server, OutSystems created an installation checklist for the .NET and Java stacks…. Read more »

OutSystems – Use of comments in Advanced Queries

      No Comments on OutSystems – Use of comments in Advanced Queries

I was creating an advanced query (see post OutSystems – Getting Database Information) for the DBCleaner application to display table space usage. When I executed the query in OutSystems Service Studio using the “Test” button, it gave a (the expected) result, so publish the application an go! Publishing the application went fine, but when I went to the page with… Read more »

OutSystems – Getting Database Information

      No Comments on OutSystems – Getting Database Information

In this post I will provide some queries that you can use to get information on the OutSystems schemas in an Oracle database.   List inactive (unused) entity tables It is pretty simple to get a list of all inactive entity (unused – the entity got removed from OutSystems) database tables. SELECT esp.name ESPACE, ent.name ENTITY, ent.physical_table_name TABLE_NAME FROM osadmin.ossys_espace… Read more »

OutSystems – Adding/Changing/Deleting Entities and Entity Attributes – Database Implications

Running into an “Database Upgrade Error” on publishing and application after I changed the length of an existing entity attribute, gave me some insight into how the OutSystems platform handles changes on entities and entity attributes. In this post I want to give an overview of the implications on the database used by OutSystems, whenever you work (add, change, delete) with… Read more »