Skip to Content
0
Former Member
Jun 08, 2005 at 10:21 AM

SQLServer datasource declaration in WebAS on Linux

16 Views

Hi everybody,

I've got problem defining a datasource (SQLServer) in Viual Administrator of my Web AS which is installed on Linux.

I think that all my parameters are correct for a connection but when I try, in DB initialisation tab, to test my connection by resquesting something in my database, I got the folloowing error :

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Can not obtain a JDBC connection

at com.sap.engine.services.ejb.entity.pm.TransactionContext.simpleGetConnection(TransactionContext.java:198)

at com.sap.engine.services.ejb.entity.pm.TransactionContext.getConnection(TransactionContext.java:278)

at com.sap.engine.services.ejb.entity.pm.PersistenceManager.getConnectionForFindMethod(PersistenceManager.java:345)

at com.twomoro.reso.op.ps.FamilleMoteurBean0PM.ejbFindAll(FamilleMoteurBean0PM.java:195)

at com.twomoro.reso.op.ps.FamilleMoteurLocalHomeImpl0.findAll(FamilleMoteurLocalHomeImpl0.java:522)

... 47 more

Caused by: 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.

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)

at com.sap.engine.services.ejb.entity.pm.PersistenceManager.getConnection(PersistenceManager.java:261)

at com.sap.engine.services.ejb.entity.pm.TransactionContext.simpleGetConnection(TransactionContext.java:191)

... 51 more

Caused by: 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.

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:188)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:286)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:231)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 53 more

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

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:159)

(...)

I was wondering if this is possible to declare an external datasource SQLServer on Windows, on a SAP Web Application Server which is installed on Linux ?

Thanx a lot,

Marc