Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jboss - mysql Table not found in statement

 
Alessandro Ilardo
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,
I'm trying to establish a connection from an EJB module running on Jboss 4 to a Mysql 5 database.





When I try to run the modue from a simple client I get the following error:
Exception is caught: EJBException:; nested exception is:
javax.ejb.EJBException: ejbCreate: Tabella non trovata in statement [insert into savingsaccount values ( ? , ? , ? , ? )]

It basically says that the table has not been found in the statement.
The query shoulb be ok, I did some test in the mysql client. It may not have the default database set. But in the jdbc parameters it has it (after the url).

Does anyone have an idea on what my problem is?
Thank in advance.
 
Alessandro Ilardo
Ranch Hand
Posts: 218
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I partially solved my problem, which was related to JBoss datasource configuration.

http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources

Partially because the ejb correclty connects to MySQL, but I've got an error from the JBoss init, so I'm going to continue this topic on JBoss forum.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alessandro,
I'm just linking to the JBoss thread in case anyone reading this wants to follow the topic over there.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic