- This topic has 5 replies, 3 voices, and was last updated 19 years, 4 months ago by
.
-
Posts
-
Eclipse 3.1 Build id: I20050627-1435
MyEclipse Build id: 20050627-4.0-Milestone-2Using Oracle 9i thin drivers. I attempt to edit a valid connection so that it will only display selected schemas. When I try and then “Add”, it tells me it must connect to the db. Then I get a second dialog asking for my password. I tried passwords for the SYS, SYSTEM, and the user I was using in the profile – none worked. I’m never offered a chance to supply the username.
Charles –
Do you actually have the oracle driver configured already (i.e. you added the appropriate JAR files in Window -> Preferences -> MyEclipse -> Database Explorer -> Drivers)? That would be the first thing to check. Beyond that, while editing a profile, it should use whatever username you entered on the first page of the wizard. Have you tried just using the “all” or “default” schema options? Can you successfully log in that way? If so, try to re-edit the profile and see if selecting particular schema will work for you.
The oracle driver is configured and works fine.
I already have a profile setup and it works with “all”, but it takes too long to read the metadata for all the schemas.:((
And of course, I’m trying it again right now to get you more details and it works properly.
Well, it appears to have been a PEBKAC…
Sorry to have bothered you on this. 😳Quick update.
I created a new connection profile, and when I initially define the connection profile, I cannot limit the schemas. If I save it and go back to edit it, then I can limit the schemas. It looks as if when you are initially creating the connection profile, that when it attempts to make the connection to the db so you can limit the schemas that it does not properly read the username out of the first pane of the dialog.
