I have setup JBoss-IDE with Eclipse with Jboss. The Jboss Version I use jboss-4.0.2RC1.
1. I have configured MySQL version 5.0.21 to Jboss. and I followed the URL
http://www.cotsec.com/documentation/installation/j2ee_jboss_mysql/index.html#3.%20Add%20the%20Java%20MySQL%20Library to configure the database with JBoss.
2. I made a small table with MySQL
CREATE TABLE `fortunedb`.`test` (
`id` varchar(10) NOT NULL,
`name` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3. I made a simple Entity Bean Call Test bean to connect to the test table as follow
ejb-jar.xml::::
<![CDATA[Description for Test]]>
<display-name>Name for Test</display-name>
<ejb-name>Test</ejb-name>
com.account.TestHome
com.account.Test
<ejb-class>com.account.TestCMP</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
False
<cmp-version>2.x</cmp-version>
<abstract-schema-name>Test</abstract-schema-name>
<cmp-field >
<![CDATA[]]>
<field-name>id</field-name>
</cmp-field>
<cmp-field >
<![CDATA[]]>
<field-name>name</field-name>
</cmp-field>
jboss.xml::::::
<ejb-name>Test</ejb-name>
<jndi-name>ejb/Test</jndi-name>
jbosscmp-jdbc.xml::::
java:/MySqlDS
<datasource-mapping>mySQL</datasource-mapping>
<enterprise-beans>
<ejb-name>Test</ejb-name>
<table-name>test</table-name>
<cmp-field>
<field-name>id</field-name>
<column-name>id</column-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
<column-name>name</column-name>
</cmp-field>
</enterprise-beans>
4. I am running a Servlet Client to get the connection
public void init(ServletConfig config) throws ServletException {
try {
Context context = new InitialContext();
Object ref = context.lookup("java:comp/env/ejb/Test");
home = (TestHome) PortableRemoteObject.narrow(ref, TestHome.class);
} catch (Exception e) {
throw new ServletException("Lookup of java:/comp/env/ failed" + e);
}
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException,
IOException {
resp.setContentType("text/html");
PrintWriter out=resp.getWriter();
try {
Test bean = home.findByPrimaryKey("jk");
out.print(bean.getName());
} catch (Exception e) {
out.print(e);
}
5. But when I run this Servlet it gives me the following error
"javax.ejb.FinderException: Find failed: java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM test t0_Test WHERE' at line 1""
Please help me to go further on this. I am totally stuck here and I coukld not realise where I made the mistake.
dbc:jkdb 