Date problem

Hello, I work with Java, Ibatis and PostGreSql. I use date type from postGre (different from timestamp) which store only the date without time. For a postgre date (2005-10-1) , I get this java value using ibatis Sat Oct 01 01:00:00 CEST 2005 and not Sat Oct 01 00:00:00 CEST 2005 . Is this

Re: Date problem

Hi, Not sure but some date types in Postgresql store the timezone as well. So, check if this is your situation and if the database timezone is the same as your java application Locale configuration. Hope that helped, Daniel Silva. On 10/20/05, TNO [EMAIL PROTECTED] wrote: Hello, I work with

Switching from local to global Transactions at runtime?

(Been out of the loop for a while ... so apologies for stupid question.) Is it possible to switch the transactional properties from local to global at runtime? Are there any good examples I can use? I am aware that the SqlMapClient, when created, relates to one of the following transactional

Re: Request to change access modifiers

For the record, iBATIS can return XML as a string as well, which you can then simply pass to an StringReader or whatever you like. If that's seriously all you're doing, then I'd be worried that the extension is too complex for what it does. Furthermore, please consider this advanced warning that

Re: Switching from local to global Transactions at runtime?

Well, as much as I'd like to just tell you how bad of an idea that is, I'll tell you how to do this... :-) My recommendation would be to have two SqlMapClient instancesand two SqlMapConfig.xml files (one configured for global, one for local). Switching between the two would simply mean

Re: using result maps within result maps

If it's 1:1 or M:1 (vs. M:N or 1:M), then why not just join the tables and use dot.notation.to.specify.the.properties you want to map to? The resultMap attribute is part of the M:N N+1 selects solution...it's not just for arbitrary mapping using a different result mapthere's no need, as you

Re: Request to change access modifiers

Clinton, I'm not sure it matters, however, I am not simply returning a string of XML. The extension I've written is a subclass of java.io.InputStream. This stream can be consumed by anything that would normally use it (i.e. an XML parser, an XSLT transformation, or simply streaming it to a

Re: Implicit Result Maps

Yes. See: http://issues.apache.org/jira/browse/IBATIS-172?page=all On 10/20/05, Meindert [EMAIL PROTECTED] wrote: Is it possible to use Implicit Result Maps for (not to) complex properties? Example; I've got a Person_Id as FK and the FirstName, LastName in a other table. I would

dataSource simple or dbcp?

Hi, as far as I understand, ibatis is shipped with a simple dataSource implementation. Is that as good as DBCP for production? Zsolt

Re: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Hi Zack, It seems ok for me when checked against the dtd. One thing that could be causing this, and i'm guessing here, is that you're using Eclipse and maybe compiling/running your app inside it using an invalid DOCTYPE. Replace in the DOCTYPE where you have www.ibatis.com for ibatis.apache.org

RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Daniel, Thanks for the idea on the DOCTYPE change. Unfortunately it didn't help. This one really has me stumped. I have started the web app through the tomcat startup script (in other words without eclipse) and still have the same error. So it would seem that eclipse is not the

RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

The stack trace suggests that the problem is in your com/tabarca/dao/ibatis/maps/User.xml file, not the sql-map-config.xml file. Can you post that one instead? Geoff --- Zack Chandler [EMAIL PROTECTED] wrote: Daniel, Thanks for the idea on the DOCTYPE change. Unfortunately it didn't

RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Geoff, Here is the User.xml file. I really appreciate the help. Thanks, Zack ?xml version=1.0 encoding=UTF-8? sqlMap namespace=User resultMap id=result class=com.tabarca.domain.User result property=id column=id / result

RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Try putting the sqlMap DOCTYPE into this file: !DOCTYPE sqlMap PUBLIC -//iBATIS.com//DTD SQL Map 2.0//EN http://www.ibatis.com/dtd/sql-map-2.dtd; (Or ibatis.apache.org, of course. I just copied the one I'm using.) Geoff --- Zack Chandler [EMAIL PROTECTED] wrote: Geoff,

RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Geoff, That did the trick! Thanks a ton! Zack -Original Message- From: Geoff Chiang [mailto:[EMAIL PROTECTED] Sent: Thursday, October 20, 2005 4:19 PM To: user-java@ibatis.apache.org Subject: RE: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas? Try

Re: SAXParseException... Error parsing XPath '/sqlMapConfig/sqlMap' -- any ideas?

Hey Zack, Good you had your issue solved. Again, just want to warn you to change your DOCTYPE elements for ibatis.apache.org. Clinton has already warned iBATIS users to do that as it was costing him more money due to the bandwidth consumption. You know, some editors/IDEs reach the URL looking

OT: N+1 Best Practice

I have a pretty straight forward situation: In a html form we ask a number of questions which have check box answers. When the form is submitted we used to save the responses for each question as a comma delimited string of the results in a table with a unique identifier and string fields, as