Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA: Could not execute the JDBC batch update

Accepted Solution Solved
Reply
Contributor
Posts: 54
Accepted Solution

SAS VA: Could not execute the JDBC batch update

Hi Experts,

 

Anyone here knows the "server error: could not execute JDBC batch update"? For additional information, we encountered this error when saving case statement with more than 5 statements comparison and the query validation is valid. Please find attached error and case statement.

 

 

Best Regards,

Carrot17

 

 

 

Attachment
Attachment

Accepted Solutions
Solution
‎04-18-2016 11:14 PM
Occasional Contributor EWS
Occasional Contributor
Posts: 19

Re: SAS VA: Could not execute the JDBC batch update

Hi Carrot17,

 

When your statement contains more then 1024 characters system will fail to execute the expression. Validation works fine but you vannot run the query.

 

http://support.sas.com/kb/51/510.html

 

 

 

View solution in original post


All Replies
Solution
‎04-18-2016 11:14 PM
Occasional Contributor EWS
Occasional Contributor
Posts: 19

Re: SAS VA: Could not execute the JDBC batch update

Hi Carrot17,

 

When your statement contains more then 1024 characters system will fail to execute the expression. Validation works fine but you vannot run the query.

 

http://support.sas.com/kb/51/510.html

 

 

 

Post a Question
Discussion Stats
  • 1 reply
  • 455 views
  • 1 like
  • 2 in conversation