Re: Datasource in Shark

Hi,

the DODS guys just discovered that data sources are not working when using DODS as standalone. If you are using DODS from an enhydra
server application, you can work with data sources, but otherwise, you can't.

In the future DODS releases, the usage of data sources will also be possible when using DODS as a standalone.

Thanks,
Sasa.


----- Original Message -----
From: "Gokcen Iskender" <[email protected]>
To: <[email protected]>
Sent: Thursday, June 23, 2005 2:43 PM
Subject: Re: [shark] Datasource in Shark


> Hi,
> I tried with the new DODS version togetger with shark
> 1.1 still gives the same exception.
>
>
> --- Sasa Bojanic <[email protected]> wrote:
>
> > Hi,
> >
> > you mentioned dods-runtime.jar ? There is no such
> > jar in current shark 1.1. version that uses DODS
> > 6.4, and previous DODS versions
> > didn't have this option for data sources. You can't
> > just use old DODS by just adding dsconnection.jar in
> > order to use data sources.
> >
> > Regards,
> > Sasa.
> >
> > ----- Original Message -----
> > From: "Gokcen Iskender" <[email protected]>
> > To: <[email protected]>
> > Sent: Thursday, June 23, 2005 9:43 AM
> > Subject: Re: [shark] Datasource in Shark
> >
> >
> > > Hi Sasa,
> > > I am experiencing the same problem.
> > > I added dods-runtime.jar and dsconnection.jar in
> > the
> > > classpath.
> > >
> > > In Shark.conf I added
> > >
> > >
> > DatabaseManager.DB.sharkdb.Connection.DataSourceName
> > =
> > > jndi:jdbc/dsi
> > >
> >
> DatabaseManager.DB.sharkdb.Connection.ConnectionFactory
> > > =
> > >
> >
> com.lutris.appserver.server.sql.DataSourceDBConnectionFactory
> > > DatabaseManager.DB.sharkdb.ConnectionAllocator =
> > >
> >
> com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator
> > >
> > >
> > > And commented out:
> > >
> >
> #DatabaseManager.DB.sharkdb.JdbcDriver="org.hsqldb.jdbcDriver"
> > >
> >
> #DatabaseManager.DB.sharkdb.Connection.Url="jdbc:hsqldb:d:/Shark-1.1/db/hsql/hsql"
> > >
> > > What is the problem?
> > >
> > > --- Sasa Bojanic <[email protected]> wrote:
> > >
> > > > Hi,
> > > >
> > > > it seems that you either didn't set properties:
> > > >
> > > >
> > >
> >
> DatabaseManager.DB.<database_id>.Connection.ConnectionFactory
> > > > =
> > > >
> > >
> >
> com.lutris.appserver.server.sql.DataSourceDBConnectionFactory
> > > >
> > DatabaseManager.DB.<database_id>.ConnectionAllocator
> > > > =
> > > >
> > >
> >
> com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator
> > > >
> > > > or you didn't include dsconnection.jar in your
> > > > classpath, so the above specified classes can't
> > be
> > > > found.
> > > >
> > > > Regards,
> > > > Sasa.
> > > >
> > > > ----- Original Message -----
> > > > From: "Monique Maker" <[email protected]>
> > > > To: <[email protected]>
> > > > Sent: Monday, June 20, 2005 9:02 AM
> > > > Subject: Re: [shark] Datasource in Shark
> > > >
> > > >
> > > > > Hello Sasa,
> > > > >
> > > > > We tried your recommendations on
> > > > shark-cvs-2005-06-02.
> > > > > Unfortunately, the engine refuses to start
> > without
> > > > this setting in Shark
> > > > > configuration file:
> > > > >
> > DatabaseManager.DB.sharkdb.Connection.Url="..."
> > > > >
> > > > > The error message is
> > > > > java.lang.Error: Failed to make Standard
> > > > Connection Allocator :
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.standard.StandardConnectionAllocator
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.loadConnectionAllocator(StandardLogicalDatabase.java:492)
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.initConf(StandardLogicalDatabase.java:271)
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.init(StandardLogicalDatabase.java:183)
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.<init>(StandardLogicalDatabase.java:169)
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.StandardDatabaseManager.loadLogicalDatabase(StandardDatabaseManager.java:536)
> > > > >         at
> > > > >
> > > >
> > >
> >
> com.lutris.appserver.server.sql.StandardDatabaseManager.<init>(StandardDatabaseManager.java:343)
> > > > >         at
> > > > >
> > > >
> > >
> >
> org.enhydra.shark.utilities.dods.DODSUtilities.init(DODSUtilities.java:204)
> > > > >         at
> > > > >
> > > >
> > >
> >
> org.enhydra.shark.instancepersistence.DODSPersistentManager.configure(DODSPersistentManager.java:99)
> > > > >         at
> > > > >
> > > >
> > >
> >
> org.enhydra.shark.SharkEngineManager.init(SharkEngineManager.java:258)
> > > > >         at
> > > > org.enhydra.shark.Shark.init(Shark.java:297)
> > > > >         at
> > > > org.enhydra.shark.Shark.configure(Shark.java:69)
> > > > > ...
> > > > >
> > > > > We want to use data sources to avoid explicit
> > > > database configuration in
> > > > > Shark config. As it seems, currently we cannot
> > > > avoid such dependancy.
> > > > >
> > > > > Is there anything else we have to change, or
> > this
> > > > is problem of the
> > > > > Shark engine?
> > > > >
> > > > > Best Regards,
> > > > > Monique
> > > > >
> > > > > Sasa Bojanic wrote:
> > > > >
> > > > > >Hi,
> > > > > >
> > > > > >this is the snippet from DODS 6.4
> > documentation:
> > > > > >Using DODS with javax.sql.DataSource
> > > > > >DODS can use separate ConnectionAllocator
> > > > implementation to support javax.sql.DataSource
> > as
> > > > database connections source for
> > > > > >connection allocation (see
> > "ConnectionAllocator"
> > > > and "ConnectionFactory" parameters reference).
> > > > > >
> > > > > >In case that DODS is configured to use
> > DataSource
> > > > then connection level parameters "Url", "User"
> > and
> > > > "Password" are sufficient.
> > > > > >Parameters named "ClassType" and "JdbcDriver"
> > are
> > > > not mandatory (DODS will try collect this
> > > > information's directly from
> > > > DataSource
> > > > > >and internal dodsConf.xml file) but this
> > > > information's can be useful in situations when
> > DODS
> > > > don''t recognize specific
> > > > > >driver/database.
> > > > > >
> > > > > >DataSource is defined externally to DODS by
> > some
> > > > environment dependent mechanism (eg. inside
> > > > Servlet/JSP Container ..) and DODS
> >
> === message truncated ===>
> > --
> > You receive this message as a subscriber of the
> > [email protected] mailing list.
> > To unsubscribe:
> > mailto:[email protected]
> > For general help:
> > mailto:[email protected]?subject=help
> > ObjectWeb mailing lists service home page:
> > http://www.objectweb.org/wws
> >
>
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your mobile phone.
> http://mobile.yahoo.com/learn/mail
>
>


--------------------------------------------------------------------------------


>
> --
> You receive this message as a subscriber of the [email protected] mailing list.
> To unsubscribe: mailto:[email protected]
> For general help: mailto:[email protected]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws