|

»

Create Domain - data type not recognized and will be ignored...

View: New views

4 Messages — Rating Filter: Alert me

	Create Domain - data type not recognized and will be ignored... by Nixo Soft :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Hi, Are there possibilities to use "Create Domain" Data Types in dbunit, without to implement a own DefaultDataTypeFactory for each "Domain Data Type"? Example: I use Postgre: CREATE DOMAIN state AS character(1) DEFAULT 'a'::bpchar CONSTRAINT state_ck CHECK ((VALUE = ANY (ARRAY['o'::bpchar, 'b'::bpchar, 'a'::bpchar, 'd'::bpchar]))); ... But I get a error, when I use new FlatXmlDataSet(...) to insert a "state" in a table (test): 21 [main] WARN org.dbunit.util.SQLHelper - test.statetyp data type (2001, 'state') not recognized and will be ignored. See FAQ for more information. org.dbunit.dataset.NoSuchColumnException: test.statetyp - (Non-uppercase input column: statetyp) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive. Greets Phil So gehst du mir nicht vor die Tür! Herbsttrends entdecken ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user
	Re: Create Domain - data type not recognized and will be ignored... by John Hurst-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I believe that this is currently not supported. But it would be good if it were supported! Would you like to raise an issue in the DbUnit bug tracker? Otherwise I will. (But I might not get on to it immediately.) Regards John Hurst On Tue, Oct 27, 2009 at 4:08 PM, Nixo Soft <nixosoft@...> wrote: Hi, Are there possibilities to use "Create Domain" Data Types in dbunit, without to implement a own DefaultDataTypeFactory for each "Domain Data Type"? Example: I use Postgre: CREATE DOMAIN state AS character(1) DEFAULT 'a'::bpchar CONSTRAINT state_ck CHECK ((VALUE = ANY (ARRAY['o'::bpchar, 'b'::bpchar, 'a'::bpchar, 'd'::bpchar]))); ... But I get a error, when I use new FlatXmlDataSet(...) to insert a "state" in a table (test): 21 [main] WARN org.dbunit.util.SQLHelper - test.statetyp data type (2001, 'state') not recognized and will be ignored. See FAQ for more information. org.dbunit.dataset.NoSuchColumnException: test.statetyp - (Non-uppercase input column: statetyp) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive. Greets Phil So gehst du mir nicht vor die Tür! Herbsttrends entdecken ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user -- Life is interfering with my game ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user
	Re: Create Domain - data type not recognized and will be ignored... by Matthias Gommeringer :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi Phil, you can actually use arbitrary custom Data Types by implementing the interface IDataTypeFactory once and creating your custom implementations of org.dbunit.dataset.datatype.DataType there. AFAIK there is no other way for custom datatypes. I also agree with John that it would be nice to have this supported out of the box. rgds, matthias > -----Ursprüngliche Nachricht----- > Von: "Nixo Soft" <nixosoft@...> > Gesendet: 27.10.09 04:09:05 > An: <dbunit-user@...> > Betreff: [dbunit-user] Create Domain - data type not recognized and will be ignored... Hi, > > Are there possibilities to use "Create Domain" Data Types in dbunit, > without to implement a own DefaultDataTypeFactory for each "Domain > Data Type"? > > Example: > > I use Postgre: > > CREATE DOMAIN state AS character(1) > DEFAULT 'a'::bpchar > CONSTRAINT state_ck CHECK ((VALUE = ANY (ARRAY['o'::bpchar, 'b':: > bpchar, 'a'::bpchar, 'd'::bpchar]))); > ... > > But I get a error, when I use new FlatXmlDataSet(...) to insert a " > state" in a table (test): > > 21 [main] WARN org.dbunit.util.SQLHelper - test.statetyp data type ( > 2001, 'state') not recognized and will be ignored. See FAQ for more > information. > org.dbunit.dataset.NoSuchColumnException: test.statetyp - (Non- > uppercase input column: statetyp) in ColumnNameToIndexes cache map. > Note that the map's column names are NOT case sensitive. > > Greets > Phil > > So gehst du mir nicht vor die Tür! Herbsttrends entdecken------------- > ----------------------------------------------------------------- > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart > your developing skills, take BlackBerry mobile applications to market > and stay ahead of the curve. Join us from November 9 - 12, 2009. > Register now! http://p.sf.net/sfu/devconference_______________________ > ________________________ dbunit-user mailing list dbunit-user@lists. > sourceforge.net https://lists.sourceforge.net/lists/listinfo/dbunit- > > user ______________________________________________________ GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT! Jetzt freischalten unter http://movieflat.web.de ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user
	Re: Create Domain - data type not recognized and will be ignored... by Nixo Soft :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Hi John, i have post it in the bug tracking system. Regards Phil Date: Tue, 27 Oct 2009 16:32:36 +1300 From: john.b.hurst@... To: dbunit-user@... Subject: Re: [dbunit-user] Create Domain - data type not recognized and will be ignored... I believe that this is currently not supported. But it would be good if it were supported! Would you like to raise an issue in the DbUnit bug tracker? Otherwise I will. (But I might not get on to it immediately.) Regards John Hurst On Tue, Oct 27, 2009 at 4:08 PM, Nixo Soft <nixosoft@...> wrote: Hi, Are there possibilities to use "Create Domain" Data Types in dbunit, without to implement a own DefaultDataTypeFactory for each "Domain Data Type"? Example: I use Postgre: CREATE DOMAIN state AS character(1) DEFAULT 'a'::bpchar CONSTRAINT state_ck CHECK ((VALUE = ANY (ARRAY['o'::bpchar, 'b'::bpchar, 'a'::bpchar, 'd'::bpchar]))); ... But I get a error, when I use new FlatXmlDataSet(...) to insert a "state" in a table (test): 21 [main] WARN org.dbunit.util.SQLHelper - test.statetyp data type (2001, 'state') not recognized and will be ignored. See FAQ for more information. org.dbunit.dataset.NoSuchColumnException: test.statetyp - (Non-uppercase input column: statetyp) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive. Greets Phil So gehst du mir nicht vor die Tür! Herbsttrends entdecken ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user -- Life is interfering with my game Das neue Windows 7: Vereinfachen Sie Ihre täglichen Aufgaben. Finden Sie den richtigen PC. ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ dbunit-user mailing list dbunit-user@... https://lists.sourceforge.net/lists/listinfo/dbunit-user