社区
Java EE
帖子详情
用Weblogic+Sql Server2000,Connection Pool的中文问题
chenxix
2003-03-06 02:39:37
如何设置Connection Pool的Properties解决存在的中文问题
...全文
19
10
打赏
收藏
用Weblogic+Sql Server2000,Connection Pool的中文问题
如何设置Connection Pool的Properties解决存在的中文问题
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
10 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
chenxix
2003-03-06
打赏
举报
回复
yshao(okxu) :你提供的解决办法我也试了,也可以正常显示!
非常感谢二位!散分!
yshao
2003-03-06
打赏
举报
回复
在Properties中设置:weblogic.codeset=gb2312
就行了喽。
chenxix
2003-03-06
打赏
举报
回复
太棒了,解决了!
这个问题困扰我两天了!
CastleKtt非常感谢你!
CastleKtt
2003-03-06
打赏
举报
回复
varchar生成的对象是String,nvarchar是Object,需要手工改成String
CastleKtt
2003-03-06
打赏
举报
回复
你把varchar改成nvarchar就行了
chenxix
2003-03-06
打赏
举报
回复
在Jboss中可这样做:把url写成jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=db2312,但在Weblogic中这样做了,不行!
chenxix
2003-03-06
打赏
举报
回复
类型为varchar(10)
CastleKtt
2003-03-06
打赏
举报
回复
你的数据库字段是什么类型?
chenxix
2003-03-06
打赏
举报
回复
数据库中存储的中文,通过CMP——>Session Bean ——〉JSP显示出来时是乱码,不只如何解决,网上的一般设置方法我都试了还是不行,听说可以在Connection Pool中设置,但是不知道如何做,求助!
CastleKtt
2003-03-06
打赏
举报
回复
什么中文问题?
MyEclipse+
WebLogic
+My
SQL
数据源
package com.
pool
.org.dao.impl; import java.
sql
.
Connection
; import java.
sql
.ResultSet; import java.
sql
.Statement; import java.util.ArrayList; import java.util.List; import com.
pool
.org.dao.UserDao; import com.
pool
.org.entity.Users; import com.
pool
.org.util.DataSourceUtil; /*** *作 者:龙叔 *创建时间:2011-12-8 *Project:
weblogic
_
pool
*类 名:UserDao.java */ public class UserDaoImpl implements UserDao {
Connection
conn=null; public List getUserList() throws Exception { conn = DataSourceUtil.get
Connection
(); String
sql
= "select * from user"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(
sql
); List list = new ArrayList(); while (rs.next()) { Users user = new Users(); user.setId(rs.getInt("id")); user.setPassword(rs.getString("password")); user.setUsername(rs.getString("username")); list.add(user); } return list; } }
hibernate.properties
hibernate.properties # # Hibernate, Relational Persistence for Idiomatic Java # # License: GNU Lesser General Public License (LGPL), version 2.1 or later. # See the lgpl.txt file in the root directory or . # ###################### ### Query Language ### ###################### ## define query language constants / function names hibernate.query.substitutions yes 'Y', no 'N' ## select the classic query parser #hibernate.query.factory_class org.hibernate.hql.internal.classic.ClassicQueryTranslatorFactory ################# ### Platforms ### ################# ## JNDI Datasource #hibernate.
connection
.datasource jdbc/test #hibernate.
connection
.username db2 #hibernate.
connection
.password db2 ## Hypersonic
SQL
hibernate.dialect org.hibernate.dialect.H
SQL
Dialect hibernate.
connection
.driver_class org.h
sql
db.jdbcDriver hibernate.
connection
.username sa hibernate.
connection
.password hibernate.
connection
.url jdbc:h
sql
db:./build/db/h
sql
db/hibernate #hibernate.
connection
.url jdbc:h
sql
db:h
sql
://localhost #hibernate.
connection
.url jdbc:h
sql
db:test ## H2 (www.h2database.com) #hibernate.dialect org.hibernate.dialect.H2Dialect #hibernate.
connection
.driver_class org.h2.Driver #hibernate.
connection
.username sa #hibernate.
connection
.password #hibernate.
connection
.url jdbc:h2:mem:./build/db/h2/hibernate #hibernate.
connection
.url jdbc:h2:testdb/h2test #hibernate.
connection
.url jdbc:h2:mem:imdb1 #hibernate.
connection
.url jdbc:h2:tcp://dbserv:8084/sample; #hibernate.
connection
.url jdbc:h2:ssl://secureserv:8085/sample; #hibernate.
connection
.url jdbc:h2:ssl://secureserv/testdb;cipher=AES ## My
SQL
#hibernate.dialect org.hibernate.dialect.My
SQL
Dialect #hibernate.dialect org.hibernate.dialect.My
SQL
InnoDBDialect #hibernate.dialect org.hibernate.dialect.My
SQL
MyISAMDialect #hibernate.
connection
.driver_class com.my
sql
.jdbc.Driver #hibernate.
connection
.url jdbc:my
sql
:///test #hibernate.
connection
.username gavin #hibernate.
connection
.password ## Oracle #hibernate.dialect org.hibernate.dialect.Oracle8iDialect #hibernate.dialect org.hibernate.dialect.Oracle9iDialect #hibernate.dialect org.hibernate.dialect.Oracle10gDialect #hibernate.
connection
.driver_class oracle.jdbc.driver.OracleDriver #hibernate.
connection
.username ora #hibernate.
connection
.password ora #hibernate.
connection
.url jdbc:oracle:thin:@localhost:1521:orcl #hibernate.
connection
.url jdbc:oracle:thin:@localhost:1522:XE ## Postgre
SQL
#hibernate.dialect org.hibernate.dialect.Postgre
SQL
Dialect #hibernate.
connection
.driver_class org.postgre
sql
.Driver #hibernate.
connection
.url jdbc:postgre
sql
:template1 #hibernate.
connection
.username pg #hibernate.
connection
.password ## DB2 #hibernate.dialect org.hibernate.dialect.DB2Dialect #hibernate.
connection
.driver_class com.ibm.db2.jcc.DB2Driver #hibernate.
connection
.driver_class COM.ibm.db2.jdbc.app.DB2Driver #hibernate.
connection
.url jdbc:db2://localhost:50000/somename #hibernate.
connection
.url jdbc:db2:somename #hibernate.
connection
.username db2 #hibernate.
connection
.password db2 ## TimesTen #hibernate.dialect org.hibernate.dialect.TimesTenDialect #hibernate.
connection
.driver_class com.timesten.jdbc.TimesTenDriver #hibernate.
connection
.url jdbc:timesten:direct:test #hibernate.
connection
.username #hibernate.
connection
.password ## DB2/400 #hibernate.dialect org.hibernate.dialect.DB2400Dialect #hibernate.
connection
.username user #hibernate.
connection
.password password ## Native driver #hibernate.
connection
.driver_class COM.ibm.db2.jdbc.app.DB2Driver #hibernate.
connection
.url jdbc:db2://systemname ## Toolbox driver #hibernate.
connection
.driver_class com.ibm.as400.access.AS400JDBCDriver #hibernate.
connection
.url jdbc:as400://systemname ## Derby (not supported!) #hibernate.dialect org.hibernate.dialect.DerbyDialect #hibernate.
connection
.driver_class org.apache.derby.jdbc.EmbeddedDriver #hibernate.
connection
.username #hibernate.
connection
.password #hibernate.
connection
.url jdbc:derby:build/db/derby/hibernate;create=true ## Sybase #hibernate.dialect org.hibernate.dialect.SybaseDialect #hibernate.
connection
.driver_class com.sybase.jdbc2.jdbc.SybDriver #hibernate.
connection
.username sa #hibernate.
connection
.password sasasa #hibernate.
connection
.url jdbc:sybase:Tds:co3061835-a:5000/tempdb ## Mckoi
SQL
#hibernate.dialect org.hibernate.dialect.MckoiDialect #hibernate.
connection
.driver_class com.mckoi.JDBCDriver #hibernate.
connection
.url jdbc:mckoi:/// #hibernate.
connection
.url jdbc:mckoi:local://C:/mckoi1.0.3/db.conf #hibernate.
connection
.username admin #hibernate.
connection
.password nimda ## SAP DB #hibernate.dialect org.hibernate.dialect.SAPDBDialect #hibernate.
connection
.driver_class com.sap.dbtech.jdbc.DriverSapDB #hibernate.
connection
.url jdbc:sapdb://localhost/TST #hibernate.
connection
.username TEST #hibernate.
connection
.password TEST #hibernate.query.substitutions yes 'Y', no 'N' ## MS
SQL
Server
#hibernate.dialect org.hibernate.dialect.
SQL
Server
Dialect #hibernate.
connection
.username sa #hibernate.
connection
.password sa ## J
SQL
Driver #hibernate.
connection
.driver_class com.jnetdirect.j
sql
.J
SQL
Driver #hibernate.
connection
.url jdbc:J
SQL
Connect://1E1/test ## JTURBO Driver #hibernate.
connection
.driver_class com.newatlanta.jturbo.driver.Driver #hibernate.
connection
.url jdbc:JTurbo://1E1:1433/test ##
WebLogic
Driver #hibernate.
connection
.driver_class
weblogic
.jdbc.ms
sql
server
4.Driver #hibernate.
connection
.url jdbc:
weblogic
:ms
sql
server
4:1E1:1433 ## Microsoft Driver (not recommended!) #hibernate.
connection
.driver_class com.microsoft.jdbc.
sql
server
.
SQL
Server
Driver #hibernate.
connection
.url jdbc:microsoft:
sql
server
://1E1;DatabaseName=test;SelectMethod=cursor ## The New Microsoft Driver #hibernate.
connection
.driver_class com.microsoft.
sql
server
.jdbc.
SQL
Server
Driver #hibernate.
connection
.url jdbc:
sql
server
://localhost ## jTDS (since version 0.9) #hibernate.
connection
.driver_class net.sourceforge.jtds.jdbc.Driver #hibernate.
connection
.url jdbc:jtds:
sql
server
://1E1/test ## Interbase #hibernate.dialect org.hibernate.dialect.InterbaseDialect #hibernate.
connection
.username sysdba #hibernate.
connection
.password masterkey ## DO NOT specify hibernate.
connection
.
sql
Dialect ## InterClient #hibernate.
connection
.driver_class interbase.interclient.Driver #hibernate.
connection
.url jdbc:interbase://localhost:3060/C:/firebird/test.gdb ## Pure Java #hibernate.
connection
.driver_class org.firebird
sql
.jdbc.FBDriver #hibernate.
connection
.url jdbc:firebird
sql
:localhost/3050:/firebird/test.gdb ## Pointbase #hibernate.dialect org.hibernate.dialect.PointbaseDialect #hibernate.
connection
.driver_class com.pointbase.jdbc.jdbcUniversalDriver #hibernate.
connection
.url jdbc:pointbase:embedded:sample #hibernate.
connection
.username PBPUBLIC #hibernate.
connection
.password PBPUBLIC ## Ingres ## older versions (before Ingress 2006) #hibernate.dialect org.hibernate.dialect.IngresDialect #hibernate.
connection
.driver_class ca.edbc.jdbc.EdbcDriver #hibernate.
connection
.url jdbc:edbc://localhost:II7/database #hibernate.
connection
.username user #hibernate.
connection
.password password ## Ingres 2006 or later #hibernate.dialect org.hibernate.dialect.IngresDialect #hibernate.
connection
.driver_class com.ingres.jdbc.IngresDriver #hibernate.
connection
.url jdbc:ingres://localhost:II7/database;CURSOR=READONLY;auto=multi #hibernate.
connection
.username user #hibernate.
connection
.password password ## Mimer
SQL
#hibernate.dialect org.hibernate.dialect.Mimer
SQL
Dialect #hibernate.
connection
.driver_class com.mimer.jdbc.Driver #hibernate.
connection
.url jdbc:mimer:multi1 #hibernate.
connection
.username hibernate #hibernate.
connection
.password hibernate ## InterSystems Cache #hibernate.dialect org.hibernate.dialect.Cache71Dialect #hibernate.
connection
.driver_class com.intersys.jdbc.CacheDriver #hibernate.
connection
.username _SYSTEM #hibernate.
connection
.password SYS #hibernate.
connection
.url jdbc:Cache://127.0.0.1:1972/HIBERNATE ################################# ### Hibernate
Connection
Pool
### ################################# hibernate.
connection
.
pool
_size 1 ########################### ### C3P0
Connection
Pool
### ########################### #hibernate.c3p0.max_size 2 #hibernate.c3p0.min_size 2 #hibernate.c3p0.timeout 5000 #hibernate.c3p0.max_statements 100 #hibernate.c3p0.idle_test_period 3000 #hibernate.c3p0.acquire_increment 2 #hibernate.c3p0.validate false ############################## ### Proxool
Connection
Pool
### ############################## ## Properties for external configuration of Proxool hibernate.proxool.
pool
_alias
pool
1 ## Only need one of the following #hibernate.proxool.existing_
pool
true #hibernate.proxool.xml proxool.xml #hibernate.proxool.properties proxool.properties ################################# ### Plugin
Connection
Provider ### ################################# ## use a custom
Connection
Provider (if not set, Hibernate will choose a built-in
Connection
Provider using hueristics) #hibernate.
connection
.provider_class org.hibernate.
connection
.DriverManager
Connection
Provider #hibernate.
connection
.provider_class org.hibernate.
connection
.Datasource
Connection
Provider #hibernate.
connection
.provider_class org.hibernate.
connection
.C3P0
Connection
Provider #hibernate.
connection
.provider_class org.hibernate.
connection
.Proxool
Connection
Provider ####################### ### Transaction API ### ####################### ## Enable automatic flush during the JTA beforeCompletion() callback ## (This setting is relevant with or without the Transaction API) #hibernate.transaction.flush_before_completion ## Enable automatic session close at the end of transaction ## (This setting is relevant with or without the Transaction API) #hibernate.transaction.auto_close_session ## the Transaction API abstracts application code from the underlying JTA or JDBC transactions #hibernate.transaction.factory_class org.hibernate.transaction.JTATransactionFactory #hibernate.transaction.factory_class org.hibernate.transaction.JDBCTransactionFactory ## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI ## default is java:comp/UserTransaction ## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class #jta.UserTransaction jta/usertransaction #jta.UserTransaction javax.transaction.UserTransaction #jta.UserTransaction UserTransaction ## to use the second-level cache with JTA, Hibernate must be able to obtain the JTA TransactionManager #hibernate.transaction.manager_lookup_class org.hibernate.transaction.JBossTransactionManagerLookup #hibernate.transaction.manager_lookup_class org.hibernate.transaction.
Weblogic
TransactionManagerLookup #hibernate.transaction.manager_lookup_class org.hibernate.transaction.WebSphereTransactionManagerLookup #hibernate.transaction.manager_lookup_class org.hibernate.transaction.OrionTransactionManagerLookup #hibernate.transaction.manager_lookup_class org.hibernate.transaction.ResinTransactionManagerLookup ############################## ### Miscellaneous Settings ### ############################## ## print all generated
SQL
to the console #hibernate.show_
sql
true ## format
SQL
in log and console hibernate.format_
sql
true ## add comments to the generated
SQL
#hibernate.use_
sql
_comments true ## generate statistics #hibernate.generate_statistics true ## auto schema export #hibernate.hbm2ddl.auto create-drop #hibernate.hbm2ddl.auto create #hibernate.hbm2ddl.auto update #hibernate.hbm2ddl.auto validate ## specify a default schema and catalog for unqualified tablenames #hibernate.default_schema test #hibernate.default_catalog test ## enable ordering of
SQL
UPDATEs by primary key #hibernate.order_updates true ## set the maximum depth of the outer join fetch tree hibernate.max_fetch_depth 1 ## set the default batch size for batch fetching #hibernate.default_batch_fetch_size 8 ## rollback generated identifier values of deleted entities to default values #hibernate.use_identifier_rollback true ## enable bytecode reflection optimizer (disabled by default) #hibernate.bytecode.use_reflection_optimizer true ##################### ### JDBC Settings ### ##################### ## specify a JDBC isolation level #hibernate.
connection
.isolation 4 ## enable JDBC autocommit (not recommended!) #hibernate.
connection
.autocommit true ## set the JDBC fetch size #hibernate.jdbc.fetch_size 25 ## set the maximum JDBC 2 batch size (a nonzero value enables batching) #hibernate.jdbc.batch_size 5 #hibernate.jdbc.batch_size 0 ## enable batch updates even for versioned data hibernate.jdbc.batch_versioned_data true ## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default) #hibernate.jdbc.use_scrollable_resultset true ## use streams when writing binary types to / from JDBC hibernate.jdbc.use_streams_for_binary true ## use JDBC 3 PreparedStatement.getGeneratedKeys() to get the identifier of an inserted row #hibernate.jdbc.use_get_generated_keys false ## choose a custom JDBC batcher # hibernate.jdbc.factory_class ## enable JDBC result set column alias caching ## (minor performance enhancement for broken JDBC drivers) # hibernate.jdbc.wrap_result_sets ## choose a custom
SQL
exception converter #hibernate.jdbc.
sql
_exception_converter ########################## ### Second-level Cache ### ########################## ## optimize cache for minimal "puts" instead of minimal "gets" (good for clustered cache) #hibernate.cache.use_minimal_puts true ## set a prefix for cache region names hibernate.cache.region_prefix hibernate.test ## disable the second-level cache #hibernate.cache.use_second_level_cache false ## enable the query cache #hibernate.cache.use_query_cache true ## store the second-level cache entries in a more human-friendly format #hibernate.cache.use_structured_entries true ## choose a cache implementation #hibernate.cache.region.factory_class org.hibernate.cache.infinispan.InfinispanRegionFactory #hibernate.cache.region.factory_class org.hibernate.cache.infinispan.JndiInfinispanRegionFactory #hibernate.cache.region.factory_class org.hibernate.cache.internal.EhCacheRegionFactory #hibernate.cache.region.factory_class org.hibernate.cache.internal.SingletonEhCacheRegionFactory hibernate.cache.region.factory_class org.hibernate.cache.internal.NoCachingRegionFactory ## choose a custom query cache implementation #hibernate.cache.query_cache_factory ############ ### JNDI ### ############ ## specify a JNDI name for the SessionFactory #hibernate.session_factory_name hibernate/session_factory ## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction; ## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which ## is the best approach in an application
server
#file system #hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory #hibernate.jndi.url file:/ #WebSphere #hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory #hibernate.jndi.url iiop://localhost:900/
SSRF服务器端请求伪造漏洞精讲+实验
程声明:该课程是教学使用,视频内涉及漏洞利用方法,请勿在互联网环境中使用;维护互联网安全,人人有责。 实验所需环境:vmware;kali虚拟机一台;windows
server
一台;有docker环境的Linux虚拟机 环境下载地址在...
jbuilder9 +
weblogic
8.1(sp3) +
SQL
Server
2000
以下是小弟综合各种各样的网络上的配置和小弟自己的配置经历进行的总结希望可以让各位借鉴。操作系统:windows
2000
professional/
server
(SP4),数据库:
SQL
Server
2000
一、首先安装JBuilder9和
WebLogic
8.1(略)二、
WebLogic
8.1 JDBC 的配置:1. 将
sql
server
2000
的驱动程序加入
weblogic
中,然后启动We
WebLogic
中
SQL
Server
2000
的JDBC
Pool
配置 (转贴)
WebLogic
中
SQL
Server
2000
的JDBC
Pool
配置 一、 采用Microsoft的JDBC Driver1 到www.microsoft.com上下载"Microsoft
SQL
Server
2000
Driver for JDBC"并安装2 安装后,在安装的目录中有三个jar文件包./lib/msbase.jar./lib/msutil.jar ./lib/ms
sql
s
Java EE
67,513
社区成员
225,879
社区内容
发帖
与我相关
我的任务
Java EE
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
复制链接
扫一扫
分享
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器,保护我们的业务核心组件(中间件),以延续它的生命力,而不是依赖J2SE/J2EE版本。
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章