Exception while getting transaction

[Max Vaha]

Hello, ranchers!
I have the following method in a JSF bean

public static boolean saveUser(LoginBean lb){
        EntityManager em = HibernateUtil.getEntityManager();
        EntityTransaction t = em.getTransaction();
        t.begin();//exception
        UserEntity user = new UserEntity();
        user.setName(lb.getName());
        user.setPassword(lb.getPassword());
        em.persist(user);
        em.flush();
        t.commit();
 
        return true;
    }

I have tried this code with MySql and Postgres, application server is Tomcat 6.14. This is the exception:

 
java.lang.UnsupportedOperationException: Not supported by BasicDataSource
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:899)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:66)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:84)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1330)
at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:38)
at util.EAO.saveUser(EAO.java:21)
at model.LoginBean.saveUser(LoginBean.java:17)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.el.parser.AstValue.invoke(AstValue.java:131)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:88)
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:77)
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:776)
at javax.faces.component.UICommand.broadcast(UICommand.java:368)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:471)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:783)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:244)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:113)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:595)
   

Has anyone any ideas about this?
[ June 09, 2008: Message edited by: Max Vaha ]

[Rodrigo Lopes]

Please, show how your datasource is configured in the hibernate.cfg.xml file.

[Cameron Wallace McKenzie]

It does look like a datasource problem, that's for sure.

Perhaps you have a way of testing your datasource apart from Hibernate? Like just write some code that looks it up, opens a db connection, queries the database, and closes the connection? If there's an easy way to do that, it might be worth your time.

Your hibernate.cfg.xml file might have a peculiar setting as well. Post it and maybe there's something in there that stands out.

Database, app server and how the datasource is being managed or created might be great info as well.

-Cameron McKenzie

[Tim Holloway]

I think you need to show how your datasource is configured in Tomcat.

[Max Vaha]

I want to use hibernate as a JPA provider, so do I need hibernate.cfg.xml?
This is persistence.xml

  
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">
 
    <persistence-unit name="photo" transaction-type="RESOURCE_LOCAL">
 
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jta-data-source>java:comp/env/jdbc/mysql</jta-data-source>
        <class>entities.UserEntity</class>
        <properties>
            <property name="hibernate.archive.autodetection" value="class, hbm"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
            <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/photo"/>
            <property name="hibernate.connection.username" value="root"/>
            <property name="hibernate.connection.password" value="1234"/>
            <property name="hibernate.c3p0.min_size" value="5"/>
            <property name="hibernate.c3p0.max_size" value="20"/>
            <property name="hibernate.c3p0.timeout" value="300"/>
            <property name="hibernate.c3p0.max_statements" value="50"/>
            <property name="hibernate.c3p0.idle_test_period" value="3000"/>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
            
        </properties>
    </persistence-unit>
</persistence>
  

Context.xml in tomcat

 
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/" reloadable="true">
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
             maxActive="100" maxIdle="30" maxWait="10000" global="jdbc/mysql"
             username="root" password="1234" driverClassName="com.mysql.jdbc.Driver" defaultAutoCommit="false"
             url="jdbc:mysql://localhost:3306/photo"/>
 
</Context>
   

I checked connection using my IDE. It's ok.

[Rodrigo Lopes]

I believe that you don't need these lines in your persistence.xml file:

<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/photo"/>
<property name="hibernate.connection.username" value="root"/>
<property name="hibernate.connection.password" value="1234"/>

They are already in your tomcat config (context.xml)
When you call em.getTransaction(); you're asking the container for a new connection.
But if you keep these properties in your persistence.xml, then you're saying that hibernate will handle you connections, not the container
[ June 10, 2008: Message edited by: Rodrigo Lopes ]

[Max Vaha]

Hmm, thanks, but the same exception is thrown without these properties in persistence.xml. It is thrown even if there is no properties. Has anyone other idea's?
[ June 17, 2008: Message edited by: Max Vaha ]

[Max Vaha]

Thanks! Finally it is done!