HTTP Status 500 - JBoss

[blertadhimitri]

where i am supposed to find this...Sorry this may be an ignorant question but at this point I need reliable resources couse i have more than 2 weeks with this project and i'm totally bored with all the problems it brought to me ...

[blertadhimitri]

Sorry for the ignorance of the question but where i'm supposed to find this??
I'm sorry but all the problems this project brought to me have totally disoriented me

[Tolls]

The MySQL Connector-J documentation.
Have a look at the examples page.

[blertadhimitri]

I did some other things trying to find the solution but the error remains the same ...

[Tolls]

What things?
Did you read those docs?
Did you change the driver you are trying to reference in your data source?

[blertadhimitri]

Yes i changed the driver and the log files now specifies that :
com.javasrc.webphotogallery.dao.AlbumDAOException: SQL Exception while getting DB connection :
2013-02-05 21:31:01,409 ERROR [STDERR] (http-127.0.0.1-8080-3) org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.)

[Tolls]

I suspect it's time to dig out the JBoss docs.

[blertadhimitri]

Uffff I read yeasterday all about the version of JBoss i am using.
I found that org.gjt.mm.mysql.Driver is an old driver - class and it was suggested to update it to com.mysql.jdbc.Driver as soon as possible...
I don't know exactly how this update should be made but when i changed the driver class specification in my webphotogallery-ds.xml from org.gjt.mm.mysql.Driver to com.mysql.jdbc.Driver the log file says the thing i mentioned before :
com.javasrc.webphotogallery.dao.AlbumDAOException: SQL Exception while getting DB connection :
2013-02-05 21:31:01,409 ERROR [STDERR] (http-127.0.0.1-8080-3) org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.)

[blertadhimitri]

The thing that i don't understand most is the fact that the connection betwee jBoss and mysql is working when i put images in the db through the class LoadImage ...

[Tolls]

So changing the Driver fixed the problem with no class found.
Something else is causing the null factory.
That could well be your code, though.
If one part works, and another part doesn't, then compare the two bits of code.

[blertadhimitri]

Okkk ... yesterday I finelly solved all my problems...I didn't change the driver class "org.gjt.mm.mysql.Driver" , but I changed the way of getting the db connection in my code!
When I got the error I was specifying the db connection as:

....
....
Connection conn = null;
        PreparedStatement ps = null;

        try
        {
            conn = this.getDBConnection();
...
...

and i had created this method:

protected Connection getDBConnection() throws AlbumDAOException
    {
        try
        {
            return datasource.getConnection();
        } 
        catch( SQLException se )
        {
            throw new AlbumDAOException( "SQL Exception while getting " +
                                         "DB connection : \n" + se);
        }
    }

To resolve the problem I removed this lines of code and replaced them with:

....
....
Connection conn = null;
        PreparedStatement ps = null;

        try
        {
		    try {
				Class.forName("org.gjt.mm.mysql.Driver");
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
            String url = "jdbc:mysql://localhost:3306/webphotogallery";
            String username = "root";
            String password = "";
            conn = DriverManager.getConnection( url, username, password );
....
....

This didn't solve my problem at all, so I tried to do sth else ...
I also included the Java connector (JDBC .jar file ) in the lib directory of WEB-INF and voilaaa , finally I had the possibility to view for the first time my web photo gallery .

I also got another error when trying to upload an image from my pc to one album of my web photo gallery .
I resolved this problem this way:
1) At first I opened Eclipse and for the ImageUploadServlet.java :
-rightclick>>Build path>>Configure Build path>>Libraries>>Add External JARs
at this point I added commons-fileupload-1.2.2.jar
2)I downloaded commons-io and encluded it in the CLASSPATH of my system environment variables and in the lib directory of WEB-INF
This resolved the problem of uploading images
Thank you all
b.dhimitri

[Tolls]

Do not set the CLASSPATH in your environment.
That is out and out the wrong way of doing things.
If it's in the WEB-INF/lib then it's accessible by your application.
If it's needed by JBoss then it needs to be higher up in one of the JBoss libs (you'd need to read the docs).

Finally, you really should figure out how to use a DataSource and it's underlying connection pool.
The way you are doing it at the moment is not scaleable.

[blertadhimitri]

Ok...
Anyway I will remove all the changes I did this week couse I built this project only for my class of Enterprise Architecture ...
I don't think I will use JBOss and java in the future