Feature #400

Add support for Oracle

Added by Andy Dufilie over 5 years ago. Updated over 5 years ago.

Status:ResolvedStart date:08/18/2011
Priority:ImmediateDue date:
Assignee:YenFu Luo% Done:

0%

Category:Admin Console and Servlets
Target version:1.0
Complexity:Medium OIC Priority:
Required by:Grand Rapids, Michigan

error_msg.png (19.1 KB) Chris Stefanich, 09/21/2011 01:18 PM


Related issues

Related to Weave - Feature #520: Add support for SQLite Resolved 09/14/2011
Related to Weave - Feature #147: Support Microsoft SQL Server Resolved 07/01/2011

History

#1 Updated by Andy Dufilie over 5 years ago

  • Assignee set to YenFu Luo

#2 Updated by Andy Dufilie over 5 years ago

  • Description updated (diff)

#3 Updated by Andy Dufilie over 5 years ago

  • Required by set to Grand Rapids, Michigan

#4 Updated by YenFu Luo over 5 years ago

  • Status changed from Open to Needs Merge

#5 Updated by Andy Dufilie over 5 years ago

  • Priority changed from Normal to High

#6 Updated by Andy Dufilie over 5 years ago

  • Priority changed from High to Immediate

#7 Updated by Andy Dufilie over 5 years ago

  • Status changed from Needs Merge to Resolved

#8 Updated by Chris Stefanich over 5 years ago

I am receiving an error when trying to set up an oracle database connection.

The connection named "weaveOracle" was not created because the server could not connect to the specified database with the given parameters.; nested exception is:
java.rmi.RemoteException: Unable to connect to SQL database; nested exception is:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

The username and password are correct, I am able to connect through SQLExplorer in Eclipse.

#9 Updated by Andy Dufilie over 5 years ago

The server log should show the connect string that it tried to use. Could you take a look at that and make sure the connect string is correct?

#10 Updated by Chris Stefanich over 5 years ago

It looks correct:

jdbc:oracle:thin:our_user_name/our_correct_password@//correct.database.url:1521/ourdbname

#11 Updated by YenFu Luo over 5 years ago

The connection string is correct.
Could you download and use the driver that matches the version of your Oracle Server?
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

#12 Updated by YenFu Luo over 5 years ago

The following link shows all TNS error message and action.(Search for 12514)
http://download.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90202/tnsus.htm#ERRMG301

#13 Updated by Andy Dufilie over 5 years ago

  • Target version set to 1.0

Also available in: Atom PDF