After some years without using Neo4j I had the chance to use the graph database in my current project. Neo4j was a good fit because it makes it really easy to prototype an idea and the project itself relies heavily upon tree structures. Modelling tree structures in relational database management Read more…
CMDBuild supports the usage of SQL queries inside the “filter” options if the type is a REFERENCE. Given: A lookup table named “Software Type” [{Code: DBMS}, {Code: App}] A class Application [{Code: MySQL, Type: DBMS}, {Code: PostgreSQL, Type: DBMS}, {Code: Tomcat, Type: App}]; “Type” references the lookup table “Software Type” Read more…
I am currently playing around with ASP.NET and its Entity Framework. At some point I wanted to execute all my migrations against a new local SQL Express database. After I had dropped the database in SQL Management Studio, the Update-Database command of the Entity Framework failed with the error “Database ‘$path.mdf’ Read more…
Recently I struggled upon the same problem, this guy described. Our Oracle database instance contains multiple schematics with almost the same structure. Every developer has it’s own schema for unit and integration tests. On application startup the Hibernate schema validator calls the DatabaseMetaData.getTables() for every linked entity. The method returns the first Read more…
Today I had to move the WSUS internal database to one of our backend database servers. Microsoft has a good instruction how to do this, nevertheless I ran into a problem. Microsoft SQL Server 2008 did not allow me to add the machine account of our WSUS frontend server (let Read more…
One of the most annoying things I get in touch with software development beside the question How can I format this date is How can I put my database under version control? If you have not already read K. Scott Allens Database series, do it now. At first follow his Read more…
Seit letzter Woche habe ich mich mit einem äußerst ominösen Problem beschäftigt: Ich habe für einen Kunden ein Import-Script geschrieben, das aus mehreren Text-Dateien die Daten in eine MS SQL Server 2005-Datenbank importiert. Bei unseren Tests hier in der Firma funktionierte alles wunderbar, es gab keine UTF-8- oder sonstigen Zeichensatz-Probleme Read more…
Ich frickel momentan an der Umstellung meines Blogs und damit steht auch die Umstellung von ISO-8859-1 auf UTF-8 auf dem Plan. Damit alles wunderbar funktioniert, hier die Vorgehensweise für eine MySQL 5-Datenbank: In PDT/ZS als Encoding des Projekts UTF-8 auswählen und Projekt neu builden lassen. Eventuell noch einmal mit Notepad++ Read more…
Marc is currently writing the complementary work for his apprenticeship as “Fachinformatiker Anwendungsentwicklung”. His work deals with generating BIRT reports using a Microsoft SQL Server 2005 Express as database backend. Using the Microsoft JDBC is not as easy as it should be: First you have to download the latest Microsoft Read more…