I have a simple ruby script that uses datamapper to insert a record into a table. It was working fine for Oracle and postgresql, but I need to update a MSSQL Database, so I switched to jruby. It still works for postgresql, but I get errors on MSSQL. I'm assuming I have the url incorrect, and can find no documentation to tell me the correct url.
Thanks in advance, Danny Details about my setup follow: Here is the ruby file: require 'rubygems' require 'data_mapper' class NrmAppserverFact include DataMapper::Resource storage_names[:default] = 'dbo.nrm_appserver_fact' property :web_address, String, :key => true end def insert_web_address_fact(datamapper_url, web_address) ENV["NLS_LANG"] = "AMERICAN_AMERICA.UTF8" # for oracle DataMapper::Logger.new($stdout, :warn) DataMapper::setup(:default, datamapper_url) DataMapper::finalize NrmAppserverFact.destroy NrmAppserverFact.create(:web_address => web_address) end oracle_datamapper_url = "oracle://dhf_mirror:x@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.3.1.22)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))" postgres_datamapper_url = "postgres://vis_mirror:visionael@localhost:5432/vis_mirror" mssql_datamapper_url = "sqlserver://dhf_mirror:xxx1234XXX@10.3.1.20:1433/dhf_mirror" datamapper_url = mssql_datamapper_url address = "http://somewhere"; insert_web_address_fact(datamapper_url, address) =================================== The gems I have installed are: jruby -S gem list --local *** LOCAL GEMS *** addressable (2.2.8) bcrypt-ruby (3.0.1 java) data_mapper (1.2.0) data_objects (0.10.8) dm-aggregates (1.2.0) dm-constraints (1.2.0) dm-core (1.2.0) dm-do-adapter (1.2.0) dm-migrations (1.2.0) dm-postgres-adapter (1.2.0) dm-serializer (1.2.2) dm-sqlserver-adapter (1.2.0) dm-timestamps (1.2.0) dm-transactions (1.2.0) dm-types (1.2.2) dm-validations (1.2.0) do-jdbc_sqlserver (1.2.4 java) do_jdbc (0.10.8 java) do_postgres (0.10.8 java) do_sqlserver (0.10.8 java) fastercsv (1.5.5) jdbc-jtds (1.2.5 java) jdbc-postgres (9.1.901) json (1.7.5 java) json_pure (1.7.5) multi_json (1.3.6) rake (0.8.7) rubygems-update (1.8.24) sources (0.0.1) stringex (1.4.0) uuidtools (2.1.3) I get the following errors: jruby test.rb ~ Can't connect: jtds.sqlserver://dhf_mirror:xxx1234XXX@10.3.1.20:1433/dhf_mirror?scheme=sqlserver&user=dhf_mirror&password=xxx1234XXX&host=10.3.1.20&port=1433&path=%252Fdhf_mirror&query=&fragment=&adapter=sqlserver I/O Error: DB server closed connection. (code: , sql state: , query: , uri: ) DataObjects::SQLError: Can't connect: jtds.sqlserver://dhf_mirror:xxx1234XXX@10.3.1.20:1433/dhf_mirror?scheme=sqlserver&user=dhf_mirror&password=xxx1234XXX&host=10.3.1.20&port=1433&path=%252Fdhf_mirror&query=&fragment=&adapter=sqlserver I/O Error: DB server closed connection. (code: , sql state: , query: , uri: ) initialize at data_objects/Connection.java:198 -- You received this message because you are subscribed to the Google Groups "DataMapper" group. To view this discussion on the web visit https://groups.google.com/d/msg/datamapper/-/3NMvtzC-iBMJ. To post to this group, send email to datamapper@googlegroups.com. To unsubscribe from this group, send email to datamapper+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/datamapper?hl=en.
