Hi, I have a very simple War, which contains a JSP and a pesistence.xml file. The Persistence.XML defines my persistence unit:
| <persistence-unit name="h-source"> | <properties> | <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/> | <property name="hibernate.connection.username" value="test_garageDB"/> | <property name="hibernate.connection.password" value="test_garageDB"/> | <property name="hibernate.connection.url" value="jdbc:oracle:thin:@opc151:1521:ora10g"/> | <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider"/> | <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect"/> | </properties> | </persistence-unit> | | The JSP creates and excutes a simple query | <%@ page info="Test" language="java" | import="javax.transaction.*, javax.naming.*, java.sql.*, com.arjuna.ats.jdbc.TransactionalDriver, java.util.Properties, | oracle.jdbc.xa.client.OracleXADataSource, javax.sql.*, javax.persistence.*, | org.hibernate.ejb.EntityManagerImpl"%> | <html> | <body> | Home is HOME | <% | oracle.jdbc.driver.OracleDriver d = new oracle.jdbc.driver.OracleDriver(); | DriverManager.registerDriver(d); | | | EntityManagerFactory emf = | Persistence.createEntityManagerFactory("h-source"); | System.out.println("emf is " + emf); | EntityManager em = emf.createEntityManager(); | EntityManagerImpl emImpl = (EntityManagerImpl)em; | Connection con = emImpl.getSession().connection(); | System.out.println("Connection is " + con); | System.out.println("em is " + em); | Query q = em.createNativeQuery("insert into TAddress (C, I, CITY) " + | "VALUES (" + 29 + ", " + 333 + | ", 'DUBLIN7')"); | q.getSingleResult(); | %> | | </body> | </html> | However, I get: | java.sql.SQLException: No suitable driver | java.sql.DriverManager.getConnection(DriverManager.java:545) | java.sql.DriverManager.getConnection(DriverManager.java:140) | I have my driver jar in the lib directory. I also instantiate it, so I cannot see what I am doing wrong? Any ideas View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4106475#4106475 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4106475 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user