Hi,
The jdbc driver is having trouble connecting to the SQL Server machine. My
German is a little rusty, (and babelfish not overly helpful), but I suspect
it's complaining that it can't connect to the socket.
a) Is the host SERVER your local machine ?
b) Can windows resolve "SERVER" to a TCP/IP host address ? (try ping SERVER
at the command line)
c) Is TCP/IP enabled on your MS SQLServer database ? (try Start/Programs/MS
Sql Server/Server Network Utility)
d) Is your SQL Server listening on the standard port of 1433 ?
e) try replacing SERVER in your URL to 127.0.0.1 e.g.
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database;SelectMethod
=cursor
HTH
Charles.
> -----Original Message-----
> From: Christian Eugster [mailto:[EMAIL PROTECTED]
> Sent: 16 March 2004 15:33
> To: [EMAIL PROTECTED]
> Subject: ojb with mssqlserver2000
>
>
> 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.ConnectionFactoryAbstractIm
> pl] 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.ConnectionFactoryAbstractImp
> l.newConnectio
> nFromDriverManager(Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$
> ConPoolFactory
> .makeObject(Unknown Source)
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Ge
> nericObjectPoo
> l.java:816)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.
> getConnectionF
> romPool(Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImp
> l.lookupConnec
> tion(Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getCon
> nection(Unknow
> n Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.getPrepared
> Statement(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.createRsItera
> tor(Unknown
> Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIterator
> FromQuery(Unkn
> own Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFr
> omQuery(Unknow
> n Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollection
> ByQuery(Unknow
> n Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl
> ectionByQuery(
> Unknown Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl
> ectionByQuery(
> 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.getPrepared
> Statement(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.createRsItera
> tor(Unknown
> Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIterator
> FromQuery(Unkn
> own Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFr
> omQuery(Unknow
> n Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionB
> yQuery(Unknown
> Source)
> at
> org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollection
> ByQuery(Unknow
> n Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl
> ectionByQuery(
> Unknown Source)
> at
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.getColl
> ectionByQuery(
> 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:
> [EMAIL PROTECTED]
> 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.SequenceDesc
> [EMAIL PROTECTED]
> 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.ConnectionFactoryAbstractImp
> l.lookupConnec
> tion(Unknown Source)
> at
> org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getCon
> nection(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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
