jnius.JavaException: JVM exception occurred: [FileMaker][FileMaker JDBC] No results were returned by the query.

[nicogrubert]

Hi there

I am trying to insert a record into a filemaker Datebase and get the following error:

jnius.JavaException: JVM exception occurred: [FileMaker][FileMaker JDBC] No results were returned by the query.

A simple SQL SELECT query to that database works without problems, but using an SQL INSERT statement returns the error above.

My code looks like this:

from jnius import autoclass

DriverManager = autoclass('java.sql.DriverManager')
JDBCDriver = autoclass('com.filemaker.jdbc.Driver')
JDBCType = autoclass('java.sql.JDBCType')

_fmsHostname = 'my.host'
_fmFilename = 'testdb'
_fmUser = 'myuser'
_fmPassword = 'mypass'

d = JDBCDriver()
con = DriverManager.getConnection('jdbc:filemaker://' + _fmsHostname + '/' + _fmFilename, _fmUser, _fmPassword)
stmt = con.createStatement()    
qry = """INSERT INTO mytable ("Firstname", "Lastname") VALUES ('John', 'Phelps')"""
stmt.executeQuery(qry)

Any idea, what might be wrong?

[github-actions]

👋 We use the issue tracker exclusively for bug reports and feature requests. However, this issue appears to be a support request. Please use our support channels to get help with the project.
Let us know if this comment was made in error, and we'll be happy to reopen the issue.