Oracle - HOUSE of CODE

Transaction trouble with Cache

Consider the following problem: We have a web app which can send messages between the users that are connected to it. A user can send a message to any number of users. The implementation is simple: When a user sends a message The message

Debug

DTC Error while running integreation testing

In one bright day, our integration tests in the build server started to fail randomly. Each test that failed showed this message: > ORA-02049: timeout: distributed transaction waiting for lock These were integration tests on our database (Oracle database). Each of these tests

st_geometry

st_geometry configuration

In st_geometry overview [https://blog.house-of-code.com/st-geometry-overview] I gone over some important issues concerning st_geometry. You saw all kind of cool things you can do in simple SQL queries. In order to use these queries you need

st_geometry

st_geometry overview

How does st_geometry works? st_geometry is a user defined type of the Oracle database. A user defined type in Oracle is like a class definition in .Net. It allows you to create a type with properties and methods. It also supports inheritance,

st_geometry

st_geometry introduction

In the last couple of months we have been using the new st_geometry type of the ArcSDE geodatabase. st_geometry allows us to use simple queries in order to retrieve and manipulate geographic data in a database. For example: SELECT * FROM buildings b

SDE

Geographic Database Migration - The solution

A long time ago I presented a problem: How can you migrate from Oracle 9i with SDE 9.1 to Oracle 10g with SDE 9.2 [https://blog.house-of-code.com/geographic-database-migration-the-problem]. After a long time I have found

ESRI

Geographic Database Migration - The problem

I would like to present a problem I had when it was decided that our GIS application needed a new version of the geographic database. Let me explain: Our geographic database includes two components: Oracle database: version 9i ESRI's SDE component: version