connecting to demo database

[Christopher L]

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

[Walter Vaughan]

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]

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.
[phone]
[phone] fax
[hidden email] <mailto:[hidden email]>
www.globalera.com

[Christopher L]

Please disregard this message.  I'm up and running on mysql instead.

Thanks!

-----Original Message-----
From: clearchris [mailto:[hidden email]]
Sent: Wednesday, June 06, 2007 3:07 PM
To: [hidden email]
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

[Eric Schwartz-6]

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: [phone]

"clearchris" <[hidden email]> wrote in message
news:[hidden email]...

> Please disregard this message.  I'm up and running on mysql instead.
>
> Thanks!
>
> -----Original Message-----
> From: clearchris [mailto:[hidden email]]
> Sent: Wednesday, June 06, 2007 3:07 PM
> To: [hidden email]
> 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
>
>
>

[Sandeepray]

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 <[hidden email]> 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: [phone]
>
> "clearchris" <[hidden email]> wrote in message
> news:[hidden email]...
> > Please disregard this message.  I'm up and running on mysql instead.
> >
> > Thanks!
> >
> > -----Original Message-----
> > From: clearchris [mailto:[hidden email]]
> > Sent: Wednesday, June 06, 2007 3:07 PM
> > To: [hidden email]
> > 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
> >
> >
> >
>
>
>
>