AnsweredAssumed Answered

setTransactionIsolation() Function not applicable for PI SQL Data Access Server

Question asked by MARY1231 on Mar 16, 2018
Latest reply on Mar 19, 2018 by vkaufmann

Hello everyone,
i'm trying to use the pi sql jdbc driver 2012 in a hadoop environment using Sqoop.
Unfortunately i'm having this error:

 

18/03/16 16:19:54 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: setTransactionIsolation() Function not applicable for PI SQL Data Access Server

java.sql.SQLException: setTransactionIsolation() Function not applicable for PI SQL Data Access Server

at com.osisoft.jdbc.ConnectionImpl.setTransactionIsolation(ConnectionImpl.java:587)

at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:910)

at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)

at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)

at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)

at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)

at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)

at org.apache.sqoop.manager.SqlManager.getColumnTypesForQuery(SqlManager.java:253)

at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:336)

at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1858)

at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1657)

at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)

at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:494)

at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:621)

at org.apache.sqoop.Sqoop.run(Sqoop.java:147)

at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)

at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)

at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)

at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)

at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

 

 

Can someone explain me  how to solve it?

 

Thanks a lot

Outcomes