Group Abstract Group Abstract

Message Boards Message Boards

0
|
2.7K Views
|
1 Reply
|
1 Total Like
View groups...
Share
Share this post:

Issue in OpenSQLConnect[Connector/J]?

Posted 3 years ago
POSTED BY: Laszlo Abraham
Posted 3 years ago

Wolfram support suggested this workaround. See Properties->

OpenSQLConnection[
 JDBC["MySQL(Connector/J)", "ip and name of remote database"], 
 "Version" -> 3.1, "Catalog" -> Automatic, "Description" -> None, 
 "autoReconnect" -> True, "Password" -> xxx", 
 "Properties" -> {"useSSL" -> "False"}, "ReadOnly" -> Automatic, "RelativePath" -> False,
  "TransactionIsolationLevel" -> Automatic, 
 "UseConnectionPool" -> Automatic, "Username" -> "xxx", 
 "Timeout" -> 1000]

It works! The developers will implement the useSSL->True in the next version.

POSTED BY: Laszlo Abraham
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard