ojb with mssqlserver2000

[Christian Eugster <ch...@bluewin.ch>]

Hi

after I have succeeded to connect to and work with mysql, postgresql,
msaccess i try to use a mssqlserver2000 as backend.

when i try to connect to the mssqlserver, that runs locally, i get the
following exception message:

[org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl] ERROR:
Error getting Connection from DriverManager with url
(jdbc:microsoft:sqlserver://SERVER:1433;DatabaseName=database;SelectMethod=c
ursor) and driver (com.microsoft.jdbc.sqlserver.SQLServerDriver)
[Microsoft][SQLServer 2000 Driver for JDBC]Fehler beim einrichten eines
Sockets.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Fehler
beim einrichten eines Sockets.
	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 java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectio
nFromDriverManager(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory
.makeObject(Unknown Source)
	at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:816)
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknow
n Source)
	at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
own Source)
	at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
	at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
	at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
	at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
	at ch.eugster.pos.db.Version.select(Version.java:85)
	at ch.eugster.pos.db.Connection.openConnection(Connection.java:49)
	at ch.eugster.pos.admin.App.connect(App.java:312)
	at ch.eugster.pos.admin.App.main(App.java:127)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR:
PersistenceBrokerException during the execution of the query: Used
ConnectionManager instance could not obtain a connection
Used ConnectionManager instance could not obtain a connection
org.apache.ojb.broker.PersistenceBrokerException: Used ConnectionManager
instance could not obtain a connection
	at
org.apache.ojb.broker.accesslayer.StatementManager.getPreparedStatement(Unkn
own Source)
	at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
	at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
	at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
	at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
	at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(
Unknown Source)
	at ch.eugster.pos.db.Version.select(Version.java:85)
	at ch.eugster.pos.db.Connection.openConnection(Connection.java:49)
	at ch.eugster.pos.admin.App.connect(App.java:312)
	at ch.eugster.pos.admin.App.main(App.java:127)
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Could not
borrow connection from pool -
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@14384c2[
  jcd-alias=standard
  default-connection=true
  dbms=MsSQLServer
  jdbc-level=2.0
  driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
  protocol=jdbc
  sub-protocol=microsoft:sqlserver
  db-alias=//SERVER:1433;DatabaseName=database;SelectMethod=cursor
  user=sa
  password=*****
  eager-release=false
  ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1, maxActive=5,
maxWait=5000, removeAbandoned=false, numTestsPerEvictionRun=10,
testWhileIdle=false, minEvictableIdleTimeMillis=600000, testOnReturn=false,
logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
  batchMode=false
  useAutoCommit=AUTO_COMMIT_SET_FALSE
  ignoreAutoCommitExceptions=false

sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@adb1d4[
     sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
     Properties={grabSize=1}
]
]
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.getConnectionF
romPool(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnec
tion(Unknown Source)
	at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknow
n Source)

has anyone an idea what my fault could be and any suggestion how to solve
it?

thank you!

Christian


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org