How to configure Jargon to use MySQL?

[Felipe Gutierrez]

Hello,

How do I configure my Java App to use Jargon with MySQL?

I am doing a query that is not working from my app:

org.irods.jargon.core.exception.CatalogSQLException: Catalog SQL error
 at org.irods.jargon.core.connection.IRODSErrorScanner.checkSpecificCodesAndThrowIfExceptionLocated(IRODSErrorScanner.java:190)

and at the iRODS log shows it is using ILIKE (postgreSQL) instead of LIKE (MySQL).

Feb  1 06:33:40 pid:15712 NOTICE: SQL Error message: [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.34]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON USER_GROUP_MAIN.user_id = R_USER_GROUP.group_user_id JOIN R_OBJT_ACCESS ON R_' at line 1
Feb  1 06:33:40 pid:15712 NOTICE: chlSpecificQuery cmlGetFirstRowFromSql failure -806000
Feb  1 06:33:40 pid:15712 NOTICE: _rsSpecificQuery: specificQuery status = -806000
Feb  1 06:33:40 pid:15712 NOTICE: rsSpecificQuery: rcSpecificQuery failed, status = -806000
Feb  1 06:33:44 pid:15712 NOTICE: bindVar[1]=/tempZone/home/rods/%
Feb  1 06:33:44 pid:15712 NOTICE: bindVar[2]=/tempZone/home/rodsFeb  1 06:33:44 pid:15712 NOTICE: cllExecSqlWithResult: SQLExecDirect error: -1, sql:WITH searchMatchForCollections AS ( select   c.coll_id,  c.coll_name,  c.parent_coll_name,  c.coll_owner_name,  c.coll_owner_zone,  c.coll_inheritance,  c.coll_type,  c.r_comment,  c.create_ts,  c.modify_ts from   R_COLL_MAIN c where   c.coll_name ILIKE ?    and   c.parent_coll_name = ? ) SELECT COUNT(*) FROM searchMatchForCollections

Thank you,

Felipe

[Terrell Russell]

Did you get this working, Felipe?

Terrell

--
--
"iRODS: the Integrated Rule-Oriented Data-management System; A community driven, open source, data grid software solution" https://www.irods.org
 
iROD-Chat: http://groups.google.com/group/iROD-Chat

---
You received this message because you are subscribed to the Google Groups "iRODS-Chat" group.
To unsubscribe from this group and stop receiving emails from it, send an email to irod-chat+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Felipe Gutierrez]

Hi Terrell,

I became a collaborator of Metalnx-web and did a fork on this project to my github. The problem was the query for PostgreSQL, so I created the queries for MySQL and it worked. Metalnx-web also released a new version to use SSL+PAM. But I still need time to test it and merge the code.

Regards,

Felipe

To unsubscribe from this group and stop receiving emails from it, send an email to irod-chat+...@googlegroups.com.

[Terrell Russell]

No worries.  Thank you.   Just wanted to make sure we hadn't left you without a solution.

Terrell

To unsubscribe from this group and stop receiving emails from it, send an email to irod-chat+unsubscribe@googlegroups.com.