Hello friends of the forum is jorge my name and I come from the equator, I am using hibernate 3.2.5, I have been doing both desktop applications such as Web smoothly thanks to the reference, I would like to know if I can help connect to mysql 5.0.37 with c3po, which is what I need to call and file in my hibernate.cfg.xml connection? For a desktop application, ie not need a web server, but of course want to know how to start the session with a different user and password every time I connect to the database ...

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:data/tutorial</property>
<property name="connection.username">sa</property> ****I hope that this data will change every time I go to start a new session ...
<property name="connection.password"></property> ****I hope that this data will change every time I go to start a new session ...
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<mapping resource="Event.hbm.xml"/>
</session-factory>
</hibernate-configuration>

this is posible? please help me, and thanks

Remove all database connection parameters from your hibernate config file. Put a file called hibernate.properties in your classpath. You can then put your connection and cp30 information there.

Example:


Hope this helps.

Mike.

Thank you for your help, what I want to know is whether it is possible to send the user and password connection, as parameters, or are statics to started SessionFactory?

Those values are static. The c3p0 cache will create a bunch of connections and hold them in a pool. You don't ask the user for a username and password for your database.

Those values are static. The c3p0 cache will create a bunch of connections and hold them in a pool. You don't ask the user for a username and password for your database.