How to track errors in JDBC log? Dont see log

Hello 

Facing problems with inserting data using JDBC

Have errors like 

org.apache.spark.SparkException: Job aborted due to stage failure: Task 0 in stage 14.0 failed 4 times, most recent failure: Lost task 0.3 in stage 14.0 (TID 109, domain_name, executor 9): java.sql.SQLException: [JDBC42ClientDSII]null
at com.simba.client.dataengine.SCResults.next(Unknown Source)
at com.simba.client.dataengine.SCResults.next(Unknown Source)
at com.simba.jdbc.common.SStatement$BatchExecutionContext.collectUpdateCounts(Unknown Source)
at com.simba.jdbc.common.SStatement$BatchExecutionContext.doProcess(Unknown Source)
at com.simba.jdbc.common.SStatement$BatchExecutionContext.processInt(Unknown Source)
at com.simba.jdbc.common.SStatement.processBatchResults(Unknown Source)
at com.simba.jdbc.common.SPreparedStatement.executeBatch(Unknown Source)

Tried turn on LOG but don't see log files. What is the format of JDBC LOG FILES?

To turn LOGING ON - used JDBC settings from DOCs

jdbc:simba://IP:12345;DATABASE=DB;SCHEMA=SH;LogLevel=5;LogPath=/usr/local/scaligent/logs 

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Is this log for Server Side? Or for client side?

    In doc i see "current working directory of the SimbaClient." (1)

    AND

    Logs are stored on ThoughtSpot.(2)

     

    Second question

    Example in docs:

    jdbc:simba://192.168.2.248:12345;SERVERS=192.168.2.249:12345,
     192.168.2.247:12345;Database=test;Schema=falcon_default_schema;**LogLevel=3;LogPath=/usr/local/scaligent/logs**

     

    Do i need to put "**"? 

    Looks weird

    Reply Like
  • you need not specify **. 

    here is an example of my connect string I use in Python
     

    "jdbc:simba://10.85.76.156:12345;LoginTimeout=5;DATABASE=jdbcexample;SCHEMA=falcon_default_schema;LogLevel=5;LogPath=/Users/rajesh.ravindran/myDummyProjs"
    Reply Like
  • Thanks - but is it a LOCAL path on client side?

    Reply Like
  • Aleksei Burenin Yes it is a local path on the client side. 

    Reply Like 1
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 4Replies
  • 12Views
  • 2 Following