|
Your account includes with
MySQL
v5.0.37 and
PosgreSQL
v8.2.4 and huge
5000MB Disc Space.
JDBC connector is already preloaded on your account. You
can also
setup your own connectors.
There is no set limit for the number of MySQL connections
at a time but for large amount of connections you'll need
to setup MySQL
connection pool service.
Range of database management options
-
Command line management: SSH
Access with SCP provided to manage through shell
-
Remote Access: Administrate Mysql/PostgreSQL database
directly from your PC. To setup remote access, email us
your mysql user and pass once your account is active.
-
Web-based administration: Worlds #1 web-based
database management tool phpMyAdmin
and phpPgAdmin, included in your accounts.
You can create secure MySQL connection over SSH tunnel so
you can manage your MySQL database over encrypted connection
between our server and your computer.
JSP <> MySQL Connector (JDBC)
Setting
up a connection (example)
MySQL <> JSP connection working example
Using PostgreSQL in your Java code
The same as MySQL, but with small difference in the connection
string:
For MySQL: jdbc:mysql - For PostgreSQL: jdbc:postgresql
You don't need to upload MySQL or PostgreSQL drivers, since
they are already pre-loaded by default.
Apache with AJP connectors
Apache is used as proxy so if file finishes in php or html
it's not sent to tomcat. If it finishes with .jsp then it's
sent to tomcat.
Run your Java Apps and any PHP script/software from
your account
Yes because of AJP Connectors you can run both PHP and JSP
pages together under your account! Run Ecommerce software
with Java apps, Blogs, PhpBB, CMS and any other Php based
application. All plug & play, system ready.
|
Run your webapps off subdomains: Unlimited
subdomains included in your plan
Develop your apps on the server directly using
our Java compliler (javac)
No domain necessary. You can run your apps
off of an IP address ($5/mo) or use one of our spare
domains (in your order form choose 'spare domain'
option)
Transfer to Oxxus with ZERO downtime. Choose
free IP as your special free gift and test your
apps here before moving DNS across.
|
Related Questions:
Testing your apps before transferring DNS
How can I dump a MySQL database from the command
line?
Where is MySQL located?
Where is the MySQL log file?
Do you support JNDI naming lookups for JDBC
connections?
Yes, you can setup JNDI yourself in the server.xml
|
See also:
Managing
your database
Running JSPs and
PHPs
Working with Servlets
Java
development frameworks
Ecommerce
and Java
Deploying webapps
Setting up JavaMail
ZERO downtime transfers
|