Shared Hosting - Datasource Configuration

Previous topic

Install & configuration

Next topic

Author	Message
Ashish Gupta	Thursday 29 September 2005 3:36:01 pm In a shared-hosting environment, where I do not have consle access to the server How Do I - Put my database connection string (which includes a MYSQ DB name/password pair) - Do I get to configure server.xml( Tomcat), if not then is there an alternative where I can use Tomcat Data Source/Connection Pooling? I am considering shared hosting ( using JSP/Tomcat.MYSQL)and I dont know how I will be able to host it, if I use connection polling, As on standalone I have complete control over Server.xml file Thanks a lot.
Łukasz Serwatka	Friday 30 September 2005 1:37:01 am Ashish, you did not provide information which language/technology you use. If Java, then read doc about working with databases. You should have driver for MySQL, JDBC for example: Connection string can look: con = DriverManager.getConnection("jdbc:mysql:///test", "root", "secret"); If PHP, than should works with mysql_connect function. Check manual for PHP. However Tomcat as web server for eZ publish is not supported. And, your question is not related to eZ publish, and supported by eZp technology. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Ashish Gupta

Thursday 29 September 2005 3:36:01 pm

In a shared-hosting environment, where I do not have consle access to the server

How Do I
- Put my database connection string (which includes a MYSQ DB name/password pair)

- Do I get to configure server.xml( Tomcat), if not then is there an alternative where I can use Tomcat Data Source/Connection Pooling?

I am considering shared hosting ( using JSP/Tomcat.MYSQL)and I dont know how I will be able to host it, if I use connection polling, As on standalone I have complete control over Server.xml file

Thanks a lot.

Łukasz Serwatka

Friday 30 September 2005 1:37:01 am

Ashish, you did not provide information which language/technology you use. If Java, then read doc about working with databases. You should have driver for MySQL, JDBC for example:

Connection string can look:
con = DriverManager.getConnection("jdbc:mysql:///test", "root", "secret");

If PHP, than should works with mysql_connect function. Check manual for PHP. However Tomcat as web server for eZ publish is not supported.

And, your question is not related to eZ publish, and supported by eZp technology.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 20 2025 08:46:57
Script start
Timing:	Jan 20 2025 08:46:57
Module start 'layout'
Timing:	Jan 20 2025 08:46:57
Module start 'content'
Timing:	Jan 20 2025 08:46:57
Module end 'content'
Timing:	Jan 20 2025 08:46:57
Script end

Main resources:

Total runtime	0.0164 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.2969	152.6406
Module start 'layout'	0.0058	0.0035	741.9375	39.4766
Module start 'content'	0.0093	0.0049	781.4141	89.3984
Module end 'content'	0.0141	0.0023	870.8125	30.3047
Script end	0.0164		901.1172

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	14.8561	14	0.0002
Check MTime	0.0012	7.0443	14	0.0001
Mysql Total
Database connection	0.0010	6.1650	1	0.0010
Mysqli_queries	0.0032	19.2307	3	0.0011
Looping result	0.0000	0.1451	1	0.0000
Template Total	0.0018	10.9	1	0.0018
Template load	0.0009	5.4410	1	0.0009
Template processing	0.0009	5.4657	1	0.0009
Override
Cache load	0.0006	3.8334	1	0.0006
General
dbfile	0.0003	1.6787	8	0.0000
String conversion	0.0000	0.0609	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs