Mike,
Try this....you need to make sure the TCP port is 1433 and no value
specified for TCP Dynamic Port for IPAll in the TCP/IP setting. For all
other IP's, you can set TCP Dynamic Ports to be 0 and leave TCP Port empty.
It can be configured through SQL Server Configuration Manager.
Cheers,
Bill
Garcia Corral, Josep wrote:
> Hello Mike,
>
> Your message is arriving to the list!
>
> I cannot help much, since I am using Cayenne, without any problem, with Oracle and MySql. I am sure some guy on the other side of the Atlantic ocean will have experience with Cayenne + SQL Server. You will get responses within a few hours (different time zone ;-)
>
> Cheers,
> Josep
>
> -----Mensaje original-----
> De: nirwan [mailto:nirwan8..mail.com]
> Enviado el: jueves, 29 de mayo de 2008 13:14
> Para: use..ayenne.apache.org
> Asunto: MSSQL + Cayenne -> connection problem
>
>
> Hello,
>
> I'm trying to use Cayenne with MSSQL Server 2005. I downloaded the fresh
> jdbc driver, created the database, set up new user with password. After
> designing the tables in the Cayenne Modeler i generate database and
> everything goes fast. I checked manualy if the database exists and so on
> (with the mssql management tools) and everything seems to be fine.Then I
> generate classes, write some simple query and here the problem starts. It
> takes great amounts of time for application to connect to the database. It
> can take up to 20s when im running first query:
> (...)
> 2008-05-29 12:29:04 org.apache.cayenne.map.EntityResolver
> applyObjectLayerDefaults
> INFO: added runtime complimentary ObjRelationship from Klient to Placowka
> 2008-05-29 12:29:04 org.apache.cayenne.map.EntityResolver
> applyObjectLayerDefaults
> INFO: added runtime complimentary ObjRelationship from DaneOsobowe to
> Wlasciciel
> 2008-05-29 12:29:04 org.apache.cayenne.conf.RuntimeLoadDelegate
> finishedLoading
> INFO: finished configuration loading in 719 ms.
> 2008-05-29 12:29:04 org.apache.cayenne.access.QueryLogger logConnect
> INFO: Opening connection:
> jdbc:sqlserver://localhost:1433;database=bazac;SelectMethod=cursor
> Login: michal
> Password: *******
> 2008-05-29 12:29:05 org.apache.cayenne.access.QueryLogger logConnectSuccess
> INFO: +++ Connecting: SUCCESS.
> 2008-05-29 12:29:05 org.apache.cayenne.access.QueryLogger
> logBeginTransaction
> INFO: --- transaction started.
> 2008-05-29 12:29:05 org.apache.cayenne.access.QueryLogger log
> INFO: Detected and installed adapter:
> org.apache.cayenne.dba.sqlserver.SQLServerAdapter
> 2008-05-29 12:29:25 org.apache.cayenne.access.QueryLogger logQueryStart
> <-----------look at the times
> INFO: --- will run 1 query.
> 2008-05-29 12:29:25 org.apache.cayenne.access.QueryLogger
> logBeginTransaction
> INFO: --- transaction started.
> 2008-05-29 12:29:25 org.apache.cayenne.access.QueryLogger logQuery
> INFO: SELECT t0.numerPlacowki, t0.miasto, t0.id FROM Placowka t0
> (...)
>
> Aplication freezes on NFO: Detected and installed adapter:
> org.apache.cayenne.dba.sqlserver.SQLServerAdapter line.
> Next one is: 2008-05-29 12:29:25 org.apache.cayenne.access.QueryLogger
> logQueryStart...
> Sometimes i even get exception:
>
> INFO: Detected and installed adapter:
> org.apache.cayenne.dba.sqlserver.SQLServerAdapter
> Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
> [v.3.0M3 Jan 27 2008 20:12:33] Commit Exception
> at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1207)
> at
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1088)
> at tools.Testy.test1(Testy.java:27)
> at mainFiles.Main.main(Main.java:22)
> Caused by: java.sql.SQLException: Can't obtain connection. Request timed
> out. Total used connections: 1
> at
> org.apache.cayenne.conn.PoolManager.uncheckPooledConnection(PoolManager.java:422)
> at
> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:351)
> at
> org.apache.cayenne.conn.PoolManager.getConnection(PoolManager.java:344)
> at
> org.apache.cayenne.access.DataNode$TransactionDataSource.getConnection(DataNode.java:331)
> at
> org.apache.cayenne.dba.sybase.SybasePkGenerator.longPkFromDatabase(SybasePkGenerator.java:168)
> at
> org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:254)
> at
> org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:165)
> at
> org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:76)
> at
> org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:80)
> at
> org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:183)
> at
> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:135)
> at
> org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:821)
> at
> org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:788)
> at
> org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
> at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:785)
> at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1175)
> ... 3 more
> Java Result: 1
>
>
> It doesn't matter what query (insert,update,select) im trying to run. Always
> stops at the same place and if there is an exception (usually there is) it
> looks like the one i posted. I think that its about commitChanges() but i
> dont know what is causing he problem. Would love to hear your advices :)
>
> Thank you for all your help and im sorry for my poor english :)
>
> Mike
> --
> View this message in context: http://www.nabble.com/MSSQL-%2B-Cayenne--%3E-connection-problem-tp17532439p17532439.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
>
>
>
This archive was generated by hypermail 2.0.0 : Thu May 29 2008 - 08:49:00 EDT