Menu

#421 Postgresql with FEATURE_QUALIFIED_TABLE_NAMES and schemas in Uppercase results in NoSuchTableException

v2.5.*
pending
None
(not fixed)
5
2019-02-02
2019-01-30
ARom
No

Enviroment:
database product name=PostgreSQL
database version=10.6 (Ubuntu 10.6-0ubuntu0.18.04.1)
jdbc driver name=PostgreSQL Native Driver
jdbc driver version=PostgreSQL 9.4.1212.jre7

dbunit 2.5.x

=====
Using a multi schema FlatXmlDataset (where tables are described by CHEMA.TABLENAME), and setting FEATURE_QUALIFIED_TABLE_NAMES to true, dbunit can not load the dataset thrwoing a NoSuchTableException.
Ex:
<core.user id="user-content-10" username="john">
<core.user id="user-content-11" username="josh"></core.user></core.user>

However, when the first xml entry of the respective SCHEMA.TABLE has the Schema in lowercase, every other will load normally
Ex:
<core.user id="user-content-10" username="john">
<core.user id="user-content-11" username="josh"></core.user></core.user>

Discussion

  • Jeff Jensen

    Jeff Jensen - 2019-02-02
    • status: open --> pending
    • assigned_to: Jeff Jensen
     
  • Jeff Jensen

    Jeff Jensen - 2019-02-02

    Which 2.5.x version? Please try with 2.6.0 in case a later version fixed (e.g. 2.5.3 table name case sensitive problems).

    What is your setting of http://dbunit.sourceforge.net/properties.html#Case_Sensitive_Table_Names ?

    Do you have time to create a reproducing test to help resolve quicker, and maybe the fix?

     

Log in to post a comment.

MongoDB Logo MongoDB