Re: [enhydra] Mysql connection

["Michael Strapp" <mstrapp@xxxxxxxxxxxxx>]

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
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >