jaydebeapi icon indicating copy to clipboard operation
jaydebeapi copied to clipboard

Allow arguments to pass extra JVM arguments ?

Open ikus060 opened this issue 5 years ago • 3 comments

For H2DB, I need to pass extra arguments to the JVM to define the default timezone of the database: -Duser.timezone="America/Toronto" Looking at the code, I don't see a proper way to pass this arguments to the JVM. Would it be possible to add an optional parameters to the connect(). Something like jvm_args ?

ikus060 avatar Jul 10 '20 19:07 ikus060

Hi @ikus060, I agree. There is #116 but it needs some polishing. Further on I'm not sure whether it would be even nicer to have a more general jvm_args param and additionally a jvm_properties param to allow for providing a python dict with the Java system properties like this

jaydebeapi.connect(.... jvm_args="-Xbla", jvm_properties={"user.timezone":"America/Toronto"})

baztian avatar Jul 15 '20 07:07 baztian

@baztian #116 Is what I was looking for. But at the same time, I see it's would not be possible to connect to different database with different arguments. For the look of it, I would need to start different instance of jpype for each database. I'm not sure jaydebeapi is supporting this usecase.

ikus060 avatar Jul 15 '20 12:07 ikus060

This would be nice to have indeed. Is anyone working/looking at #116 at all?

dschiavu avatar Mar 04 '22 11:03 dschiavu