Hi,
I am using Jboss 3.0.3 and database is Mysql ,i am deploying the message
driven been,
i am unable to insert the data into database, the following warning is comming
///warning
16:46:39,646 WARN [LocalTxConnectionManager$LocalConnectionEventListener]
prepare called on a local tx. You are not getting the semantics you expect!
here is my code:
data source name in mysql-service.xml is MySQLPool
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=MySQLPool">
<attribute name="JndiName">MySQLPool</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:mysql://192.168.5.1:3306/IGSMsg</config-property>
<config-property name="DriverClass"
type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
<!--set these only if you want only default logins, not through
JAAS -->
<config-property name="UserName"
type="java.lang.String">root</config-property>
<config-property name="Password"
type="java.lang.String"></config-property>
</properties>
</attribute>
///////
my ejb-jar.xml is
<resource-ref>
<res-ref-name>jdbc/MySQLPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
////////////
my Message Driven Bean is
InitialContext initial = new InitialContext();
DataSource ds =
(DataSource)initial.lookup("java:comp/env/jdbc/MySQLPool");
.......
...............
String sqlStmt = "INSERT INTO IGSMESSAGE VALUES ( ? , ? , ?, ?)";
con = ds.getConnection();
PreparedStatement stmt = con.prepareStatement(sqlStmt);
stmt.setString(1, messageId);
stmt.setString(2, type);
stmt.setString(3, ((TextMessage)message).getText());
stmt.setString(4,topicName);
stmt.executeUpdate( sqlStmt);
stmt.close();
..............
so, where is the problem?Data source is bounding, and Some times's It's giving
SQL Exception ,Table not found exception even though the table is existing,
Can anyone help me? I am unable to find the problem? am I missing any thing? I
tried 100 of times but same error is comming..
Thanks in advance.
--
Madhu Sudhan .A
M.Tech,MIGS,(MS)
Software Engineer
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
infoGLYPTIC Software (P) Ltd
Ph: 523 4448/49/50, fax: 523 4451 ext: 335
Cell: 98451 05295
[EMAIL PROTECTED]
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
