Seam Framework and MySQL Database

IvanV · Jul 10, 2010, 12:29 AM

I'm trying to make a Seam application that uses a MySQL database as datasource. I tried modifying one of the examples built into Seam, but I keep getting errors. Can anyone give me an example of a working persistence.xml (and any other file which I have to modify in order to use my own database instead of the built in one) file for an application that connects to MySQL?

***craig5320*** · Jul 10, 2010, 02:38 AM

What kind of errors are you getting? MySQL errors? I'm not familiar with Seam I'm afraid.

IvanV · Jul 10, 2010, 12:54 PM

I must say I no longer remember. I was helping a friend to get any kind Seam web app up and running from 6:30 PM till 5 AM (mostly to the sounds of heavy metal, we were in the basement of our faculty building which, at night, works as a club), finally went to bed at 6:30 AM and, after 5 h of sleep, bits of last night are a blur.

The good news is that once we figured other things out, we were able to properly set up a new Seam application in Eclipse and it generated the XML files for us (we previously abandoned it because we found it confusing with all the folders in the project structure and stuff, plus we kept beating it up with bad code to the point where it could no longer stop and restart jboss, so we reverted to using Notepad and command line for awhile

).

One of the frustrating things was that we were unable to find almost any help. In case of the problem of connecting to MySQL, I knew I had to modify persistence.xml and set the right SQL dialect, database url, schema name, username and password, but all I found on the matter were people asking "I made this, why doesn't it work?" and others answering "Try this/try that", none of which helped and not a single working example (the examples that come with Seam use some hidden database built into jboss and lack most of these settings), so at one point I thought I might ask here.

Thanks for showing interest, Craig.

***craig5320*** · Jul 10, 2010, 05:36 PM

No worries, I know how frustrating it can be trying to troubleshoot code, when things here work, and then others don't and there's just no logical explanation. lol

Jul 10, 2010, 12:29 AM	#1
IvanV HH Assassin Guild Member Join Date: Dec 2004 Posts: 5,921 Rep Power: 336 System Specs	Seam Framework and MySQL Database I'm trying to make a Seam application that uses a MySQL database as datasource. I tried modifying one of the examples built into Seam, but I keep getting errors. Can anyone give me an example of a working persistence.xml (and any other file which I have to modify in order to use my own database instead of the built in one) file for an application that connects to MySQL? __________________ If anyone has Portal 2 and hasn't played the co-op and wants to do me a favour, let me know (PM me or whatever).

Jul 10, 2010, 02:38 AM	#2
*craig5320* HH Administrator Join Date: May 2002 Location: Manchester, UK Posts: 8,578 Rep Power: 445 System Specs	Re: Seam Framework and MySQL Database What kind of errors are you getting? MySQL errors? I'm not familiar with Seam I'm afraid. __________________ HardwareHeaven on Facebook

Jul 10, 2010, 12:54 PM	Thread Starter #3
IvanV HH Assassin Guild Member Join Date: Dec 2004 Posts: 5,921 Rep Power: 336 System Specs	Re: Seam Framework and MySQL Database I must say I no longer remember. I was helping a friend to get any kind Seam web app up and running from 6:30 PM till 5 AM (mostly to the sounds of heavy metal, we were in the basement of our faculty building which, at night, works as a club), finally went to bed at 6:30 AM and, after 5 h of sleep, bits of last night are a blur. The good news is that once we figured other things out, we were able to properly set up a new Seam application in Eclipse and it generated the XML files for us (we previously abandoned it because we found it confusing with all the folders in the project structure and stuff, plus we kept beating it up with bad code to the point where it could no longer stop and restart jboss, so we reverted to using Notepad and command line for awhile ). One of the frustrating things was that we were unable to find almost any help. In case of the problem of connecting to MySQL, I knew I had to modify persistence.xml and set the right SQL dialect, database url, schema name, username and password, but all I found on the matter were people asking "I made this, why doesn't it work?" and others answering "Try this/try that", none of which helped and not a single working example (the examples that come with Seam use some hidden database built into jboss and lack most of these settings), so at one point I thought I might ask here. Thanks for showing interest, Craig. __________________ If anyone has Portal 2 and hasn't played the co-op and wants to do me a favour, let me know (PM me or whatever).

Jul 10, 2010, 05:36 PM	#4
*craig5320* HH Administrator Join Date: May 2002 Location: Manchester, UK Posts: 8,578 Rep Power: 445 System Specs	Re: Seam Framework and MySQL Database No worries, I know how frustrating it can be trying to troubleshoot code, when things here work, and then others don't and there's just no logical explanation. lol __________________ HardwareHeaven on Facebook