[InterMine Dev] Error trying to use Hikari datasource

Steven Neuhauser Steven.Neuhauser at jax.org
Tue Jul 29 17:37:38 BST 2014


This seems to have resolved itself after I set maxConnections to lower values?

db.production.datasource.maxConnections=20   (was 50)
db.common-tgt-items.datasource.maxConnections=5  (was 10)



From: dev-bounces at intermine.org [mailto:dev-bounces at intermine.org] On Behalf Of Steven Neuhauser
Sent: Tuesday, July 29, 2014 10:07 AM
To: dev at intermine.org
Subject: [InterMine Dev] Error trying to use Hikari datasource

Hi Folks,

I merged with the beta branch and made the following changes to my default.intermine.integrate.properties to use Hikari.

-db.production.datasource.class=org.postgresql.ds.PGPoolingDataSource
+db.production.datasource.class=com.zaxxer.hikari.HikariDataSource
+db.production.datasource.dataSourceClassName=org.postgresql.ds.PGSimpleDataSource


-db.common-tgt-items.datasource.class=org.postgresql.ds.PGPoolingDataSource
+db.common-tgt-items.datasource.class=com.zaxxer.hikari.HikariDataSource
+db.common-tgt-items.datasource.dataSourceClassName=org.postgresql.ds.PGSimpleDataSource

I get the following error:

Caused by: java.lang.IllegalArgumentException: ObjectStore 'os.common-translated-std' not found in properties
        at org.intermine.objectstore.fastcollections.ObjectStoreFastCollectionsForTranslatorImpl.getInstance(ObjectStoreFastCollectionsForTranslatorImpl.java:101)
        ... 37 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.intermine.objectstore.ObjectStoreFactory.getObjectStore(ObjectStoreFactory.java:61)
        at org.intermine.objectstore.fastcollections.ObjectStoreFastCollectionsForTranslatorImpl.getInstance(ObjectStoreFastCollectionsForTranslatorImpl.java:94)
        ... 37 more
Caused by: java.lang.IllegalArgumentException: Unable to get sub-ObjectStore for Translating ObjectStore (check properties file)
        at org.intermine.objectstore.translating.ObjectStoreTranslatingImpl.getInstance(ObjectStoreTranslatingImpl.java:86)
        ... 43 more


If I revert the changes it works....
Am I missing some additional configs for Hikari?

Thanks,
Steve


The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.

The information in this email, including attachments, may be confidential and is intended solely for the addressee(s). If you believe you received this email by mistake, please notify the sender by return email as soon as possible.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.intermine.org/pipermail/dev/attachments/20140729/83dc3172/attachment.html>


More information about the dev mailing list