hibernate配置proxool出错

sjzpc040529 2008-06-04 09:43:31
hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="proxool.pool_alias">proxoolPool</property>
<property name="proxool.xml">proxoolconf.xml</property>
<property name="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</property>
<property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
</session-factory>
</hibernate-configuration>

proxool.xml
<?xml version='1.0' encoding='UTF-8'?>
<!--the proxool configuratin can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>proxoolPool</alias>
<driver-url>jdbc:microsoft:sqlserver://localhost:1433</driver-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<driver-properties>
<property name="username" value="sa"></property>
<property name="password" value="sa"/>
</driver-properties>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>20</maximum-new-connections>
<prototype-count>5</prototype-count>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
</proxool>
</something-else-entirely>

hibernate工程类
HibernateSessionFactory.java
package com.zsw.DB.Factory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
public class HibernateSessionFactory {
// 配置文件路径
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
// 单体session线程
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
// 工厂类
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* @返回 ThreadLocal Session 实例
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();

if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}

return session;
}

/**
* @关闭单个ThreadLocal Session 实例
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);

if (session != null) {
session.close();
}
}
}

测试类Test.java
package com.zsw.DB.Factory;
public class Test {
public static void main(String[] args) {
HibernateSessionFactory.getSession();
System.out.println("=========");
}

}
...全文
847 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
M_song 2008-06-06
  • 打赏
  • 举报
 回复
恩,搞定就行!
结帖吧!
sjzpc040529 2008-06-06
  • 打赏
  • 举报
 回复
本人搞定了，是因为他们低端的代码有所更改。急两行代码就可以了
M_song 2008-06-04
  • 打赏
  • 举报
 回复
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。

这嘛,怎么会用null用户登陆哪?
一洽客服系统 2008-06-04
  • 打赏
  • 举报
 回复
这么多啊 看都看不过来 at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) 不是有效的连接 根本打不开好好检查下配置文件
sjzpc040529 2008-06-04
  • 打赏
  • 举报
 回复
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.zsw.DB.Factory.HibernateSessionFactory.<clinit>(HibernateSessionFactory.java:29)
at com.zsw.DB.Factory.Test.main(Test.java:9)
422 [Prototyper] ERROR proxool.proxoolPool - Prototype
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:95)
at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:42)
422 [main] INFO dialect.Dialect - Using dialect: org.hibernate.dialect.SQLServerDialect
453 [main] INFO transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
453 [main] INFO transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
453 [main] INFO cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
453 [main] INFO cfg.SettingsFactory - Automatic session close at end of transaction: disabled
453 [main] INFO cfg.SettingsFactory - Scrollable result sets: disabled
453 [main] INFO cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
453 [main] INFO cfg.SettingsFactory - Connection release mode: auto
453 [main] INFO cfg.SettingsFactory - Default batch fetch size: 1
453 [main] INFO cfg.SettingsFactory - Generate SQL with comments: disabled
453 [main] INFO cfg.SettingsFactory - Order SQL updates by primary key: disabled
453 [main] INFO cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
453 [main] INFO ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
453 [main] INFO cfg.SettingsFactory - Query language substitutions: {}
453 [main] INFO cfg.SettingsFactory - Second-level cache: enabled
453 [main] INFO cfg.SettingsFactory - Query cache: disabled
453 [main] INFO cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
453 [main] INFO cfg.SettingsFactory - Optimize cache for minimal puts: disabled
453 [main] INFO cfg.SettingsFactory - Structured second-level cache entries: disabled
468 [main] INFO cfg.SettingsFactory - Echoing all SQL to stdout
468 [main] INFO cfg.SettingsFactory - Statistics: disabled
468 [main] INFO cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
468 [main] INFO cfg.SettingsFactory - Default entity-mode: pojo
500 [main] INFO impl.SessionFactoryImpl - building session factory
500 [main] WARN config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/D:/zsw0422/ArticleCharge/WebRoot/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
515 [main] INFO impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
=========
547 [Shutdown Hook] INFO proxool.proxoolPool - Shutting down 'proxoolPool' pool immediately [Shutdown Hook]
547 [Shutdown Hook] ERROR proxool.ShutdownHook - Problem calling "get cause" on IllegalStateException.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ShutdownHook.remove(ShutdownHook.java:40)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:238)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:220)
at org.logicalcobwebs.proxool.ShutdownHook.run(ShutdownHook.java:99)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.IllegalStateException: Shutdown in progress
at java.lang.ApplicationShutdownHooks.remove(ApplicationShutdownHooks.java:55)
at java.lang.Runtime.removeShutdownHook(Runtime.java:220)
... 9 more
sjzpc040529 2008-06-04
  • 打赏
  • 举报
 回复
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.zsw.DB.Factory.HibernateSessionFactory.<clinit>(HibernateSessionFactory.java:29)
at com.zsw.DB.Factory.Test.main(Test.java:9)
406 [main] WARN cfg.SettingsFactory - Could not obtain connection metadata
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。
sjzpc040529 2008-06-04
  • 打赏
  • 举报
 回复
运行结果
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
265 [main] INFO proxool.ProxoolFacade - Proxool 0.8.3 (14-Dec-2003 16:06)
281 [main] WARN proxool.proxoolPool - Use of proxool.maximum-new-connections is deprecated. Use more descriptive proxool.simultaneous-build-throttle instead.
312 [main] INFO connection.ProxoolConnectionProvider - Configuring Proxool Provider to use pool alias: proxool.proxoolPool
312 [main] INFO connection.ProxoolConnectionProvider - autocommit mode: false
406 [main] ERROR proxool.ProxoolDriver - Problem
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 '(null)' 登录失败。原因: 未与信任 SQL Server 连接相关联。


SSH框架示例（可以直接用）
proxool里面没有注释是因为程序解析的时候出错所以没写，这个网上大把。 顺便发了个创建用户以及两个测试表的sql语句，保证可以直接用哦。 持久层是用了hibernate和spring。hibernate负责ORM,hql操作对象。 ...
IOIF基于开源技术的JAVA开发框架
IOIF以EXTJS为前端，以Spring、Struts、Hibernate为后端，整合了Proxool、Log4j、Quartz、Oscache、Castor、Memcached、redis等优秀的开源软件。 支持Tomcat6及Resin3等应用服务器，支持Oracle、MYSQL等数据库。IOIF...
IOIF面向项目的开源开发框架
IOIF以EXTJS为前端，以Spring、Struts、Hibernate为后端，整合了Proxool、Log4j、Quartz、Oscache、Castor、Memcached、redis等优秀的开源软件。 支持Tomcat6及Resin3等应用服务器，支持Oracle、MYSQL等数据库。IOIF...
Spring+Hibernate+Proxool配置
Spring+Hibernate+Proxool配置 Spring 2.0 Hibernate 3 Proxool 0.9RC1   如果用RC2会出错。   Spring配置入下： &lt;property name="hibernateProperties"&gt; &lt;props&gt; &...
Hibernate Proxool连接池配置总结及常遇问题
Hibernate Proxool连接池配置总结及常遇问题2008-04-12 13:38使用的proxool版本:proxool-0.9.0RC3.jar配置目录:Hibernate.hbm.xml文件配置 "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "ht
Web 开发

81,092

社区成员

341,717

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章