Re: [enhydra] Would someone please tell me how to set those DB parameters

[Slobodan Vujasinovic <slobodan@xxxxxxxxxxxxx>]

Hi,

You should use:

context.xml:
------------
<Resource name="appDB" type="javax.sql.DataSource"
    url="URL"  password="password" maxActive="40" maxWait="5000"
    driverClassName="msql_driver_class_name"
    username="username" maxIdle="20"/>

web.xml:
---------
<env-entry>
<env-entry-name>DatabaseManager/DB/appDB/Connection/DataSourceName</env-entry-name>
<env-entry-value>jndi:appDB</env-entry-value>
<env-entry-type>java.lang.String</env-entry-type>
</env-entry>

<env-entry>
<env-entry-name>DatabaseManager/DB/appDB/ConnectionAllocator</env-entry-name>
<env-entry-value>com.lutris.appserver.server.sql.datasource.DataSourceConnectionAllocator</env-entry-value>
<env-entry-type>java.lang.String</env-entry-type>
</env-entry>

<env-entry>
<env-entry-name>DatabaseManager/DB/appDB/Connection/ConnectionFactory</env-entry-name>
<env-entry-value>com.lutris.appserver.server.sql.DataSourceDBConnectionFactory</env-entry-value>
<env-entry-type>java.lang.String</env-entry-type>
</env-entry>

Regards,
 Slobodan Vujasinovic
Enhydra Development Team



pwhitefield@xxxxxxxxxxxx wrote:

> I am currently using microsoft SQL as our DB server. There are a few 
> parameters that need to be set, would someone please fill in the ???? for me 
> to make it work. I tried using different class in there, but none work. I 
> have different exception while I was trying with different classes.
>
> thanks in advance.....
>
> Also, when I download enhydra 6.4 from objectweb, I could not find the jars 
> for com.lutris.appserver.server.sql.msql. I only have the standard DB 
> classes. Would someone please tell me why? I thought it was only for 
> enterprise version, but from the CVS directory, it should also be for Enhydra.
>
> <Resource name="appDB" type="????" 
>  maxWait="5000" maxActive="40" password="" maxIdle="2" username="sa"
>  driverClassName="com.inet.tds.TdsDriver"
>  url="URL" />
>
> <env-entry>
>            <env-entry-name>DatabaseManager/DB/appDB/ConnectionAllocator</env-entry-name> 
>    <env-entry-value>????</env-entry-value> 
>    <env-entry-type>java.lang.String</env-entry-type>
>        </env-entry>
>
> <env-entry> 
>            <env-entry-name>DatabaseManager/DB/appDB/Connection/ConnectionFactory</env-entry-name>
>    <env-entry-value>????</env-entry-value>
>    <env-entry-type>java.lang.String</env-entry-type>
> </env-entry>
>
>
>  
>
> ------------------------------------------------------------------------
>
>
> --
> 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
>