Re: [enhydra] Mysql connection

[Kjell-Einar Ofstad <kjell-einar.ofstad@xxxxxxxxxx>]

Hi Mike.

Good grief..., it works!!! :-)
You just saved me from downloading the source..., thanks: 

As a conclusion: I'm using the settings described in "Getting
Started"-manual except for the jdbc-driver...
--------------------------------------------------------------------------
DatabaseManager.DB.simpleApp.JdbcDriver = com.mysql.jdbc.Driver
DatabaseManager.DB.simpleApp.Connection.Url =
"jdbc:mysql://heraklit:3306/simpleApp"
---------------------------------------------------------------------------

mvh
Kjell-Einar


On fre, 2004-04-23 at 23:31, Michael Strapp wrote:
> Hi Kjell,
>     I scanned for that the text of that exception in the Enhydra source
> code, and found it in one of the database classes that reads the connection
> details.  From the look of the code, and the look of the config you
> supplied, almost everything is fine - but it looks like the problem might be
> case sensitivity with the 'DatabaseManager.DB.x.Connection.Url' setting - in
> my config file, the example database config has this parameter as Url, but I
> see that you have it as URL.  Switch it to
> 'DatabaseManager.DB.simpleapp.Connection.Url' , cross your fingers, and
> hopefully that will do the trick!
> 
> Take care...
> Mike
> 
> ----- Original Message ----- 
> From: "Kjell-Einar Ofstad" <kjell-einar.ofstad@xxxxxxxxxx>
> To: <enhydra@xxxxxxxxxxxxx>
> Sent: Friday, April 23, 2004 5:12 PM
> Subject: Re: [enhydra] Mysql connection
> 
> 
> > Hi...
> >
> > Here's another message in between the stack-trace:
> > ------------------
> > Caused by: com.lutris.util.ConfigException: Bad
> > DatabaseManager.DB.simpleApp.Connection section defined in config file.
> > --------------------
> >
> > Well, something is wrong with the configuration although the message all
> > but self-explanatory
> >
> > Kjell-Einar
> >
> > > > > > > ----- Original Message ----- 
> > > > > > > From: "Kjell-Einar Ofstad" <kjell-einar.ofstad@xxxxxxxxxx>
> > > > > > > To: <enhydra@xxxxxxxxxxx>
> > > > > > > Sent: Friday, April 23, 2004 5:59 PM
> > > > > > > Subject: [enhydra] Mysql connection
> > > > > > >
> > > > > > > > I cannot get my simpleApp connected with mySql.
> > > > > > > > What's wrong?
> > > > > > > >
> > > > > > > >
> > > > > > > > * I have installed mysql-jdbc
> > > > > > > > * I have included mysql-jdbc in CLASSPATH in 'input/run.in'
> > > > > > > > * I have tested the connection with JDBCtest.java..., it
> worked
> > > OK.
> > > > > > > >
> > > > > > > > This is from 'input/conf/simpleApp.conf.in':
> > > > > > > > --------------------------------------------
> > > > > > > > DatabaseManager.Databases[] = simpleApp
> > > > > > > > DatabaseManager.DefaultDatabase = simpleApp
> > > > > > > > DatabaseManager.Debug = true
> > > > > > > > DatabaseManager.DB.simpleapp.ClassType = Standard
> > > > > > > > DatabaseManager.DB.simpleapp.Connection.User = simpleuser
> > > > > > > > DatabaseManager.DB.simpleapp.Connection.Password = simplepw
> > > > > > > > DatabaseManager.DB.simpleapp.Connection.MaxPoolSize = 5
> > > > > > > > DatabaseManager.DB.simpleapp.Connection.AllocationTimeout =
> 10000
> > > > > > > > DatabaseManager.DB.simpleapp.Connection.Logging = true
> > > > > > > > DatabaseManager.DB.simpleapp.ObjectId.CacheSize = 1024
> > > > > > > > DatabaseManager.DB.simpleapp.ObjectId.MinValue = 100
> > > > > > > > DatabaseManager.DB.simpleapp.JdbcDriver =
> "com.mysql.jdbc.Driver"
> > > > > > > >
> > > > > > >
> > > > >
> > >
> DatabaseManager.DB.simpleapp.Connection.URL="jdbc:mysql://localhost/simpleAp
> > > > > p"
> > > > > > > >
> > > > > > > >
> > > > > > > > This is the error (only the start of it...)
> > > > > > > > ---------------------------------
> > > > > > > > 2004-04-23 17:27:00,713: simpleApp,INFO,: simpleApp: init
> > > > > > > > 2004-04-23 17:27:00,999: Multiserver,ERROR,: Unable to change
> > > > > > > > application to running state
> > > > > > > > com.lutris.appserver.server.ApplicationException: Could not
> create
> > > > > > > > logical database simpleApp: Could not create logical database
> > > > > > > simpleApp
> > > > > > > >         at
> > > > > > > >
> > > > > > >
> > > > >
> > >
> com.lutris.appserver.server.StandardApplication.createDatabaseManager(Unknow
> > > > > n Source)
> > > > > > > >         at
> > > > > > > >
> com.lutris.appserver.server.StandardApplication.startup(Unknown
> > > > > > > Source)
> > > > > > > >         at simpleapp.SimpleApp.startup(SimpleApp.java:32)
> > > > > > > >         at
> > > > > > > >
> > > > > > >
> > > > >
> > >
> com.lutris.appserver.server.httpPresentation.servlet.HttpPresentationServlet
> > > > > .changeToRunningState(Unknown Source)
> > > > > > > > ----------------------------
> > > > > > > >
> > > > > > > >
> > > > > > > > \Kjell-Einar
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> 
> 
> 
> ______________________________________________________________________
> --
> You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx 
> mailing list.
> To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws