Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

WSAD Connectivity to remote Oracle 8i db for enity ejb mapping

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am attempting to map an entity ejb to an existing table in Oracle 8i.
For this while trying to create a connection to a remote database on
Oracle using a thin driver, WebSphere Studio Application Developer is
unable to create a connection.
While making the connection it shows the following message on the
status
bar:
'loading the database metadata...'
but then it stops responding.
However, There is no problem while connecting to a local DB2 UDB.
Kindly provide a solution to this.

When making a new connection from the DBExplorer, the following
connection
settings are provided:

Connection Name: Oracon
Database : dbn002
UserID : userid
Password : password
Database Vendor Type : Oracle8i, V8.1.7
JDBC Driver : Oracle THIN JDBC DRIVER
Host : ip address
Optional Port No : 1621
Server Name : ( Non-editable Field )
JDBC Driver Class racle.jdbc.driver.OracleDriver
Class Location : D:\a020\classes12.zip

Connetion URL : jdbc racle:thin:@ipaddress:1621 bn002 (Non-editable Field)
THANKS..
Sanjay Joshi
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had similar situation. But, I waited long long time (more than 30 mts). Evenutally, it did connect. I guess your database must be an existing/old database with lots of users and db objects. I think WSAD is querying all the meta data and loads into the db viewer and it takes long time to load it.
I had tried to connect to 2 different databases. One is a test database with only 5 tables and another our existing legacy database. For the test databse, it took less than a minute to connect and for the other one it took more than 30 mts.
-- Rambo
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have the same problem trying to connect to an Oracle 8.1.6 database. It simply hangs when trying to "loading jdbc metadata...". I know my drivers are good because the connectivity works everywhere but WSAD. Any more ideas?
Thanks
 
j-two-ee
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wow, it just went through. I guess the trick is to let stay idle for about 30 minutes... even if it says "Not Responding"
 
Here. Have a potato. I grew it in my armpit. And from my other armpit, this tiny ad:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
    Bookmark Topic Watch Topic
  • New Topic