Hello, Platform: TomEE Web profile 1.5.0.
I am trying to do a very basic thing, setup a data source for MySQL. I have read the official guide (http://openejb.apache.org/configuring-datasources.html). It asks us to enter a Resource element in openejb.xml. I can not find that file anywhere in tomee-webprofile-1.5.0. I read in other places that I could use tomee.xml for the same purpose. So, I added this to my conf/tomee.xml. <Resource id="TestDS" type="DataSource"> JdbcDriver com.mysql.jdbc.Driver JdbcUrl jdbc:mysql://localhost/test UserName root Password some_pass </Resource> I copied MySQL driver JAR to tomee/lib folder. I wrote this code. Showing snippets here: @Resource(name="TestDS") DataSource ds; Connection con = ds.getConnection(); PreparedStatement ps = con.prepareStatement("select * from UserProfile"); The prepareStatement() call is throwing this exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERPROFILE at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) Why is the system using hsqldb driver? In fact, no matter what is use as name for @Resource, I get the same exception. What am I doing wrong? I am starting ToMEE from Eclipse, if that makes any difference. -- View this message in context: http://openejb.979440.n4.nabble.com/How-to-configure-MySQL-data-source-tp4659201.html Sent from the OpenEJB User mailing list archive at Nabble.com.
