Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Is it a bug about jforum-custom.conf file?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys,
when installed jforum,jforum-custom.conf file will be created in WEB-INF\config path.

In jforum-custom.conf file,there is one line below :


database.connection.string=jdbc\:mysql\://${database.connection.host}\:${database.connection.port}/${database.connection.dbname}?user\=${database.connection.username}&password\=${database.connection.password}&autoReconnect\=true${mysql.unicode}${mysql.encoding}&useNewIO\=false&zeroDateTimeBehavior\=convertToNull&useServerPrepStmts\=false


Would these two params ${mysql.unicode}${mysql.encoding} connect together? I think these were not use in fact.
When i added two params "useUnicode\=true&characterEncoding\=UTF-8", and run fine.But when i search some topics about Chinese,can not found.

And then when I remove these two params,and changed this line to:

database.connection.string=jdbc\:mysql\://${database.connection.host}\:${database.connection.port}/${database.connection.dbname}?user\=${database.connection.username}&password\=${database.connection.password}&autoReconnect\=true&useNewIO\=false&zeroDateTimeBehavior\=convertToNull&useServerPrepStmts\=false&useUnicode\=true&characterEncoding\=UTF-8


Restart jforum,it work fine and can search any content,include Chinese.

Now,I found in http://www.jforum.net/jforum can not search Chinese or other multi-byte content,may be is this reason.
[originally posted on jforum.net by forsoft]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can remove them safely.

If you keep them, you have the option to set their values to empty, in the config file.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I try it with you method and it in the full search can work in gear,but in the mistiness input some words ,it can't search it out !
[originally posted on jforum.net by fangbiao]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!