Hi,
I managed to get things working on SQL Server 2008. The database part of config.xml looks like below and I have attached two SQL scripts to create and fill the database.
main-db
jeeves.resources.dbms.DbmsPool
geonetworkuser
geonetworkpwd!
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://WIN-KF3T7TL0B3S;database=GeoNetwork;integratedSecurity=false;
10
WIN-KF3T7TL0B3S is the name of my server/instance and GeoNetwork an empty database I created for this purpose.
I simply took the MySQL scripts and changed three things:
-
Change datatype longtext to text
-
Change TUNCATE to DELETE FROM (TRUNCATE TABLE worked poorly with relationships)
-
Change the three inserts below to use apostrophe around the last value, thereby inserting as a text, not a number
INSERT INTO Settings VALUES (701,700,‘mdmode’,‘1’);
INSERT INTO Settings VALUES (702,700,‘tokentimeout’,‘3600’);
INSERT INTO Settings VALUES (703,700,‘cachesize’,‘60’);
Please, also note information from Jose below. You need to download Microsoft SQL Server JDBC Driver 3.0 and copy the files sqljdbc.jar and sqljdbc4.jar to the lib directory.
Question: Are there any form of automated tests I can run to verify that everything really works okay now?
Regards,
Mikael
Mikael Elmquist
Regionchef
Göteborg
Telefon direkt 031-62 76 63
Mobil 070-605 01 61
Telefax 031-62 77 22
mikael.elmquist@anonymised.com
|
Sweco Position AB
Gullbergs Strandgata 3
Box 2203
403 14 Göteborg
Telefon 031-62 75 00
www.sweco.se
|
|
Please consider the environment before printing my e-mail.
Från: jose garcia [mailto:josegar74@anonymised.com]
Skickat: den 29 september 2010 22:54
Till: Elmquist Mikael
Kopia: geonetwork-users@lists.sourceforge.net
Ämne: Re: [GeoNetwork-users] Configure GeoNetwork against SQL Server
Hi
Never tried GeoNetwork with SqlServer, but in http://msdn.microsoft.com/en-us/library/ms378428.aspx there’s some useful information about the connection url format. Should be similar to:
main-db
jeeves.resources.dbms.DbmsPool
USER
PASSWORD
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://SERVER;database=DBNAME;integratedSecurity=true;
10
3600
</resource>
You’ll need to add sqlserver jdbc driver in lib folder of GeoNetwork as not provided by GeoNetwork.
Also if using 2.4.X you’ll need to adapt one of the create db scripts in gast/setup/sql for SQLServer and execute it manually to setup the database.
If using 2.6, you have to check the setup db scripts in web/geonetwork/WEB-INF/classes/setup/sql/create and the data files in web/geonetwork/WEB-INF/classes/setup/data
Hope you success in the configuration. Should be nice if you provide later the custom sql scripts, so we can include in next versions of GeoNetwork to support SqlServer.
Regards,
Jose Garcia
On Wed, Sep 29, 2010 at 6:36 PM, Elmquist Mikael <Mikael.Elmquist@anonymised.com> wrote:
Does anyone have any sample of how the database configuration shall look to work with SQL Server 2008? See below for sample using mySQL.
main-db
jeeves.resources.dbms.DbmsPool
admin
admin
com.mysql.jdbc.Driver
jdbc:mysql://$WEBSERVER_HOST/geonetwork
10
3600
Regards,
Mikael
Mikael Elmquist
Regionchef
Göteborg
Telefon direkt 031-62 76 63
Mobil 070-605 01 61
Telefax 031-62 77 22
mikael.elmquist@anonymised.com
Sweco Position AB
Gullbergs Strandgata 3
Box 2203
403 14 Göteborg
Telefon 031-62 75 00
www.sweco.se<http://www.sweco.se>
[cid:image001.png@anonymised.com]
[cid:image002.png@anonymised.com]Please consider the environment before printing my e-mail.
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
(attachments)
create-db-sqlserver.sql (6.7 KB)
data-db-sqlserver.sql (417 KB)