DBFit Setup

[Leonard Littleton]

I just installed DBFit 3.2.0 on my machine to play around with ETL testing.  When trying to connect to my database (or run a test period), I'm getting the following error:

'Could not complete testing: java.io.IOException: A size value could not be read. Fragment=|| '

I haven't seen anyone else with this issue, so I'm assuming it's just a configuration error with JRE.  Any guidance on this issue? I get this error regardless of the code I input.  In fact, I just ran a blank test page to get this error.  Thanks in advance for any help!

Leonard

[Yavor Nikolov]

Can you confirm that the issue still occurs with the following quick smoke test:

0) Check your Java version:

$ java -version

In my case it's "java version "1.8.0_66"". (Java 7 should work OK too)

1) Download dbfit and make sure the package is not corrupted - md5 sum should be:

9bf3805221f79762e7f5e3896c10ce14 *dbfit-complete-3.2.0.zip

2) Unzip it and start DbFit server:

./startFitnesse.sh -p 8085

3) Run the following test suite from your browser (it's built-in, there is no need to setup additional JDBC drivers):

http://localhost:8085/DbFit.AcceptanceTests.JavaTests.HsqlTests.FlowMode.CoreTests?suite

(Normally it's all green).

Best Regards,

Yavor

--
You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at https://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.

[Leonard Littleton]

Java Version "1.8.0_51".  DBFit Version 3.2.0 is installed.  Result of smoke test yielded the following result:

Could not complete testing: java.lang.NumberFormatException: For input string: " "

Any ideas?

[Yavor Nikolov]

Hmm. That's perhaps not dbfit specific but FitNesse in general is affected. I can see such issues have reported at https://github.com/unclebob/fitnesse/issues/533. A few ideas in my mind:

* Is your working folder simple enough (no network paths, no whitespace in it, etc.)

* Any environment variables affecting Java (CLASSPATH, JAVA_OPTIONS, ...)

* National settings (decimal point character, thousands separator, ...)

* Is there any firewall in place (if yes - is there any difference when the Firewall is switched off)?

[Leonard Littleton]

I'm not sure then either!  This is a work computer and there are strict firewalls.  I had to go through a huge approval process to get permission to download Fitnesse and DBFit in the first place.  Something I did notice, which I'm not sure affects anything, is that the version of Fitnesse DBFit runs on is different than the Fitnesse standalone I downloaded.  Does that matter? And can you share with me the configurations I need for CLASSPATH and things like that so I can verify that there's nothing there interfering?

[Yavor Nikolov]

DbFit has fitnesse-standalone built in: in general you don't need to download FitNesse standalone separately. Are you running both for some reason?

FitNesse is using TCP/IP for some of its internal communication (even though it's internal connection on one and the same host). If a firewall on your host is blocking something - it could be a problem.

What is your OS (Windows, Linux, OS X, ...)? How do you start your DbFit server (startFitNesse.sh, startFitNesse.bat)? 

In my case CLASSPATH is not set explicitly. You may check your env variables and unset possibly affecting one in your startFitNesse script.

[Leonard Littleton]

I'm brand new to all of this.  In my downtime, I've been searching trying to find solutions for automating ETL testing procedures.  I stumbled on Fitnesse and thought this may be the answer.  I thought I needed both Fitnesse and DBFit so I requested both since I have a long approval process.  I use startFitNesse.bat as I have Windows 7 OS.  And honestly, I know how to change env variables and classpaths, but I don't understand them fully.  So, I'm not sure if what I have is right or wrong.

[Yavor Nikolov]

OK. One hypothesis so far is that you have firewall running on your box (maybe it's Windows Firewall); you should make sure it 's not blocking java.exe.

If you have restrictions on your computer (e.g. the firewall is blocking you and you cannot change it), alternatively - if you're able to run a virtual machine on it, you can setup one and run dbfit inside (assuming you'll have full control inside the VM).