Eclipse Community Forums: Jubula » Problem while connecting to the ORACLE Database

Home » Archived » Jubula » Problem while connecting to the ORACLE Database(Exception while connecting to oracle database from jubula.)

Show: Today's Messages :: Show Polls :: Message Navigator

Problem while connecting to the ORACLE Database [message #1022273]

Thu, 21 March 2013 15:37

Yuga M

Messages: 7
Registered: October 2012

Junior Member

i installed the Oracle XE 11g release 2 and i want to use it as a database for all my test cases.

Oracle DB ---> choose "Preferences", select the "Test/Database Connections" tab and click "Add" to get the DB registration dialog. Select Oracle from the combo box and provide the necessary data for your db instance. Afterwards you can choose this connection in the "Select Database" dialog.

after following all these steps, i got exception as below.

-----------------------------------------------------------------------------------
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:SAL1
Error Code: 0
-----------------------------------------------------------------------------------
what are all the requirements do i need to follow for connecting to oracle thru jubula.

i just installed oracle and connected to database with default user name(SYSTEM) and password.

[Updated on: Fri, 22 March 2013 06:15]

Report message to a moderator

Re: Problem while connecting to the ORACLE Database [message #1022565 is a reply to message #1022273]

Fri, 22 March 2013 06:13

Yuga M

Messages: 7
Registered: October 2012

Junior Member

I myself solved this problem.
i didn't give the SID name correctly.
And for those who are facing similar kind of problem:-

in windows serives; "find item with name "oracleserivceABCD" where ABCD is ur SID. and it should be started...

And in my case; iam using oracle 11g Express edition (free Version) and my sid is "XE"

[Updated on: Fri, 22 March 2013 06:14]

Report message to a moderator

Re: Problem while connecting to the ORACLE Database [message #1022607 is a reply to message #1022565]

Fri, 22 March 2013 08:26

Alexandra Schladebeck

Messages: 1613
Registered: July 2009

Senior Member

Thanks for posting the solution Yuga!

Report message to a moderator

Re: Problem while connecting to the ORACLE Database [message #1703415 is a reply to message #1022607]

Fri, 31 July 2015 12:28

Alva Christeen

Messages: 6
Registered: December 2014

Junior Member

If your IP address and port number are good but SID is not known.
SID (System ID)- is the name of your database. SID = xe in your connection string.

Ask your DBA for SID of your database.
If you have access to the DB server, try to locate tnsnames.ora file,
it should be under $ORACLE_HOME/network/admin subdirectory (ORACLE_HOME is an environment variable pointing to the DB subdirectory),
If you have any other oracle related issue then visit:

oracle.filerepairtool.net/blog/common-oracle-error-messages

Report message to a moderator

Previous Topic:	Database Manipulation
Next Topic:	Jubula H2 Database Recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 03:06:23 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter