RE: [MVC-Programmers] IBatis returns null
Vic, 1.i do not need a web app. Only, simple java app. 2.I tried both Dbcp and SimpleDataSourceFactory. both give null. Connecting to oracle database. I know it is connecting to the database, because it complains if i leave syntax errors. This is the sample that i am trying to run - from IBatis Web site: SqlMapConfigExample.xml datasource name=basic default = true factory-class=com.ibatis.db.sqlmap.datasource.SimpleDataSourceFactory property name=JDBC.Driver value=${driver}/ property name=JDBC.ConnectionURL value=${url}/ property name=JDBC.Username value=${username}/ property name=JDBC.Password value=${password}/ /datasource sql-map resource=examples/sqlmap/maps/Account.xml / Account.xml result-map name=indexed-account-result2 class=examples.domain.Account property name=id column=ACC_ID columnIndex=1/ property name=firstNamecolumn=ACC_FIRST_NAME columnIndex=2/ property name=lastName column=ACC_LAST_NAME columnIndex=3/ /result-map mapped-statement name=getAccount cache-model=account-cache result-map=indexed-account-result2 select ACC_ID, ACC_FIRST_NAME, ACC_LAST_NAME from ACCOUNT where ACC_ID = #value# /mapped-statement * SqlMapConfigExample.java (Don't i have to use the datasource name basic anywhere ? static { Reader reader = Resources.getResourceAsReader(examples/sqlmap/maps/SqlMapConfigExample.xml ); sqlMap = XmlSqlMapBuilder.buildSqlMap(reader); } *** QueryForListExample.java SqlMap sqlMap = SqlMapConfigExample.getSqlMap(); try { sqlMap.startTransaction(); Account account = (Account) sqlMap.executeQueryForObject(getAccount, new Integer(1)); sqlMap.commitTransaction(); } Sorry about the long email Santhi -Original Message- From: Vic Cekvenich [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 3:49 PM To: [EMAIL PROTECTED] Subject: Re: [MVC-Programmers] IBatis returns null It's best to use JNDI container DataSource pools, howerver: datasource name=ids factory-class=com.ibatis.db.sqlmap.datasource.SimpleDataSourceFactory default=true property name=JDBC.Driver value=org.postgresql.Driver/ property name=JDBC.ConnectionURL value=jdbc:postgresql://localhost:5432/bp?autoReconnect=true/ property name=JDBC.Username value=bpuser/ property name=JDBC.Password value=changeme/ /datasource aboove is a sample iBatis pool. I think that was your question. From there, it is just standard iBatis. .V Peyathevar, Santhi {PBG} wrote: All: 1.I am trying to use IBatis for running some SQL from simple java code. 2.using DbcpDataSourceFactory 3.It connects to the database but the result is null Can anybody help? Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] struts double action execution!?
Frank, HttpRequest that you see in Action Class has some get..Path methods. That might help to see where the action was called from Santhi -Original Message- From: Otto, Frank [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:51 AM To: '[EMAIL PROTECTED]' Subject: AW: [MVC-Programmers] struts double action execution!? Is there a possibility in struts to check from where was the action called? -Ursprüngliche Nachricht- Von: Peyathevar, Santhi {PBG} [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 9. Oktober 2003 17:02 An: '[EMAIL PROTECTED]' Betreff: RE: [MVC-Programmers] struts double action execution!? Frank, Where you meant to forward to a jsp page (n Struts config.) may be you are forwarding to the action again? Santhi -Original Message- From: Otto, Frank [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:08 AM To: '[EMAIL PROTECTED]' Subject: AW: [MVC-Programmers] struts double action execution!? Thanks for your answer. No, I have no sub-class. In struts-config.xml there is only this entry: controller contentType=text/html;charset=ISO-8859-1 debug=3 locale=true nocache=true maxFileSize=2M / Regards, Frank -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 9. Oktober 2003 15:30 An: [EMAIL PROTECTED] Betreff: Re: [MVC-Programmers] struts double action execution!? Have you sub-classed the RequestProcessor? if so I would look in there to see if there are any hassles with the code. Cheers, Kristen. -- Kristen Gillard Multitask Consulting Pty Ltd Lvl 8, 20 Loftus Street, Circular Quay, NSW, 2000 -- Ph: 61-2-9252-1462 Fx: 61-2-9252-4636 Mo: 0409-000-123 -- http://www.multitask.com.au/ Otto, Frank [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/10/2003 10:37 PM Please respond to [EMAIL PROTECTED] To '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc Subject [MVC-Programmers] struts double action execution!? Hello, I have a difficult problem. My action was executed twice and I don't know why. There is a global forward in my main.jsp: %@ taglib uri=/WEB-INF/struts-logic.tld prefix=logic % logic:forward name=startpage/ struts-config.xml: struts-config global-forwards forward name=startpage path=/action/welcome / ... /global-forwards action-mappings action path=/welcome type=test.actions.CWelcomeAction name=loginForm scope=request validate=false forward name=Success path=dos.Welcome / /action ... /action-mappings tiles-def.xml: tiles-definitions definition name=dos.DefaultLayout page=/pages/layouts/dosDefaultLayout.jsp put name=header value=/pages/header/empty.jsp/ put name=agb value=/pages/submenu/common/agb.jsp/ /definition definition name=dos.WelcomeLayout extends=dos.DefaultLayout put name=header value=/pages/header/startpage.jsp/ put name=mainmenu_top value=/pages/mainmenu_top/emptymain.jsp/ put name=mainmenu_bottom value=/pages/mainmenu_bottom/welcomemain.jsp/ put name=submenu value=/pages/submenu/main/login.jsp/ put name=navigation value=/pages/navigation/empty.jsp/ /definition definition name=dos.Welcome extends=dos.WelcomeLayout put name=caption value=/pages/captions/main/welcome.jsp/ put name=content value=/pages/mainpage/main/welcome.jsp/ /definition ... /tiles-definitions That was written in the log-file: DEBUG 2003-10-09 08:50:46,204 - Get module name for path /action DEBUG 2003-10-09 08:50:46,204 - Module name found: default DEBUG 2003-10-09 08:50:46,205 - Processing a 'GET' for path '/welcome' DEBUG 2003-10-09 08:50:46,205 - Looking for ActionForm bean instance in scope 'request' under attribute key 'loginForm' DEBUG 2003-10-09 08:50:46,205 - Creating new ActionForm instance of type 'test.forms.main.CLoginForm' DEBUG 2003-10-09 08:50:46,205 - -- [EMAIL PROTECTED] DEBUG 2003-10-09 08:50:46,205 - Storing ActionForm bean instance in scope 'request' under attribute key 'loginForm' DEBUG 2003-10-09 08:50:46,206 - Populating bean properties from this request DEBUG 2003-10-09 08:50:46,206 - BeanUtils.populate([EMAIL PROTECTED], {}) DEBUG 2003-10-09 08:50:46,206 - Looking for Action instance for class test.actions.CWelcomeAction DEBUG 2003-10-09 08:50:46,206 - Returning existing Action instance DEBUG 2003-10-09 08:50:46,206 - Begin CWelcomeAction.execute() DEBUG 2003-10-09 08:50:46,206 - dispatch: ActionConfig[path=/welcome,name=loginForm,scope=request,type=test.actions.CW elcome Action ... DEBUG 2003-10-09 08:50:46,211 - End CWelcomeAction.execute() DEBUG 2003-10-09 08:50:46,211 - processForwardConfig(dos.Welcome, false) DEBUG 2003-10-09 08:50:46,212 - uri=/pages/layouts/dosDefaultLayout.jsp doInclud e=false DEBUG 2003-10-09 08:50
RE: [MVC-Programmers] struts double action execution!?
Frank, Where you meant to forward to a jsp page (n Struts config.) may be you are forwarding to the action again? Santhi -Original Message- From: Otto, Frank [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 10:08 AM To: '[EMAIL PROTECTED]' Subject: AW: [MVC-Programmers] struts double action execution!? Thanks for your answer. No, I have no sub-class. In struts-config.xml there is only this entry: controller contentType=text/html;charset=ISO-8859-1 debug=3 locale=true nocache=true maxFileSize=2M / Regards, Frank -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 9. Oktober 2003 15:30 An: [EMAIL PROTECTED] Betreff: Re: [MVC-Programmers] struts double action execution!? Have you sub-classed the RequestProcessor? if so I would look in there to see if there are any hassles with the code. Cheers, Kristen. -- Kristen Gillard Multitask Consulting Pty Ltd Lvl 8, 20 Loftus Street, Circular Quay, NSW, 2000 -- Ph: 61-2-9252-1462 Fx: 61-2-9252-4636 Mo: 0409-000-123 -- http://www.multitask.com.au/ Otto, Frank [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/10/2003 10:37 PM Please respond to [EMAIL PROTECTED] To '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc Subject [MVC-Programmers] struts double action execution!? Hello, I have a difficult problem. My action was executed twice and I don't know why. There is a global forward in my main.jsp: %@ taglib uri=/WEB-INF/struts-logic.tld prefix=logic % logic:forward name=startpage/ struts-config.xml: struts-config global-forwards forward name=startpage path=/action/welcome / ... /global-forwards action-mappings action path=/welcome type=test.actions.CWelcomeAction name=loginForm scope=request validate=false forward name=Success path=dos.Welcome / /action ... /action-mappings tiles-def.xml: tiles-definitions definition name=dos.DefaultLayout page=/pages/layouts/dosDefaultLayout.jsp put name=header value=/pages/header/empty.jsp/ put name=agb value=/pages/submenu/common/agb.jsp/ /definition definition name=dos.WelcomeLayout extends=dos.DefaultLayout put name=header value=/pages/header/startpage.jsp/ put name=mainmenu_top value=/pages/mainmenu_top/emptymain.jsp/ put name=mainmenu_bottom value=/pages/mainmenu_bottom/welcomemain.jsp/ put name=submenu value=/pages/submenu/main/login.jsp/ put name=navigation value=/pages/navigation/empty.jsp/ /definition definition name=dos.Welcome extends=dos.WelcomeLayout put name=caption value=/pages/captions/main/welcome.jsp/ put name=content value=/pages/mainpage/main/welcome.jsp/ /definition ... /tiles-definitions That was written in the log-file: DEBUG 2003-10-09 08:50:46,204 - Get module name for path /action DEBUG 2003-10-09 08:50:46,204 - Module name found: default DEBUG 2003-10-09 08:50:46,205 - Processing a 'GET' for path '/welcome' DEBUG 2003-10-09 08:50:46,205 - Looking for ActionForm bean instance in scope 'request' under attribute key 'loginForm' DEBUG 2003-10-09 08:50:46,205 - Creating new ActionForm instance of type 'test.forms.main.CLoginForm' DEBUG 2003-10-09 08:50:46,205 - -- [EMAIL PROTECTED] DEBUG 2003-10-09 08:50:46,205 - Storing ActionForm bean instance in scope 'request' under attribute key 'loginForm' DEBUG 2003-10-09 08:50:46,206 - Populating bean properties from this request DEBUG 2003-10-09 08:50:46,206 - BeanUtils.populate([EMAIL PROTECTED], {}) DEBUG 2003-10-09 08:50:46,206 - Looking for Action instance for class test.actions.CWelcomeAction DEBUG 2003-10-09 08:50:46,206 - Returning existing Action instance DEBUG 2003-10-09 08:50:46,206 - Begin CWelcomeAction.execute() DEBUG 2003-10-09 08:50:46,206 - dispatch: ActionConfig[path=/welcome,name=loginForm,scope=request,type=test.actions.CW elcome Action ... DEBUG 2003-10-09 08:50:46,211 - End CWelcomeAction.execute() DEBUG 2003-10-09 08:50:46,211 - processForwardConfig(dos.Welcome, false) DEBUG 2003-10-09 08:50:46,212 - uri=/pages/layouts/dosDefaultLayout.jsp doInclud e=false DEBUG 2003-10-09 08:50:46,214 - insert page='/pages/header/startpage.jsp'. DEBUG 2003-10-09 08:50:46,219 - insert page='/pages/mainmenu_bottom/welcomemain. jsp'. DEBUG 2003-10-09 08:50:46,226 - insert page='/pages/submenu/main/login.jsp'. DEBUG 2003-10-09 08:50:46,230 - insert page='/pages/submenu/common/agb.jsp'. DEBUG 2003-10-09 08:50:46,236 - insert page='/pages/navigation/empty.jsp'. DEBUG 2003-10-09 08:50:46,238 - insert page='/pages/captions/main/welcome.jsp'. DEBUG 2003-10-09 08:50:46,240 - insert page='/pages/mainpage/main/welcome.jsp'. DEBUG 2003-10-09 08:50:46,242 - 'dos.Welcome' - processed as definition THE SECOND ONE: DEBUG
RE: Re: [MVC-Programmers] Design for Requirements
I always wondered: Why does the Object Model have to keep changing with requirements and not the Database Design ! Santhi :) ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] Help: Lab2
Any one who has taken Vic's web class: Lab2, Step N: Bean and Unit Test I have the results coming out of the Test Servlet. To display all the rows, do i need to write a method in my bean (TaskBean) or is there some infrastructure in ScaFfolding\BaseBean.java -looks like there is some in BaseBean.java (getDisplayList). But a lot of reflection(?) is going on. Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] new newsgroups:Lab1
Yes. I realised that the classes folder was getting cleaned up whenever i built. I ended up copying the properties dir. manually to classes dir. from a temp. location. Any .properties from src dir gets copied to classes dir? (eclipse does that? We usually keep the property files in WEB-INF and use that path in the config files) * Received the class notes/CD. Thank you very much. *** The report pdf (tasks.pdf) had only the template (The database column names). Not the data from the database? Will try once again tonight. Please let me know if it is an obvious mistake. *** Santhi -Original Message- From: Vic Cekvenich [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 11:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [MVC-Programmers] new newsgroups:Lab1 Glad you sollved it. This question has come up before in a private class. Also do not modify classes folder. Modify file in source, so when you compile it replaces classes content. .V Peyathevar, Santhi {PBG} wrote: All: Problem: My taskEdit.jsp is not picking up the message from property file 1.taskEdit.jsp: fmt:message key=pepsi.task.name/ 2.struts.xml: message-resourcesparameter=properties/messages_en-US/ 3.messages.properties, messages_en-US.properties exist in WEB-INF\classes\properties 4.property entries are in both .property files What am i missing? In step 2, tried: parameter=WEB-INF/classes/properties/messages_en-US Santhi -- Vic Cekvenich, Struts Instructor, 1-800-917-JAVA Advanced a href =baseBeans.comStruts Training/a and project recovery in North East. Open Source a href =baseBeans.comContent Management/a basicPortal sofware Best practicea href =baseBeans.comStruts Support/a v.1.1 helper ScafflodingXPress ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] new newsgroups:Lab1
All: Problem: My taskEdit.jsp is not picking up the message from property file 1.taskEdit.jsp: fmt:message key=pepsi.task.name/ 2.struts.xml: message-resourcesparameter=properties/messages_en-US/ 3.messages.properties, messages_en-US.properties exist in WEB-INF\classes\properties 4.property entries are in both .property files What am i missing? In step 2, tried: parameter=WEB-INF/classes/properties/messages_en-US Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] Frames / IFrames
Is it alright to use Frames / IFrames in Struts based App? Does the Navigation suffer in any way? (We have an existing Frame based pages) Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] new newsgroups:Lab1
Gary, Looks like it does not matter whether we have it as messages_en-US or messages 1. If available, it takes from the messages_en-US.properties file. Else looks in messages.properties 2. added fmt:setBundle basename='properties.messages'/ to the jsp file. Now it works Santhi -Original Message- From: Gary Boal [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 1:39 PM To: [EMAIL PROTECTED] Subject: Re: [MVC-Programmers] new newsgroups:Lab1 I believe you need to remove the _en-US from the filename when identifying it in the struts-config.xml file. Struts will append the suffix automatically. E.g. message-resourcesparameter=properties/messages/ Gary Boal [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Original Message - From: Peyathevar, Santhi {PBG} mailto:[EMAIL PROTECTED] To: '[EMAIL PROTECTED]' mailto:'[EMAIL PROTECTED]' Sent: Wednesday, July 09, 2003 10:08 AM Subject: RE: [MVC-Programmers] new newsgroups:Lab1 All: Problem: My taskEdit.jsp is not picking up the message from property file 1.taskEdit.jsp: fmt:message key=pepsi.task.name/ 2.struts.xml: message-resourcesparameter=properties/messages_en-US/ 3.messages.properties, messages_en-US.properties exist in WEB-INF\classes\properties 4.property entries are in both .property files What am i missing? In step 2, tried: parameter=WEB-INF/classes/properties/messages_en-US Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] help
Is there a way to display the input field as empty? html:text name= valObj property= price Net Price I have a double price field in my value object. JSP uses the value object, defined as a bean in the JSP page. i do not want the value to be displayed, if it is zero. If i use logic:equal, the field itself is not displayed. 1.we could have a parallel String field in my Value Obj - just for display purpose. 2.we could write scriplets Is there any other way? Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] Former Students
Vic, The private email does not seem to reach you? Santhi -Original Message- From: Vic Cekvenich [mailto:[EMAIL PROTECTED] Sent: Saturday, May 31, 2003 8:36 PM To: [EMAIL PROTECTED] Subject: [MVC-Programmers] Former Students If a former student wants to take this new class (I suggest you do, same topics but better materials) please let me know via a private e-mail. -- Vic Cekvenich, Struts Instructor, 1-800-917-JAVA Advanced a href =baseBeans.comStruts Training/a and project recovery in North East. Open Source a href =baseBeans.comContent Management/a basicPortal sofware Best practicea href =baseBeans.comStruts Support/a v.1.1 helper ScafflodingXPress ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
RE: [MVC-Programmers] Re: action chaining [was] Re: major headaches:)
I am not an expert. But successfully completed 2 modules of Struts code. It was a pleasure to see how beautifully things fall in place. 1.Navigation did not have to consider the form bean (as long as we keep track of the Model / object(s)) 2.One action per form - (at a time :yes). But i have multiple buttons on the page. Each one maps to one action. We could use any recommendation / sample only as a guideline. Individual's situation may require a variation of design. Would not be fair to blame the sample or best practice if that does not suit 100% of our requirements. Vic and Rick need a small break? :) Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
[MVC-Programmers] help Lab1
All: I am trying to use the Tiles- insert header layouts.xml looks like this: tiles-definitions definition name=baseDef template=/portlets/Layout.jsp put name=title value=basicPortal com/ put name=logo value=/portlets/common/logo.jsp/ put name=header value=/portlets/common/header.jsp/ put name=leftBar value=/portlets/common/leftBar.jsp/ put name=bodyvalue=/index.jsp/ put name=adBar value=/portlets/common/adBarA.jsp/ put name=footer_left value=/portlets/common/footer_left.jsp/ put name=footer value=/portlets/common/footer.jsp/ put name=footer_right value=/portlets/common/footer_right.jsp/ put name=css value=/portlets/css/css.jsp/ /definition definition name= cmsList.pgextends =baseDef put name= body value=/portlets/CMSLst.jsp/ /definition /tiles-definitions ** java.lang.NullPointerException at org.apache.struts.taglib.tiles.InsertTag.processAttribute(Ljava.lang.String; )Lorg.apache.struts.taglib.tiles.InsertTag$TagHandler;(InsertTag.java:651) at org.apache.struts.taglib.tiles.InsertTag.createTagHandler()Lorg.apache.strut s.taglib.tiles.InsertTag$TagHandler;(InsertTag.java:483) *** Have you seen this problem before? Am i doing something wrong? Thank you Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
[MVC-Programmers] Introduction
I do not remember if i have introduced myself already. Would not hurt to introduce again. a. name : Santhi Peyathevar b. real organization:Pepsico/PBG, Somers, NY c. role : Developer in a Middleware/Architecture Team d. Years of java/web. : About 5 / 2 e. What your expectations of the class are.: Hoping to find one simple/good way to develop a web application. f. Something non technical, like last fiction book read, or a non-computer hobby: To Kill a Mocking Bird - still half way - Very nicely written, hobby - trying to learn music from my daughter. I will try to dig through the archives for your intro's. Santhi ___ MVC-Programmers mailing list [EMAIL PROTECTED] http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers