Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
SuiteAnalytics Connect JDBC Driver - Failed to retrieve data
Context:
I'm build a pipeline to extract the data from Netsuite to our database. I'm connecting to SuiteAnalytics Connector with JDBC (by Python).
The list table include some large tables (transaction ~ 3 million records). So, I tried to execute the query (select * from transaction) and keep the ResultSet.
After that, I have a loop to retrieve the data from result_set.next(). Like this
However, I only can retrieve around 170,000 records from result_set and got the error:
Traceback (most recent call last): File "com.netsuite.jdbc.oabase.oaca.java", line -1, in com.netsuite.jdbc.oabase.oaca.next Exception: Java Exception