OFBiz › OFBiz - User

running ofbiz - exception

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

7 messages Options

ericcho-2

running ofbiz - exception

I'm a newbie to ofbiz and forgive me if this question has been answered already, but I'm having trouble starting the application.

So far I've gotten the latest source from SVN and have attepted to run it both via command line and Eclipse... only to get the same result.

Here's what spits out on the console.....

.....
2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ] - order by not in select [false]
2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ] - alter table add column [true]*
2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ] - non-nullable column [true]*
2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ] Getting Table Info From Database
2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ] Getting Column Info From Database
java.lang.NullPointerException
at java.util.TreeMap.compare(TreeMap.java:1108)
at java.util.TreeMap.getEntry(TreeMap.java:362)
at java.util.TreeMap.containsKey(TreeMap.java:219)
at java.util.TreeSet.contains(TreeSet.java:211)
at org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
......

Its pretty vague.... does this look familiar to anyone? If so, is there a step I've missed?

Any help is appreciated.

Regards,
Eric

Jacques Le Roux

Re: running ofbiz - exception

Administrator

Eric,

Did you ran "ant run-install" before ? It loads OOTB data demo and should run fine.

Jacques

----- Original Message -----
From: <[hidden email]>
To: <[hidden email]>
Sent: Monday, January 15, 2007 6:10 PM
Subject: running ofbiz - exception

>
>
>
>
> I'm a newbie to ofbiz and forgive me if this question has been answered already, but I'm having trouble starting the application.
>
> So far I've gotten the latest source from SVN and have attepted to run it both via command line and Eclipse... only to get the
same result.

>
> Here's what spits out on the console.....
>
> .....
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ] - order by not in select [false]
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ] - alter table add column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ] - non-nullable column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ] Getting Table Info From Database
> 2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ] Getting Column Info From Database
> java.lang.NullPointerException
> at java.util.TreeMap.compare(TreeMap.java:1108)
> at java.util.TreeMap.getEntry(TreeMap.java:362)
> at java.util.TreeMap.containsKey(TreeMap.java:219)
> at java.util.TreeSet.contains(TreeSet.java:211)
> at org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
> ......
>
> Its pretty vague.... does this look familiar to anyone? If so, is there a step I've missed?
>
> Any help is appreciated.
>
> Regards,
> Eric

ericcho-2

Re: running ofbiz - exception

In reply to this post by ericcho-2

Hi Jacques,

Yes, I ran the run-install with success.... or at least it wasn't apparent that there were any errors.

Could there be another cause?

Thanks,

Eric

Jacques Le Roux <[hidden email]>
01/15/2007 06:42 PM CETPlease respond [hidden email]

To [hidden email]
cc
bcc
Subject Re: running ofbiz - exception

Jacques Le Roux

Re: running ofbiz - exception

Administrator

Did you check the log after "run-install" ? Sounds like data are missing in DB ...

Jacques
----- Original Message -----
From: [hidden email]
To: [hidden email]
Sent: Monday, January 15, 2007 7:07 PM
Subject: Re: running ofbiz - exception

Hi Jacques,

Yes, I ran the run-install with success.... or at least it wasn't apparent that there were any errors.

Could there be another cause?

Thanks,

Eric

Jacques Le Roux <[hidden email]>
01/15/2007 06:42 PM CETPlease respond [hidden email]

To [hidden email]
cc
bcc
Subject Re: running ofbiz - exception

Eric,

Did you ran "ant run-install" before ? It loads OOTB data demo and should run fine.

Jacques

----- Original Message -----
From: <[hidden email]>
To: <[hidden email]>
Sent: Monday, January 15, 2007 6:10 PM
Subject: running ofbiz - exception

>
>
>
>
> I'm a newbie to ofbiz and forgive me if this question has been answered already, but I'm having trouble starting the application.
>
> So far I've gotten the latest source from SVN and have attepted to run it both via command line and Eclipse... only to get the
same result.
>
> Here's what spits out on the console.....
>
> .....
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ] - order by not in select [false]
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ] - alter table add column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ] - non-nullable column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ] Getting Table Info From Database
> 2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ] Getting Column Info From Database
> java.lang.NullPointerException
> at java.util.TreeMap.compare(TreeMap.java:1108)
> at java.util.TreeMap.getEntry(TreeMap.java:362)
> at java.util.TreeMap.containsKey(TreeMap.java:219)
> at java.util.TreeSet.contains(TreeSet.java:211)
> at org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
> ......
>
> Its pretty vague.... does this look familiar to anyone? If so, is there a step I've missed?
>
> Any help is appreciated.
>
> Regards,
> Eric

=

ericcho-2

Re: running ofbiz - exception

Hi Jacques,

Yes but just to make sure.... I removed the tables from the databases and ran the "run-install" again. After double checking the logs to make sure no exceptions were thrown, I tried running the application again, only to get the same exception.

I forgot to mention that I was using this against a MySQL DB.

I changed my configuration back to derby.... ran the "run-install" and everything seems to be working now.

Is there a chance that the mysql install module is in error? Has anyone else encountered this issue?

Thanks,
Eric

Jacques Le Roux <[hidden email]>

15/01/2007 11:37 AM To
[hidden email]
cc
Please respond to
[hidden email] Subject
Re: running ofbiz - exception

Did you check the log after "run-install" ? Sounds like data are missing in DB ...

Jacques
----- Original Message -----
From: [hidden email]
To: [hidden email]
Sent: Monday, January 15, 2007 7:07 PM
Subject: Re: running ofbiz - exception

Hi Jacques,

Yes, I ran the run-install with success.... or at least it wasn't apparent that there were any errors.

Could there be another cause?

Thanks,

Eric

Jacques Le Roux <[hidden email]>
01/15/2007 06:42 PM CETPlease respond [hidden email]

To [hidden email]
cc
bcc
Subject Re: running ofbiz - exception

Eric,

Did you ran "ant run-install" before ? It loads OOTB data demo and should run fine.

Jacques

----- Original Message -----
From: <[hidden email]>
To: <[hidden email]>
Sent: Monday, January 15, 2007 6:10 PM
Subject: running ofbiz - exception

>
>
>
>
> I'm a newbie to ofbiz and forgive me if this question has been answered already, but I'm having trouble starting the application.
>
> So far I've gotten the latest source from SVN and have attepted to run it both via command line and Eclipse... only to get the
same result.
>
> Here's what spits out on the console.....
>
> .....
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ] - order by not in select [false]
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ] - alter table add column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ] - non-nullable column [true]*
> 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ] Getting Table Info From Database
> 2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ] Getting Column Info From Database
> java.lang.NullPointerException
> at java.util.TreeMap.compare(TreeMap.java:1108)
> at java.util.TreeMap.getEntry(TreeMap.java:362)
> at java.util.TreeMap.containsKey(TreeMap.java:219)
> at java.util.TreeSet.contains(TreeSet.java:211)
> at org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
> at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
> ......
>
> Its pretty vague.... does this look familiar to anyone? If so, is there a step I've missed?
>
> Any help is appreciated.
>
> Regards,
> Eric

=

Jacques Le Roux

Re: running ofbiz - exception

Administrator

Eric,

Please check that your JDBC driver version corresponds to the version of the DB you use. Also are you sure of your parameters in
entityengine.xml for MySQL (login/pwd, etc.) ? The last point seems OK BTW since your MyDQL DB seems to work (you deleted tables)

Jacques

----- Original Message -----
From: <[hidden email]>
To: <[hidden email]>
Sent: Monday, January 15, 2007 10:57 PM
Subject: Re: running ofbiz - exception

>
>
>
>
> Hi Jacques,
>
> Yes but just to make sure.... I removed the tables from the databases and ran the "run-install" again. After double checking the
logs to make sure no exceptions were thrown, I tried running the application again, only to get the same exception.

>
> I forgot to mention that I was using this against a MySQL DB.
>
> I changed my configuration back to derby.... ran the "run-install" and everything seems to be working now.
>
> Is there a chance that the mysql install module is in error? Has anyone else encountered this issue?
>
> Thanks,
> Eric
>
>
>
>
> Jacques Le Roux <[hidden email]>
>
> 15/01/2007 11:37 AM

To
> [hidden email]
>
cc
> Please respond to
> [hidden email]
Subject
> Re: running ofbiz -
exception
>
>
>

>
>
>
>
>
>
>
> Did you check the log after "run-install" ? Sounds like data are missing in DB ...
>
> Jacques
> ----- Original Message -----
> From: [hidden email]
> To: [hidden email]
> Sent: Monday, January 15, 2007 7:07 PM
> Subject: Re: running ofbiz - exception
>
>
> Hi Jacques,
>
> Yes, I ran the run-install with success.... or at least it wasn't apparent that there were any errors.
>
> Could there be another cause?
>
> Thanks,
>
> Eric
>
>
> Jacques Le Roux <[hidden email]>
> 01/15/2007 06:42 PM CETPlease respond [hidden email]
>
> To [hidden email]
> cc
> bcc
> Subject Re: running ofbiz - exception
>
>
>
>
> Eric,
>
> Did you ran "ant run-install" before ? It loads OOTB data demo and should run fine.
>
> Jacques
>
> ----- Original Message -----
> From: <[hidden email]>
> To: <[hidden email]>
> Sent: Monday, January 15, 2007 6:10 PM
> Subject: running ofbiz - exception
>
>
> >
> >
> >
> >
> > I'm a newbie to ofbiz and forgive me if this question has been answered already, but I'm having trouble starting the

application.

> >
> > So far I've gotten the latest source from SVN and have attepted to run it both via command line and Eclipse... only to get the
> same result.
> >
> > Here's what spits out on the console.....
> >
> > .....
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ] - order by not in select [false]
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ] - alter table add column [true]*
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ] - non-nullable column [true]*
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ] Getting Table Info From Database
> > 2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ] Getting Column Info From Database
> > java.lang.NullPointerException
> > at java.util.TreeMap.compare(TreeMap.java:1108)
> > at java.util.TreeMap.getEntry(TreeMap.java:362)
> > at java.util.TreeMap.containsKey(TreeMap.java:219)
> > at java.util.TreeSet.contains(TreeSet.java:211)
> > at org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
> > at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
> > at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
> > ......
> >
> > Its pretty vague.... does this look familiar to anyone? If so, is there a step I've missed?
> >
> > Any help is appreciated.
> >
> > Regards,
> > Eric
>
>
> =
>

ericcho-2

Re: running ofbiz - exception

Hi Jacques,

I'm fairly certain that I'm using the correct jdbc driver for MySQL. Its
the same driver I've been using for the last couple projects I've been
working on.
And yes, i believe the parameters are fine in the entityengine.xml for
MySQL. After the run-install, I verified that there are newly created
tables in the ofbiz and ofbiz_odbc databases with the MySQL admin client.

I will continue to play with it when I have time, and I'll let you know if
I resolve anything.

Regards,
Eric

Jacques Le Roux <[hidden email]>
16/01/2007 01:14 AM
Please respond to
[hidden email]

To
[hidden email]
cc

Subject
Re: running ofbiz - exception

Eric,

Please check that your JDBC driver version corresponds to the version of
the DB you use. Also are you sure of your parameters in
entityengine.xml for MySQL (login/pwd, etc.) ? The last point seems OK BTW
since your MyDQL DB seems to work (you deleted tables)

Jacques

----- Original Message -----
From: <[hidden email]>
To: <[hidden email]>
Sent: Monday, January 15, 2007 10:57 PM
Subject: Re: running ofbiz - exception

>
>
>
>
> Hi Jacques,
>
> Yes but just to make sure.... I removed the tables from the databases
and ran the "run-install" again. After double checking the
logs to make sure no exceptions were thrown, I tried running the
application again, only to get the same exception.
>
> I forgot to mention that I was using this against a MySQL DB.
>
> I changed my configuration back to derby.... ran the "run-install" and
everything seems to be working now.
>
> Is there a chance that the mysql install module is in error? Has anyone
else encountered this issue?

>
> Thanks,
> Eric
>
>
>
>
> Jacques Le Roux <[hidden email]>
>
> 15/01/2007 11:37 AM

To
> [hidden email]
>
cc
> Please respond to
> [hidden email]
Subject
> Re: running ofbiz -
exception
>
>
>

>
>
>
>
>
>
>
> Did you check the log after "run-install" ? Sounds like data are missing
in DB ...

>
> Jacques
> ----- Original Message -----
> From: [hidden email]
> To: [hidden email]
> Sent: Monday, January 15, 2007 7:07 PM
> Subject: Re: running ofbiz - exception
>
>
> Hi Jacques,
>
> Yes, I ran the run-install with success.... or at least it wasn't

apparent that there were any errors.

>
> Could there be another cause?
>
> Thanks,
>
> Eric
>
>
> Jacques Le Roux <[hidden email]>
> 01/15/2007 06:42 PM CETPlease respond [hidden email]
>
> To [hidden email]
> cc
> bcc
> Subject Re: running ofbiz - exception
>
>
>
>
> Eric,
>
> Did you ran "ant run-install" before ? It loads OOTB data demo and

should run fine.

>
> Jacques
>
> ----- Original Message -----
> From: <[hidden email]>
> To: <[hidden email]>
> Sent: Monday, January 15, 2007 6:10 PM
> Subject: running ofbiz - exception
>
>
> >
> >
> >
> >
> > I'm a newbie to ofbiz and forgive me if this question has been

answered already, but I'm having trouble starting the
application.
> >
> > So far I've gotten the latest source from SVN and have attepted to
run it both via command line and Eclipse... only to get the
> same result.
> >
> > Here's what spits out on the console.....
> >
> > .....
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:807:INFO ]
- order by not in select [false]
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:809:INFO ]
- alter table add column [true]*
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:810:INFO ]
- non-nullable column [true]*
> > 2007-01-15 09:12:27,411 (main) [ DatabaseUtil.java:847:INFO ]
Getting Table Info From Database
> > 2007-01-15 09:12:53,608 (main) [ DatabaseUtil.java:982:INFO ]
Getting Column Info From Database
> > java.lang.NullPointerException
> > at java.util.TreeMap.compare(TreeMap.java:1108)
> > at java.util.TreeMap.getEntry(TreeMap.java:362)
> > at java.util.TreeMap.containsKey(TreeMap.java:219)
> > at java.util.TreeSet.contains(TreeSet.java:211)
> > at
org.ofbiz.entity.jdbc.DatabaseUtil.getColumnInfo(DatabaseUtil.java:1030)
> > at
org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:143)
> > at
org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:119)
> > ......
> >
> > Its pretty vague.... does this look familiar to anyone? If so, is
there a step I've missed?
> >
> > Any help is appreciated.
> >
> > Regards,
> > Eric
>
>
> =
>