Hi Dave, defaultTransactionIsolation=1 should work
Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://rmannibucau.metawerx.net/> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> 2018-01-24 7:58 GMT+01:00 Cannizzaro David <david.cannizz...@basenet.ch>: > Hi > > > > I produced this Stacktrace trying to set defaultTransactionIsolation > > > > SEVERE: FATAL ERROR: Unknown error in Assembler. Please send the > following stack trace and this message to users@tomee.apache.org : > > org.apache.xbean.recipe.ConstructionException: Error invoking factory > method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceFactory.create( > java.lang.String,boole > > an,java.lang.Class,java.lang.String,org.apache.openejb. > util.Duration,org.apache.openejb.util.Duration,org.apache.openejb.util.Duration) > throws java.lang.IllegalAccessException,java.lang.InstantiationE > > xception,java.io.IOException > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:1006) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:276) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.openejb.assembler.classic.Assembler. > doCreateResource(Assembler.java:2673) > > at org.apache.openejb.assembler.classic.Assembler. > createResource(Assembler.java:2553) > > at org.apache.openejb.assembler.classic.Assembler. > buildContainerSystem(Assembler.java:552) > > at org.apache.openejb.assembler.classic.Assembler.build( > Assembler.java:464) > > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:151) > > at org.apache.openejb.OpenEJB.init(OpenEJB.java:309) > > at org.apache.tomee.catalina.TomcatLoader.initialize( > TomcatLoader.java:256) > > at org.apache.tomee.catalina.ServerListener.install( > ServerListener.java:167) > > at org.apache.tomee.catalina.ServerListener.lifecycleEvent( > ServerListener.java:54) > > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( > LifecycleSupport.java:117) > > at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent( > LifecycleBase.java:90) > > at org.apache.catalina.util.LifecycleBase.setStateInternal( > LifecycleBase.java:394) > > at org.apache.catalina.util.LifecycleBase.init( > LifecycleBase.java:110) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:642) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:667) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:253) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:427) > > Caused by: org.apache.xbean.recipe.ConstructionException: Unable to > convert property value from java.lang.String to int for injection public > void org.apache.tomcat.jdbc.pool.PoolProperties.setDefaultT > > ransactionIsolation(int) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:503) > > at org.apache.xbean.recipe.ObjectRecipe.setProperties( > ObjectRecipe.java:371) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:286) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:49) > > at org.apache.openejb.resource.jdbc.pool. > PoolDataSourceCreator.build(PoolDataSourceCreator.java:98) > > at org.apache.tomee.jdbc.TomEEDataSourceCreator.pool( > TomEEDataSourceCreator.java:82) > > at org.apache.openejb.resource.jdbc.pool.PoolDataSourceCreator. > poolManaged(PoolDataSourceCreator.java:80) > > at org.apache.openejb.resource.jdbc.DataSourceFactory.create( > DataSourceFactory.java:196) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:996) > > ... 24 more > > Caused by: org.apache.xbean.propertyeditor.PropertyEditorException: > java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:31) > > at org.apache.xbean.propertyeditor.AbstractConverter.toObject( > AbstractConverter.java:86) > > at org.apache.xbean.propertyeditor.PropertyEditors.getValue( > PropertyEditors.java:284) > > at org.apache.xbean.recipe.RecipeHelper.convert( > RecipeHelper.java:172) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:497) > > ... 38 more > > Caused by: java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at java.lang.NumberFormatException.forInputString( > NumberFormatException.java:65) > > at java.lang.Integer.parseInt(Integer.java:580) > > at java.lang.Integer.valueOf(Integer.java:766) > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:29) > > ... 42 more > > > > Jan 24, 2018 7:58:28 AM org.apache.openejb.OpenEJB$Instance <init> > > SEVERE: OpenEJB has encountered a fatal error and cannot be started: > Assembler failed to build the container system. > > org.apache.openejb.OpenEJBException: > org.apache.xbean.recipe.ConstructionException: > Error invoking factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceF > > actory.create(java.lang.String,boolean,java.lang. > Class,java.lang.String,org.apache.openejb.util.Duration, > org.apache.openejb.util.Duration,org.apache.openejb.util.Duration) throws > java.lang.IllegalAcce > > ssException,java.lang.InstantiationException,java.io.IOException: Error > invoking factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceFactory.create(java > > .lang.String,boolean,java.lang.Class,java.lang.String, > org.apache.openejb.util.Duration,org.apache.openejb. > util.Duration,org.apache.openejb.util.Duration) throws java.lang. > IllegalAccessException,java.l > > ang.InstantiationException,java.io.IOException > > at org.apache.openejb.assembler.classic.Assembler.build( > Assembler.java:477) > > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:151) > > at org.apache.openejb.OpenEJB.init(OpenEJB.java:309) > > at org.apache.tomee.catalina.TomcatLoader.initialize( > TomcatLoader.java:256) > > at org.apache.tomee.catalina.ServerListener.install( > ServerListener.java:167) > > at org.apache.tomee.catalina.ServerListener.lifecycleEvent( > ServerListener.java:54) > > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( > LifecycleSupport.java:117) > > at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent( > LifecycleBase.java:90) > > at org.apache.catalina.util.LifecycleBase.setStateInternal( > LifecycleBase.java:394) > > at org.apache.catalina.util.LifecycleBase.init( > LifecycleBase.java:110) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:642) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:667) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:253) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:427) > > Caused by: org.apache.xbean.recipe.ConstructionException: Error invoking > factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceFactory.create(java.lang.St > > ring,boolean,java.lang.Class,java.lang.String,org.apache. > openejb.util.Duration,org.apache.openejb.util.Duration, > org.apache.openejb.util.Duration) throws java.lang. > IllegalAccessException,java.lang.Inst > > antiationException,java.io.IOException > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:1006) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:276) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.openejb.assembler.classic.Assembler. > doCreateResource(Assembler.java:2673) > > at org.apache.openejb.assembler.classic.Assembler. > createResource(Assembler.java:2553) > > at org.apache.openejb.assembler.classic.Assembler. > buildContainerSystem(Assembler.java:552) > > at org.apache.openejb.assembler.classic.Assembler.build( > Assembler.java:464) > > ... 17 more > > Caused by: org.apache.xbean.recipe.ConstructionException: Unable to > convert property value from java.lang.String to int for injection public > void org.apache.tomcat.jdbc.pool.PoolProperties.setDefaultT > > ransactionIsolation(int) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:503) > > at org.apache.xbean.recipe.ObjectRecipe.setProperties( > ObjectRecipe.java:371) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:286) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:49) > > at org.apache.openejb.resource.jdbc.pool. > PoolDataSourceCreator.build(PoolDataSourceCreator.java:98) > > at org.apache.tomee.jdbc.TomEEDataSourceCreator.pool( > TomEEDataSourceCreator.java:82) > > at org.apache.openejb.resource.jdbc.pool.PoolDataSourceCreator. > poolManaged(PoolDataSourceCreator.java:80) > > at org.apache.openejb.resource.jdbc.DataSourceFactory.create( > DataSourceFactory.java:196) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:996) > > ... 24 more > > Caused by: org.apache.xbean.propertyeditor.PropertyEditorException: > java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:31) > > at org.apache.xbean.propertyeditor.AbstractConverter.toObject( > AbstractConverter.java:86) > > at org.apache.xbean.propertyeditor.PropertyEditors.getValue( > PropertyEditors.java:284) > > at org.apache.xbean.recipe.RecipeHelper.convert( > RecipeHelper.java:172) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:497) > > ... 38 more > > Caused by: java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at java.lang.NumberFormatException.forInputString( > NumberFormatException.java:65) > > at java.lang.Integer.parseInt(Integer.java:580) > > at java.lang.Integer.valueOf(Integer.java:766) > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:29) > > ... 42 more > > > > Jan 24, 2018 7:58:28 AM org.apache.tomee.catalina.ServerListener install > > SEVERE: TomEE Listener can't start OpenEJB > > org.apache.openejb.OpenEJBException: > org.apache.xbean.recipe.ConstructionException: > Error invoking factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceF > > actory.create(java.lang.String,boolean,java.lang. > Class,java.lang.String,org.apache.openejb.util.Duration, > org.apache.openejb.util.Duration,org.apache.openejb.util.Duration) throws > java.lang.IllegalAcce > > ssException,java.lang.InstantiationException,java.io.IOException: Error > invoking factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceFactory.create(java > > .lang.String,boolean,java.lang.Class,java.lang.String, > org.apache.openejb.util.Duration,org.apache.openejb. > util.Duration,org.apache.openejb.util.Duration) throws java.lang. > IllegalAccessException,java.l > > ang.InstantiationException,java.io.IOException > > at org.apache.openejb.assembler.classic.Assembler.build( > Assembler.java:477) > > at org.apache.openejb.OpenEJB$Instance.<init>(OpenEJB.java:151) > > at org.apache.openejb.OpenEJB.init(OpenEJB.java:309) > > at org.apache.tomee.catalina.TomcatLoader.initialize( > TomcatLoader.java:256) > > at org.apache.tomee.catalina.ServerListener.install( > ServerListener.java:167) > > at org.apache.tomee.catalina.ServerListener.lifecycleEvent( > ServerListener.java:54) > > at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent( > LifecycleSupport.java:117) > > at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent( > LifecycleBase.java:90) > > at org.apache.catalina.util.LifecycleBase.setStateInternal( > LifecycleBase.java:394) > > at org.apache.catalina.util.LifecycleBase.init( > LifecycleBase.java:110) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:642) > > at org.apache.catalina.startup.Catalina.load(Catalina.java:667) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:253) > > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:427) > > Caused by: org.apache.xbean.recipe.ConstructionException: Error invoking > factory method: public static javax.sql.CommonDataSource > org.apache.openejb.resource.jdbc.DataSourceFactory.create(java.lang.St > > ring,boolean,java.lang.Class,java.lang.String,org.apache. > openejb.util.Duration,org.apache.openejb.util.Duration, > org.apache.openejb.util.Duration) throws java.lang. > IllegalAccessException,java.lang.Inst > > antiationException,java.io.IOException > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:1006) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:276) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.openejb.assembler.classic.Assembler. > doCreateResource(Assembler.java:2673) > > at org.apache.openejb.assembler.classic.Assembler. > createResource(Assembler.java:2553) > > at org.apache.openejb.assembler.classic.Assembler. > buildContainerSystem(Assembler.java:552) > > at org.apache.openejb.assembler.classic.Assembler.build( > Assembler.java:464) > > ... 17 more > > Caused by: org.apache.xbean.recipe.ConstructionException: Unable to > convert property value from java.lang.String to int for injection public > void org.apache.tomcat.jdbc.pool.PoolProperties.setDefaultT > > ransactionIsolation(int) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:503) > > at org.apache.xbean.recipe.ObjectRecipe.setProperties( > ObjectRecipe.java:371) > > at org.apache.xbean.recipe.ObjectRecipe.internalCreate( > ObjectRecipe.java:286) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:96) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:61) > > at org.apache.xbean.recipe.AbstractRecipe.create( > AbstractRecipe.java:49) > > at org.apache.openejb.resource.jdbc.pool. > PoolDataSourceCreator.build(PoolDataSourceCreator.java:98) > > at org.apache.tomee.jdbc.TomEEDataSourceCreator.pool( > TomEEDataSourceCreator.java:82) > > at org.apache.openejb.resource.jdbc.pool.PoolDataSourceCreator. > poolManaged(PoolDataSourceCreator.java:80) > > at org.apache.openejb.resource.jdbc.DataSourceFactory.create( > DataSourceFactory.java:196) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at org.apache.xbean.recipe.ReflectionUtil$StaticFactory. > create(ReflectionUtil.java:996) > > ... 24 more > > Caused by: org.apache.xbean.propertyeditor.PropertyEditorException: > java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:31) > > at org.apache.xbean.propertyeditor.AbstractConverter.toObject( > AbstractConverter.java:86) > > at org.apache.xbean.propertyeditor.PropertyEditors.getValue( > PropertyEditors.java:284) > > at org.apache.xbean.recipe.RecipeHelper.convert( > RecipeHelper.java:172) > > at org.apache.xbean.recipe.ObjectRecipe.setProperty( > ObjectRecipe.java:497) > > ... 38 more > > Caused by: java.lang.NumberFormatException: For input string: > "TRANSACTION_READ_UNCOMMITTED" > > at java.lang.NumberFormatException.forInputString( > NumberFormatException.java:65) > > at java.lang.Integer.parseInt(Integer.java:580) > > at java.lang.Integer.valueOf(Integer.java:766) > > at org.apache.xbean.propertyeditor.IntegerEditor. > toObjectImpl(IntegerEditor.java:29) > > ... 42 more > > > > Regards > > > > Dave Cannizzaro > > > > [image: cid:image002.png@01D1D110.00736720] > > > > Base-Net Informatik AG > Wassergrabe 14, CH-6210 Sursee > <https://maps.google.com/?q=Wassergrabe+14,+CH-6210+Sursee&entry=gmail&source=g> > > Zentrale > > +41 41 925 73 25 > > Internet > > www.basenet.ch > > E-Mail > > dave.cannizz...@basenet.ch > > > > > > >