tomcat 5+jtds + hibernate JNDI 问题，请指教！！

jackbai

tomcat 5/conf/server.xml 文件内容：
<Context path="/hibernate" docBase="hibernate" debug="0"   reloadable="true" crossContext="true">;
<Resource name="jdbc/hibernate" auth="Container" type="javax.sql.DataSource"/>;   
     <ResourceParams name="jdbc/hibernate">;
     <parameter>;
         <name>;factory</name>;
     <value>;org.apache.commons.dbcp.BasicDataSourceFactory</value>;
     </parameter>;
     <parameter>;
        <name>;driverClassName</name>;
         <value>;net.sourceforge.jtds.jdbc.Driver</value>;
      </parameter>;
      <parameter>;
          <name>;url</name>;
           <value>;jdbc:jtds:sqlserver://scmtest1:1433/test </value>;   
         </parameter>;
      <parameter>;
         <name>;username</name>;
         <value>;sa</value>;
      </parameter>;
     <parameter>;
        <name>;password</name>;
        <value>;scmtest1</value>;
          </parameter>;
     <parameter>;
    <name>;maxActive</name>;
    <value>;20</value>;
  </parameter>;
         <parameter>;
      <name>;maxIdle</name>;
          <value>;10</value>;
  </parameter>;
  <parameter>;
         <name>;maxWait</name>;
    <value>;-1</value>;
  </parameter>;
    </ResourceParams>;   
  </Context>;   

VVVVVVVVVVVVVVVVVVVVVVVVVVVVVV
hibernate.properties 文件：

######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'

## package imports

hibernate.query.imports net.sf.hibernate.test, net.sf.hibernate.eg

## JNDI Datasource
hibernate.connection.datasource java:/comp/env/jdbc/hibernate

hibernate.connection.provider_class net.sf.hibernate.connection.DatasourceConnectionProvider

hibernate.transaction.factory_class net.sf.hibernate.transaction.JTATransactionFactory


## SQL server

hibernate.dialect net.sf.hibernate.dialect.SQLServerDialect
hibernate.connection.username sa
hibernate.connection.password scmtest1
## JTDS Driver
hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
hibernate.connection.url jdbc:jtds:sqlserver://scmtest1:1433/test

#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1
hibernate.statement_cache.size 25


hibernate.show_sql true


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

hibernate.jdbc.batch_size 0

## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true

VVVVVVVVVVVVVVVvvvvvvvvvvvvvvv
出错信息：  
...........................
2004-7-29 17:30:56 net.sf.hibernate.connection.DriverManagerConnectionProvider c
onfigure
信息: Using Hibernate built-in connection pool (not for production use!)
2004-7-29 17:30:57 net.sf.hibernate.connection.DriverManagerConnectionProvider c
onfigure
信息: Hibernate connection pool size: 1
2004-7-29 17:30:57 net.sf.hibernate.connection.DriverManagerConnectionProvider c
onfigure
信息: using driver: net.sourceforge.jtds.jdbc.Driver at URL: jdbc:jtds:sqlserver
://scmtest1:1433/test
2004-7-29 17:30:57 net.sf.hibernate.connection.DriverManagerConnectionProvider c
onfigure
信息: connection properties: {user=sa, password=scmtest1}
2004-7-29 17:30:57 net.sf.hibernate.transaction.TransactionManagerLookupFactory
getTransactionManagerLookup
信息: No TransactionManagerLookup configured (in JTA environment, use of process
level read-write cache is not recommended)
2004-7-29 17:30:58 net.sf.hibernate.cfg.SettingsFactory buildSettings
警告: Could not obtain connection metadata
java.sql.SQLException: Connection refused: connect
        at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:181)
        at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:160)
        at net.sourceforge.jtds.jdbc.TdsConnection.<init>;(TdsConnection.java:182
)
..........................................

2004-7-29 17:30:59 net.sf.hibernate.impl.SessionFactoryImpl <init>;
信息: building session factory
2004-7-29 17:31:01 net.sf.hibernate.impl.SessionFactoryObjectFactory addInstance

信息: no JNDI name configured

dennis2

>; 警告: Could not obtain connection metadata
>; java.sql.SQLException: Connection refused: connect

数据库连接出的问题。检查一下 SQL Server 是否运行，已经 connection url 是否正确。

jackbai

的确是SQL server 没有联上，但是当我确认SQL server没有问题后，tomcat 5 依然报错如下：

信息: No TransactionManagerLookup configured (in JTA environment, use of process
level read-write cache is not recommended)
2004-7-30 9:18:32 net.sf.hibernate.cfg.SettingsFactory buildSettings
警告: Could not obtain connection metadata
java.sql.SQLException: Logon failed: Old database mismatch.
        at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:183)
        at net.sourceforge.jtds.jdbc.TdsConnection.<init>;(TdsConnection.java:209
)
        at net.sourceforge.jtds.jdbc.TdsConnectionJDBC3.<init>;(TdsConnectionJDBC
3.java:53)
        at net.sourceforge.jtds.jdbc.Driver.getConnection(Driver.java:102)
        at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:85)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)

james5

java.sql.SQLException: Logon failed: Old database mismatch.
at net.sourceforge.jtds.jdbc.TdsUtil.getSQLException(TdsUtil.java:183)

应该是你的驱动和数据库不匹配..
找一个和你的数据库版本一致的驱动吧.

goncha

Tomcat本身是不提供JTS服务的, 像WebLogic, JBoss这样的J2EE AS会提供. 当然也可以使用一些开源的Lib来提供. 一般在Hibernate中使用JDBCTransactionFactory应该就可以了.

cooljia

有个问题
java:/comp/env/jdbc/hibernate
写错了啊，应该是...
java:comp/env/jdbc/hibernate