Questions tagged [jdbc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

Connection of MariaDB 11.2 to work with Mathematica 13.3.1

I would like to get the proper driver settings in place to permit the mariaDB database to connect to Mathematica via a JDBC driver running on a Windows11 64-bit machine. I've got mariaDB version 11.2 ...
Stuart Poss's user avatar
  • 1,774
1 vote
1 answer

How can I use older JDBC driver(s) to connect with old mySQL databases?

I got a new Mac at work, fresh install of Mathematica v13.3 (old 2015 Mac is dying and has v11.3). Problem: In v13.3 I cannot connect to older mySQL databases, using v13's JDBC driver (...
Mark_in_DK's user avatar
1 vote
1 answer

JDBC::error when connecting to MySQL database

I'm trying to connect to a MySQL database. I've seen quite a few different methods (some of which are conflicting and seem to be outdated) of connecting but haven't managed to get any to work so far. ...
wmv's user avatar
  • 359
6 votes
0 answers

Who broke the JDBC?

For the last 10 years or so, I have been accessing the tables of a PostgreSQL database successfully. Suddenly, having upgraded to Version 13.0, I get error messages in the simplest of queries, such as ...
Matthias's user avatar
  • 343
2 votes
1 answer

Issue in OpenSQLConnect[MySQL[JDBC[Connector/J ...]

Struggling with OpenSQLConnect[Connector/J] in Mathematica version 13.0. The code is: ...
Laszlo's user avatar
  • 51
1 vote
0 answers

JDBC connection fail after change JVM heap size

Due to the lack of heap capacity, I follow to increase the heap size, but afterward, I cannot connect to the DB even, ...
lingtao zhang's user avatar
1 vote
2 answers

Insert a DateObject into MySQL database?

I want to use Mathematica to do some SQL tasks like insert. However, I have difficulty in inserting date into SQL. Here is an example. ...
407PZ's user avatar
  • 1,441
0 votes
1 answer

QODBC (Quickbooks), ODBC Mathematica connection string [duplicate]

I am trying to connect to QuickBooks using QODBC driver. I am able to successfully connect when I use RazorSQL but can not figure out the correct statements in Mathematica (11.2) nor can Icconnect ...
David Kerr's user avatar
3 votes
1 answer

JDBC with "autoReconnect=True"

I sometimes leave long computations running overnight and return in the morning to find that my database connection has timed out. I typically have to kill the kernel and launch a new database ...
Michael Stern's user avatar
4 votes
1 answer

How to access AWS Redshift

Hello i am trying to access AWS redshift server. I have the driver installed JDBC[ "",... ] However it seems that i can't ...
bernddude's user avatar
  • 161
0 votes
2 answers

SQLInsert SQLExpr not working in V11

This worked fine in Mathematica 7. Any ideas how to fix it for version 11? ...
Chris Degnen's user avatar
  • 30.8k
4 votes
0 answers

How to OpenSQLConnection with JDBC for "Microsoft Excel"?

I have a very large Microsoft Excel file that will not Import even after setting a 5GB heap size for Java as follows. ...
Edmund's user avatar
  • 41.7k
11 votes
3 answers

JDBC-to-ODBC bridge gone. How to connect to SQL Server now in case of Windows Authentication?

Connecting to our corporate SQL servers using JDBC never worked for me, perhaps related to the Windows Authentication method that is necessary in our network. However, I found out that configuring the ...
Sjoerd C. de Vries's user avatar