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

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
>  


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