multiple databases

[varunthecool]

i want to create a database for each user with a number of tables.as we all know in JDBC we require a odbc bridge which creates a datasource which lets you access database...is it possible to create a data source using a java application and can a single java program access multiple databases using many data sources or should i do it using a single data source...(it is possible that i would want to do it as a server version(JSP or servlet) )
PS : a datasource points only to a single database??is there some way that i can make it point to many databases??i know its not logical but nethin can happen :)) now for every user a database...for each user sign up i need to create a database for him....should i use JNDI n API's like this??

[Heather]

Hi, I just know that data source is uses to access an only data base.
Although with an application you can access to other data bases.
I think that the idea is have an only data base where you access, and it's in tables from the data base where you organize the user's information.

[varunthecool]

i refined my ideas