uDIG

Oracle Wizard with JDBCNG

Details

  • Type: Bug Bug
  • Status: Analysis Analysis
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: UDIG 1.2.M8
  • Fix Version/s: UDIG 1.4.1
  • Component/s: database
  • Labels:
    None

Description

Oracle wizard has been updated for JDBC-NG - but does not seem to work.

Change order to database name 1st; then user / password;
1. the database name is needed before schema lookup
2. schema

Could not manage to connect.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Jody Garnett added a comment -
Also when welcome view was open the Wizard code would never exit; it was waiting for confirmation from the Map perhaps?
Show
Jody Garnett added a comment - Also when welcome view was open the Wizard code would never exit; it was waiting for confirmation from the Map perhaps?
Hide
Permalink
Jody Garnett added a comment -
Testing from Alex on udig-users...

I don't know Oracle all that well, but I should note this is Oracle Locator on 10g, not a full-blown Oracle Spatial database. Not sure if that makes a difference or not.

I downloaded & installed udig-1.2-RC1.macosx.cocoa.x86.zip, and I'm not having any success displaying Oracle data here either. It actually seems a lot worse than 1.1.1.

Here's what I've done:
- File > New > New Map
- Layer > Add
- Select 'Oracle Spatial'
- Enter connection information. I notice the wizard no longer automatically populates the list of available schema, as it did in uDig 1.1.1.
  When I enter a database name and click 'Lookup', I get a list of available schemas, but the 'Database' value I entered disappears.
- I select the correct schema, re-enter the database name, and click 'Connect', and then 'Next >'.
- I see a message telling me there are no features available, or words to that effect. This is at the same time that I'm able to view polygons from this same schema in uDig 1.1.1.

If I manually enter the name of my schema, rather than selecting it from the list, uDig hangs and becomes unresponsive when I click 'Next >'. I've left it sitting for several minutes and never seen it recover. I end up having to force quit uDig and start over.

When I repeat all the steps above, I cannot get the auto-population of schema names to work at all, even after I click the 'Lookup' button. It doesn't blank out the database name like it did last time. 'Lookup' appears to not do anything at all.

Are there log files I could capture or other ways I could help you troubleshoot this further? I wish I could give you better steps to reproduce the problem, but the behavior of the application seems quite inconsistent and hard to understand. Let me know if I can provide more information which might be helpful.
Show
Jody Garnett added a comment - Testing from Alex on udig-users... I don't know Oracle all that well, but I should note this is Oracle Locator on 10g, not a full-blown Oracle Spatial database. Not sure if that makes a difference or not. I downloaded & installed udig-1.2-RC1.macosx.cocoa.x86.zip, and I'm not having any success displaying Oracle data here either. It actually seems a lot worse than 1.1.1. Here's what I've done: - File > New > New Map - Layer > Add - Select 'Oracle Spatial' - Enter connection information. I notice the wizard no longer automatically populates the list of available schema, as it did in uDig 1.1.1.   When I enter a database name and click 'Lookup', I get a list of available schemas, but the 'Database' value I entered disappears. - I select the correct schema, re-enter the database name, and click 'Connect', and then 'Next >'. - I see a message telling me there are no features available, or words to that effect. This is at the same time that I'm able to view polygons from this same schema in uDig 1.1.1. If I manually enter the name of my schema, rather than selecting it from the list, uDig hangs and becomes unresponsive when I click 'Next >'. I've left it sitting for several minutes and never seen it recover. I end up having to force quit uDig and start over. When I repeat all the steps above, I cannot get the auto-population of schema names to work at all, even after I click the 'Lookup' button. It doesn't blank out the database name like it did last time. 'Lookup' appears to not do anything at all. Are there log files I could capture or other ways I could help you troubleshoot this further? I wish I could give you better steps to reproduce the problem, but the behavior of the application seems quite inconsistent and hard to understand. Let me know if I can provide more information which might be helpful.
Hide
Permalink
Paul Joyce added a comment -
I concur with Jody's experiences. I have seen most of the same problems on my uDig 1.2.0

1. Enter connection information; the wizard does not auto-populate the list of available schemas.
2. If you click Lookup, the list is populated, but the Database value is gone, and must be manually re-entered to continue
3. Click Next> can result in long delays before the list of tables/views is presented.

I also noticed the following:
4. If a previous uDig session has created an Oracle connection, it stays in the "Catalog" window. If you go through the wizard again (in what I thought was a brand new session), enter different values for username/password/schema/etc, you still get presented with the same list of tables from the connection in the Catalog. You have to delete the connection out of the Catalog window to get to see a different set of data.

I did eventually get some data to draw.
Show
Paul Joyce added a comment - I concur with Jody's experiences. I have seen most of the same problems on my uDig 1.2.0 1. Enter connection information; the wizard does not auto-populate the list of available schemas. 2. If you click Lookup, the list is populated, but the Database value is gone, and must be manually re-entered to continue 3. Click Next> can result in long delays before the list of tables/views is presented. I also noticed the following: 4. If a previous uDig session has created an Oracle connection, it stays in the "Catalog" window. If you go through the wizard again (in what I thought was a brand new session), enter different values for username/password/schema/etc, you still get presented with the same list of tables from the connection in the Catalog. You have to delete the connection out of the Catalog window to get to see a different set of data. I did eventually get some data to draw.

People

  • Assignee:
    Unassigned
    Reporter:
    Jody Garnett
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: