DBUnit not fully support Postgre 8.3.8 issue

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

DBUnit not fully support Postgre 8.3.8 issue

shrimpywu
Hi all,

I am using PostgreSQL 8.3.8 in machine, and when i use dbunit library, it always give the warning message below,
how can i fix it?

 
main       |W|10:59:10,230|org.dbunit.dataset.AbstractTableMetaData:166  -=> Potential problem found: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database 'PostgreSQL' (e.g. some datatypes may not be supported properly). In rare cases you might see this message because the list of supported database products is incomplete (list=[derby]). If so please request a java-class update via the forums.If you are using your own IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override getValidDbProducts() to specify the supported database products.


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DBUnit not fully support Postgre 8.3.8 issue

John Hurst-2
You need to configure the PostgreSQL DataTypeFactory.

See http://www.dbunit.org/properties.html.

You need to add something like this:

    DatabaseConfig databaseConfig = databaseConnection.getConfig();
    databaseConfig.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new PostgresqlDataTypeFactory());

Hope this helps.

John Hurst

On Thu, Oct 29, 2009 at 1:00 PM, shrimpy <[hidden email]> wrote:
Hi all,

I am using PostgreSQL 8.3.8 in machine, and when i use dbunit library, it always give the warning message below,
how can i fix it?

 
main       |W|10:59:10,230|org.dbunit.dataset.AbstractTableMetaData:166  -=> Potential problem found: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database 'PostgreSQL' (e.g. some datatypes may not be supported properly). In rare cases you might see this message because the list of supported database products is incomplete (list=[derby]). If so please request a java-class update via the forums.If you are using your own IDataTypeFactory extending DefaultDataTypeFactory, ensure that you override getValidDbProducts() to specify the supported database products.


------------------------------------------------------------------------------
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DBUnit not fully support Postgre 8.3.8 issue

Roberto Lo Giacco-4
In reply to this post by shrimpywu
shrimpy wrote:
> Hi all,
>
> I am using PostgreSQL 8.3.8 in machine, and when i use dbunit library,
> it always give the warning message below,
> how can i fix it?
I'm going to add an entry in the FAQs about this, but please, have a
look at documentation or mailing list archives before posting...

>
>  
>
>     main      
>     |W|10:59:10,230|org.dbunit.dataset.AbstractTableMetaData:166  -=>
>     Potential problem found: The configured data type factory 'class
>     org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause
>     problems with the current database 'PostgreSQL' (e.g. some
>     datatypes may not be supported properly). In rare cases you might
>     see this message because the list of supported database products
>     is incomplete (list=[derby]). If so please request a java-class
>     update via the forums.If you are using your own IDataTypeFactory
>     extending DefaultDataTypeFactory, ensure that you override
>     getValidDbProducts() to specify the supported database products.
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>  


--

  Roberto Lo Giacco

  Chief Technical Officer
  SmartLab s.r.l.
  via Spagna, snc - 87036 Rende (CS) - Italy

  Mobile: +39 392 8765657
  Email: [hidden email]
  Skype: longisland-75
  Web: http://www.smartlab.it 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DBUnit not fully support Postgre 8.3.8 issue

John Hurst-2
Roberto,

I already promised to work on the DbUnit documentation, and this is one of the things ... so if you don't get to it by tomorrow I'll probably do it. (I'm hoping tomorrow will be a DbUnit day!)

JH

On Thu, Oct 29, 2009 at 4:48 PM, Roberto Lo Giacco <[hidden email]> wrote:
shrimpy wrote:
> Hi all,
>
> I am using PostgreSQL 8.3.8 in machine, and when i use dbunit library,
> it always give the warning message below,
> how can i fix it?
I'm going to add an entry in the FAQs about this, but please, have a
look at documentation or mailing list archives before posting...
>
>
>
>     main
>     |W|10:59:10,230|org.dbunit.dataset.AbstractTableMetaData:166  -=>
>     Potential problem found: The configured data type factory 'class
>     org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause
>     problems with the current database 'PostgreSQL' (e.g. some
>     datatypes may not be supported properly). In rare cases you might
>     see this message because the list of supported database products
>     is incomplete (list=[derby]). If so please request a java-class
>     update via the forums.If you are using your own IDataTypeFactory
>     extending DefaultDataTypeFactory, ensure that you override
>     getValidDbProducts() to specify the supported database products.
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>


--

 Roberto Lo Giacco

 Chief Technical Officer
 SmartLab s.r.l.
 via Spagna, snc - 87036 Rende (CS) - Italy

 Mobile: +39 392 8765657
 Email: [hidden email]
 Skype: longisland-75
 Web: http://www.smartlab.it


------------------------------------------------------------------------------
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user
Reply | Threaded
Open this post in threaded view
|

Re: DBUnit not fully support Postgre 8.3.8 issue

Roberto Lo Giacco-4
John Hurst wrote:
> Roberto,
>
> I already promised to work on the DbUnit documentation, and this is
> one of the things ... so if you don't get to it by tomorrow I'll
> probably do it. (I'm hoping tomorrow will be a DbUnit day!)
>
already committed to svn rev 1085

> JH
>
> On Thu, Oct 29, 2009 at 4:48 PM, Roberto Lo Giacco
> <[hidden email] <mailto:[hidden email]>> wrote:
>
>     shrimpy wrote:
>     > Hi all,
>     >
>     > I am using PostgreSQL 8.3.8 in machine, and when i use dbunit
>     library,
>     > it always give the warning message below,
>     > how can i fix it?
>     I'm going to add an entry in the FAQs about this, but please, have a
>     look at documentation or mailing list archives before posting...
>     >
>     >
>     >
>     >     main
>     >     |W|10:59:10,230|org.dbunit.dataset.AbstractTableMetaData:166
>      -=>
>     >     Potential problem found: The configured data type factory 'class
>     >     org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause
>     >     problems with the current database 'PostgreSQL' (e.g. some
>     >     datatypes may not be supported properly). In rare cases you
>     might
>     >     see this message because the list of supported database products
>     >     is incomplete (list=[derby]). If so please request a java-class
>     >     update via the forums.If you are using your own IDataTypeFactory
>     >     extending DefaultDataTypeFactory, ensure that you override
>     >     getValidDbProducts() to specify the supported database products.
>     >
>     >
>     >
>     ------------------------------------------------------------------------
>     >
>     >
>     ------------------------------------------------------------------------------
>     > 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
>     > [hidden email]
>     <mailto:[hidden email]>
>     > https://lists.sourceforge.net/lists/listinfo/dbunit-user
>     >
>
>
>     --
>
>      Roberto Lo Giacco
>
>      Chief Technical Officer
>      SmartLab s.r.l.
>      via Spagna, snc - 87036 Rende (CS) - Italy
>
>      Mobile: +39 392 8765657
>      Email: [hidden email] <mailto:[hidden email]>
>      Skype: longisland-75
>      Web: http://www.smartlab.it
>
>
>     ------------------------------------------------------------------------------
>     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
>     [hidden email]
>     <mailto:[hidden email]>
>     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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>  


--

  Roberto Lo Giacco

  Chief Technical Officer
  SmartLab s.r.l.
  via Spagna, snc - 87036 Rende (CS) - Italy

  Mobile: +39 392 8765657
  Email: [hidden email]
  Skype: longisland-75
  Web: http://www.smartlab.it 


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/dbunit-user