Fail ti install time4u on Jboss

[outstretched]

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.

[outstretched]

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

[peterj]

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... ;-)

[outstretched]

Thanks PeterJ, i'll be checking the forum

[peterj]

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

[outstretched]

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

[peterj]

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.

[outstretched]

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

[outstretched]

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?

[outstretched]

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.