SIGSEGV error in JRE when connecting to the database

[koxudaxi]

SIGSEGV error in JRE when connecting to the database

[koxudaxi]

@agatim
I will check the documents!!
Thank you very much 😄

[agatim]

@koxudaxi
Hello!

If you want the column metadata you can query the table information_schema.columns (is available for Postgres and MySQL). Check the documentation:

PostgresSQL: https://www.postgresql.org/docs/9.1/infoschema-columns.html
MySQL: https://dev.mysql.com/doc/refman/8.0/en/columns-table.html

[alexisespinosa]

Hi @koxudaxi

I hit same error, is there a workaround? Saw your #69 pr but not sure if that fixes it

Thanks!

UPDATE: I just tried your change and now it works

[koxudaxi]

@Apoalex92

Thank you for creating the issue.

It seems that the problem is related to the amount of memory space reserved to the JVM, as suggested into the stacktrace it could be useful to increase it.

I will search for a method of how to increase reserved JVM memory size 👍

By the way, for further enhancement I suggest to remove the JDBC approach for connecting to database instances. Since the program is written in Python, it could be more efficient using psycopg2 o pymysql.

I agree!! But, I choice JDBC driver for actual ColumnMetadata.

I made it with pymysql to access a DB.
However, I know we need to get ColumnMetadata with includeResultMetadata.
https://docs.aws.amazon.com/rdsdataservice/latest/APIReference/API_ColumnMetadata.html
I had found the metadata came from JDBC drivers.
I had implemented it with the JDBC drivers.
If we can create ColumnMetadata from pymysql or driver on python then I change JDBC drivers to another driver on python.

Now, The code is broken to use pymysql in this app. I will fix it. Sorry.
However, ResultMetadata is not correct. the quality is a mock level.

[koxudaxi]

@alexisespinosa

Thank you for your reporting!!
It's awesome 🚀

I can't be waiting for the release of jpype 😆

[koxudaxi]

I think this problem is resolved.