Hi all,
We've been trying to access a MySQL database by JNDI using
JBoss 3.0.4 with Connector J3.0.5 Gamma as JDBC driver. When I try to get
connection an exception is throwed.
Follows the source code:
Context c = new InitialContext ();
javax.sql.DataSource datasource = (javax.sql.DataSource) c.lookup ("java:/AcmeSQL");
m_connectionDB = datasource.getConnection (new String ("root"), new String (""));
Follows the exception:
javax.ejb.EJBException: ICCProductionEJB: Could not create connection; - nested throwable: (java.sql.SQLException: Could not retrieve transaction isolation level from server); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not retrieve transaction isolation level from server))
What do I need to configure to get the connection properly?
Thanks in advance,
M�rcio Azevedo.
Follows the source code:
Context c = new InitialContext ();
javax.sql.DataSource datasource = (javax.sql.DataSource) c.lookup ("java:/AcmeSQL");
m_connectionDB = datasource.getConnection (new String ("root"), new String (""));
Follows the exception:
javax.ejb.EJBException: ICCProductionEJB: Could not create connection; - nested throwable: (java.sql.SQLException: Could not retrieve transaction isolation level from server); - nested throwable: (org.jboss.resource.ResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Could not retrieve transaction isolation level from server))
What do I need to configure to get the connection properly?
Thanks in advance,
M�rcio Azevedo.
--
M�rcio Em�lio Cruz Vono de Azevedo
Especialista em
Sistemas
Inatel Competence Center
http://www.inatel.br
