Re: [enhydra] Mysql connection

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

Hi,

No, the portnumber did not make any difference either... :-(

It seems to me that the classloader cannot find "something (!?)" as it
is reporting "Unknown source" with all functions in the stack trace:

-------------------------
com.lutris.appserver.server.ApplicationException: Could not create
logical database simpleApp: Could not create logical database simpleApp
        at
com.lutris.appserver.server.StandardApplication.createDatabaseManager(Unknown 
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)
-------------------

Maybe it cannot find the database engine, or is it the jdbc-driver it
doesn't find?

I believe the exception is thrown in this statement:
-->  connection = Enhydra.getDatabaseManager().allocateConnection(); <--

Anyway, I don't find any documentation of these methods..., so I find it
hard to see whats really going on here...

mvh
Kjell-Einar



On fre, 2004-04-23 at 21:53, Michael Strapp wrote:
> Hi again,

>     Since the config setting looked OK, I googled for info on the MySQL
> connect string, and it looks like maybe you need the MySQL db port number in
> your connect string (3306 was used in the examples I found).  Have you tried
> "jdbc:mysql://localhost:3306/simpleApp" for a connect string?
> 
> Mike.
> 
> ----- Original Message ----- 
> From: "Kjell-Einar Ofstad" <kjell-einar.ofstad@xxxxxxxxxx>
> To: <enhydra@xxxxxxxxxxxxx>
> Sent: Friday, April 23, 2004 2:16 PM
> Subject: Re: [enhydra] Mysql connection
> 
> 
> >
> > Well, that is exactly what I have done in my run file (input/run.in)...
> >
> > Kjell-Einar
> >
> >
> > On fre, 2004-04-23 at 19:19, Michael Strapp wrote:
> > ,
> > >     You might need put the mysql-jdbc driver into your system CLASSPATH
> > > environment variable.
> > >
> > > ----- Original Message ----- 
> > > From: "Kjell-Einar Ofstad" <kjell-einar.ofstad@xxxxxxxxxx>
> > > To: <enhydra@xxxxxxxxxxxxx>
> > > Sent: Friday, April 23, 2004 1:05 PM
> > > Subject: Re: [enhydra] Mysql connection
> > >
> > >
> > > >
> > > > No, that does not work either...
> > > >
> > > > The error is still the same.
> > > >
> > > > Kjell-Einar
> > > >
> > > > On fre, 2004-04-23 at 18:25, Sinisa Milosevic wrote:
> > > > > Hi,
> > > > >
> > > > > Try with following configuration:
> > > > >
> > > > > DatabaseManager.Databases[] = simpleApp
> > > > >
> > > > > DatabaseManager.DB.simpleApp.ClassType = Standard
> > > > > DatabaseManager.DB.simpleApp.Connection.User = simpleuser
> > > > >
> > > > > Regards,
> > > > > Sinisa
> > > > >
> > > > >
> > > > > ----- 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
> > > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> > --------------------------------------------------------------------------
> --
> > > ----
> > >
> > >
> > > >
> > > > --
> > > > 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
> > > >
> > >
> > >
> > >
> > > ______________________________________________________________________
> > > --
> > > 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
> >
> >
> >
> 
> 
> ----------------------------------------------------------------------------
> ----
> 
> 
> >
> > --
> > 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
> >
> 
> 
> 
> ______________________________________________________________________
> --
> 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