Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java and oracle 11g connectivity

Ashish ParabJun 22 2014 — edited Oct 15 2014

i created java front end and i will be using oracle 11 g database.

for connectivity i use jdbc-odbc bridge.

for that i need to create oracle dsn(data source name).

but after creating dsn when i test the connection it throws an exception" ora 12154 tns could resolve.......".

how to go about it?

also please explain type 4 driver. that is pure java driver using socket programming ..

Comments

thatJeffSmith-Oracle
Answer

Sorry, this forum space isn't for EM Express or 12c-specific questions, it's for the Oracle SQL Developer IDE/GUI

Marked as Answer by 2662756 · Sep 27 2020
2662756

Thanks!, let me go to the correct forum

unknown-7404

Repost in the Multitenant forum and see my reply dated Apr 22, 2014 3:54 PM in this thread:

https://community.oracle.com/thread/3550674

Oracle 12c uses a NEW, and different, multitenant architecture. That requires that certain, basic operations (e.g. creating users, connecting) are done DIFFERENTLY.

If you want to avoid the RTFM responses that might be coming your way read jump the gun on them by reading chapters 17 and 18 in the Database Concepts doc. Those chapters, and my reply in that thread, will answer your question.

http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 21 2014
Added on Jun 22 2014
#11g, #connection, #database, #database-connectivity-discussions, #java, #jdbc
6 comments
508 views