Re: handle international characters

2005-10-21 Thread Scott Zhu
Thanks, Daniel. I actually didn't think the problem would be in ibatis, but I wanted to be sure I didn't miss any obvious settings. I was using Weblogic's (bea) sql server type 4 driver. I found later that I have to set "CodePageOverride=UTF8" in the driver to get this to work. I don't quite unders

Re: handle international characters

2005-10-21 Thread Daniel Henrique Ferreira e Silva
Scott, That UTF-8 thing just states the xml file character encoding. It's not related to what get inserted into your database. You should look for info on configuring your JDBC driver encoding or ways to work around this within your database. Which database engine are you using? Cheers, Daniel S

handle international characters

2005-10-21 Thread Scott Zhu
Hi, I tried to look this up in the user guide. I have to insert something into the database (SQL Server) with international characters. I tried to debug the code and I could see just before the ibatis query, the characters are preserved correctly. But those characters ended in the database as "?"s.

RE: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Niels Beekman
No, because Tomcat has imported DBCP into the org.apache-package, iBATIS uses the public DBCP-version (of course). That is why I strongly suggest you do the configuration in Tomcat, then use JNDI to use them in iBATIS. Niels -Original Message- From: Zsolt [mailto:[EMAIL PROTECTED] Sent:

Re: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Daniel Henrique Ferreira e Silva
Zsolt, Why do you have to use tomcat's DBCP? I mean, today your app ships with Tomcat, and if you want to ship it tomorrow with Resin? Honestly, i don't see any good in using Tomcat embedded libs as that would tie you to the versions that Tomcat uses. Had been there, done that, and will never do

Re: OT: N+1 Best Practice

2005-10-21 Thread Daniel Henrique Ferreira e Silva
Hi Zoran, Usually i try to follow all normalization rules when designing a database data model. But sometimes, normalizing is not the best solution in real world. In your very specific situation i'd do as follows: Survey -< Questions --- wrote: > I have a pretty straight forward

RE: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Zsolt
Does it mean that I cannot use directly the tomcat dbcp library? zsolt >-Original Message- >From: Niels Beekman [mailto:[EMAIL PROTECTED] >Sent: Friday, October 21, 2005 10:14 AM >To: user-java@ibatis.apache.org >Subject: RE: How to use tomcat's naming-factory-dbcp.jar > >Ok, then you pro

RE: iBaits ignores my TyeHandler

2005-10-21 Thread Niels Beekman
You only defined the typehandler for resultmaps (reads), to make it also work with updates and inserts, you need to: - define a parameterMap with the typehandler - declare typehandler globally in the config using the typehandler-tag When you choose the latter option, you can remove the typehandl

iBaits ignores my TyeHandler

2005-10-21 Thread Reza Farsi
Hi all, to handle the new Java 5 object type (enum), I started a test project to handle the enums. I simply define an object to be persisted called TestEnum. It has two attributes, an LangEnum (enum) and an integer. In my xml config file I defined the type handler for this attribute. After start

RE: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Niels Beekman
Ok, then you probably have to write your own transactionmanager and put the following in your SQLMap config.xml: This requires implementations of: - com.ibatis.sqlmap.engine.transaction.TransactionConfig (extend com.ibatis.sqlmap.engine.transaction.BaseTransactionConfig) - com.i

RE: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Zsolt
Thank you Niels, but I would like configure the database connection in sqlmap-config.xml. Because we ship our application with tomcat it would be easier if we could configure ibatis to use naming-factory-dbcp.jar that is always there. Zsolt >-Original Message- >From: Niels Beekman [mailt

RE: How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Niels Beekman
You should reference the datasources defined in Tomcat using JNDI, this can be found in the documentation. Niels -Original Message- From: Zsolt [mailto:[EMAIL PROTECTED] Sent: vrijdag 21 oktober 2005 9:15 To: user-java@ibatis.apache.org Subject: How to use tomcat's naming-factory-dbcp.ja

How to use tomcat's naming-factory-dbcp.jar

2005-10-21 Thread Zsolt
Hi, I use tc-5.5.12 and that is shipped with naming-factory-dbcp.jar. It looks like it has new class names such as: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory How do I have to configure sqlmap-config.xml to use this library? Zsolt