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
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
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
posted 17 years ago
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: