You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by clearchris <cl...@hotmail.com> on 2007/06/06 22:07:18 UTC
connecting to demo database
Hello.
Sorry for this incredibly noobish question. I'm half a step from scrapping
derby and going with a DB that I know how to use.
I'm trying to browse the DB via the database browser in netbeans. I am
using the org.apache.derby.jdbc.EmbeddedDriver driver, with the database url
set to "jdbc:derby:ofbiz", and both the user and password set to "ofbiz".
Startofbiz.bat is running in another window. Netbeans complains about not
being able to find the "ofbiz" database. Is my configuration correct?
Thanks.
Chris
Re: connecting to demo database
Posted by Sandeep Ray <sa...@gmail.com>.
Hi Chris,
I am new to OFBiz myself and had a need to play around with Derby
understanding data part a little more. Found SQuirreL quite useful . Here is
the link http://db.apache.org/derby/integrate/SQuirreL_Derby.html
- Sandeep
On 6/7/07, Eric Schwartz <er...@steelerubber.com> wrote:
>
> make sure you use InnoDB instead of MyISAM as the database engine, since
> it
> supports transactions and foreign keys.
>
> --
> Eric Schwartz
> Web Developer/IT Staff
> Steele Rubber Products
> 6180 E NC 150 HWY
> Denver, NC 28037
> 704-483-9343 ext 273
> Fax: 704-483-6650
>
> "clearchris" <cl...@hotmail.com> wrote in message
> news:BAY126-DAV12C9A482F1957DC374F0DD5270@phx.gbl...
> > Please disregard this message. I'm up and running on mysql instead.
> >
> > Thanks!
> >
> > -----Original Message-----
> > From: clearchris [mailto:clearchris@hotmail.com]
> > Sent: Wednesday, June 06, 2007 3:07 PM
> > To: user@ofbiz.apache.org
> > Subject: connecting to demo database
> >
> > Hello.
> >
> >
> >
> > Sorry for this incredibly noobish question. I'm half a step from
> > scrapping
> > derby and going with a DB that I know how to use.
> >
> >
> >
> > I'm trying to browse the DB via the database browser in netbeans. I am
> > using the org.apache.derby.jdbc.EmbeddedDriver driver, with the database
> > url
> > set to "jdbc:derby:ofbiz", and both the user and password set to
> "ofbiz".
> > Startofbiz.bat is running in another window. Netbeans complains about
> not
> > being able to find the "ofbiz" database. Is my configuration correct?
> >
> >
> >
> > Thanks.
> >
> >
> >
> > Chris
> >
> >
> >
>
>
>
>
Re: connecting to demo database
Posted by Eric Schwartz <er...@steelerubber.com>.
make sure you use InnoDB instead of MyISAM as the database engine, since it
supports transactions and foreign keys.
--
Eric Schwartz
Web Developer/IT Staff
Steele Rubber Products
6180 E NC 150 HWY
Denver, NC 28037
704-483-9343 ext 273
Fax: 704-483-6650
"clearchris" <cl...@hotmail.com> wrote in message
news:BAY126-DAV12C9A482F1957DC374F0DD5270@phx.gbl...
> Please disregard this message. I'm up and running on mysql instead.
>
> Thanks!
>
> -----Original Message-----
> From: clearchris [mailto:clearchris@hotmail.com]
> Sent: Wednesday, June 06, 2007 3:07 PM
> To: user@ofbiz.apache.org
> Subject: connecting to demo database
>
> Hello.
>
>
>
> Sorry for this incredibly noobish question. I'm half a step from
> scrapping
> derby and going with a DB that I know how to use.
>
>
>
> I'm trying to browse the DB via the database browser in netbeans. I am
> using the org.apache.derby.jdbc.EmbeddedDriver driver, with the database
> url
> set to "jdbc:derby:ofbiz", and both the user and password set to "ofbiz".
> Startofbiz.bat is running in another window. Netbeans complains about not
> being able to find the "ofbiz" database. Is my configuration correct?
>
>
>
> Thanks.
>
>
>
> Chris
>
>
>
RE: connecting to demo database
Posted by clearchris <cl...@hotmail.com>.
Please disregard this message. I'm up and running on mysql instead.
Thanks!
-----Original Message-----
From: clearchris [mailto:clearchris@hotmail.com]
Sent: Wednesday, June 06, 2007 3:07 PM
To: user@ofbiz.apache.org
Subject: connecting to demo database
Hello.
Sorry for this incredibly noobish question. I'm half a step from scrapping
derby and going with a DB that I know how to use.
I'm trying to browse the DB via the database browser in netbeans. I am
using the org.apache.derby.jdbc.EmbeddedDriver driver, with the database url
set to "jdbc:derby:ofbiz", and both the user and password set to "ofbiz".
Startofbiz.bat is running in another window. Netbeans complains about not
being able to find the "ofbiz" database. Is my configuration correct?
Thanks.
Chris
Re: connecting to demo database
Posted by Vince Clark <vc...@globalera.com>.
I have never been able to establish a jdbc connection via a tool to
derby. I'm sure it can be done but wasn't worth troubleshooting. We
primarily use Postgres.
Note that the Entity Reference under Web Tools -> Entity Engine Tools
should provide all you need. It is very useful and every table
definition has a link to view the data, where you can also add or delete
records.
Walter Vaughan wrote:
> clearchris wrote:
>
>> Sorry for this incredibly noobish question. I'm half a step from
>> scrapping
>> derby and going with a DB that I know how to use.
>
> That's pretty much the idea. Derby is there as a proof of concept, not
> something you would want to do in real life.
>
> * PostgreSQL = probably highest use by developement team
> * MS-SQL = some have had good luck, others bad luck
> * MySQL = problematic at times use PostgreSQL
> * Oracle = new commits have fixed most problem
> * anything else you are flying solo from my impression
> YMMV
>
> Regardless you really don't want to be messing with the data from the
> back end anyways, other than backups/restores unless you really
> understand all the relationships involved in the hundreds of tables
> that may be impacted when you dink with data from the back end.
>
> From experiece, and I guess a few others will chime in... if you can
> run postgresql you will have the best chance of sucess with ofBiz or
> Opentaps.
>
> --
> Walter
--
Vince Clark
Global Era
The freedom of open source.
(303) 493-6723
(303) 455-2409 fax
vclark@globalera.com <ma...@globalera.com>
www.globalera.com
Re: connecting to demo database
Posted by Walter Vaughan <wv...@steelerubber.com>.
clearchris wrote:
> Sorry for this incredibly noobish question. I'm half a step from scrapping
> derby and going with a DB that I know how to use.
That's pretty much the idea. Derby is there as a proof of concept, not something
you would want to do in real life.
* PostgreSQL = probably highest use by developement team
* MS-SQL = some have had good luck, others bad luck
* MySQL = problematic at times use PostgreSQL
* Oracle = new commits have fixed most problem
* anything else you are flying solo from my impression
YMMV
Regardless you really don't want to be messing with the data from the back end
anyways, other than backups/restores unless you really understand all the
relationships involved in the hundreds of tables that may be impacted when you
dink with data from the back end.
From experiece, and I guess a few others will chime in... if you can run
postgresql you will have the best chance of sucess with ofBiz or Opentaps.
--
Walter