Arquivo da categoria: Banco de Dados

Link

I’m in a new personal project that involves a collection of document-oriented information. So I’ve had studying a couple of NoSQL databases to choose the best one to store the documents.
The project I’m working has a schema like a discography – artist, album, track, etc.
MongoDB was my choose. Lets play with that! 😉

This is the link to the how to documentation to install Mongo on Ubuntu:

http://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/

Anúncios

Oracle SQL Developer on Ubuntu

sqldeveloper

First of all you need to download Oracle SQL Developer here.

Now you got a file-name.rpm. You need to convert it to a file-name.deb.

You can do this using alien. If you hasn’t alien installed in your sistem, just:

$ sudo apt-get install alien

Now you can convert the file:

$ alien file-name-rpm

Once you have converted the file, you can install it:

$ sudo dpkg -i file-name.deb

Now, you can play with SQL Developer:

$ sqldeveloper 

Oracle DB Playing Tricks On Me

Earlier at work I spent one hour trying to understand why I was unable to insert some data in a table – Oracle Database.

More specifically I was trying to insert a number value (BigDecimal(100)) from a Java application, but I always got the follow error: “ORA-01438: value larger than specified precision allowed for this column”.

I thought “Ok, let’s check the column’s properties and confront that with the value I’m trying to insert…”

Continuar lendo