private Connection GetConnectionInternal() { // load driver class string driverClassName = properties.GetProperty("driverClassName"); try { ClassLoader cl = Thread.CurrentThread().ContextClassLoader; Type.ForName(driverClassName, true, cl); } catch (ClassNotFoundException ex) { throw new RuntimeException("Error loading driver class '" + driverClassName + '\'', ex); } catch (RuntimeException ex) { throw new RuntimeException("Error loading driver class '" + driverClassName + '\'', ex); } // use driver manager to get a connection Connection connection; string url = properties.GetProperty("url"); string user = properties.GetProperty("username"); string pwd = properties.GetProperty("password"); try { connection = DriverManager.GetConnection(url, user, pwd); } catch (SQLException ex) { string detail = "SQLException: " + ex.Message + " SQLState: " + ex.SQLState + " VendorError: " + ex.ErrorCode; throw new RuntimeException("Error obtaining database connection using url '" + url + "' with detail " + detail , ex); } return(connection); }
/// <exception cref="Java.Sql.SQLException"/> internal static void Connect() { if (connection == null) { System.Diagnostics.Debug.Assert(googleNgram_dbname != null, "set googleNgram_dbname variable through the properties file"); connection = DriverManager.GetConnection("jdbc:postgresql://" + googleNgram_hostname + "/" + googleNgram_dbname, googleNgram_username, string.Empty); } }
/// <summary>Returns a connection object o the DB</summary> /// <exception cref="System.TypeLoadException"></exception> /// <exception cref="Java.Sql.SQLException"></exception> public virtual Connection GetConnection() { Sharpen.Runtime.GetType(conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration .DriverClassProperty)); if (conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration.UsernameProperty) == null) { return(DriverManager.GetConnection(conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration .UrlProperty))); } else { return(DriverManager.GetConnection(conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration .UrlProperty), conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration.UsernameProperty ), conf.Get(Org.Apache.Hadoop.Mapreduce.Lib.DB.DBConfiguration.PasswordProperty) )); } }
/// <exception cref="System.Exception"/> private void CreateConnection(string driverClassName, string url) { Sharpen.Runtime.GetType(driverClassName); connection = DriverManager.GetConnection(url); connection.SetAutoCommit(false); }
public void Connect() { Java.Sql.IConnection con = null; try { var driver = new Net.Sourceforge.Jtds.Jdbc.Driver(); String username = "******"; String password = "******"; String address = "192.168.1.101"; String port = "1433"; String database = "Database"; String connString = String.Format("jdbc:jtds:sqlserver://{0}:{1}/{2};user={3};password={4}", address, port, database, username, password); con = DriverManager.GetConnection(connString, username, password); IPreparedStatement stmt = null; try { //Prepared statement stmt = con.PrepareStatement("SELECT * FROM Users WHERE Id = ? AND Name = ?"); stmt.SetLong(1, 1); stmt.SetString(2, "John Doe"); stmt.Execute(); RunOnUiThread(() => Toast.MakeText(this, "SUCCESS!", ToastLength.Short).Show()); IResultSet rs = stmt.ResultSet; IResultSetMetaData rsmd = rs.MetaData; PrintColumnTypes.PrintColTypes(rsmd); Console.WriteLine(""); int numberOfColumns = rsmd.ColumnCount; for (int i = 1; i <= numberOfColumns; i++) { if (i > 1) { Console.Write(", "); } String columnName = rsmd.GetColumnName(i); Console.Write(columnName); } Console.WriteLine(""); while (rs.Next()) { for (int i = 1; i <= numberOfColumns; i++) { if (i > 1) { Console.Write(", "); } String columnValue = rs.GetString(i); Console.Write(columnValue); } Console.WriteLine(""); } stmt.Close(); con.Close(); } catch (Exception e) { RunOnUiThread(() => Toast.MakeText(this, e.Message, ToastLength.Long).Show()); Console.WriteLine(e.StackTrace); stmt.Close(); } con.Close(); } catch (Exception e) { Console.WriteLine(e.StackTrace); RunOnUiThread(() => Toast.MakeText(this, e.Message, ToastLength.Long).Show()); } RunOnUiThread(() => _button.Enabled = true); }
/// <exception cref="Java.Sql.SQLException"/> public static IConnection GetConnection() { //System.out.println("username is " + dbusername + " and location is " + dbLocation); return(DriverManager.GetConnection(dbLocation + "?host=" + host + "&user="******"&password="******"&characterEncoding=utf-8&" + "useUnicode=true")); }
public static void Main(string[] args) { string db_file_name_prefix = args.Length > 0 && !"-info".Equals(args[0].ToLower()) ? args[0] : "test_db"; //for now just terminate if we're invoked with the -info option if (args.Length > 0 && "-info".Equals(args[0].ToLower())) { return; } //the database connection Connection conn = null; Console.WriteLine("Success1!"); IJvmLoader loader = JvmLoader.GetJvmLoader(true, true, TraceFacility.TraceJvm, TraceLevel.TraceErrors); //loader.JvmPath = @"jvm.dll"; try { loader.JvmPath = @"C:\Program Files\Java\jdk1.8.0_161\jre\bin\server\jvm.dll"; //loader.AppendBootClassPath = "hsqldb.jar"; loader.AppendToClassPath("hsqldb.jar"); //Append your db jar: // loader.AppendToClassPath("MyHSQLDB.jar"); //Append any other Java jars needed eg: loader.AppendToClassPath("castor-0.9.3.21.jar"); IJvm jvm = loader.Load(); if (jvm != null) { Console.WriteLine("Success2!"); // put the hsqldb classes (driver) on the bootclasspath to work around a // limitation in the DriverManager when invoked from .NET //loader.AppendBootClassPath = "../lib/hsqldb.jar;../../lib/hsqldb.jar"; Console.WriteLine("Success2.1!"); Class.ForName("java.lang.String"); Console.WriteLine("Success2.5!"); Console.WriteLine("Success3!"); // make the JDBC driver available by preloading it Class.ForName("org.hsqldb.jdbcDriver"); Console.WriteLine("Success4!"); // connect to the database. This will load the db files and start the // database if it is not alread running. // db_file_name_prefix is used to open or create files that hold the state // of the db. // It can contain directory names relative to the // current working directory conn = DriverManager.GetConnection("jdbc:hsqldb:" + db_file_name_prefix, "sa", // username ""); Console.WriteLine("Success5!"); try { //Uncomment this first time run: //Update(conn, "CREATE TABLE sample_table ( id INTEGER IDENTITY, str_col VARCHAR(256), num_col INTEGER)"); //// add some rows - will create duplicates if run more then once //// the id column is automatically generated Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('Ford', 100)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('Toyota', 200)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('Honda', 300)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('GM', 400)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('BMW', 80)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('Mercedes-Benz', 60)"); Update(conn, "INSERT INTO sample_table(str_col,num_col) VALUES('VW', 800)"); } catch (SQLException sqle) { Console.WriteLine(sqle.Message); } catch (Throwable it) { Console.WriteLine(it.StackTrace); } catch (System.Exception ie) { Console.WriteLine(ie.ToString()); } Console.WriteLine("Success6!"); try { Console.WriteLine("---------------"); // do a query Query(conn, "SELECT * FROM sample_table WHERE num_col < 250"); Console.WriteLine("---------------"); // do another query //Query(conn, "SELECT str_col FROM sample_table WHERE num_col >= 100"); Console.WriteLine("---------------"); conn.Close(); } catch (Throwable t) { Console.WriteLine("Caught throwable of type {0}", t.GetClass().GetName()); Console.WriteLine(t.ToString()); return; } catch (JuggerNETFrameworkException jnfe) { Console.WriteLine("Caught framework exception"); Console.WriteLine(jnfe.Message); Console.WriteLine(jnfe.StackTrace); return; } Console.WriteLine("Success7!"); } else { Console.WriteLine("No Jvm!"); } } catch (System.Exception e) { Console.WriteLine(e.Message); } Console.WriteLine("Done!"); }