[eugenejsn]

OS: SUSE Linux 12
MyEclipse PRO 2014
App Server: Jboss 7.1
Database Server: AWS RDS Oracle 12

When I point the app server to a local Oracle server, using
<connection-url>jdbc:oracle:thin:@192.168.1.24:1521:test</connection-url>

Start the server (from MyEclipse) with the deployed app on it, and it works.

Now, repoint the connection url to a remote server such as the AWS RDS Oracle,

<connection-url>jdbc:oracle:thin:@test.west-2.rds.amazonaws.com:1521:test</connection-url>

The deployment failed.

It looks like connection to the remote Oracle server from MyEclipse is prohibited somehow.

Please help.

For a reference, I also tried connection to the same AWS RDS Oracle server using SQL Developer from my local network, and used the same connection string jdbc:oracle:thin:@test.west-2.rds.amazonaws.com:1521:test, and it worked. But when I tried it from MyElipse, it failed.

Thanks

Eugene

[support-swapna]

Eugene,

Sorry that you are seeing this issue. We could connect to the remote AWS RDS Oracle using the MyEclipse Database Explorer at our end.

Can you please check if you can connect to the remote server using the MyEclipse Database Explorer ?
Here is the FAQ for connecting to a database in MyEclipse : https://www.genuitec.com/products/myeclipse/learning-center/db/connecting-database-myeclipse/

If you can connect without any issues using the Database explorer, then it might be an issue with the JBoss server.

Let us know how it works for you.

–Swapna
MyEclipse Support

[eugenejsn]

Staring JBoss server within MyEclipse to access the remote database may take longer time (than access of the local database), for loading the parameters required by the application. So I need to increase the timeout in the server. But where and how to do that (say, I want to increase the timeout to 5 minutes)?

[eugenejsn]

I found some suggestions but not sure if they are on the target:

JBoss recipe of the day
If you try to start JBoss from Eclipse, by default Eclipse has a 50 second limit which is really too short, especially if you are starting JBoss xx releases.

To overcome this limit you have two options:

Double click on the server icon (In the Servers tab). In the next panel choose an appropriate timeout for your server.

Start JBoss AS from the JBoss AS Server View. In order to do so, you have to install JBoss tools on your Eclipse.

But not sure how can I implement it.

Eugene

[support-swapna]

Eugene,

I am afraid there is no way to modify the timeout for JBoss in MyEclipse 2014. The support for modifying timeout for a server is available in MyEclipse 2015.

From MyEclipse 2015 onwards,we have merged our connector framework with the Web Tools server framework, giving you the best server tooling across both camps. I recommend you move to MyEclipse 2015 which is based on Eclipse Luna and take advantage of the productivity-enhancing improvements.

Here is the link to download MyEclipse 2015 : https://www.genuitec.com/products/myeclipse/download/
You can download the MyEclipse 2015 CI or MyEclipse 2015 Stable stream and install it to a different location alongside your existing MyEclipse 2014 install. The license you currently hold is valid for MyEclipse 2015 as well.

In MyEclipse 2015, servers can be configured from : New > Other > Server wizard. Once the server is added, you can double click on the server in the Servers view to open the server Overview page.
In the Timeouts section of the Overview page, you can set the appropriate value for Start/Stop, save and restart the server. By default the timeout for JBoss Start and Stop is 240 seconds in MyEclipse 2015.

Here is the guide to using Application Servers in MyEclipse 2015 :
https://www.genuitec.com/products/myeclipse/learning-center/deploy/myeclipse-basic-application-server-tutorial/

Let us know how it works for you.

–Swapna
MyEclipse Support

[Author]

Posts