You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "ashishvijaywargiya (via GitHub)" <gi...@apache.org> on 2026/05/19 11:55:33 UTC

[PR] OFBIZ-13413 - Fix JdbcSQLDataException during startup caused by null table parameter in getPrimaryKeys [ofbiz-framework]

ashishvijaywargiya opened a new pull request, #1229:
URL: https://github.com/apache/ofbiz-framework/pull/1229

   Fixed: Here is the fix to remove the null parameter attempt entirely and use the "%" wildcard as our primary optimization path. This preserves performance for databases that accept wildcards, while allowing strict databases to silently return zero rows and gracefully fall back to compliant table-by-table iteration without polluting the logs with stack traces.
   
   While some database drivers tolerate a null argument here, the official JDBC specification mandates that this parameter must be an exact table name. Because H2 enforces this specification strictly, it throws an exception before OFBiz eventually catches it and falls back to querying tables individually.
   
   This commit will fix the following error/warnings returned on the console:
   
   2026-05-17 23:51:35,252 |OFBiz-batch-2        |DatabaseUtil                  |I| Getting Column Info From Database
   2026-05-17 23:51:35,252 |OFBiz-batch-1        |DatabaseUtil                  |I| Error getting primary key info from database with null tableName, will try other means: org.h2.jdbc.JdbcSQLDataException: Invalid value "null" for parameter "table" [90008-240]
   2026-05-17 23:51:35,252 |OFBiz-batch-1        |DatabaseUtil                  |I| Searching in 7 tables for primary key fields ...
   2026-05-17 23:51:35,252 |OFBiz-batch-1        |DatabaseUtil                  |I| Reviewed 9 primary key fields from database.
   2026-05-17 23:51:35,253 |OFBiz-batch-3        |DatabaseUtil                  |I| Error getting primary key info from database with null tableName, will try other means: org.h2.jdbc.JdbcSQLDataException: Invalid value "null" for parameter "table" [90008-240]
   2026-05-17 23:51:35,253 |OFBiz-batch-3        |DatabaseUtil                  |I| Searching in 6 tables for primary key fields ...
   2026-05-17 23:51:35,253 |OFBiz-batch-3        |DatabaseUtil                  |I| Reviewed 8 primary key fields from database.
   2026-05-17 23:51:35,268 |OFBiz-batch-2        |DatabaseUtil                  |I| Error getting primary key info from database with null tableName, will try other means: org.h2.jdbc.JdbcSQLDataException: Invalid value "null" for parameter "table" [90008-240]
   2026-05-17 23:51:35,268 |OFBiz-batch-2        |DatabaseUtil                  |I| Searching in 870 tables for primary key fields ...
   2026-05-17 23:51:35,274 |OFBiz-batch-2        |DatabaseUtil                  |I| Reviewed 1697 primary key fields from database.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [PR] OFBIZ-13413 - Fix JdbcSQLDataException during startup caused by null table parameter in getPrimaryKeys [ofbiz-framework]

Posted by "ashishvijaywargiya (via GitHub)" <gi...@apache.org>.
ashishvijaywargiya commented on PR #1229:
URL: https://github.com/apache/ofbiz-framework/pull/1229#issuecomment-4488311251

   > Thanks Ashish, works perfectly
   
   Thank you, Sir!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [PR] OFBIZ-13413 - Fix JdbcSQLDataException during startup caused by null table parameter in getPrimaryKeys [ofbiz-framework]

Posted by "JacquesLeRoux (via GitHub)" <gi...@apache.org>.
JacquesLeRoux commented on PR #1229:
URL: https://github.com/apache/ofbiz-framework/pull/1229#issuecomment-4488115330

   Thanks Ashish, works perfectly


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [PR] OFBIZ-13413 - Fix JdbcSQLDataException during startup caused by null table parameter in getPrimaryKeys [ofbiz-framework]

Posted by "ashishvijaywargiya (via GitHub)" <gi...@apache.org>.
ashishvijaywargiya merged PR #1229:
URL: https://github.com/apache/ofbiz-framework/pull/1229


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org