JDBC configuration and also error logs files

[Former Member]

Hi all,

I have encountered some error during the configuration of the JBDBC at the server side. I wan to know whether for the configuration part. we have to enter the

host and the port number.

I entered this,

<IPAddress>:80;databasename="database"

is the port number correct? I am not too sure. But they is prob running when i tried to execute my SELECT statement to try out whether it can work or not. I check the log files and these are my errors

error 1:

com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

error 2:

com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

error 3:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Have anyone encountered these error b4?? How to solve them ??

Thanks loads

Quatre

[Former Member · Accepted solution]

Hi

For configuration, we add database URL which as

jdbc:sqlserver://<host_name>:<port>;DatabaseName=<db_name>

host_name is either localhost or ip address

Port is generally 1433

Thanks & Regards

Harsimran

[Former Member · Accepted solution]

hi there..

Thanks,i will try it out.

Quatre

[Former Member · Accepted solution]

Hi quatre,

i don't know if you have answered your request.

I get the same problem with MaxDB Database and i solved thanks to the following Wiki :

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/step-by-step%2bguide%2bmaxdb%2bjdbc

I know that it is for MaxDB but maybe it could help you.

Emmanuel

[Former Member · Accepted solution]

Hi again,

you can also find the solution in the following link :

Emmanuel

[Former Member]

Hi there,

Thanks for ur help, i have resolved my problem already.

For solution pls go to this thread,

<a href="https://www.sdn.sap.com/irj/sdn/thread?forumID=41&threadID=402668">https://www.sdn.sap.com/irj/sdn/thread?forumID=41&threadID=402668</a>

Thanks loads

Quatre

[Former Member]

Hi Quatre,

Along with Connection URL you need to provide the Driver class name as

com.sap.portals.jdbc.sqlserver.SQLServerDriver

Regards,

Biswadidev