Unicode support for ibatis

2006-04-17 Thread Juan Cañadas
Hi i'm working with ibatis, struts and Oracle 9... when I get data published by a form, UTF-8 encoded, it's stored in a nvarchar2 column (Oracle 9)... When I display this data, it's displayed as in the html code... I'm working with Oracle's thin client,

Re: Abator, How to use generated code

2006-04-17 Thread Jeff Butler
The basic steps are these: 1. Create an SqlMapConfig.xml file that lists all the generated SQL map files. This file also needs to specify the database connection properties, and make sure that statement namespaces are enabled. You can read about the format of the SqlMapConfig file in the SQL Map

Need Help with JNDI Connection

2006-04-17 Thread Ali, Mohammed \(Liquidity Risk Technology\)
Title: Need Help with JNDI Connection Hi, Please help me with this error. SqlMapConfig.xml transactionManager type=JDBC dataSource type=JNDI property name=cams value=java:jdbc/cams_dev/ /dataSource /transactionManager I have connection pooling datasource set on the test server in

RE: Need Help with JNDI Connection

2006-04-17 Thread Niels Beekman
Title: Need Help with JNDI Connection Should be: name=cams should be: name=DataSource Niels From: Ali, Mohammed (Liquidity Risk Technology) [mailto:[EMAIL PROTECTED] Sent: maandag 17 april 2006 18:07 To: user-java@ibatis.apache.org Subject: Need Help with JNDI Connection

RE: Need Help with JNDI Connection

2006-04-17 Thread Voorhoeve, Niels {PBG}
Title: Need Help with JNDI Connection Looks like you need to specify the "DataSource" property. My config looks like this: transactionManager type="JDBC" dataSource type="JNDI" property name="DataSource" value="dev.ap.ap.datasource"/ /dataSource /transactionManager From: Ali,

RE: Need Help with JNDI Connection

2006-04-17 Thread Ali, Mohammed \(Liquidity Risk Technology\)
Title: Message Hi Niel, I changed to as per your suggestion and still getting same error. Also tried without"java:" from value and same results I have 2 config files as 2 different datasources. Is this the issue as application needs to see 2 databases. SqlMapConfigCams.xml

RE: Need Help with JNDI Connection

2006-04-17 Thread Erica Cody
I am using a datasource, and here is how it is defined. This seems to work. I know I had to remove the java: prefix. transactionManager type=JDBC dataSource type=JNDI property name=DataSource value=jdbc/MyDatasourceName / /dataSource /transactionManager

RE: Need Help with JNDI Connection

2006-04-17 Thread Erica Cody
I am using a datasource with Websphere 5.1 and here is how mine is defined. I know I had to remove the java: previx. transactionManager type=JDBC dataSource type=JNDI property name=DataSource value=jdbc/myDataSourceName / /dataSource /transactionManager

Re: Need Help with JNDI Connection

2006-04-17 Thread Balaji
Title: Message Ali, Try this !-- JNDI DataSource JDBC Transaction Manager --transactionManager commitRequired="true" type="EXTERNAL" property name="DefaultAutoCommit" value="false"/property name="SetAutoCommitAllowed" value="false"/ dataSource type="JNDI"property name="DataSource"

Re: Need Help with JNDI Connection

2006-04-17 Thread Christopher . Mathrusse
I believe your JNDI reference should read either as: property name=cams value=java:comp/env/jdbc/cams_dev/ or property name=cams value=jdbc/cams_dev/ The correct one depends upon your context. Chris Mathrusse [EMAIL PROTECTED] Sybase, Inc One Sybase Drive Dublin, CA 94568 (925) 236-5553

RE: Need Help with JNDI Connection

2006-04-17 Thread Ali, Mohammed \(Liquidity Risk Technology\)
Title: Message All Thank You, Your suggestion worked. Just curios for multiple datasources, do I need separate config files or add Datasource in the one file ? transactionManager type="JDBC" dataSource type="JNDI" property name="DataSource" value="jdbc/cams_dev"/ /dataSource

RE: Need Help with JNDI Connection

2006-04-17 Thread Christopher . Mathrusse
If you are going to have multiple data sources then you need to place them in separate config files. Then that also means you are going to need to think about distributed transactions and an external transaction manager. Chris Mathrusse [EMAIL PROTECTED] Sybase, Inc One Sybase Drive Dublin, CA

RE: Unicode support for ibatis

2006-04-17 Thread Shannon, Bryan
I have no trouble using unicode with iBatis, and didn't have to do any configuration for it to work; However, I use Sybase and ran into a similar problem with unicode and java although not related to iBatis, so maybe this will help. You should connect to oracle saying I'm Unicode, and I want a

RE: Need Help with JNDI Connection

2006-04-17 Thread Shannon, Bryan
Title: Message I use multiple datasources... I use separate instances of SqlMapClient, each built from separate config files... I don't think iBatis supports having a single SqlMapClient with multiple datasources (it might have in the 1.x series). But it's a good idea not to support that

Re: Adding sqlmap at runtime

2006-04-17 Thread Marcelo Martins
I need this too. Its only thing that miss in ibatis for me.On 2/23/06, Richard Lin [EMAIL PROTECTED] wrote: Is there anyway to add/load a sqlmap XML file at runtime instead ofincluding in the sqlmap-config file? I'm working on a framework that needs to discover and load sqlmapfiles dynamically

Namespace Again

2006-04-17 Thread Zoran Avtarovski
When using Ibatis 2.x do I need to have the setting useStatementNamespaces=true in order to access select statements in other sql mapping files? At present I don't and I'm getting an error when trying to access a statement in another file. For example I have a result map entry: result