Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

java.NullPointerException with MSSQL queries

Description

Mailing list : https://dev.lucee.org/t/java-nullpointerexception-with-mssql-queries/12692

I recently upgraded my app from an old version of Lucee (lucee-5.2.7.63 to lucee-5.3.10.120) and this now longer works

works fine with a standard dsn definition

<cfscript> dsn = StructNew(); dsn.database = "luceetestdb"; dsn.host = "localhost"; dsn.port = 1433; dsn.type = "MSSQL"; dsn.dbType = "sqlserver"; dsn.username = "username"; dsn.password = "password" dsn.class = "com.microsoft.sqlserver.jdbc.SQLServerDriver" query = new Query(datasource=dsn); sql = "SELECT @@version"; query.setSQL(sql); writedump(query.execute().getResult()); </cfscript>

Environment

None

Attachments

3
  • 14 Jun 2023, 11:15 am
  • 14 Jun 2023, 06:59 am
  • 14 Jun 2023, 06:59 am

Activity

Show:

Zac Spitzer 8 August 2023 at 09:04

can you post to the mailing list about this, with more details?

Ulf Unger 8 August 2023 at 08:26

Same issue on Lucee 6.0.0.519-RC with an Other - JDBC Driver (deprecated) datasource for SQLite database. The datasource inside the app is still working fine - just the issue in editing inside the administrator seems to be the same.

Zac Spitzer 14 June 2023 at 15:12

Zac Spitzer 14 June 2023 at 11:37

works fine with a standard datasource

Zac Spitzer 14 June 2023 at 11:15

with 6.0 the error is due to username and password being null

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Affects versions

Created 14 June 2023 at 06:37
Updated 12 November 2024 at 10:51

Flag notifications