maybe you could allow it to run fo a longer period of time. or use a
database admin sotware to see if it is doing any activity on hte db or ust
staying there
On 8/3/06, Mark Thomas <[EMAIL PROTECTED]> wrote:
Hi,
I have tried installing ofBiz on freeBSD 4.11, but it hangs during
startup.
I first tried downloading the opentravel zip file and running that, then
I tried loading ofBiz from svn - but in both cases, the console screen
just stops at a particular point during startup.
For instance, if I do this in my ofbiz home directory : ./ant run-install
Everything seems to work nicely up to the bit where it gets information
from the database : specifically the localderbyodbc database.
The last few lines of the hang are :
[java] 2006-08-03 18:24:47,145 (main) [
GenericDelegator.java:176:INFO ] Delegator "default" initializing helper
"localderbyodbc" for entity group "org.ofbiz.odbc".
[java] 2006-08-03 18:24:47,147 (main) [
GenericDelegator.java:193:INFO ] Doing database check as requested in
entityengine.xml with addMissing=true
[java] 2006-08-03 18:24:50,609 (main) [
DatabaseUtil.java:765:INFO ] Database Product Name is Apache Derby
[java] 2006-08-03 18:24:50,612 (main) [
DatabaseUtil.java:766:INFO ] Database Product Version is 10.1.3.1
[java] 2006-08-03 18:24:50,613 (main) [
DatabaseUtil.java:774:INFO ] Database Driver Name is Apache Derby
Embedded JDBC Driver
[java] 2006-08-03 18:24:50,614 (main) [
DatabaseUtil.java:775:INFO ] Database Driver Version is 10.1.3.1
[java] 2006-08-03 18:24:50,616 (main) [
DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0
[java] 2006-08-03 18:24:50,617 (main) [
DatabaseUtil.java:786:INFO ] Database Setting/Support Information (those
with a * should be true):
[java] 2006-08-03 18:24:50,618 (main) [
DatabaseUtil.java:787:INFO ] - supports transactions [true]*
[java] 2006-08-03 18:24:50,623 (main) [
DatabaseUtil.java:788:INFO ] - isolation None [false]
[java] 2006-08-03 18:24:50,625 (main) [
DatabaseUtil.java:789:INFO ] - isolation ReadCommitted [true]
[java] 2006-08-03 18:24:50,626 (main) [
DatabaseUtil.java:790:INFO ] - isolation ReadUncommitted[true]
[java] 2006-08-03 18:24:50,630 (main) [
DatabaseUtil.java:791:INFO ] - isolation RepeatableRead [true]
[java] 2006-08-03 18:24:50,632 (main) [
DatabaseUtil.java:792:INFO ] - isolation Serializable [true]
[java] 2006-08-03 18:24:50,647 (main) [
DatabaseUtil.java:793:INFO ] - default fetchsize [1]
[java] 2006-08-03 18:24:50,649 (main) [
DatabaseUtil.java:794:INFO ] - forward only type [true]
[java] 2006-08-03 18:24:50,650 (main) [
DatabaseUtil.java:795:INFO ] - scroll sensitive type [false]
[java] 2006-08-03 18:24:50,652 (main) [
DatabaseUtil.java:796:INFO ] - scroll insensitive type [true]
[java] 2006-08-03 18:24:50,653 (main) [
DatabaseUtil.java:797:INFO ] - is case sensitive [false]
[java] 2006-08-03 18:24:50,660 (main) [
DatabaseUtil.java:798:INFO ] - stores LowerCase [false]
[java] 2006-08-03 18:24:50,663 (main) [
DatabaseUtil.java:799:INFO ] - stores MixedCase [false]
[java] 2006-08-03 18:24:50,664 (main) [
DatabaseUtil.java:800:INFO ] - stores UpperCase [true]
[java] 2006-08-03 18:24:50,666 (main) [
DatabaseUtil.java:801:INFO ] - max table name length [128]
[java] 2006-08-03 18:24:50,667 (main) [
DatabaseUtil.java:802:INFO ] - max column name length [128]
[java] 2006-08-03 18:24:50,669 (main) [
DatabaseUtil.java:803:INFO ] - max schema name length [128]
[java] 2006-08-03 18:24:50,672 (main) [
DatabaseUtil.java:804:INFO ] - concurrent connections [0]
[java] 2006-08-03 18:24:50,673 (main) [
DatabaseUtil.java:805:INFO ] - concurrent statements [0]
[java] 2006-08-03 18:24:50,675 (main) [
DatabaseUtil.java:806:INFO ] - ANSI SQL92 Entry [false]
[java] 2006-08-03 18:24:50,676 (main) [
DatabaseUtil.java:807:INFO ] - ANSI SQL92 Itermediate [false]
[java] 2006-08-03 18:24:50,677 (main) [
DatabaseUtil.java:808:INFO ] - ANSI SQL92 Full [false]
[java] 2006-08-03 18:24:50,679 (main) [
DatabaseUtil.java:809:INFO ] - ODBC SQL Grammar Core [false]
[java] 2006-08-03 18:24:50,680 (main) [
DatabaseUtil.java:810:INFO ] - ODBC SQL Grammar Extended[false]
[java] 2006-08-03 18:24:50,681 (main) [
DatabaseUtil.java:811:INFO ] - ODBC SQL Grammar Minimum [true]
[java] 2006-08-03 18:24:50,683 (main) [
DatabaseUtil.java:812:INFO ] - outer joins [true]*
[java] 2006-08-03 18:24:50,684 (main) [
DatabaseUtil.java:813:INFO ] - limited outer joins [true]
[java] 2006-08-03 18:24:50,685 (main) [
DatabaseUtil.java:814:INFO ] - full outer joins [false]
[java] 2006-08-03 18:24:50,687 (main) [
DatabaseUtil.java:815:INFO ] - group by [true]*
[java] 2006-08-03 18:24:50,688 (main) [
DatabaseUtil.java:816:INFO ] - group by not in select [true]
[java] 2006-08-03 18:24:50,689 (main) [
DatabaseUtil.java:817:INFO ] - column aliasing [true]
[java] 2006-08-03 18:24:50,691 (main) [
DatabaseUtil.java:818:INFO ] - order by not in select [false]
[java] 2006-08-03 18:24:50,692 (main) [
DatabaseUtil.java:820:INFO ] - alter table add column [true]*
[java] 2006-08-03 18:24:50,693 (main) [
DatabaseUtil.java:821:INFO ] - non-nullable column [true]*
[java] 2006-08-03 18:24:50,695 (main) [
DatabaseUtil.java:858:INFO ] Getting Table Info From Database
[java] 2006-08-03 18:24:52,967 (main) [
DatabaseUtil.java:993:INFO ] Getting Column Info From Database
I'm not sure what's supposed to come next, but it is probably that next
bit which is holding me up.
I tried starting with the 'startup' script too and checked the log files
- it stopped at the same point.
I also tried using a postgresql database instead of the default derby
database - once again, same problem - so I'm assuming the problem is
with this 'odbc' database or whatever is supposed to start next.
Any help greatly appreciated.
Thanks,
Mark
