7 Replies Latest reply on Sep 5, 2003 10:34 AM by unngh

    deploying nukes with mysql

    Kevin Hooke Newbie

      Hi - I've read through as much of the docs and other posts as I can fid about this - I want to deploy nukes to run against mysql db. As far as I can make out, this is what I need to do:
      - run ddl script (from the cvs source) to create the nukes tables in mysql
      - modify the nukes-ds.xml to point to mysql and use mysql jdbc driver etc

      Is there anything else I need to do? Do I need to build the whole app from source just to run it against mysql, or can I use the prebuilt download and just make the changes I mentioned above?

      Thanks in advance,
      Kevin Hooke

        • 1. Re: deploying nukes with mysql
          David Anderson Newbie

          That is pretty much what it took to get my site up. Although I built from source (snapshot from around 7 days ago), so I cant really answer on the alpha binary download. I would build from source, if you have ant it is relatively simple. I used jikes as my compiler, and the property file already has options for jikes compiling although they are turned off.

          • 2. Re: deploying nukes with mysql
            unngh Newbie


            I am also trying to deploy nukes with mysql. So far, following the docs, I was able to download nukes-snapshot.tar.gz for 2003-09-02, build it and deploy on jboss-3.2.2RC3.

            I am using mysql 4.0.12 and I receive the error below when attempting to "add an html page" with the "manage html" module.

            2003-09-02 14:59:51,700 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract org.jboss.nukes.core.ejb.FileEJBLocal org.jboss.nukes.core.ejb.FileEJBLocalHome.create(java.lang.String,int,java.lang.String,byte[]) throws javax.ejb.CreateException, causedBy:
            java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL IDENTITY()' at line 1"
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956)
            at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:928)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:1871)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:1805)
            at com.mysql.jdbc.Statement.executeQuery(Statement.java:1143)
            at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:213)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.executeInsert(JDBCIdentityColumnCreateCommand.java:63)

            Any advice on how to resolve this?


            • 3. Re: deploying nukes with mysql
              David Anderson Newbie

              For what its worth, my JBOSS version is 3.2.2.RC2, and my mysql version is 4.0.14.

              Im not sure what your problem is, as I have only been running the system for a little over a week and most the time that was with hsqldb. But this is what it sounds like to me.

              in your build directory there is a file called local.properties. You should check that file my guess is your file has "nukes.type-mapping=hsqldb" instead of "nukes.type-mapping=mySQL" in it. You can find a local.properties configured for mySQL in build/etc directory. Try rebuilding your system and modules after making that change and see if it works.


              • 4. Re: deploying nukes with mysql
                Ulf Tidstrand Newbie

                It seems like you are still using the Hypersonic CMP mapping. First, check that you have the right nukes.type-mapping in nukes/build/local.properties. Then recompile. If your problem still exists, delete the directory nukes/nukes/${build.resources} (a simple "build clean" doesn't seem to delete that directory). The compile the nukes module with "build deploy".

                I had this problem when trying to configure nukes for MS SQL Server 2000 earlier today. Now it works perfectly...

                • 5. Re: deploying nukes with mysql

                  man, send me your how to for configuring sqlserver, I will include it in the codebase.



                  • 6. Re: deploying nukes with mysql
                    Ulf Tidstrand Newbie

                    I have only adapted the core module config to MS SQL Server 2000, but I'll send you my config files via e-mail in a minute.


                    • 7. Re: deploying nukes with mysql
                      unngh Newbie

                      Thanks wolfie.

                      Your advice resolved the issue.