Hey I learned something new! Thanks Armin
Jeff
On Sunday 02 March 2003 04:17 am, you wrote:
> Hi Cornelius,
>
> ----- Original Message -----
> From: "Cornelius Keller" <[EMAIL PROTECTED]>
> To: "OJB Users List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Sunday, March 02, 2003 5:00 AM
> Subject: Re: OJB 0.9.9 & mysql: Database User & password form repository
> not used?
>
> > Yes thats solves the Problem,
> >
> > but then I have to recompile if I want to change the Database
>
> settigns, and
>
> > One of the reaseons for using OJB is that i dont want to.
> > Any other Solutions so that OJB uses the user and Password defined in
>
> the
>
> > repository_databases.xml?
> >
> > I am clling
>
> PersistenceBrokerFactory.createPersistenceBroker("default");
>
> If you set the 'default-connection' attribute
> to 'true' (and set user/password) in your jdbc-connection-descriptor,
> it's possible to lookup the PB with
>
> PersistenceBrokerFactory.defaultPersistenceBroker();
>
> or you could use
>
> PersistenceBrokerFactory.createPersistenceBroker(new PBKey("default"));
>
>
> If you got problems using PBKey("default"), there is a small bug
> in 0.9.9. Fix is in CVS.
> More info and how to patch under
>
> http://archives.apache.org/eyebrowse/[EMAIL PROTECTED]
> pache.org&msgNo=5507
>
>
> HTH
> regards,
> Armin
>
> > Thank you
> >
> > > Here is what I use for fetching a PersistenceBroker in my code:
> > >
> > > PersistenceBroker broker =
> > > PersistenceBrokerFactory.createPersistenceBroker(new
> > > PBKey("default","sa",""));
> > >
> > > Where "sa" equals a user id and "" is the password.
> > >
> > > Hope this info helps,
> > >
> > > Jeff
> > >
> > > On Saturday 01 March 2003 06:19 pm, you wrote:
> > > > Hello List,
> > > >
> > > > I am using the following Connection descriptor:
> > > >
> > > > <jdbc-connection-descriptor
> > > > jcd-alias="default"
> > > > default-connection="true"
> > > > platform="MySQL"
> > > > jdbc-level="2.0"
> > > > driver="org.gjt.mm.mysql.Driver"
> > > > protocol="jdbc"
> > > > subprotocol="mysql"
> > > > dbalias="//localhost:3306/fldb?autoReconnect=true"
> > > > username="root"
> > > > password="x"
> > > > batch-mode="false"
> > > >
> > > >
> > > > When creating a Persistence Broker, I am reciving the follwoing
> >
> > Exception :
> > > > General error: Access denied for user: '@localhost' to database
>
> 'fldb'
>
> > > > java.sql.SQLException: General error: Access denied for user:
> >
> > '@localhost'
> >
> > > > to database 'fldb'
> > > > at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> > > > at
> >
> > org.gjt.mm.mysql.Connection.connectionInit(Connection.java:264)
> >
> > > > at
>
> org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
>
> > > > at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
> > > > at
>
> java.sql.DriverManager.getConnection(DriverManager.java:512)
>
> > > > at
>
> java.sql.DriverManager.getConnection(DriverManager.java:193)
>
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConne
> cti
>
> > > >o nFromDriverManager(Unknown Source)
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFac
> tor
>
> > > >y .makeObject(Unknown Source)
> > > > at
>
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
> tPo
>
> > > >o l.java:710)
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnect
> ion
>
> > > >F romPool(Unknown Source)
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupCo
> nne
>
> > > >c tion(Unknown Source)
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Un
> kno
>
> > > >w n Source)
> > > > at
>
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Unkno
> wn
>
> > > > Source)
> > > > at
>
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.beginTransaction(Un
> kno
>
> > > >w n Source)
> > > > at
>
> org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.beginTransact
> ion
>
> > > >( Unknown Source)
> > > > at com.ckeller.flweb.application.FLApp.login(Unknown
>
> Source)
>
> > > > .......
> > > >
> > > >
> > > > When Creating a the first PersistenceBroker.
> > > > Why is OJB using the Databese and and url defined in the
>
> repository but
>
> > not
> >
> > > > the username and password?
> > > >
> > > > I just updated from OJB 0.9.7 to 0.9.9, in 0.9.7 my database setup
> >
> > worked
> >
> > > > well.
> > > > What am I doing wrong now?
> > > >
> > > > Thanks in Advance for your Time
> > > > - Cornelius
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --------------------------------------------------------------
> > > > Cornelius Keller
> > > > Stud. Inf.
> > > > Humbold Universit�t Berlin
> > > > ---------------------------------------------------------------
> > > > crewmeber of space station C-Base -
> > > > culture communication carbonite in berlin
> > > > visit: http://www.c-base.org/
> > > > ---------------------------------------------------------------
> >
> > ---------------------------------------------------------------------
> >
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> > ---------------------------------------------------------------------
> >
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
