9 Replies Latest reply on Feb 12, 2009 4:14 PM by Carlos Gajardo

    Fail ti install time4u on Jboss

    Carlos Gajardo Newbie

      Hi,
      i'm actually trying to put the time4U client in Jboss, i followed instructions step by step (this instructions: http://time4u.sourceforge.net/install/server.html)... meaning, i installed Jboss, I deployed time4U using Apache Ant, but when i try to start the service, ie:
      JBOSS_HOME/bin/run.bat -c time4U

      i get this error

      10:31:07,828 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      


      After that i get a lot of errors related to java clases, i'm using Jboss 4.2.3.GA, jdk1.5.0 (i know, they are old versions, but that's what time4u require; if i use newer version, it completly fail), apache ant 1.7 an MySQL 5.1.26.

      I think is something with de data base, i'm using MySQL, and i properly set the variables in build.properties (change the host, add the username/password) before doing the deploy.

      Even though the service start correctly, 'couse i can get to http://localhost:8080/time4u
      but when it ask me for username/password (wich for default are admin/admin) i cann't log in, and i get an error with users.propertie file missing... anyway.

      Can anyone help me? this is really important to my internship.

      Sorry about my english... i'm from Chile.

        • 1. Re: Fail ti install time4u on Jboss
          Carlos Gajardo Newbie

          oh, and i also get this error


          Incomplete Deployment listing:

          --- MBeans waiting for other MBeans ---
          ObjectName: time4u:service=ConfigService
          State: FAILED
          Reason: java.lang.RuntimeException: javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state
          I Depend On:
          time4u:service=LocalIdService
          jboss.j2ee:ear=time4u-assemblies-ear.ear,jar=time4u-server-ejb-0.9.5.jar,name=RevisionGenerator,service=EJB3
          persistence.units:ear=time4u-assemblies-ear.ear,unitName=time4u
          jboss.j2ee:ear=time4u-assemblies-ear.ear,jar=time4u-server-ejb-0.9.5.jar,name=LocalIdService,service=EJB3
          Depends On Me:
          time4u:service=DynamicLoginConfig

          --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
          ObjectName: time4u:service=ConfigService
          State: FAILED
          Reason: java.lang.RuntimeException: javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state
          I Depend On:
          time4u:service=LocalIdService
          jboss.j2ee:ear=time4u-assemblies-ear.ear,jar=time4u-server-ejb-0.9.5.jar,name=RevisionGenerator,service=EJB3
          persistence.units:ear=time4u-assemblies-ear.ear,unitName=time4u
          jboss.j2ee:ear=time4u-assemblies-ear.ear,jar=time4u-server-ejb-0.9.5.jar,name=LocalIdService,service=EJB3
          Depends On Me:
          time4u:service=DynamicLoginConfig




          THANKS

          • 2. Re: Fail ti install time4u on Jboss
            Peter Johnson Master

            Hmm, this looks like an app I could use. I'll give it a try and see what I can find out but it might not be until the next day or two (today is the JBoss Virtual Experience so I'm booked for today).

            Of course, other forum readers should feel free to offer their insight... ;-)

            • 3. Re: Fail ti install time4u on Jboss
              Carlos Gajardo Newbie

              Thanks PeterJ, i'll be checking the forum

              • 4. Re: Fail ti install time4u on Jboss
                Peter Johnson Master

                I installed it and it started up just fine for me.

                Please post the build.properties file you used to install time4u.

                At the start of the console log there will be three lines the describe the JVM and OS being used, please post those. Example:

                08:50:38,907 INFO [ServerInfo] Java version: 1.5.0_16,Sun Microsystems Inc.
                08:50:38,908 INFO [ServerInfo] Java VM: Java HotSpot(TM) 64-Bit Server VM 1.5.0
                _16-b02,Sun Microsystems Inc.
                08:50:38,909 INFO [ServerInfo] OS-System: Windows Vista 6.0,amd64

                • 5. Re: Fail ti install time4u on Jboss
                  Carlos Gajardo Newbie

                  Hi...
                  the build.properties files i'm using is this one:

                  # JBoss home directory
                  jboss.home=../jboss-4.2.3.GA
                  
                  # JBoss configuration
                  jboss.config=time4u
                  
                  # Database engine
                  db.engine=mysql
                  
                  db.host=localhost
                  db.name=two
                  db.user=root
                  db.password=123456
                  



                  and the start of the console shows something like this:

                   JBoss Bootstrap Environment
                  
                   JBOSS_HOME: C:\Archivos de programa\jboss-4.2.3.GA
                  
                   JAVA: C:\Archivos de programa\Java\jdk1.5.0_06\bin\java
                  
                   JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
                  
                   CLASSPATH: C:\Archivos de programa\Java\jdk1.5.0_06\lib\tools.jar;C:\Archivos de programa\jboss-4.2.3.GA\bin\run.jar
                  
                  ==================================================
                  11:49:42,609 INFO [Server] Starting JBoss (MX MicroKernel)...
                  11:49:42,609 INFO [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)
                  11:49:42,609 INFO [Server] Home Dir: C:\Archivos de programa\jboss-4.2.3.GA
                  11:49:42,609 INFO [Server] Home URL: file:/C:/Archivos de programa/jboss-4.2.3.GA/
                  11:49:42,609 INFO [Server] Patch URL: null
                  11:49:42,609 INFO [Server] Server Name: time4u
                  11:49:42,609 INFO [Server] Server Home Dir: C:\Archivos de programa\jboss-4.2.3.GA\server\time4u
                  11:49:42,609 INFO [Server] Server Home URL: file:/C:/Archivos de programa/jboss-4.2.3.GA/server/time4u/
                  11:49:42,609 INFO [Server] Server Log Dir: C:\Archivos de programa\jboss-4.2.3.GA\server\time4u\log
                  11:49:42,609 INFO [Server] Server Temp Dir: C:\Archivos de programa\jboss-4.2.3.GA\server\time4u\tmp
                  11:49:42,609 INFO [Server] Root Deployment Filename: jboss-service.xml
                  11:49:42,875 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems Inc.
                  11:49:42,875 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0_06-b05,Sun Microsystems Inc.
                  11:49:42,875 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
                  11:49:43,343 INFO [Server] Core system initialized
                  



                  i really appreciate your help

                  • 6. Re: Fail ti install time4u on Jboss
                    Peter Johnson Master

                    Try moving JBoss AS out of Archivos de programa. Spaces in paths tend to confuse some Java libraries. I have mine at f:\opt\jboss\jboss-4.2.3.GA

                    You JDK is really old - download and install the latest JDK 5 (1.5.0_17?). I also recommend not installing that in Archivos de programa. Mine is at c:\apps\java\jdk1.5.0_17.

                    • 7. Re: Fail ti install time4u on Jboss
                      Carlos Gajardo Newbie

                      i'll give it a try and i'll tell you how it went on.
                      Thanks for your help :)

                      • 8. Re: Fail ti install time4u on Jboss
                        Carlos Gajardo Newbie

                        it's me again... i did exactly as PeterJ told and i use new paths to instal java, jboss, and everything else, i download jdk1.5.0_17, but i still get this error:

                        ===============================================================================
                        
                         JBoss Bootstrap Environment
                        
                         JBOSS_HOME: C:\jboss-4.2.3.GA
                        
                         JAVA: C:\jdk1.5.0_17\bin\java
                        
                         JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
                        
                         CLASSPATH: C:\jdk1.5.0_17\lib\tools.jar;C:\jboss-4.2.3.GA\bin\run.jar
                        
                        ===============================================================================
                        
                        17:40:54,406 INFO [Server] Starting JBoss (MX MicroKernel)...
                        17:40:54,406 INFO [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181417)
                        17:40:54,406 INFO [Server] Home Dir: C:\jboss-4.2.3.GA
                        17:40:54,406 INFO [Server] Home URL: file:/C:/jboss-4.2.3.GA/
                        17:40:54,406 INFO [Server] Patch URL: null
                        17:40:54,406 INFO [Server] Server Name: time4u
                        17:40:54,406 INFO [Server] Server Home Dir: C:\jboss-4.2.3.GA\server\time4u
                        17:40:54,406 INFO [Server] Server Home URL: file:/C:/jboss-4.2.3.GA/server/time4u/
                        17:40:54,406 INFO [Server] Server Log Dir: C:\jboss-4.2.3.GA\server\time4u\log
                        17:40:54,406 INFO [Server] Server Temp Dir: C:\jboss-4.2.3.GA\server\time4u\tmp
                        17:40:54,406 INFO [Server] Root Deployment Filename: jboss-service.xml
                        17:40:54,671 INFO [ServerInfo] Java version: 1.5.0_17,Sun Microsystems Inc.
                        17:40:54,671 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0_17-b04,Sun Microsystems Inc.
                        17:40:54,671 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
                        17:40:55,234 INFO [Server] Core system initialized
                        
                        ...
                        
                        17:41:26,312 INFO [EJBContainer] STARTED EJB: de.objectcode.time4u.server.ejb.config.ConfigService ejbName: ConfigService
                        17:41:27,312 WARN [JDBCExceptionReporter] SQL Error: 1048, SQLState: 23000
                         17:41:27,312 ERROR [JDBCExceptionReporter] Column 'GIVENNAME' cannot be null
                        17:41:27,312 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
                        org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
                         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
                         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
                         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
                         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
                         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
                         at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
                         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
                         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
                         at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
                         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
                         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
                         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
                         at
                        



                        I can see there is a problem when jboss try to insert a registry with the field GIVENNAME in null, but... this happens before i even try to access the service (so... why i joss , or time4u eventualy, trying to add data to the database)
                        Am i missing something... maybe a plug in to acces mySQL database or something... the freakest thing is that the tables are actually created, i check the database and all the tables were correctly created by Jboss... but i don't understand why it is arguing about this null field.

                        Anybody have a clue?

                        • 9. Re: Fail ti install time4u on Jboss
                          Carlos Gajardo Newbie

                          wiiiiiii!!

                          I just fix it!

                          I actually edit "manually" the table 't4u_persons' and make every field but 'ID' and 'LASTSYNCHRONIZE' allowed for null entries.... it actually works.. and i'm really happy about it.

                          Once and again, thanks PeterJ for your help.