Ask Your Question
0

Why is my JDBC connection to NetSuite failing?

asked 2020-03-26 20:25:48 -0500

J3 gravatar image

Is the connection string syntax not a typical string?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2020-03-26 20:27:55 -0500

J3 gravatar image

updated 2020-03-26 20:29:25 -0500

Figured it out, this is the connection string that worked for me:

jdbc:ns://{Account ID}.connect.api.netsuite.com:1708;ServerDataSource=NetSuite.com;Encrypted=1;CustomProperties=(AccountID={Account ID};RoleID={Role ID})

Note replace {Account ID} with the account ID assigned to your company, and {Role ID} assigned to you.

Also, it turns out the latest 64-bit Linux JDBC driver at the time of this writing is 8.10.85.0, which is pre-JDBC 4 compliant driver. Therefore, I had to in the JDBC Origin Configuration Legacy Drivers tab, specify the JDBC Driver Class Name:

com.netsuite.jdbc.openaccess.OpenAccessDriver
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-26 20:25:48 -0500

Seen: 12 times

Last updated: Mar 26