Testing a JDBC connection

Thread view:

Tmuldoon - 13 Sep 2007 18:53 GMT

Hello,

Running an app that uses jdbc to connect to my sql 2005 database. I
am getting a error:

javax.servlet.ServletException: Error initializing BEA ALI Studio
- Error starting database connection pooling.
- SQLException occurred in JDBCPool: com.inet.tds.SQLException:
java.net.UnknownHostException: TESTDB\SQL2K5
params: com.inet.tds.TdsDriver, jdbc:inetdae7:TESTDB\SQL2K5:1433?
database=studiodb. Please check your username, password and other
connectivity info.

I tested the connection useing a MS Datalink object (.udl), it
connects fine.

How can I test the JDBC connection?

Thanks,

Tmuld.

Reply to this Message

Roedy Green - 13 Sep 2007 20:08 GMT

>How can I test the JDBC connection?

you did test it, and it failed.

Cut paste the sample connect code you got from BEA and your code, with
the password replaced by "sesame". Perhaps eyes here can see the
typo.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Arne Vajhøj - 14 Sep 2007 03:20 GMT

> Running an app that uses jdbc to connect to my sql 2005 database. I
> am getting a error:
[quoted text clipped - 11 lines]
>
> How can I test the JDBC connection?

I don't know that driver - I always use the MS one, but my
guess would be that jdbc:inetdae7:TESTDB\SQL2K5:1433 should
be jdbc:inetdae7:ipnameornumberofserver:1433 !

Arne

Reply to this Message

Ruud de Koter - 17 Sep 2007 15:58 GMT

> javax.servlet.ServletException: Error initializing BEA ALI Studio
> - Error starting database connection pooling.
[quoted text clipped - 3 lines]
> database=studiodb. Please check your username, password and other
> connectivity info.

It isn't that difficult: TESTDB\SQL2K5 isn't a host, so you clearly can
not give the instance there and/or using the backslash syntax. You seem
to be assuming M$'s syntax is universal. It isn't.

If you'd check the driver manual at
http://www.inetsoftware.de/products/jdbc/mssql/manual.asp#Syntax you 'd
find how to code for a named instance OR a port number, not for both.
There 's a catch in the port to be used by your named instance, as you
'll see.

Regards,

Ruud de Koter.

Reply to this Message

Tmuldoon - 17 Sep 2007 22:04 GMT

Hello Ruud,

the actual config line is:

<url>jdbc:inetdae7:Station-123.abc.com\SQL2K5:1433?database=studiodb</
url>

station-123 the name of the computer. Station-123.abc.com is the full
domain name. On that workstation there is an SQL Server 2005 (in
compatibility mode) database called studiodb.

The correct id and password are used.

The main application is running off a vpc - it asks for the database -
it is located on Station-123 (which is also running the VPC).

I checked with the link you sent (thanks!)

* jdbc:inetpool:inetdae7:www.inetsoftware.de:1433
* jdbc:inetpool:inetdae7:localHost:1433
* jdbc:inetdae7:210.1.164.19:1433
* jdbc:inetdae7:[2002:d201:a413::d201:a413]:1433
* jdbc:inetpool:inetdae7://MyServer/pipe/sql/query
* jdbc:inetpool:jdbc:inetdae7:www.inetsoftware.de:1433
* jdbc:inetpool:jdbc:inetdae7:localHost:1433
* jdbc:inetpool:jdbc:inetdae7://MyServer/pipe/sql/query

Tried changing the slash, adding the full domain name and not - still
- no connection

Again, using a .udl - it connects using station-123\SQL2K5...

I tried pasting this on the cmd :
jdbc:inetdae7:Station-123.abc.com\SQL2K5:1433?database=studiodb of
course it error our not knowing that command

Trying to telnet to station-123 1433 on a cmd prompt says:

Connecting To station-123...Could not open connection to the host, on
port 1433: Con
nect failed.

How else can I proceed?

Thanks,

Tmuld

Reply to this Message

Ruud de Koter - 17 Sep 2007 22:22 GMT

Hi Tmuldoon (is that really your name?),

Some comments inline.

> the actual config line is:
>
[quoted text clipped - 5 lines]
> The main application is running off a vpc - it asks for the database -
> it is located on Station-123 (which is also running the VPC).

I wouldn't know whether the use of vpc would make a difference here. You
might want to check that.

> I checked with the link you sent (thanks!)
>
> Tried changing the slash, adding the full domain name and not - still
> - no connection

The way I read the doc it tells you to use either:
jdbc:inetdae7:Station-123.abc.com/SQL2K5 (provided the instance is
running on port 1434)
or:
jdbc:inetdae7:Station-123.abc.com:1433 (if it is running on port 1433).

Did you try these?

> How else can I proceed?

Are you sure the instance is on port 1433? In that case you should use
the second URL suggested.

I don't suppose you have a support contract with iNet (don't tell me how
you got the drive ;-(). Their support is very responsive.

Hope this helps,

Ruud.

> Thanks,
>
> Tmuld

Reply to this Message

Roedy Green - 18 Sep 2007 03:52 GMT

>I tested the connection useing a MS Datalink object (.udl), it
>connects fine.

If you are you are trying to connect to a Microsoft SQL Server
database, have a look at
http://mindprod.com/jgloss/jdbc.html#CONNECTING
for sample code.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Roedy Green - 18 Sep 2007 03:53 GMT

>Running an app that uses jdbc to connect to my sql 2005 database. I
>am getting a error:
>
>javax.servlet.ServletException: Error initializing BEA ALI Studio

So you are using a BEA servlet womb with a MySQL database?

What puzzles me is your connect strings look very different from those
I used to access MySQL.

If you are accessing MySQL, have a look at
http://mindprod.com/jgloss/jdbc.html#CONNECTING
for sample code.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Testing a JDBC connection

Free Magazines