I have started working with Jboss and was trying to access 2 different mysql databases on the same server. When I do this the server comes up with the following warning:
13:44:38,984 WARN [LocalTxConnectionManager$LocalConnectionEventListener] prepare called on a local tx. You are not getting the semantics you expect! 13:44:38,985 WARN [LocalTxConnectionManager$LocalConnectionEventListener] prepare called on a local tx. You are not getting the semantics you expect! If only access one of the databases (either one), no warnings and response is quick. If I hit both I get the warning and much slower response. I suppose because it has to process the Event. In all cases, it does retrieve the correct information from the databases. Any ideas about this warning??? We are running jboss-3.0.0_tomcat-4.0.3 on a Solaris system using jdk 1.3. Here is the code: package cae.mysql; import java.util.*; import javax.ejb.SessionBean; import javax.naming.*; import javax.rmi.PortableRemoteObject; import java.sql.*; public class MySQLBean implements SessionBean { public void ejbCreate() {} public void ejbPostCreate() {} public String getTL (String tlname) throws java.rmi.RemoteException { return getchk(); } public String getchk() { PreparedStatement pstmt = null; Connection conn = null; try { conn = getConnectionchk(); pstmt = conn.prepareStatement("Select fval from checkit where find = 1"); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { return rs.getString("fval"); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) pstmt.close(); } catch (Exception e) {} try { if (conn != null) conn.close(); } catch (Exception e) {} } return "Shucks"; } public String getTL() { PreparedStatement pstmt = null; Connection conn = null; try { conn = getConnectionTL(); pstmt = conn.prepareStatement("Select des_num from contains where draw_num = 174183"); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { return rs.getString("des_num"); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (pstmt != null) pstmt.close(); } catch (Exception e) {} try { if (conn != null) conn.close(); } catch (Exception e) {} } return "Dang, Missed again<br>\n"; } public Connection getConnectionchk() throws Exception { try { Context ctx = new InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/chkDS"); return ds.getConnection(); } catch (Exception e) { System.err.println("Couldn't get datasource!"); e.printStackTrace(); throw e; } } public Connection getConnectionTL() throws Exception { try { Context ctx = new InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/TravLogDS"); return ds.getConnection(); } catch (Exception e) { System.err.println("Couldn't get datasource!"); e.printStackTrace(); throw e; } } public void ejbActivate() {} public void ejbPassivate() {} public void ejbRemove() {} public void setSessionContext(javax.ejb.SessionContext ec) {} } _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user