I'm new to using Hibernate, I read some doc and trying to save my first object to db, here's the code I'm using, and the stack trace of the exception I get:

Hibernate version:2.1

Configuration cfg = new Configuration();
cfg.addResource("hello/Message.hbm.xml");
cfg.setProperties(System.getProperties());
SessionFactory sessions = cfg.buildSessionFactory();

Session session = sessions.openSession();
Transaction tx = session.beginTransaction();
Message message = new Message("Hello World");
session.save(message);
tx.commit();
session.close();

java.lang.UnsupportedOperationException: The user must supply a JDBC connection
at net.sf.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:32)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:289)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3361)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3321)
at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)
at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2251)
at hello.Message.main(Message.java:61)

Name and version of the database you are using:Oracle8i Enterprise Edition Release 8.1.7.0.0

and here's the contents of my hibernate.properties:

hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@linuxdev05.intra.it:1521:LINUXMF
hibernate.connection.username=mbank
hibernate.connection.password=mbank
hibernate.dialect=net.sf.hibernate.dialect.OracleDialect
hibernate.c3p0.min_size=5
hibernate.c3p0.max_size=20
hibernate.c3p0.timeout=300
hibernate.c3p0.max_statements=50
hibernate.c3p0.idle_test_period=3000

Can you help me?
Thank you.

have haven't set your connection provider.

can you tell me how to do that?

look connection provider up in the reference documentation.

read documentation,
modified my hibernate.properties:

hibernate.connection.provider_class=net.sf.hibernate.connection.C3P0ConnectionProvider

hibernate.dialect=net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@host:1521:sid
hibernate.connection.username=user
hibernate.connection.password=pwd

hibernate.c3p0.min_size=1
hibernate.c3p0.max_size=1
hibernate.c3p0.timeout=1800
hibernate.c3p0.max_statements=50

...still does not work :( i get the same error

dont want to be spoonfed but the beginnings are often troublesome, and the settings are overwhelming...

thanks

the error states that it is using the UserSuppliedConnectionProvider - hinting that it is either not seeing your hibernate.properties file and/or some issues with not being able to access the c3po provider.

Enable debug logging and see what it tells you.

I GOT IT!!!!!!
I was trying to use hibernate.properties in my classpath but I was also calling setProperties on Configuration!



took out .setProperties(System.getProperties())
works pretty fine
:)