uDIG

Oracle spatial resources inactive

Details

  • Type: Bug Bug
  • Status: Analysis Analysis
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: UDIG 1.1.RC1
  • Fix Version/s: UDIG 1.4.1
  • Component/s: database
  • Labels:
    None
  • Environment:
    Windows XP SP2, JRE 1.5, RCP 3.1.2 Oracle10

Description

Cannot add Oracle 10 spatial as a data source. Use of Oracle enterprise manager console confirms two
map layers. Maps are viewable from Oracle console. Especially annoying is that the completion of the data for Oracle connection (e.g. Host, username, password, database) returns no messages like can not connect to Oracle spatial server or missing JDBC driver, etc). Resource selection screen is blank. JDBC driver installed and working.

  1. Java Source File
    DataBaseRegistryWizardPage.java
    29/Jun/09 3:51 AM
    60 kB
    rahul kumar
  2. Java Source File
    OracleGeoResource.java
    29/Jun/09 3:51 AM
    8 kB
    rahul kumar
  1. oracle spatial.JPG
    46 kB
    29/Jun/09 3:51 AM
  2. oracle spatial error 1.2M5.JPG
    155 kB
    17/Jun/09 2:13 AM

Activity

Ascending order - Click to sort in descending order
Cory Horner made changes -
Field Original Value New Value
Fix Version/s UDIG 1.1.RC2 [ 12628 ]
Assignee Jody Garnett [ jgarnett ]
Fix Version/s UDIG 1.1.RC1 [ 12347 ]
Jesse Eichar made changes -
Fix Version/s UDIG 1.1.RC2 [ 12628 ]
Fix Version/s udig 1.1.RC4 [ 12704 ]
Cory Horner made changes -
Fix Version/s UDIG 1.2 [ 11975 ]
Fix Version/s UDIG 1.1.RC5 [ 12704 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.1.2 [ 14910 ]
Fix Version/s UDIG 1.2.M1 [ 11975 ]
Jody Garnett made changes -
Component/s oracle [ 11374 ]
Component/s database [ 11361 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.M4 [ 15071 ]
Ben Walding made changes -
Workflow jira [ 57955 ] udig [ 107556 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.M4 [ 15071 ]
Fix Version/s UDIG 1.2.M5 [ 15119 ]
rahul kumar made changes -
Attachment oracle spatial error 1.2M5.JPG [ 42653 ]
rahul kumar made changes -
Status Open [ 1 ] Analysis [ 10002 ]
rahul kumar made changes -
Attachment oracle spatial.JPG [ 42855 ]
Attachment DataBaseRegistryWizardPage.java [ 42857 ]
Attachment OracleGeoResource.java [ 42856 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.M6 [ 15474 ]
Fix Version/s UDIG 1.2.M5 [ 15119 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.M7 [ 15476 ]
Fix Version/s UDIG 1.2.M6 [ 15474 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.1.2 [ 14910 ]
Fix Version/s UDIG 1.2.M9 [ 16115 ]
Fix Version/s UDIG 1.2.M7 [ 15476 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.M9 [ 16115 ]
Fix Version/s UDIG 1.2.RC [ 16163 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.RC [ 16163 ]
Fix Version/s UDIG 1.2.0 [ 16264 ]
Jody Garnett made changes -
Comment [ From Alex Dean via email ...

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. ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.1 [ 16440 ]
Fix Version/s UDIG 1.2.0 [ 16264 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.x [ 15072 ]
Fix Version/s UDIG 1.2.1 [ 16440 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.3 [ 17485 ]
Fix Version/s UDIG 1.2.2 [ 15072 ]
Jody Garnett made changes -
Fix Version/s uDig 1.3.0 [ 17860 ]
Fix Version/s UDIG 1.2.3 [ 17485 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.2.3 [ 17485 ]
Fix Version/s uDig 1.3.0 [ 17860 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.3.1 [ 18149 ]
Fix Version/s UDIG 1.3.0 [ 17485 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.3.2 [ 18235 ]
Fix Version/s UDIG 1.3.1 [ 18149 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.3.3 [ 18773 ]
Fix Version/s UDIG 1.3.2 [ 18235 ]
Jody Garnett made changes -
Fix Version/s UDIG 1.4.1 [ 19165 ]
Fix Version/s UDIG 1.4.0 [ 18773 ]

People

  • Assignee:
    Unassigned
    Reporter:
    Jeffrey C Bernard
Vote (2)
Watch (2)

Dates

  • Created:
    Updated: