Hi everybody,

we are developing a project using Hibernate V3.3.1.GA on JBoss 5.1/SQLServer. We noticed that the application always connects to the database defined as default for the given user on the SQLServer, regardless of the database name specified in the connection uri. In other words, it behaves as if no database name is passed to the jdbc driver...

Is this a bug or the correct behaviour?

Many thanks, Enrico

What happens if you try to connect via direct JDBC, with the same URL? Does it uses the "default" database, or the one you specified in the URL? How does the URL looks like? Are you specifying the connection parameters as hibernate properties, or via a JBoss managed DataSource?

I had the same doubt and therefore wrote a little jdbc test application to verify the behaviour. The test shows that if one omits the database name the connection is effectively established with the default database, but if the database name is provided, the connection is established with the desired database. That is why I suspect that Hibernate drops the database name from the uri...


The connection details are spedified in Jboss DataSource as following:


Unfortunately, on the SQLServer the dt_ep user defaults to a different database, with which the connection is established...

Thanks in advance, Enrico

Should I assume your database name is "DT_GestioneEdiliziaPrivata_Test"? If so, try this URL instead:

jdbc:sqlserver://srv002:1433;databaseName=DT_GestioneEdiliziaPrivata_Test