This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes jboss - mysql Table not found in statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jboss - mysql Table not found in statement" Watch "jboss - mysql Table not found in statement" New topic
Author

jboss - mysql Table not found in statement

Alessandro Ilardo
Ranch Hand

Joined: Dec 23, 2005
Posts: 218
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.


trying to decode a woman mind....
Alessandro Ilardo
Ranch Hand

Joined: Dec 23, 2005
Posts: 218
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

Alessandro,
I'm just linking to the JBoss thread in case anyone reading this wants to follow the topic over there.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jboss - mysql Table not found in statement
 
Similar Threads
Error while starting jboss(java.lang.ClassNotFoundException: No ClassLoaders found for: com.mysql.j)
Throw an exception dosnt cause to rollback when it is not
help needed
JNDI error message
Could not find datasource !!!