[SOLVED] Deploying Visual Web JSF in production Glassfish server

[andresdelosreyes]

Hello everyone, I'm having trouble deploying my Visual web JSF app in the glassfish v2 production server which is not registered in Netbeans 6.5, I'm using my .war file, I've already uploaded to the production server via admin console, created the jdbc's via resources in the admin console, and my app is running, but it has trouble when connecting to the database, when it connects via a class for login it works perfectly, but when it has to display tables created by dragging a database table to the visual table component, it just does not show them.

Please help me here

Andres de los Reyes

[jyeary]

I have encountered something similar in the past. It may have to do with the dataproviders in dataprovider.jar. I had to login as the user who owns the tables to work on them, if I remember correctly. It would not allow transitive permissions to another user.

I hope that helps.


On Wed, Jul 14, 2010 at 11:31 AM, andresdelosreyes <address-removed ([email]address-removed[/email])> wrote:

[andresdelosreyes]

Can you be a little more specific please about the same user, where can I change users, or where can I find the file dataprovider.jar??

if it helps here is my log file

[jyeary]

The user you are using for your JNDI connection should match the owner of the tables. You change the login in your JNDI connections on GlassFish. The dataprovider.jar is bundled in your war file once you compile and package your application.

I am not sure what this means:

Caused by: javax.naming.NameNotFoundException: sist_juridico_MySQL not found

Is sist_juridico_MySQL the name of the database? If so, you seem to have an issue with your JNDI lookup. You can check the connections and ping

[andresdelosreyes]

The user I'm using matches the owner of the tables, and yes sist_juridico_MySQL is the name of my JDBC resource in glassfish 2.1, what I don't understand is Why if the complete name is "jdbc/sist_juridico_MYSQL" the one that is missing is "sist_juridico_MYSQL", I tried creating it whit that name but I still get the same error message.

I have ping my Connection Pool and it pings successfully, I have no idea what is the problem here, the only hint I have is the "javax.naming.NameNotFoundException:" can you help me, where can I check the JNDI lookup. or what do I have to check in the Netbeans Glassfish v2.1 and compare it whith my produccion server Glassfish 2.1?

Please help, I'm a total newbie in glassfish

[andresdelosreyes]

Just solved the problem!!!

What I did was to add my production server in Netbeans servers, then changed the project properties so that the project deploys in my production server, and led Netbeans handle the server (Glassfish v2.1) configuration, now its working perfectly, thanks jyeary for your help, I guess something was wrong with the connection pool or the odbc's...

[jyeary]

I am glad you resolved it. I was approaching it from what I thought was a different issue.

Cheers.


On Tue, Jul 20, 2010 at 9:17 AM, andresdelosreyes <address-removed ([email]address-removed[/email])> wrote: