Re: [udig-devel] [udig-users] SQL Server connection bug [SEC=UNCLASSIFIE

[andrea antonello <andrea.antonello@xxxxxxxxx>]

Hi Steve,

directing this in the developer's list, since there you might find more help. Let's discuss this there.

 

I think the SQLServerDataStoreFactory class in Geotools has a problem. This might explain why I cannot connect to the DB from uDig.

 

(1) The test class org.geotools.data.sqlserver.SQLServerTestSetup has the line:

 

fixture.put("password", "geotools");

 

It should be :

 

fixture.put("passwd", "geotools");

 

I’m trying to find where this param is set inside udig to see if it’s wrong there as well.

That is a good question. In fact I assume you are using the SQL Server connection as of Import->Datastore->Microsoft SQL Server

Right?

That means that the proper connection classes are extracted from geotools and you will not find any SQLServerDataStoreFactory 

written anywhere.

But you might be able to catch some exception that maybe isn't being trapped.

The plugin you are looking for is (Jody please jump in) net.refractions.udig.catalog.geotools

which handles all the geotools supported datasets, supplying an autogenerated gui.

So if you debug after the connection is done, you might be able to catch something.

I am in a real rush,so tale the following with caution :)

I guess the gui is built in: net.refractions.udig.catalog.geotools.data.DataStoreParameterPage

There is an internal class that tests for the connection: net.refractions.udig.catalog.geotools.data.DataStoreParameterPage.TestConnection

That might be a good place to lurk with a breakpoint.

Hope that get's you a bit further.

Good luck,

Andrea

 

 

 

 

Stephen Cameron

Antarctic Fisheries Computing and Database Support Provider

Australian Antarctic Division

Kingston, Tasmania

 

Phone: 03 62323571

 

___________________________________________________________________________

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
        Visit our web site at http://www.antarctica.gov.au/
___________________________________________________________________________

_______________________________________________
udig-users mailing list
udig-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.refractions.net/mailman/listinfo/udig-users