Home » Eclipse Projects » EGL Development Tools » EGL Deployment (Not getting database )
| EGL Deployment [message #906217] |
Fri, 31 August 2012 17:26  |
 Nathan Reed
Messages: 74
Registered: June 2012 |
Member |
|
|
Desktop: Mac 10.6.8 EGL EDT 0.8.1
Deploying to host: CentOS 6.3 MySQL 5.1 Tomcat 6.0 Apache 2.4
I am trying my first deploy to a remote host from EDT EGL. I am deploying to a web project and then creating a war file from tomcat. When I ftp the file to the webapps folder in tomcat it explodes as expected. I am able to access a web page as expected.
I do not get data as expected.
I have one dedicated service that does all of my data access. I am not certain I understand the resource bindings in the deployment descriptor.
My service program connects with code as follows:
ProcessorMasterTable SQLDataSource? { @resource { uri="binding:NewMySQL"}};
NewMySQL is the name of the resource binding in the one and only deployment descriptor. I created a connection profile and have the radio button for connection profile checked. This deployment descriptor setting works during development and it works when the application is deployed locally.
For deployment to the host I do the following:
In the one and only deployment descriptor I check the radio button Specify Connection Information. Then I supply the following information:
SQL Database: not an enterable field so it is blank
JDBC Driver Class: com.mysql.jdbc.Drive
Connection URL: jdbc:mysql://ip-placed-here:3306/pinstruc
User ID: supplied
User Password: supplied
Default schema: supplied
Class locations: left blank
I then save the deployment descriptor and deploy. I am able to use the connection information supplied here to connect to the remote host via the MySQL workbench with no issue.
When I deploy as above I can bring up a page that should display a list of records in a grid. The page displays as expected and an activity circle appears in the upper left hand corner of the page but no records ever display.
If I modify this and supply:
Class locations: mysql-connector-java-5.1.17.jar
Then the page displays but I do not see the activity circle.
The noted jar file is in the tomcat install lib directory.
In all cases I have Connect using a JNDI data source NOT checked.
Questions.
1. Should I be placing the database name in the url connection?
2. Do I need to specify the entire path for the class location? I was assuming it would find it in tomcat.
3. Is my assumption correct that selecting Specify connection information the deployment would use this for the mysql connection given the way I have my service program set?
4. Is there a better way to accomplish what I am trying to do? Just want to specify how to connect to a MySQL database in deployed application.
Any help would be appreciated.
Thx,
Nathan Reed
|
|
|
Current Time: Sat May 25 13:06:13 EDT 2013
Powered by FUDForum. Page generated in 0.01692 seconds
|
] 
Search
Help
Register
Login
Home
