connection to a flat file

[nikhil bajaj]

I have connected to no. of databases through dbfit but 1 thing is
still left.
And i badly want to know the way I can connect to a flat file through
dbfit for displaying data in that file and taking data from that
file.
Does anyone have any idea about the same. ???

[dbpat...@gmail.com]

Therer's a filehandler.

> --
>
>
> You received this message because you are subscribed to the Google Groups "dbfit" group.
>
>
> To post to this group, send email to db...@googlegroups.com.
>
>
> To unsubscribe from this group, send email to dbfit+un...@googlegroups.com.
>
>
> For more options, visit this group at http://groups.google.com/group/dbfit?hl=en.
>
>
>
>
>
>

[MatMan]

Write the class for handling flat files through JDBC and share it with the rest of the community!

 

Not sure if you'll find a JDBC driver for flat files that supports enough of the JDBC API for DbFit to use it as it stands.

[swapni...@cwc.com]

Hi Nikhil,

Let me know if you got solution to connect to file using dbfit and also the fixtures to use, steps and sample dbfit page to achieve this.

Regards,

Swapnil

[MatMan]

There's no 'file' database type in dbfit at the moment but there are some JDBC drivers out there that might be viable for a dbfit enhancement: -

http://sourceforge.net/projects/jdbcfiledriver/

http://sourceforge.net/projects/csvjdbc/

and I know Oracle Data Integrator has a file based JDBC driver too that I've used before.

If you're just looking to setup input data files to load to a DB (e.g. data warehouse) then test that the data has arrived in your database then you don't need dbfit for the creation of those files of course.

[Lukasz Wasylow]

As a workaround just use HSQLDB. You can define file table.

http://hsqldb.org/doc/guide/texttables-chapt.html#ttc_table_definition

Quit cool. It's not direct to file but will do job.

[swapni...@cwc.com]

Hi Lukasz,

Excellent suggestion. 

Thanks! It worked...

Swapnil

[Lukasz Wasylow]

Glad I helped :)

Its getting quite powerfull when you run page in standalone mode so you can compare flat file with e.g. Oracle data etc. (of course still memory limits).

--
You received this message because you are subscribed to a topic in the Google Groups "dbfit" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dbfit/itnWSuhQHvk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dbfit+un...@googlegroups.com.

To post to this group, send email to db...@googlegroups.com.

Visit this group at http://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.