Crashes when calling Query in Electron

[bskimball]

I am trying to use this module in an electron app. I can establish a successful connection to the database. I can list the tables of the schema, but when I run query on one of those tables the app tells me there's a Javascript error in the main process.

The funny thing is that if I run the same js function that uses odbc from node it works as expected. Is there something about the query function that is different than the tables function? Is there something special I have to do for electron that you all know of?

Is this module compatible with Electron?

[BrendanC23]

I haven't run into any issues using this package with Electron and didn't need to do anything special to set it up. Can you post your code, your query, and the full error you're getting? What database are you using?

[bskimball]

I'm connecting to IBMi DB2. The connection itself is successful and I can do some things like list the tables but queries error.

I'm using the electron-vite library so it may be that. I will provide a reproduction when I get a chance.

The error just says Javascript error in the main process.

[BrendanC23]

I'm not sure, then. I use electron-vite as well and haven't run into any issues. If you aren't getting a useful stack trace from the error, you can try stepping through the code with a debugger and seeing which line of code the error is coming from.

You could also try the debugging steps from the README, but I'm not sure how comprehensible the output would be.

[bskimball]

I tried the debugging steps and it did not record any errors. The code runs fine as a Node process (i.e. node run-process.js) but inside Electron I just get a generic Error in Main Process.

Here's the code that errors

    try {
      console.log('Testing ODBC connection')
      const connection = await odbc.connect(
        'DSN=Harford;DRIVER=IBM i Access ODBC Driver;System=<ip-address>;UID=<username>;PWD=<password>;CMT=0;XDYNAMIC=0;DBQ=GRTPLNHYD;'
      ) // <-- this works
      console.log('Connection successful') // <-- this works
      const data = await connection.columns(null, 'GRTPLNHYD', tableName, null) // <-- this works
      console.log(data) // <-- this displays the columns
      const resultset = await connection.query(`SELECT * FROM ${tableName}`) // <-- this throws the error
      console.log(resultset)
    } catch (err) {
      throw new Error(err instanceof Error ? err.message : String(err))
    }

[bskimball]

I was able to capture the diagnostic error but I am unsure what it means. Seems to be maybe related to SMALLINT fields? I am using Windows 11 with the 32/64-bit IBM i Access ODBC driver version 13.64.28.00

electron.exe    5fe0-aa64	EXIT  SQLFreeHandle  with return code -1 (SQL_ERROR)
		SQLSMALLINT                  2 <SQL_HANDLE_DBC>
		SQLHANDLE           0x000001DD94BAC2E0

		DIAG [HY010] [Microsoft][ODBC Driver Manager] Function sequence error (0) 

Here is the relevant code that runs in the main process of electron-vite

// src/main/transfer-routine

import { emitter } from './utils'
import dayjs from 'dayjs'
import { TransferStatus } from '../types'
import odbc from 'odbc'

const tableNames: string[] = [
  'GL00100',
  'IV00101',
  'IV00102',
  'IV00108',
  'RM00101',
  'RM00102',
  'RM00301',
  'SOP10100',
  'SOP10101',
  'SOP10103',
  'SOP10105',
  'SOP10200',
  'SOP30200',
  'SOP60300'
]

function emitStatus(status: TransferStatus): void {
  emitter.emit('transfer-status', status)
}

export async function transfer(): Promise<void> {
  const startTime = dayjs().format('YYYY-MM-DD HH:mm:ss')
  emitStatus({ status: 'running', startTime })

  console.log('Testing ODBC connection')
  const connection = await odbc.connect('DSN=<DSN>;UID=<USER>;PWD=<PASSWORD>;DBQ=<LIBRARY>')
  console.log('Connection successful')

  console.log('Starting select')
  for (const tableName of tableNames) {
    console.log(`Current ${tableName}`)
    try {
      const data = await connection.columns(null, <LIBRARY>, tableName, null) // <-- this shows the columns
      console.log(data) 
      const resultset = await connection.query(`SELECT * FROM ${tableName}`) // <-- this is where the error occurs
      console.log(resultset)
    } catch (err) {
      throw new Error(err instanceof Error ? err.message : String(err))
    }
  }

  emitStatus({ status: 'complete', startTime })
}

I can run the above function in Node (using tsx) and it works without issue

// src/tester.ts
import { transfer } from './main/transfer-routine'

async function runTransfer(): Promise<void> {
  try {
    await transfer()
  } catch (error) {
    console.error('Error occurred during transfer:', error)
  }
}

runTransfer()
  .then(() => {
    console.log('Transfer routine completed successfully.')
  })
  .catch((error) => {
    console.error('Transfer routine failed:', error)
  })
  .finally(() => {
    console.log('Transfer routine finished.')
    process.exit(0)
  })