[GeoNetwork-devel] Sql Server DB Support

Hi all,

Has anybody managed to get this working fully with SqlServer 2005/8?

I have created the Schema and database. Used both the Sqlserver and jTDS
drivers (type 4) and I have managed to start the application.

The issue I am getting is that it appears to be generating a lock in the
database with the default transaction level being serializable. This seems
to focus on the update of popularity and / or rating. I am aware that this
is probably not an issue with GeoNetworks, but wondered if anybody has had
simular issues or has go 2.4.2 working with SqlServer?

Thanks

R.
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4906224.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

Hi Rod,

No experience with SqlServer - however I was planning to reduce the transaction level to read_committed for all databases as serializable seems a little too conservative - however I didn't get around to doing this (no time to test for any complications). That said, I changed the transaction level to read_committed for Oracle sometime ago as serializable was definitely causing problems in Oracle 10g. So if your problem is the transaction level then look into the connect method of jeeves/src/jeeves/resources/dbms/Dbms.java.

Cheers,
Simon
________________________
From: rodhiggins [roderick.higgins@anonymised.com]
Sent: Thursday, 15 April 2010 6:30 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: [GeoNetwork-devel] Sql Server DB Support

Hi all,

Has anybody managed to get this working fully with SqlServer 2005/8?

I have created the Schema and database. Used both the Sqlserver and jTDS
drivers (type 4) and I have managed to start the application.

The issue I am getting is that it appears to be generating a lock in the
database with the default transaction level being serializable. This seems
to focus on the update of popularity and / or rating. I am aware that this
is probably not an issue with GeoNetworks, but wondered if anybody has had
simular issues or has go 2.4.2 working with SqlServer?

Thanks

R.
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4906224.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.

_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Thanks Simon,

I will change it and let you know the result.

Thanks
Rod.
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4907321.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

Thanks Simon,

I made the changes to Jeeves (set Transaction to Read committed and even to
read_uncommitted) and it still errors when trying to update the popularity
on the metadata. It locks the table and the connection pool holds the
connection open. Evenetually this pool fills up and locks the application.

I am currently looking into it a bit deeper, but if anyone else has got this
to work with SQL Server 2008, I would be interested.

Regards

Rod
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4936046.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

Hi Rod,

I think you mentioned you were running 2.4.2 - maybe this has nothing to do with sqlserver and you are being tripped by a fix that came after 2.4.2? Check that the actual db connection is being closed in src/org/fao/geonet/services/metadata/Show.java - the last line of the run method in the IncreasePopularityTask class should be:

context.getResourceManager().close();

ie. explicitly close the dbms resource (this is done by jeeves for services but not for threads like this).

This is fixed in 2.4.3 - see http://geonetwork.svn.sourceforge.net/viewvc/geonetwork/branches/2.4.x/src/org/fao/geonet/services/metadata/Show.java?view=markup

Cheers,
Simon
________________________________________
From: rodhiggins [roderick.higgins@anonymised.com]
Sent: Wednesday, 21 April 2010 7:59 PM
To: geonetwork-devel@lists.sourceforge.net
Subject: Re: [GeoNetwork-devel] Sql Server DB Support

Thanks Simon,

I made the changes to Jeeves (set Transaction to Read committed and even to
read_uncommitted) and it still errors when trying to update the popularity
on the metadata. It locks the table and the connection pool holds the
connection open. Evenetually this pool fills up and locks the application.

I am currently looking into it a bit deeper, but if anyone else has got this
to work with SQL Server 2008, I would be interested.

Regards

Rod
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4936046.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.

------------------------------------------------------------------------------
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net

GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Simon,

Thanks, I have given this a try and it appears you are right. .

As this is fixed in 4.2.3 there appears to be no point in progressing it,
however, perhaps support for SQLServer via jTDS might be included at some
point in the future.

Thanks again

Rod
--
View this message in context: http://n2.nabble.com/Sql-Server-DB-Support-tp4906224p4936783.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.