{"id":10108,"date":"2015-08-02T09:00:25","date_gmt":"2015-08-02T13:00:25","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/?p=10108"},"modified":"2015-08-04T10:20:10","modified_gmt":"2015-08-04T14:20:10","slug":"some-simple-utilities-for-building-oracle-and-sybase-jdbc-connections","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=10108","title":{"rendered":"Some simple utilities for building Oracle and Sybase JDBC connections"},"content":{"rendered":"<p><span class=\"\" lang=\"bn\"><span class=\"hps\">\u098f\u0987<\/span> <span class=\"hps\">\u09b8\u09be\u09a7\u09be\u09b0\u09a3<\/span> <span class=\"hps\">\u0989\u09a6\u09cd\u09a6\u09c7\u09b6\u09cd\u09af\u09c7 \u09a4\u09c8\u09b0\u09bf\u0995\u09c3\u09a4\u00a0<\/span><span class=\"hps\">\u0995\u09cb\u09a1<\/span> \u09a8\u09df <span class=\"hps\">&#8211; \u098f\u099f\u09be<\/span> <span class=\"hps\">\u0986\u09ae\u09be\u09a6\u09c7\u09b0<\/span> <span class=\"hps alt-edited\">\u09b2\u09cb\u0995\u09be\u09b2<\/span> <span class=\"hps\">\u09b8\u09c7\u099f\u0986\u09aa<\/span> \u098f\u09b0 <span class=\"hps\">\u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09aa\u09cd\u09b0\u09af\u09cb\u099c\u09cd\u09af\u0964<\/span><\/span><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre>package cwp;\r\n\r\n\/** Some simple utilities for building Oracle and Sybase\r\n\u00a0*\u00a0 JDBC connections. This is not general-purpose\r\n\u00a0*\u00a0 code -- it is specific to my local setup.\r\n\u00a0*\/\r\n\r\npublic class DriverUtilities {\r\n\u00a0 public static final int ORACLE = 1;\r\n\u00a0 public static final int SYBASE = 2;\r\n\u00a0 public static final int UNKNOWN = -1;\r\n\r\n\u00a0 \/** Build a URL in the format needed by the\r\n\u00a0\u00a0 *\u00a0 Oracle and Sybase drivers I am using.\r\n\u00a0\u00a0 *\/\r\n\u00a0 \r\n\u00a0 public static String makeURL(String host, String dbName,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 int vendor) {\r\n\u00a0\u00a0\u00a0 if (vendor == ORACLE) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(\"jdbc:oracle:thin:@\" + host + \":1521:\" + dbName);\r\n\u00a0\u00a0\u00a0 } else if (vendor == SYBASE) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(\"jdbc:sybase:Tds:\" + host\u00a0 + \":1521\" +\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \"?SERVICENAME=\" + dbName);\r\n\u00a0\u00a0\u00a0 } else {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(null);\r\n\u00a0\u00a0\u00a0 }\r\n\u00a0 }\r\n\r\n\u00a0 \/** Get the fully qualified name of a driver. *\/\r\n\u00a0 \r\n\u00a0 public static String getDriver(int vendor) {\r\n\u00a0\u00a0\u00a0 if (vendor == ORACLE) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(\"oracle.jdbc.driver.OracleDriver\");\r\n\u00a0\u00a0\u00a0 } else if (vendor == SYBASE) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(\"com.sybase.jdbc.SybDriver\");\r\n\u00a0\u00a0\u00a0 } else {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(null);\r\n\u00a0\u00a0\u00a0 }\r\n\u00a0 }\r\n\r\n\u00a0 \/** Map name to int value. *\/\r\n\r\n\u00a0 public static int getVendor(String vendorName) {\r\n\u00a0\u00a0\u00a0 if (vendorName.equalsIgnoreCase(\"oracle\")) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(ORACLE);\r\n\u00a0\u00a0\u00a0 } else if (vendorName.equalsIgnoreCase(\"sybase\")) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(SYBASE);\r\n\u00a0\u00a0\u00a0 } else {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 return(UNKNOWN);\r\n\u00a0\u00a0\u00a0 }\r\n\u00a0 }\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u098f\u0987 \u09b8\u09be\u09a7\u09be\u09b0\u09a3 \u0989\u09a6\u09cd\u09a6\u09c7\u09b6\u09cd\u09af\u09c7 \u09a4\u09c8\u09b0\u09bf\u0995\u09c3\u09a4\u00a0\u0995\u09cb\u09a1 \u09a8\u09df &#8211; \u098f\u099f\u09be \u0986\u09ae\u09be\u09a6\u09c7\u09b0 \u09b2\u09cb\u0995\u09be\u09b2 \u09b8\u09c7\u099f\u0986\u09aa \u098f\u09b0 \u0995\u09cd\u09b7\u09c7\u09a4\u09cd\u09b0\u09c7 \u09aa\u09cd\u09b0\u09af\u09cb\u099c\u09cd\u09af\u0964 &nbsp; &nbsp; package cwp; \/** Some simple utilities for building Oracle and Sybase \u00a0*\u00a0 JDBC connections. This is not general-purpose \u00a0*\u00a0 code &#8212; it is specific to my local setup. \u00a0*\/ public class DriverUtilities { \u00a0 public static final int ORACLE = &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=10108\">Continue reading<\/a><\/p>\n","protected":false},"author":130,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1417,1424],"tags":[706,1446,1448,1447],"class_list":["post-10108","post","type-post","status-publish","format-standard","hentry","category-code-programming-samples--","category-javaj2eej2me","tag-code","tag-jdbc","tag-sybase","tag-1447","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":26824,"url":"http:\/\/bangla.sitestree.com\/?p=26824","url_meta":{"origin":10108,"position":0},"title":"Some simple utilities for building Oracle and Sybase JDBC connections #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 2, 2021","format":false,"excerpt":"DriverUtilities.java Some simple utilities for building Oracle and Sybase JDBC connections. This is not general-purpose code -- it is specific to our local setup. package cwp; \/** Some simple utilities for building Oracle and Sybase * JDBC connections. This is not general-purpose * code -- it is specific to my\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26826,"url":"http:\/\/bangla.sitestree.com\/?p=26826","url_meta":{"origin":10108,"position":1},"title":"FruitCreation.java:  Creates a simple table named fruits in either an Oracle or a Sybase database. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 2, 2021","format":false,"excerpt":"FruitCreation.java Creates a simple table named fruits in either an Oracle or a Sybase database. ************************************** package cwp; import java.sql.*; \/** Creates a simple table named \"fruits\" in either * an Oracle or a Sybase database. * *\/ public class FruitCreation { public static void main(String[] args) { if (args.length\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26844,"url":"http:\/\/bangla.sitestree.com\/?p=26844","url_meta":{"origin":10108,"position":2},"title":"EmployeeTest.java:  A test case for the database utilities. Prints results in plain text. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 3, 2021","format":false,"excerpt":"package cwp; import java.sql.*; \/** Connect to Oracle or Sybase and print \"employees\" table. * *\/ public class EmployeeTest { public static void main(String[] args) { if (args.length < 5) { printUsage(); return; } String vendorName = args[4]; int vendor = DriverUtilities.getVendor(vendorName); if (vendor == DriverUtilities.UNKNOWN) { printUsage(); return; }\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26846,"url":"http:\/\/bangla.sitestree.com\/?p=26846","url_meta":{"origin":10108,"position":3},"title":"EmployeeTest2.java:  A test case for the database utilities. Prints results formatted as an HTML table. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 3, 2021","format":false,"excerpt":"package cwp; import java.sql.*; \/** Connect to Oracle or Sybase and print \"employees\" table * as an HTML table. * *\/ public class EmployeeTest2 { public static void main(String[] args) { if (args.length < 5) { printUsage(); return; } String vendorName = args[4]; int vendor = DriverUtilities.getVendor(vendorName); if (vendor ==\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26822,"url":"http:\/\/bangla.sitestree.com\/?p=26822","url_meta":{"origin":10108,"position":4},"title":"FruitTest.java:  A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the &quot;fruits&quot; table. #Programming Code Examples #Java\/J2EE\/J2ME #JDBC","author":"Author-Check- Article-or-Video","date":"May 2, 2021","format":false,"excerpt":"# FruitTest.java A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the \"fruits\" table. package cwp; import java.sql.*; \/** A JDBC example that connects to either an Oracle or * a Sybase database and prints out the values\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10106,"url":"http:\/\/bangla.sitestree.com\/?p=10106","url_meta":{"origin":10108,"position":5},"title":"FruitTest.java: A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the &#8220;fruits&#8221; table.","author":"","date":"August 2, 2015","format":false,"excerpt":"# FruitTest.java\u00a0 A class that connects to either an Oracle or a Sybase database and prints out the values of predetermined columns in the \"fruits\" table. package cwp; import java.sql.*; \/** A JDBC example that connects to either an Oracle or \u00a0*\u00a0 a Sybase database and prints out the values\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/130"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10108"}],"version-history":[{"count":6,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10108\/revisions"}],"predecessor-version":[{"id":10624,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/10108\/revisions\/10624"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10108"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}