Weird Interaction with IBMDBPY

[GraemeHutcheon]

If I import brunel and things from IBMDBPY in the same cell when I access the routine in IBMDBPY is complain that it cannot find the DB2 drivers.
If I do not include brunel and rerun it works.
Seems like brunel is doing something which as a side effect on IBMDBPY.

import numpy as np
import pandas as pd
from ibmdbpy.base import IdaDataBase
import brunel

db=IdaDataBase(dsn=DATABASE, uid=USER, pwd=PASSWORD)

Will cause unable to find driver error but

import numpy as np
import pandas as pd
from ibmdbpy.base import IdaDataBase
# import brunel

db=IdaDataBase(dsn=DATABASE, uid=USER, pwd=PASSWORD)

will work

[danrope]

Interesting. This may be because both packages use JPype to work with Java and each requires different .jars. To help confirm, can you try to put the brunel import after the database is actually loaded and let me know you whether you have the opposite problem (brunel not working, IBMDBPY working). Thx.

[danrope]

It is likely the only solution to this is to manually start the JVM using JPype and include the required .jar files for all products BEFORE importing brunel or the other package.