Ask Your Question

Why is my JDBC connection to NetSuite failing?

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

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

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

J3 gravatar image

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

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

jdbc:ns://{Account ID};;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, 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:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 121 times

Last updated: Mar 26