As this is a part of the hibernate configuration rather than the
database / datasource configuration the SQL dialect has to be configured
in the hibernate configuration file, not in the context.
Here's my SessionFactory class just in case:
(I think this could be realized in a better way using
is it possible to define SQL Dialects "org.hibernate.dialect.MySQLDialect" in
context.xml in Tomcat? how? thanks.
Jens Greven wrote:
>
> You can also use c3p0 with Tomcat JNDI, e. g.
>
>
>
>auth="Container"
> type="com.mchange.v2.c3p0.ComboPooledDataS
You can also use c3p0 with Tomcat JNDI, e. g.
description="DB Connection"
jdbcUrl="jdbc:mysql://server:3306/mysql?autoReconnect=true"
driverClass="com.mysql.jdbc.Driver"
user="root"
password="password"
thank you, it works!
there are two factor need to mention:
1) as i used hibernate to create Database-connection before, the connection
pool C3P0 was used in hibernate. but when i try to maintain
Database-connection through JNDI in tomcat, i donn't need C3P0 anymore. so,
i SHOULD delete configura
On 23/11/2009 16:03, dishmily wrote:
i have made few changes, but it didn't work.
(my project uses tomcat and hibernate.)
You didn't mention that before.
You need to configure Hibernate to use the DataSource "jdbc/mysql" that
you've created. It doesn't appear to be correctly configured at t
i have made few changes, but it didn't work.
(my project uses tomcat and hibernate.)
1) $Tomcat_Home\conf\context.xml was changed to:
WEB-INF/web.xml
2) was added into $Tomcat_Home\webapps\axis2\WEB-INF\web.xml
:
...
DB Connection
jdbc/mysql
thanks. the tomcat i use is Tomcat 6.0.
i will have a look at the URL.
Pid Ster wrote:
>
> On 23/11/2009 13:00, dishmily wrote:
>>
>> i use 3 tomcats in one PC, in each tomcat i have a webservice, for each
>> webservice i use a mysql database.
>>
>> my question is:
>>
>> how can i write a confi
On 23/11/2009 13:00, dishmily wrote:
i use 3 tomcats in one PC, in each tomcat i have a webservice, for each
webservice i use a mysql database.
my question is:
how can i write a config file in each tomcat to let tomcat1 load DB1,
tomcat2 load DB2 and tomcat3 load DB3.
thanks.
I'm guessing
