jdbc

A Rust library that allows you to use JDBC and JDBC drivers.

Usage

First, add the following to your Cargo.toml:

[dependencies]
jdbc = "0.1"

Next, add this to your crate root:

extern crate jdbc;

Then you can in your main function do something like this:

let jvm_options = ["-Djava.class.path=./jars/postgresql-42.1.1.jar", "-Xcheck:jni"];
let _ = unsafe { jvm::JVM::from_options(&jvm_options) };

let url = "jdbc:postgresql://localhost/test";

let connection = DriverManager::get_connection(url).unwrap();
let statement = connection.create_statement().unwrap();
let result_set = statement.execute_query("SELECT * FROM customers").unwrap();
let metadata = result_set.get_meta_data().unwrap();
let columns = metadata.get_column_count().unwrap();

while result_set.next().unwrap() {
  print!("row:");
  for i in 1 .. columns + 1 {
    print!(" {:?}", result_set.get_string(i).unwrap());
  }
  println!("");
}

What is jdbc?

The primary purpose of this crate is to allow you to use Java JDBC database drivers from Rust in a convenient way with a relatively safe interface. It does this via embedding a JVM in your process so be aware that if you use JNI in some other way in your app you will need to tell jdbc to play nice.

Platforms

I am testing on my Mac, but I would love to setup some CI to get this party started.

Contributing

Patches are welcome, don't forget to add yourself to the Authors list.

Authors

Aurora <@rawrasaur, [email protected]>

Safe Rust --- GraalVM Polyglot bindings using procedural macros

The class macro is the primary way to generate bindings to Java types; it will generate a struct (with generics if specified) that implements Pass and Receive and has all the methods you give stubs for. The methods generated can be used like normal rust methods, however mutability is not enforced. The fully-qualified type name should precede a block containing method and constructor stubs. Java primitives like char, int, and byte are aliased to corresponding Rust types.

33 Dec 28, 2022

Comments

Overlap with Rucaja

Hi,

i've noticed that you've written similar code in order to instantiate and use the JVM as i've had in Rucaja for Tinkerpop-rs.

Maybe there is code/best practises to be shared. It would be especially interesting to come up with a type-safe but ergonomic API.

opened by kud1ing 7
rust-jdbc/jvm are not currently on crates.io and example doesn't link jvm

Both rust-jdbc and rust-jvm are not on the crates.io repo. I currently can build both using rust nightly "cargo +nightly build". BUT when I try to build the provided example source, I get cc linker error -ljvm not found. I tried to point it to the java sdk's libjvm.so but it still fails to link and I have not successfully run any examples with your rust-jdbc yet.

Thank you for listening.

opened by omac777 0
What is performance like?

I made a java Jetty server daemon to expose SELECT/UPDATE/DELETE/INSERT operations of a JDBC driver.

I'd be curious how performance with HTTP + JSON serialization/deserialization overhead would compare to this.

opened by brandonros 0