February 18th, 2008

Dive into the archives.


  • Oracle Hibernate URL Connection String

    Bout: jdbc:oracle:thin:@localhost:1521/orcl vs jdbc:oracle:thin://localhost:1521/orcl
    Story:
    1. Checked out the project
    2. set parameters for the DB connection
    3. built it and attempted to run it.
    Problem: The app wouldn’t run.
    Attempts to solve:Checked parameters of database-c3p0.properties
    * system.connection.username=system (able to use this in the sqlplus)
    * system.connection.password=password (this was the password assigned during […]

  • Weird Behavior in partitioning disk

    I have this old partitioning designed for Ubuntu 6.06 (Dapper)
    partition 1 NTFS my windows partition
    partition 2 FAT32 for writing files that would be accessible for both windows and linux
    partition 3 is my Ubuntu partition
    since Gutsy Gibbon does write in NTFS i had to remove FAT and expand my NTFS
    the queer thing was, when i booted […]

  • Dumping data to Oracle 10g via command line

    Assuming you have already created the DB user, see http://blogs.exist.com/jcutaran/2008/02/18/creating-a-user-in-oracle-10g-through-command-line/
    1. Log into a command console with the oracle user
    > su - oracle
    2. execute the command template below
    imp userid= fromuser= toUser= file= log= compile=y commit=y
    example:
    > imp userid=system/password fromuser=NPN6 toUser=NPN6 file=~/version1.dmp log=~/imp.log compile=y commit=y
    some notes:
    userid - refers to […]

  • Creating a user in Oracle 10g through command line

    Assuming Oracle is installed and running…
    1. Log into a command console with the oracle user.
    > su - oracle
    2. Creat a file and place the text below.
    drop user npn6 cascade;
    create user npn6 identified by npn6;
    grant resource, connect, create view to npn6;
    commit;
    3. log into sqlplus to run the file you created
    >sqlplus / […]