RE: Oracle OC4J and signon
Hi David, After looking at the screen attached, i'm sure your problem is NOT the application. It seems to be a realm problem or, if OC4J has integrated authentication with Windows, an OC4J config issue. Let us know when/how you fixed this issue. Cheers, Daniel Silva. --- Trussell David N [EMAIL PROTECTED] wrote: My apologies for attaching a screenshot. I understand that's frowned upon in a discussion list, but I don't know a better way of answer your question. It's the same window in Firefox and MS IE6. I assume it's an MS Windows window. Maybe I'll look at it as a Windows configuration problem instead of an OC4J trick. I'll check into the realm thing, too. Thank you very much for your reply. -Original Message- From: Daniel H. F. e Silva [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 6:01 AM To: ibatis-user-java@incubator.apache.org Subject: RE: Oracle OC4J and signon Hi David, What is this window? A MS Windows window? A basic realm window? Have you checked if your webserver has any kind of realm configured? Hope that helps. Cheers, Daniel Silva. --- Trussell David N [EMAIL PROTECTED] wrote: It's the same database.properties file that's under Tomcat and that works just fine. I thought maybe the JDBC driver had to be in /WEB-INF/lib under jpetstore so I tried both classes12.jar and ojdbc14.jar. Nope. I also put something totally bogus for the driver name in database.properties and it didn't even complain (at least, anywhere I can see). It's just pops up that window. Ya know, this is really maddening. I've spent two days trying to get Appfuse running on OC4J with no success. Even Matt Raible and company couldn't help me. Now it's the same thing with iBATIS. Heavy sigh. I really wish I could just use Tomcat. -Original Message- From: Brice Ruth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 2:38 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Oracle OC4J and signon Is your DB connection authenticating properly to Oracle? I get this with DB2 if my password has expired or the account has been locked out. Brice On 5/11/05, Trussell David N [EMAIL PROTECTED] wrote: I've just deployed JPetStore to Oracle OC4J 10.1.2 (I've also tried 9.0.4) on Win XP and when I click Sign-in or Enter the Store an authentication window pops-up asking for my userid and password. I can't get past it. Where can I disable this? Thank you. -- Brice Ruth Software Engineer, Madison WI __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
Re: java.sql.PreparedStatement or java.sql.Statement used?
Hi Martin, iBATIS has a feature for allowing this kind of situation. It's syntax is like this: select * from ACCOUNT_$category$ You'll find all necessary details in the iBATIS Developer Guide. Cheers, Daniel Silva. --- Zeltner Martin [EMAIL PROTECTED] wrote: Hello, I've tried to find out in which combination a java.sql.PreparedStatement and in which a java.sql.Statement is used. Is there a possability to config each statement? I'd like to realize that I can access a table dependent of a given parameter. The sql could looks like the following: select * from ACCOUNT_#category# Of course, in this case a PreparedStatement will not work. Does anyone can tell me how I can switch between prepared and not prepared statements? Is this issue somewhere documented? Thanks, Martin __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
RE: Oracle OC4J and signon
Hi David, What is this window? A MS Windows window? A basic realm window? Have you checked if your webserver has any kind of realm configured? Hope that helps. Cheers, Daniel Silva. --- Trussell David N [EMAIL PROTECTED] wrote: It's the same database.properties file that's under Tomcat and that works just fine. I thought maybe the JDBC driver had to be in /WEB-INF/lib under jpetstore so I tried both classes12.jar and ojdbc14.jar. Nope. I also put something totally bogus for the driver name in database.properties and it didn't even complain (at least, anywhere I can see). It's just pops up that window. Ya know, this is really maddening. I've spent two days trying to get Appfuse running on OC4J with no success. Even Matt Raible and company couldn't help me. Now it's the same thing with iBATIS. Heavy sigh. I really wish I could just use Tomcat. -Original Message- From: Brice Ruth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 2:38 PM To: ibatis-user-java@incubator.apache.org Subject: Re: Oracle OC4J and signon Is your DB connection authenticating properly to Oracle? I get this with DB2 if my password has expired or the account has been locked out. Brice On 5/11/05, Trussell David N [EMAIL PROTECTED] wrote: I've just deployed JPetStore to Oracle OC4J 10.1.2 (I've also tried 9.0.4) on Win XP and when I click Sign-in or Enter the Store an authentication window pops-up asking for my userid and password. I can't get past it. Where can I disable this? Thank you. -- Brice Ruth Software Engineer, Madison WI __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail
Re: How to support multiple SQL dialects?
Hi Karsten, I'd recommend using ANSI SQL. Almost all databases support it. Specially regarding join syntax. Oracle is one example. I used to write joins this way: select foo from blah1 a, blah2 b where a.id = b.a_id Writing that in ANSI SQL would be: select foo from blah1 a inner join blah2 b on (a.id = b.a_id) After rewriting all my SQL statements to be ANSI-compliant, i didn't have problems porting to another database anymore. Hope that helped. Cheers, Daniel Silva. --- Karsten Silz [EMAIL PROTECTED] wrote: Hi! I've used SqlMaps on a couple of projects and I'm quite happy with it. However, I don't know how to handle one requirement that has shown up recently: supporting multiple SQL dialects (i.e., different JOIN syntax etc.) when you interacting with different databases. If you assume that the query just look a little different, I could see how you have multiple sets of query files and just use / ship a different one for each installation. Now could you have a base set where most queries are in (because they are the same across databases) and then sets with queries that are specific for each database (similar to accessing resource bundles)? I would really like to avoid duplicating each and every query for each supported database. Or could you use the namespace feature for that? Now this breaks down when there are queries that are one query for one database and multiple queries / queries plus Java code for another database. Would you have to build a little framework around SqlMaps then? I guess SqlMaps isn't really build to handle this kind situation. Or is it? Any help would be appreciated. -- Karsten Silz It is dangerous to be sincere unless you are also stupid. George Bernard Shaw (quote found on http://www.theinquirer.net) __ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail
Re: invalid column type
Hi Jason, According to the stack trace you've posted, i would say that you are facing problems with data type conversions done by your JDBC driver. I guess your 'isFeature' property is a boolean value and your table column 'isFeature' is of another type? If so, i faced this problem before: my java objects held boolean values and my database columns used to hold varchar2(1) values as 'Y', 'N' or 'T', 'F'. If all i mentioned above is your current situation, my advise is: write a CTH (Custom Type Handler). The iBatis Wiki has some nice details about this issue. Hope that helped. Cheers, Daniel Silva. --- Jason Punzalan [EMAIL PROTECTED] wrote: this works on mysql but not on oracle. same table layout. any ideas? insert id=insertContent parameterClass=Content ![CDATA[ insert into content(publication, modified_by, priority, source, type_id, body, id, subtitle, title, isFeature, modified, summary, page_id, enabled, created_by, created, status, sub_type) values(#publication#, #modifiedBy#, #priority#, #source#, #typeId#, #body#, #id#, #subtitle#, #title#, #isfeature#, now(), #summary#, #pageId#, #enabled#, #createdBy#, now(), draft, #subType.id#) ]] /insert org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation): encountered SQLException [ --- The error occurred in com/ruderfinn/maps/Content.xml. --- The error occurred while applying a parameter map. --- Check the insertContent-InlineParameterMap. --- Check the parameter mapping for the 'isfeature' property. --- Cause: java.sql.SQLException: Invalid column type]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ruderfinn/maps/Content.xml. --- The error occurred while applying a parameter map. --- Check the insertContent-InlineParameterMap. --- Check the parameter mapping for the 'isfeature' property. --- Cause: java.sql.SQLException: Invalid column type com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ruderfinn/maps/Content.xml. --- The error occurred while applying a parameter map. --- Check the insertContent-InlineParameterMap. --- Check the parameter mapping for the 'isfeature' property. --- Cause: java.sql.SQLException: Invalid column type Caused by: java.sql.SQLException: Invalid column type __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Help needed...
You could check also your xml encoding. If you work with special charaters not in utf-8, you will get in trouble. I had this as my native language is portuguese and we have some special characters not supported by utf-8. So, if this is your case, try iso-8859-1 or one that fits better to your needs. Cheers, Daniel Silva. --- Larry Meadors [EMAIL PROTECTED] wrote: Make sure that there is no white space and no odd chars at the top of your config file. Larry On 4/18/05, KK [EMAIL PROTECTED] wrote: I get the following error when I try to build sqlCOnfigmap..does it look familiar to someone? com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance. --- The error occurred in the SQL Map Configuration file. --- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. at com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap (XmlSqlMapClientBuilder.java:203) at com.ibatis.sqlmap.client. SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:49) Your help is greatly appreciated. Thanks, KK __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Help needed...
Hi Brice, I know that UTF-8 is supposed to cover all kind of alphabet characters available in Earth. But, i had faced this issue sometimes ago, when a parser tried to parse a file with encoding=utf-8 set and simply gave me an error message. After thinking about that issue, i simply changed encoding=utf-8 to encoding=iso-8859-1 and that fixed my problem. So, if UTF-8 is really supposed to cover all kind of stuff, why did i get that error? I'd love to hear your explanation. Cheers, Daniel Silva. --- Brice Ruth [EMAIL PROTECTED] wrote: What special characters aren't supported by UTF-8?! I have never heard of such a thing. My understanding is that UTF-8 represents the full Unicode character set as a multi-byte value. And since Unicode is supposed to encompass all known characters for all known languages (with space for new Chinese characters created daily) - what's not covered?! There most certainly shouldn't be anything that iso-8859-1 or latin1 (Windows-1252) covers that is not in Unicode. Brice On 4/20/05, Daniel H. F. e Silva [EMAIL PROTECTED] wrote: You could check also your xml encoding. If you work with special charaters not in utf-8, you will get in trouble. I had this as my native language is portuguese and we have some special characters not supported by utf-8. So, if this is your case, try iso-8859-1 or one that fits better to your needs. Cheers, Daniel Silva. --- Larry Meadors [EMAIL PROTECTED] wrote: Make sure that there is no white space and no odd chars at the top of your config file. Larry On 4/18/05, KK [EMAIL PROTECTED] wrote: I get the following error when I try to build sqlCOnfigmap..does it look familiar to someone? com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance. --- The error occurred in the SQL Map Configuration file. --- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. Cause: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. Caused by: java.io.UTFDataFormatException: Invalid byte 3 of 3-byte UTF-8 sequence. at com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder.buildSqlMap (XmlSqlMapClientBuilder.java:203) at com.ibatis.sqlmap.client. SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:49) Your help is greatly appreciated. Thanks, KK __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- Brice Ruth Software Engineer, Madison WI __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
RE: Mapping Problem
Ben, Seems to me that you're using a sequence that gives you integer values, aren't you? So, why does your pk column has type VARCHAR(20)? If your database is Oracle, i bet the problem is happening due to converting an integer to a string and then back. What happens if you replace your #id# in the VALUES list with the call of the sequence? Cheers, Daniel Silva. --- Ben Gill [EMAIL PROTECTED] wrote: Yeah I tried that... in fact I have tried a whole nuch of things but cannot get it to work!! I am now using: typeAlias alias=offence type=com.ocado.tracker.offences.forms.OffenceForm/ insert id=addOffence parameterClass=offence selectKey resultClass=java.lang.String keyProperty=id SELECT OFFENCES_SEQ.NEXTVAL AS ID FROM DUAL /selectKey insert into OFFENCES (OFFENCE_UUID, STATUS, AUTHORITY, TICKET_NUMBER, OFFENCE, EMPLOYEE_UUID, DATETIME_OF_OFFENCE, DATETIME_OF_TICKET, SITE, FLEET_UUID, LOC_OF_OFFENCE, POSTCODE, FINE, ORDER_NUMBER, ROUTE_ID, ENTERED_BY, ASSIGNED_TO, LAST_MODIFIED_BY, LAST_MODIFIED, CREATION_DATE) values (#id#, 'new', #authority#, #ticketNumber#, #offence#, #employeeID#, to_date(#dateOfOffence#,'dd/mm/ HH24:mi'), to_date(#dateOfTicket#,'dd/mm/ HH24:mi'), #site#, #fleetID#, #locOfOffence#, #postcode#, #fine#, #orderNumber#, #routeID#, #enteredBy#, #assignedTo#, sysdate, sysdate); /insert org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation): en countered SQLException [ --- The error occurred in com/ocado/tracker/offences/dao/sql/OffenceSQL.xml. --- The error occurred while applying a parameter map. --- Check the addOffence-InlineParameterMap. --- Check the parameter mapping for the 'id' property. --- Cause: java.sql.SQLException: Invalid column type]; nested exception is com. ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ocado/tracker/offences/dao/sql/OffenceSQL.xml. --- The error occurred while applying a parameter map. --- Check the addOffence-InlineParameterMap. --- Check the parameter mapping for the 'id' property. --- Cause: java.sql.SQLException: Invalid column type com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ocado/tracker/offences/dao/sql/OffenceSQL.xml. --- The error occurred while applying a parameter map. --- Check the addOffence-InlineParameterMap. --- Check the parameter mapping for the 'id' property. --- Cause: java.sql.SQLException: Invalid column type Caused by: java.sql.SQLException: Invalid column type at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUp date(GeneralStatement.java:86) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExe cutorDelegate.java:500) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionI mpl.java:89) -Original Message- From: Aitor Imaz [mailto:[EMAIL PROTECTED] Sent: 04 February 2005 12:19 To: ibatis-user-java@incubator.apache.org Subject: Re: Mapping Problem I can see one thing, in your selectKey the resultClass attribute should be a String if I'm not wrong. You should put there the class of the primary key returned, not of the object itself. Maybe that's the cause of the error (the selectkey mapping)? Hope it helps, Aitor _ This message has been checked for all known viruses by the MessageLabs Virus Control Centre. This message has been checked for all known viruses by the MessageLabs Virus Control Centre. * Notice: This email is confidential and may contain copyright material of Ocado Limited (the Company). Opinions and views expressed in this message may not necessarily reflect the opinions and views of the Company. If you are not the intended recipient, please notify us immediately and delete all copies of this message. Please note that it is your responsibility to scan this message for viruses. Company reg. no. 3875000. Ocado Limited Titan Court 3 Bishops Square Hatfield Business Park Hatfield Herts AL10 9NE * __ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250
RE: sql fragment as parameter
Guys, Use the $property$ notation. Properties with dashes are binded using PreparedStatement class. What you want to do is a kind of macro substitution. So, use $whereCriteriaString$. For any other problems, read the iBATIS Manual. It is quite good indeed! Hope that helped you. Cheers, Daniel Silva. --- roberto [EMAIL PROTECTED] wrote: What is ld.language? Is that in the 'pojos' table with the dot notation? Roberto -Original Message- From: Kris Barnhoorn [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 11:54 AM To: ibatis-user-java@incubator.apache.org Subject: sql fragment as parameter Hi, First I'd like to thank the developers for this great tool. I'd like to insert an sql fragment as a parameter to an sql select statement. what i do is generate some sql in a class which is used as parameterClass in the xml file the whereCriteriaString constructs the string based criteria selectable on the webpage. Users can choose the make more than one filter filter: property | value | (AND | OR) add filter So I simply did this: select id=getPojos parameterClass=org.foo.SqlQuery resultClass=org.foo.Pojo SELECT * FROM `pojos` WHERE dynamic isNotEmpty property=whereCriteriaString #whereCriteriaString# /isNotEmpty /dynamic /select What generates 218 [main] DEBUG sql.PreparedStatement - {pstm-14} PreparedStatement: SELECT * FROM `pojos` WHERE ? 218 [main] DEBUG sql.PreparedStatement - {pstm-14} PreparedStatement: Parameters: [(ld.language = 'en' ) ] 218 [main] DEBUG sql.PreparedStatement - {pstm-14} Types: [java.lang.String] This doesn't work So my question is can iBatis generate this? 218 [main] DEBUG sql.PreparedStatement - {pstm-14} PreparedStatement: SELECT * FROM `pojos` WHERE (ld.language = 'en' ) I looked at iterate, but I don't think I can emulate a similar behaviour with it. Thank you, Kris. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: SQL Maps and/or DAO
Hi Albert, Well, i'm not one of the masters of iBATIS but i'm going to try to answer your questions. Brandon, Larry and Clinton, please, you can slap me if i say something stupid. ;-) 1. DAO framework and SQL Maps framework are different things. You can use both to leverage your application design, but, you can use anyone by itself. For example, i wrote once an application that used only DAO framework because i was not fetching data from a relational database but from an LDAP data source. Doing so, DAO framework gave me a invaluable feature: decoupling. No matter from where i was fetching data, my application would work the same way ever. 2. Clinton is the right guy to answer this question. But, as far as i know, JPetsore uses DAO framework too. But i can be wrong (with a large probability ;-) ). There is a simple tutorial that can help to make some points clearer to you. It was written by a great guy and friend of Brandon, Larry and Clinton. His name is Rick. Look it here: http://www.reumann.net/struts/main.do. Pick the Struts with iBATIS tutorial. That was my 2 cents! Cheers, Daniel Silva. --- Albert L. Sapp [EMAIL PROTECTED] wrote: 1. Can someone explain to me how the DAO framework enhances the use of SQL Maps framework or is the DAO framework a replacement for SQL Maps framework? Both of them seem to be used as transaction managers. All I am wanting to do is some transaction processing against a Oracle database using a JDBC connection and SQL statements. 2. When I look at the source code files for JPetStore, I can seem to follow what is happening. It seems to only use SQL Maps. Am I correct? Once I know what the relationship between the two is, I may be able to figure out how to complete the project I am working on. Right now, none of our dao.xml or sql-maps.xml files look very close to the pet store samples. Thanks, Al __ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250