{"id":1828,"date":"2014-11-13T00:15:10","date_gmt":"2014-11-13T00:15:10","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=1828"},"modified":"2014-11-18T22:59:33","modified_gmt":"2014-11-18T22:59:33","slug":"jdbc-url-formatting","status":"publish","type":"post","link":"https:\/\/alt2.minisoft.com\/support\/jdbc-url-formatting\/","title":{"rendered":"JDBC &#8211; URL Formatting"},"content":{"rendered":"<h4>URL Formatting<\/h4>\n<p>Start with this:<\/p>\n<pre>String url;\r\n      Class c = Class.forName( \"com.minisoft.jdbc.MSJDBCDriver\" );\r\n      String hostname = \"127.0.0.1\";\r\n      String portnum = \"30504\";\r\n\r\n      url = \"jdbc:MSJDBC:\/\/\/\";      \r\n      if ( args.length &gt; 1 ) {\r\n            hostname = args[1];\r\n            if ( args.length &gt; 2 ) {\r\n                  portnum = args[2];\r\n            }\r\n            url = \"jdbc:MSJDBC:\/\/\" + hostname + \":\" + portnum + \"\/\";\r\n      }<\/pre>\n<p>Add this:<\/p>\n<pre>      Properties p = new Properties();\r\n      p.put( \"Server\", \"192.168.1.70\" );\r\n      p.put( \"ServerPort\", \"30007\" );\r\n      p.put( \"ServerType\", \"0\" );\r\n      p.put( \"User\", \"MGR\" );\r\n      p.put( \"UserPassword\", \"PASSWORD\" );\r\n      p.put( \"Account\", \"MINISOFT\" );\r\n      p.put( \"ImageDatabase0\", \"MSCARD,DO-ALL,1,5\" );\r\n      p.put( \"Group\", \"\" );\r\n      \r\n      Connection con = DriverManager.getConnection( url, p );<\/pre>\n<p>Or this:<\/p>\n<pre>      url = url+\"?\"\r\n          + \"Server=192.168.1.70&amp;\"\r\n          + \"ServerPort=30007&amp;\"\r\n          + \"ServerType=0&amp;\"\r\n          + \"User=MGR&amp;\"\r\n          + \"UserPassword=PASSWORD&amp;\"\r\n          + \"Account=MINISOFT&amp;\"\r\n          + \"ImageDatabase0=MSCARD.NEAL,DO-ALL,1,5&amp;\"\r\n          + \"Group=&amp;\";\r\n      \r\n      Connection con = DriverManager.getConnection( url );<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>URL Formatting Start with this: String url; Class c = Class.forName( &#8220;com.minisoft.jdbc.MSJDBCDriver&#8221; ); String hostname = &#8220;127.0.0.1&#8221;; String portnum = &#8220;30504&#8221;; url = &#8220;jdbc:MSJDBC:\/\/\/&#8221;; if ( args.length &gt; 1 ) { hostname = args[1]; if ( args.length &gt; 2 ) { portnum = args[2]; } url = &#8220;jdbc:MSJDBC:\/\/&#8221; + hostname + &#8220;:&#8221; + portnum + [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64,54],"tags":[],"_links":{"self":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1828"}],"collection":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=1828"}],"version-history":[{"count":3,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1828\/revisions"}],"predecessor-version":[{"id":1831,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1828\/revisions\/1831"}],"wp:attachment":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=1828"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=1828"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=1828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}