mysql - DBUnit ignores column aliases, when creating dataset from query? -

-

i have 2 datasets, want compare dbunit: 1 defines xml file, other trying create using query:

dbconnection.createquerytable("my_table", "select ...");

select goes on couple of tables, few of them has same column names, using aliases distinguish between them. query runs fine, seems while creating dataset, dbunit ignores column aliases , uses original names instead. seen in debug log:

01.03.13 14:18:43,228 [ debug] abstractdatabaseconnection - createquerytable(resultname=my_table, sql=         select `table1`.`name`             , `table2`.`label` `table2_label`             , `table3`.`label`         `table1`             , `table2`             , `table3`         `table1`.`id` = `table2`.`table1_id`             , `table2`.`id` = `table3`.`table2_id`     ) - start 01.03.13 14:18:43,228 [ debug] databasedatasourceconnection - getconnection() - start 01.03.13 14:18:43,228 [ debug] databaseconfig$configurator - statement fetch size set 100 01.03.13 14:18:43,240 [ debug] databasedatasourceconnection - getconnection() - start 01.03.13 14:18:43,240 [ debug] databasetablemetadata - 'schemaname' resultsetmetadata empty-string , not applicable hence. not try lookup column properties via databasemetadata.getcolumns. 01.03.13 14:18:43,240 [ debug] databasetablemetadata - 'schemaname' resultsetmetadata empty-string , not applicable hence. not try lookup column properties via databasemetadata.getcolumns. 01.03.13 14:18:43,240 [ debug] databasetablemetadata - 'schemaname' resultsetmetadata empty-string , not applicable hence. not try lookup column properties via databasemetadata.getcolumns. 01.03.13 14:18:43,240 [ debug] forwardonlyresultsettable - getvalue(row=0, columnname=name) - start 01.03.13 14:18:43,240 [ debug] forwardonlyresultsettable - getvalue(row=0, columnname=label) - start 01.03.13 14:18:43,240 [ debug] forwardonlyresultsettable - getvalue(row=0, columnname=label) - start 01.03.13 14:18:43,240 [ debug] forwardonlyresultsettable - getvalue(row=1, columnname=name) - start 01.03.13 14:18:43,241 [ debug] forwardonlyresultsettable - getvalue(row=1, columnname=label) - start 01.03.13 14:18:43,241 [ debug] forwardonlyresultsettable - getvalue(row=1, columnname=label) - start 01.03.13 14:18:43,241 [ debug] forwardonlyresultsettable - getvalue(row=2, columnname=name) - start 01.03.13 14:18:43,241 [ debug] forwardonlyresultsettable - getvalue(row=2, columnname=label) - start 01.03.13 14:18:43,241 [ debug] forwardonlyresultsettable - getvalue(row=2, columnname=label) - start

as see - getvalue(row=x) uses label name table2 , table3 columns , not table2_label , label defined in query...

how solve this? using mysql database.

this looks caused change in mysql java connector

caused databasetablemetadata calling resultsetmetadata#getcolumnname() rather #getcolumnlabel()

you don't state version of dbunit/mysql using, dbunit 2.2 & 2.4.9 affected mysql connector 5.1.26.

as workaround, mysql devs have included backward compatability option, discussed in change above.

to configure it, add property jdbc url:

jdbc:mysql://host/db_name?useoldaliasmetadatabehavior=true

as per these instructions.


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

multithreading - Exception in Application constructor -

-
i wanna write snake game javafx , there exception don't know , want know how fix it. ( know it's not complete yet ) and want know , class extends application ( start override ) main in other programs? see , here not static void main bc didn't need, if want add main shoud do? it's exeption... exception in application constructor exception in thread "main" java.lang.nosuchmethodexception: main_snake.main([ljava.lang.string;) @ java.lang.class.getmethod(class.java:1819) @ com.intellij.rt.execution.application.appmain.main(appmain.java:125) and code : import javafx.animation.animationtimer; import javafx.application.application; import javafx.event.eventhandler; import javafx.scene.scene; import javafx.scene.canvas.canvas; import javafx.scene.canvas.graphicscontext; import javafx.scene.input.keyevent; import javafx.scene.layout.borderpane; import javafx.scene.paint.color; import javafx.stage.stage; import java.util.arraylist; /** * creat...
Read more

windows - CertCreateCertificateContext returns CRYPT_E_ASN1_BADTAG / 8009310b -

-
i realize similar post others (e.g. this one ), there details missing posts might significant case. to start with, here's simplified program: #include "stdafx.h" #include <windows.h> #include <wincrypt.h> int _tmain(int argc, _tchar* argv[]) { // usage: certextract certpath char keyfile[] = "c:\\certificates\\public.crt"; byte lp[65536]; security_attributes sa; handle hkeyfile; dword bytes; pccert_context certcontext; sa.nlength = sizeof(sa); sa.lpsecuritydescriptor = null; sa.binherithandle = false; hkeyfile = createfile(keyfile, generic_read, file_share_read, &sa, open_existing, file_attribute_normal, null); if (hkeyfile) { if (readfile(hkeyfile, lp, getfilesize(hkeyfile, null), &bytes, null) && bytes > 0) { certcontext = certcreatecertificatecontext(x509_asn_encoding, lp, bytes); if (certcontext) { printf("yay...
Read more