|
Home > Archive > WebSphere Application Server > January 2004 > DataSource configuration ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DataSource configuration ?
|
|
| Java_Forum 2004-01-19, 2:54 pm |
|
hi,
iwould like to connect to a Microsoft-access database using a
javax.sql.DataSource, so i have create a data source as it shown in the wasd
tutorial, but i have an exception when trying to connect to the database.
my question is, can i use the obbcjdbc bridge trough a javax.sql.datasource,
if yes how to configure the jdbc provider information (name, class name)
and which information have i to give in the data source dialog (name, jndi
name, ....)
thanks for your help
| |
| Bibhas Bhattacharya 2004-01-19, 2:54 pm |
| ODBC has built in connection pooling. Just use DriverManager.getConnection.
--
Thank you,
Bibhas Bhattacharya
--
Web Age Solutions Inc.
WebSphere and WebLogic Training and Consulting Services
www.webagesolutions.com
"Java_Forum" <hbekkali@wanadoo.fr> wrote in message
news:btron1$2ncg$1@news.boulder.ibm.com...quote:
>
>
> hi,
> iwould like to connect to a Microsoft-access database using a
> javax.sql.DataSource, so i have create a data source as it shown in the
wasdquote:
> tutorial, but i have an exception when trying to connect to the database.
> my question is, can i use the obbcjdbc bridge trough a
javax.sql.datasource,quote:
> if yes how to configure the jdbc provider information (name, class name)
> and which information have i to give in the data source dialog (name, jndi
> name, ....)
> thanks for your help
>
>
| |
| Java_Forum 2004-01-19, 2:54 pm |
| thanks for your answer
i really wan to use a javax.sql.Datasource and bind it to a jndi name,
because i want to make an example looking for a name in the jndi context,
and
extract my datasource, and after make a getConnection,
take for your answer
what i want is how to configure the jdbc provider dialog and the data source
dialog in websphere when the target database is a Ms-Access
THANKS AGAIN
--
__________________________________
Bekkali Hicham
34, rue de l'abreuvoir
91370 Vérriéres le buisson
Dom : 01 60 11 54 49
email : hbekkali@wanadoo.fr
"Bibhas Bhattacharya" <bibhas@webagesolutions-NO-SPAM.com> a écrit dans le
message de news:btsd0l$4ilo$1@news.boulder.ibm.com...quote:
> ODBC has built in connection pooling. Just use
DriverManager.getConnection.quote:
>
> --
> Thank you,
>
> Bibhas Bhattacharya
> --
> Web Age Solutions Inc.
> WebSphere and WebLogic Training and Consulting Services
> www.webagesolutions.com
>
> "Java_Forum" <hbekkali@wanadoo.fr> wrote in message
> news:btron1$2ncg$1@news.boulder.ibm.com...
> wasd
database.[QUOTE][color=darkred]
> javax.sql.datasource,
jndi[QUOTE][color=darkred]
>
>
| |
|
| Seems that it's possible to create a JDBC-ODBC datasource with JDK 1.4.1.
See http://java.sun.com/j2se/1.4.1/docs...rt/bridge.html. But
being sun.* package, I don't think you shouldn't rely on this for more than
samples, and I don't know if IBM JDK comes with such packages.
If you're merely doing examples, you could use Cloudscape.
|
|
|
|
|