13 Replies Latest reply on May 18, 2004 8:15 AM by Sherman Wood

    Getting started -- updated documentation on wiki

    Howard Pearlmutter Novice

      Hi folks --

      If you are new to Nukes, you'll find the latest documentation on how to get started at the following wiki page:

      http://jboss.org/wiki/Wiki.jsp?page=InstallUninstallUpgrade

      This is freshly-updated, step-by-step assistance on how to get up and running with Nukes on JBoss.

      For those of you who have already been through the process, you might want to take another look. The description of the process is much more detailed and refined than it was last month. If you have any corrections or suggestions for improvement, post them here (or make them directly if, you are a wiki-phile).



      -- Howard

        • 1. Re: Getting started -- updated documentation on wiki
          Howard Pearlmutter Novice


          Also, I've reorganized the main Nukes wiki page, to make it much easier for newcomers to find what they need. The general sequence of topics goes from getting-started type topics, to the advanced user topics, to the getting into development topics, to the more advanced development topics. This main Nukes wiki page is still at:

          http://jboss.org/wiki/Wiki.jsp?page=NukesForJBoss


          -- Howard

          • 2. [CALL FOR TESTING] Re: Getting started -- updated documentat
            Howard Pearlmutter Novice

            CALL FOR TESTING

            Nukes 1.1 is coming out soon -- and you can help make sure it gets tuned up nicely before it goes out the door!

            Because there are some major changes going on in the backend part of Nukes currently, we need people to do some extra testing and give some extra feedback.

            Please go through the steps at:

            http://jboss.org/wiki/Wiki.jsp?page=InstallUninstallUpgrade

            paying special attention to any rough spots you encounter with setting up datasources, or using Nukes with your chosen database.

            Besides posting any problems you encounter, please also post any successes --- include specs of your configuration, such as which database, which operating system, etc.

            Also, if you have any suggestions for improvement of the InstallUninstallUpgrade wiki, please post them here.


            Thanks!

            --Howard

            • 3. Re: Getting started -- updated documentation on wiki
              Gary Cuozzo Newbie

              I'm running last night's CVS snapshot with PostgreSQL on Linux.

              So far, I've had a few issues:
              1. I added a poll and told it to go on the right hand side, but it came out on the left. When I try to move it, I get an exception saying "javax.management.InstanceNotFoundException: nukes.blocks:name=poll is not registered."
              2. When adding a quote, I get an exception that a sequence does not exist.
              3. Tried to add a news item: java.sql.SQLException: ERROR: ExecInsert: Fail to add null value in not null attribute topic_id
              4. When logged in as admin, I cannot manage or access sections.
              5. Admin messages is just blank, I'm not sure how to add a new message.

              I'm planning to also try mysql to see if some of this is only postgresql releated.

              Cheers,
              gary.

              • 4. Re: [CALL FOR TESTING] Re: Getting started -- updated docume
                joe hobson Newbie

                 

                "hxp" wrote:
                CALL FOR TESTING
                Nukes 1.1 is coming out soon -- and you can help make sure it gets tuned up nicely before it goes out the door!


                I updated my CVS last night and took it for a spin. There were a few issues but i don't have any specific errors to show yet. One example was the news section, which i was anxious to try out since i've read much about the new enhancements. No luck trying to get an item posted. Since not too many people seem to be running on PostgreSQL I'll spend some time tracking down issues and bugs this weekend to help out.

                Also, I don't have a complete dev environment setup yet. I was trying to work via jEdit but noticed many praising Eclipse so i thought i'd try it. The Wiki on Nukes Eclipse setup wasn't very helpful though so i started updating it with whatever information I find from forum posts and via the web. I'll try to finish up that document, but if anyone wants to post simple bullet point steps (such as setting up Nukes module projects -faq, news, etc- with anonymous CVS update), i'll give it a go and fill-in the documentation as i do it. Could be helpful in easing the learning curve for JBoss/Nukes/Eclipse newbies like me.

                ... .joe

                • 5. Re: Getting started -- updated documentation on wiki
                  jae Master

                  hrm - guess i should get an instance of postgres and mysql running somewhere so i can help investigate this as well.

                  do you get any exceptions when trying to post a news item? how about when the tables are created?

                  • 6. thoughts on Nukes 1.1 RC1
                    joe hobson Newbie

                    my thoughts on Nukes 1.1 RC1

                    system:

                    JBoss 3.2.3
                    J2sdk 1.4.2_03
                    lates Nukes from CVS 2004-05-16
                    postgreSQL 7.4.1


                    Installing:
                    built completely from latest CVS, dropped old database completely
                    deployed installer, all tables created from installer, Did see two errors when tables created, in postgreSQL log


                    "ERROR: operator does not exist: boolean = integer"
                    "ERROR: column t0_s.quotesejb_upk does not exist"


                    FAQ:
                    tried out the FAQ module with no problems


                    News:
                    tried to add new topic: clicked on News Admin and then on "Create", threw pgsql error: Could not create entity:org.postgresql.util.PSQLException: ERROR: null value in column "topic_id" violates not-null constraint


                    Quotes
                    tried to add a quote. got "an error has occurred". Nothing in the logs though so it must have been trapped somewhere. Found this comment in the Quotes code right above the add: "user errors can cause this exception so I don't think it should go on the console" - i would rethink that one.
                    - looked at postgreSQL log and found these two...
                    "ERROR: relation "nuke_quotes_quotesejb_upk_seq" does not exist"
                    "ERROR: column t0_s.quotesejb_upk does not exist"


                    Polls
                    although it seemed normal the first time i went in to get the "create a new poll" screen, it seemed odd on subsequent visits. I think i would default to "manage existing polls" screen
                    i added a poll okay, but when i deployed to the right side it didn't show up
                    when i went in to blocks management it was on the left so i tried to move it to the right and it threw "some error occurred". Seems that the block is not actually registered. Won't let me edit the block registration either.


                    Sections
                    by default no one has permissions for the sections module. Would be nice to let admins have admin capabilities by default.



                    minor gripe
                    there are too many things in the left navigation so it's hard to find anything, especially since it's not in any aparent order (alphabetical or other). multiple items should be combined: News, Forums, etc. I realize that this is probably difficult because of permissions for separate items. There should probably be a second level of navigation in left side.

                    so that's what i have so far. Would definitely be willing to help test any updates that you think might fix some of these issues, especially PostgreSQL errors since i know we're faced with some new CMP issues lately and pgsql isn't the most common db configuration. Thanks for your work out there... .joe



                    • 7. Re: Getting started -- updated documentation on wiki
                      Viet Master

                      thanks for the feedback.

                      I am working on the news module and will see that.
                      I am not using postgres so I cannot test it. If you know what to modify to make it working give us the changes, that would be very helpfull

                      • 8. Re: Getting started -- updated documentation on wiki
                        joe hobson Newbie

                         

                        "cooper" wrote:
                        I am not using postgres so I cannot test it. If you know what to modify to make it working give us the changes, that would be very helpfull


                        I took a look at it this morning trying to compare the way the EJB's are done in the news module with how they were done in FAQ. In the nuke_faq table, the default value for pn_id is set to the nextval() of a sequence. Since this is all done thru CMP and xdoclet though, i'm not sure exactly how to make that happen when the table is created. There are a couple of pieces (xdoclet?) for primary key and foreign key that aren't in the TopicEJB.java. Something like this...
                        @jboss.unknown-pk
                        @ejb.pk
                        

                        I tried making similar changes to the TopicEJB.java as stuff that i saw in the FaqEJB.java, but ran into some trouble. First it was the return type from ejbCreate, which i tried changing. Then it ran into problems with the StoryEJB. It seems that changing the TopicEJB will filter down into the other objects and how they deal with primary keys. So it will probably need a whole overhaul by someone that understands EJB and CMP much more than myself. Maybe Howard can do same thing he did with the FAQ module? doubt he has the time now, but it would be nice, if FAQ is really going to be a model for how we do it across the board.

                        sorry i couldn't be of more help... .joe

                        • 9. Re: Getting started -- updated documentation on wiki
                          jae Master

                          i just installed postgres to try this out myself and the problem does seem to be w/ the way the primary key is being generated.

                          i will devote more attention to this tonight when i get home.

                          • 10. Re: Getting started -- updated documentation on wiki
                            jae Master

                            i also learned that "nukes.pk-constraint" needs to be set to false in order for the table creation to work.

                            thx again for tracking that down joe - it shouldn't take too long to fix.

                            anybody in mysql or oracle land having problems?

                            • 11. Re: Getting started -- updated documentation on wiki
                              joe hobson Newbie

                               

                              "jae77" wrote:
                              i also learned that "nukes.pk-constraint" needs to be set to false in order for the table creation to work.


                              Actually I'm not sure that is true. My nukes.pk-constraint is true, just as the postgresql.properties file shows, and the faq module works fine with its pure CMP backend. i'm not in front of my dev box right now, but i remember the way the pn_id field was set on the nuke_faq table. It's still an integer field, but the default is set to something like nextval('public.nuke_faq_pn_id_seq'::text) which basically takes the next value of a sequence. A sequence is the postgresql way of doing auto-increment. I assume that it's all handled with CMP, but i couldn't completely figure out how to make the news module setup its tables that way.

                              glad to be of some service.... .joe


                              • 12. Re: Getting started -- updated documentation on wiki
                                jae Master

                                yes - you are correct w/ the pk-constraint, i just switched it back to true and it deploys ok.

                                is the faq module working properly for you? every time i try to create a category, i get an error telling me that i'm trying to insert "null" into a non-null column.

                                same goes for the news stuff. i can create topics w/o any issues, but as soon as i try to create a story, it gives me an error saying the "topic_id" is null.

                                when i look at the tables, it tells me that the default value for the topic_id in the "nuke_news_stories" table is this: nextval('public.nuke_news_stories_topic_id_seq'::text), so i don't know if the issue lies w/ my postgres install or not.

                                i'm using whatever the latest version of postgres is that comes w/ cygwin and pg74.213.jdbc3.jar as the driver.

                                any ideas?

                                • 13. Re: Getting started -- updated documentation on wiki
                                  Sherman Wood Apprentice

                                   

                                  there are too many things in the left navigation so it's hard to find anything, especially since it's not in any aparent order (alphabetical or other). multiple items should be combined: News, Forums, etc. I realize that this is probably difficult because of permissions for separate items. There should probably be a second level of navigation in left side.


                                  I have a menu block where you can define the order of the items and have headings and sub items in the menu. It takes into account the security issues around what items should appear for the logged in user. I will look into generalizing it and contributing it back.


                                  Sherman