| private AddAllJarsClassPath ( string directory ) : void | ||
| directory | string | |
| return | void | |
private static void Main(string[] args)
{
try
{
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
bridgeSetup.IgnoreJavaHome = true;
//bridgeSetup.Verbose = true;
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(Date).Assembly);
Bridge.RegisterAssembly(typeof(KnowledgeBaseFactory).Assembly);
Bridge.RegisterAssembly(typeof(TypedCashflow_).Assembly);
Example1();
Example2();
Example3();
Example4();
Example5();
Example6();
}
catch(System.Exception ex)
{
Console.WriteLine(ex);
}
}
static void Main(string[] args)
{
try
{
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(SimpleMySQLDriver).Assembly);
ISimpleMySQLDriver driver = new SimpleMySQLDriver();
String query = "";
String driver_name = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:5510/sakila";
String username = "******";
String password = "******";
query = "SELECT * FROM sakila.actor WHERE last_name LIKE 'B%'";
String results = driver.QueryResultSetAsString(driver_name, url, username, password, query);
//Console.Write(results);
Debug.WriteLine(results);
//String last_name = String.Format("Smith{0}", DateTime.Now.Ticks.ToString());
//query = String.Format("INSERT INTO sakila.actor (first_name, last_name) VALUES ('John', '{0}')", last_name);
//driver.RunStaticQuery(query);
}
catch (System.Exception ex)
{
Console.WriteLine("***Error in Main(): " + ex.Message);
}
}
/// <summary>
/// Start this from directory \samples\samples\fop\
/// with \samples\lib populated with jni4net.j.jar and jni4net.n.dll
/// and with \samples\samples\fop\lib populated with FOP jar files.
/// </summary>
private static void Main()
{
FixStartupDirectory();
// automaticaly setup Java classpath to find jni4net.j
var setup = new BridgeSetup(true);
// setup Java classpath to find FOP libraries
setup.AddAllJarsClassPath("lib");
// we don't need to call back from Java
setup.BindStatic = false;
// now we create JVM and bind jni4net core
Bridge.CreateJVM(setup);
// now we bind all proxies of FOP objects
// which are compiled in this assembly
Bridge.RegisterAssembly(typeof (Program).Assembly);
const string inFileName = "data/jni4net.fo";
const string outFileName = "data/jni4net.pdf";
//Below is just plain Copy&Paste of FOP basic sample java code
OutputStream output = null;
try
{
// Step 1: Construct a FopFactory
// (reuse if you plan to render multiple documents!)
FopFactory fopFactory = FopFactory.newInstance();
// Step 2: Set up output stream.
output = new BufferedOutputStream(new FileOutputStream(new File(outFileName)));
// Step 3: Construct fop with desired output format
Fop fop = fopFactory.newFop(MimeConstants_.MIME_PDF, output);
// Step 4: Setup JAXP using identity transformer
TransformerFactory factory = TransformerFactory.newInstance();
Transformer transformer = factory.newTransformer(); // identity transformer
// Step 5: Setup input and output for XSLT transformation
// Setup input stream
Source src = new StreamSource(new File(inFileName));
// Resulting SAX events (the generated FO) must be piped through to FOP
Result res = new SAXResult(fop.getDefaultHandler());
// Step 6: Start XSLT transformation and FOP processing
transformer.transform(src, res);
}
finally
{
// Clean-up
if (output != null)
{
output.close();
}
}
}
public static void Init(string robocodeHome)
{
BridgeSetup bridgeSetup = new BridgeSetup();
bridgeSetup.BindStatic = true;
bridgeSetup.BindNative = true;
bridgeSetup.AddAllJarsClassPath(Path.Combine(robocodeHome, "libs"));
Bridge.CreateJVM(bridgeSetup);
Bridge.LoadAndRegisterAssemblyByName(typeof(RobocodeEngine).Assembly.FullName);
//Bridge.Setup.BindNative = true;
Bridge.Setup.BindStatic = true;
}
public static void Main(string[] arsg)
{
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(DemoCalc).Assembly);
ICalc calc = new DemoCalc();
int result = calc.MySuperSmartFunctionIDontHaveInJava("Answer to the Ultimate Question of Life, the Universe, and Everything");
Console.WriteLine("Answer to the Ultimate Question is : " + result);
}
public static IMojoHiveDriver CreateCustomDriver(String drivername)
{
IMojoHiveDriver driver = null;
try
{
String local_path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
_logger.LogMsg(log4net.Core.Level.Debug, "Connector program folder: " + local_path);
_logger.LogMsg(log4net.Core.Level.Debug, "Creating .NET-Java bridge.");
var bridgeSetup = new BridgeSetup();
// The local_path is the folder where the connector EXE itself is located.
bridgeSetup.AddAllJarsClassPath(local_path);
// Check to see if a specific folder has been configured as the location for the current driver.
// If so, load all JARs in that folder.
String driver_folder = "";
Boolean found_the_folder = false;
try
{
if (Properties.Settings.Default.Drivers.Contains(drivername))
{
int driver_index = Properties.Settings.Default.Drivers.IndexOf(drivername);
if (Properties.Settings.Default.DriverLocations.Count > driver_index)
{
driver_folder = Properties.Settings.Default.DriverLocations[driver_index];
// First assume the folder is a full path, check if it exists.
if (Directory.Exists(driver_folder)) found_the_folder = true;
else
{
// Try to append to the driver folder to the current local EXE path as a sub-folder.
driver_folder = Path.Combine(local_path, driver_folder);
if (Directory.Exists(driver_folder)) found_the_folder = true;
}
// Always try to add the folder if it exists.
if (found_the_folder)
{
bridgeSetup.AddAllJarsClassPath(driver_folder);
}
}
}
}
catch (Exception ex)
{
_logger.LogMsg(Level.Warn, String.Format("Error adding custom driver folder [{0}] to Java CLASSPATH: {1}.", driver_folder, ex.Message));
}
_logger.LogMsg(log4net.Core.Level.Debug, "Creating Java virtual machine (JVM).");
Bridge.CreateJVM(bridgeSetup);
_logger.LogMsg(log4net.Core.Level.Debug, "Registering custom driver assembly with .NET-Java bridge.");
Bridge.RegisterAssembly(typeof(MojoHiveDriver).Assembly);
_logger.LogMsg(log4net.Core.Level.Debug, "Creating custom driver proxy for .NET.");
driver = new MojoHiveDriver();
}
catch (System.Exception ex)
{
_logger.LogMsg(log4net.Core.Level.Error, "Error creating MojoHiveDriver proxy: " + ex.Message);
}
return driver;
}
/// <summary>
///
/// </summary>
internal bool Start(bool alwaysStart)
{
if (!alwaysStart && !CheckCurrent()) return false;
UpdateMenuState(DebuggerState.Starting);
// load JVM.. only once
if (!jvm_up)
{
try
{
BridgeSetup bridgeSetup = null;
bridgeSetup = new BridgeSetup();
string flexSDKPath = null;
if (currentProject != null) flexSDKPath = currentProject.CurrentSDK;
else flexSDKPath = PluginCore.Helpers.PathHelper.ResolvePath(PluginBase.MainForm.ProcessArgString("$(FlexSDK)"));
if (flexSDKPath != null && Directory.Exists(flexSDKPath))
{
Dictionary<string, string> jvmConfig = JvmConfigHelper.ReadConfig(flexSDKPath);
String javaHome = JvmConfigHelper.GetJavaHome(jvmConfig, flexSDKPath);
if (!String.IsNullOrEmpty(javaHome)) bridgeSetup.JavaHome = javaHome;
}
bridgeSetup.AddAllJarsClassPath(PluginCore.Helpers.PathHelper.PluginDir);
bridgeSetup.AddAllJarsClassPath(Path.Combine(PluginCore.Helpers.PathHelper.ToolDir, @"flexlibs\lib"));
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(IProgress).Assembly); // ??
Bridge.RegisterAssembly(typeof(Bootstrap).Assembly);
jvm_up = true;
}
catch (Exception ex)
{
String msg = "Debugger startup error. For troubleshooting see: http://www.flashdevelop.org/wikidocs/index.php?title=F.A.Q\n";
TraceManager.Add(msg + "Error details: " + ex.ToString());
return false;
}
}
PluginBase.MainForm.ProgressBar.Visible = true;
PluginBase.MainForm.ProgressLabel.Visible = true;
PluginBase.MainForm.ProgressLabel.Text = TextHelper.GetString("Info.WaitingForPlayer");
if (bgWorker == null || !bgWorker.IsBusy)
{
// only run a debugger if one is not already runnin - need to redesign core to support multiple debugging instances
// other option: detach old worker, wait for it to exit and start new one
bgWorker = new BackgroundWorker();
bgWorker.DoWork += bgWorker_DoWork;
bgWorker.RunWorkerAsync();
}
return true;
}
static void Main(string[] args)
{
try
{
String xml_results = "<Results><Row><billtocode>3DAKE</billtocode><billtodesc>l@K(>ur(ZCxbt</billtodesc><billtoeffdt>2009-10-18 00:00:00</billtoeffdt><billtoexpdt>2011-07-04 00:00:00</billtoexpdt></Row><Row><billtocode>3DAKE</billtocode><billtodesc>l@K(>ur(ZCxbt</billtodesc><billtoeffdt>2009-10-18 00:00:00</billtoeffdt><billtoexpdt>2011-07-04 00:00:00</billtoexpdt></Row></Results>";
System.Xml.XmlDocument doc = new XmlDocument();
doc.LoadXml(xml_results);
XmlNode root = doc.FirstChild;
if (root.HasChildNodes)
{
// These are row nodes
//for (int i = 0; i < root.ChildNodes.Count; i++)
//{
// Debug.WriteLine(root.ChildNodes[i].Name);
// for (int ii = 0; ii < root.ChildNodes[i].ChildNodes.Count; ii++)
// {
// Debug.WriteLine(root.ChildNodes[i].ChildNodes[ii].Name);
// }
//}
foreach (XmlNode row_node in root.ChildNodes)
{
Debug.WriteLine(row_node.Name);
foreach (XmlNode field_node in row_node.ChildNodes)
{
Debug.WriteLine(field_node.Name + " = " + field_node.InnerText);
}
}
}
String local_path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
bridgeSetup.AddAllJarsClassPath(local_path);
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(MojoHiveDriver).Assembly);
String drivername = "org.apache.hive.jdbc.HiveDriver";
String url = "jdbc:hive2://54.218.97.70:21050/;auth=noSasl";
String username = "";
String password = "";
String queuename = "";
IMojoHiveDriver driver = new MojoHiveDriver();
int result = driver.TestConnection(drivername, url, queuename, username, password);
Console.WriteLine("Connection successful.");
String sql = "SELECT * FROM billtocodes WHERE billtocode LIKE '3D%'";
String xml = driver.QueryResultSetAsXML(drivername, url, queuename, username, password, sql);
Console.WriteLine("Results\r\n" + xml);
}
catch (System.Exception ex)
{
Console.WriteLine("***Error in Main(): " + ex.Message);
}
}
public void QuandoOCalculoDePosicaoECalculado()
{
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
bridgeSetup.IgnoreJavaHome = true;
// Workaround: https://jira.talendforge.org/browse/TUP-477
bridgeSetup.AddJVMOption("-Ddrools.dialect.java.compiler.lnglevel", "1.6");
//bridgeSetup.Verbose = true;
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(Date).Assembly);
Bridge.RegisterAssembly(typeof(KnowledgeBaseFactory).Assembly);
Bridge.RegisterAssembly(typeof(TypedCashflow_).Assembly);
var fatos = new List<Object>();
// Eventos
foreach (var evento in ScenarioContext.Current.Get<List<Evento>>("EVENTOS"))
{
fatos.Add(Bridge.WrapCLR(evento));
}
// Escalas.
foreach (var escala in ScenarioContext.Current.Get<List<Escala>>("ESCALAS"))
{
fatos.Add(Bridge.WrapCLR(escala));
}
var ksession = new RuleRunner().runRules(new string[] { "RegraPosicao.drl" }, fatos.ToArray());
var objetos = ksession.getObjects();
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Resultado Final:");
Console.WriteLine();
var eventosComOcorrencia = new List<Evento>();
foreach (var objeto in objetos.toArray())
{
Console.WriteLine(objeto.toString());
try
{
var objetoCrl = Bridge.UnwrapCLR<Evento>(objeto);
if (objetoCrl != null)
{
eventosComOcorrencia.Add(objetoCrl);
}
}
catch (InvalidCastException)
{
}
}
ScenarioContext.Current.Add("EVENTOS_COM_OCORRENCIA", eventosComOcorrencia);
}
private static void Main(string[] args)
{
try
{
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
bridgeSetup.IgnoreJavaHome = true;
// Workaround: https://jira.talendforge.org/browse/TUP-477
bridgeSetup.AddJVMOption("-Ddrools.dialect.java.compiler.lnglevel", "1.6");
//bridgeSetup.Verbose = true;
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(Date).Assembly);
Bridge.RegisterAssembly(typeof(KnowledgeBaseFactory).Assembly);
Bridge.RegisterAssembly(typeof(TypedCashflow_).Assembly);
//Example1();
//Example2();
//Example3();
//Example4();
//Example5();
//Example6();
RegraPosicao();
}
catch(System.Exception ex)
{
Console.WriteLine(ex);
}
}
private IEnumerable<QvxDataRow> GetBillToCodes()
{
String tableName = "BillToCodes";
String xml_results = "";
try
{
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "GetBillToCodes()");
_logger.LogMsg(log4net.Core.Level.Info, "Enter callback function GetBillToCodes()");
// DEBUGGING: try to connect to named pipe from here.
//Program.RunNamedPipeHandler(Program._parentWindowHandle, Program._commandQueue, _logger);
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, String.Format("GetEvents(log: {0}, tableName: {1})", log, tableName));
// TO DO: put this back in?
//VerifyCredentials();
// TO DO: put in basic validation of query ?
//if (!EventLog.Exists(log))
//{
// throw new QvxPleaseSendReplyException(QvxResult.QVX_TABLE_NOT_FOUND,
// String.Format("There is no EventLog with name: {0}", tableName));
//}
// Run the query, get a dataset in XML ?
// Get the path to the executing program so we can add it to the Java CLASSPATH.
String local_path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location );
_logger.LogMsg(log4net.Core.Level.Info, "Working folder: " + local_path);
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "Opening DotNet-Java bridge.");
_logger.LogMsg(log4net.Core.Level.Info, "Opening DotNet-Java bridge.");
var bridgeSetup = new BridgeSetup();
bridgeSetup.AddAllJarsClassPath(".");
bridgeSetup.AddAllJarsClassPath(local_path);
Bridge.CreateJVM(bridgeSetup);
Bridge.RegisterAssembly(typeof(MojoHiveDriver).Assembly);
String drivername = "org.apache.hive.jdbc.HiveDriver";
String url = "jdbc:hive2://54.218.97.70:21050/;auth=noSasl";
String username = "";
String password = "";
String queuename = "";
// *** Create the Java proxy class
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "Creating MojoHiveDriver proxy.");
_logger.LogMsg(log4net.Core.Level.Info, "Creating MojoHiveDriver proxy.");
IMojoHiveDriver driver = new MojoHiveDriver();
// *** Test Cloudera connection
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, String.Format("Testing connection: driver={0} | url={1} | queuename={2} | username={3} | password={4}.", drivername, url, queuename, username, password));
_logger.LogMsg(log4net.Core.Level.Info, String.Format("Testing connection: driver={0} | url={1} | queuename={2} | username={3} | password={4}.", drivername, url, queuename, username, password));
int result = driver.TestConnection(drivername, url, queuename, username, password);
if (result == 0)
{
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "Connection successful.");
_logger.LogMsg(log4net.Core.Level.Info, "Connection successful.");
}
else
{
//QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "Connection failed: " + driver.GetLastExceptionMessage());
_logger.LogMsg(log4net.Core.Level.Info, "Connection failed: " + driver.GetLastExceptionMessage());
}
// *** Run an actual query
//TO DO: get this from QlikView ? Must use named pipes?
//String sql = "SELECT * FROM billtocodes WHERE billtocode='3DAKE'";
//String sql = "SELECT * FROM billtocodes WHERE billtocode LIKE '4P%'";
String sql = "SELECT * FROM billtocodes WHERE billtoeffdt > '2008-02-01 00:00:00' AND billtoeffdt < '2008-02-28 00:00:00'";
_logger.LogMsg(log4net.Core.Level.Info, "Running query: " + sql);
xml_results = driver.QueryResultSetAsXML(drivername, url, queuename, username, password, sql);
//_logger.LogMsg(log4net.Core.Level.Info, "XML results:\r\n" + xml_results);
}
catch (System.Exception ex)
{
_logger.LogMsg(log4net.Core.Level.Error, "Fatal exception: " + ex.Message);
}
_logger.LogMsg(log4net.Core.Level.Info, "Loading XML into parser." + xml_results);
System.Xml.XmlDocument doc = new XmlDocument();
doc.LoadXml(xml_results);
XmlNode root = doc.FirstChild;
if (root.HasChildNodes)
{
_logger.LogMsg(log4net.Core.Level.Info, String.Format("Query returned {0} rows.", root.ChildNodes.Count.ToString()));
_logger.LogMsg(log4net.Core.Level.Info, "Moving data from XML to QlikView objects." + xml_results);
foreach (XmlNode row_node in root.ChildNodes)
{
//Debug.WriteLine(row_node.Name);
yield return MakeEntry(row_node, FindTable(tableName, MTables));
//foreach (XmlNode field_node in row_node.ChildNodes)
//{
// Debug.WriteLine(field_node.Name + " = " + field_node.InnerText);
//}
}
}
else
{
_logger.LogMsg(log4net.Core.Level.Warn, "No rows returned!" + xml_results);
}
}