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 setup)
* hibernate.connection.username = npn6 (this was created)
* hibernate.connection.password = npn6 (this was the password assigned during creation of user)
* hibernate.connection.url = jdbc:oracle:thin:@localhost:1521/orcl.sublime.local (changed to jdbc:oracle:thin:@localhost:1521/orcl , no go)

My last resort: Called Ken D

Solution: he used “jdbc:oracle:thin://localhost:1521/orcl” for the hibernate.connection.url

—

thanks Ken D

Posted on 02.18.08 to Oracle by Julz. Tagged Oracle, URL Connection String. Subscribe to follow comments on this post. No comments yet. Add your thoughts or trackback from your own site.

• BROWSE / IN TIMELINE
• « Weird Behavior in partitioning disk
• » Eclipse: running your project via mvn jetty:run and debugging it

• BROWSE / IN Oracle
• « Dumping data to Oracle 10g via command line
• » Installing Oracle 10g in Ubuntu 7.10 (Gutsy Gibbon)