Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Thanks for all your help, especially Romain ...

I have now resolved the issue. For reference

(1) persistence resource and datasource id must be the same
(2) When running in Eclipse make sure that you follow the advanced set-up 
here    - Eclipse uses local
copies of tomee.xml which are not updated automatically (unless configured
to do so) when you update your /install/tomee/conf/tomee.xml
(3) JMX is useful for debugging. You should launch using jconsole and look
for your dataSource under openejb.managed - if it is not there then there is
something wrong

Onwards, and upwards !



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659652.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

You should go further using:


$ cat src/main/tomee/conf/tomee.xml






  IgnoreDefaultValues true
  JdbcDriver com.mysql.jdbc.Driver
  JdbcUrl jdbc:mysql://localhost:3306/test
  UserName root
  Password pwd
  JtaManaged true
  jmxEnabled true





$ cat  src/main/webapp/WEB-INF/persistence.xml

http://java.sun.com/xml/ns/persistence"; version="1.0">


jdbc/testDB
com.TestEntity
 


  
  
  


Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/14 avrono :
> I have put the source here  https://github.com/avrono11/openejb_issue.git
> 
>
> I was trying to launch the JSP - addItem.jsp - which has to offending
> datasource
>
>
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659644.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

I have put the source here  https://github.com/avrono11/openejb_issue.git
  

I was trying to launch the JSP - addItem.jsp - which has to offending
datasource





--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659644.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Actually I did notice those .


INFO: Auto-linking resource-ref 'java:comp/env/avronDB' in bean
localhost/PRSX.Comp to Resource(id=My DataSource)
14-Dec-2012 13:23:04 org.apache.openejb.config.AutoConfig processResourceRef
INFO: Auto-linking resource-ref 'java:comp/env/avronDB' in bean HelloBean to
Resource(id=My DataSource)

14-Dec-2012 13:23:04 org.apache.openejb.config.AutoConfig setJtaDataSource
INFO: Adjusting PersistenceUnit avronDBP  to Resource ID
'My DataSource' from 'jdbc/testDB'
14-Dec-2012 13:23:04 org.apache.openejb.config.AutoConfig
setNonJtaDataSource
INFO: Adjusting PersistenceUnit avronDBP  to Resource
ID 'My Unmanaged DataSource' from 'null'
.
14-Dec-2012 13:23:04 org.apache.openejb.config.AutoConfig setJtaDataSource
INFO: Adjusting PersistenceUnit PRSX  to Resource ID 'My
DataSource' from 'jdbc/testDB'
14-Dec-2012 13:23:04 org.apache.openejb.config.AutoConfig
setNonJtaDataSource
INFO: Adjusting PersistenceUnit PRSX  to Resource ID
'My Unmanaged DataSource' from 'null'





--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659643.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Jean-Louis MONTEIRO]

Just on point, did you see a message in logs (please grep into logs/ dir)
like "Adjusting "
If so, could you copy/paste those lines?

JLouis


2012/12/14 Romain Manni-Bucau 

> ok basically
>
> create the following structure:
>
> src
>main
>java
>
>tomee
>conf
>   tomee.xml
>
> then install maven
> (
> http://www.apache.org/dyn/closer.cgi/maven/maven-3/3.0.4/binaries/apache-maven-3.0.4-bin.zip
> ),
> set in your console JAVA_HOME to your java installation then M2_HOME
> to the folder where maven is (once the zip is extracted) and finally
> add to the path M2_HOME/bin.
>
> then simply run mvn clean package tomee:run
>
> if you need more help i'll be on IRC freenode.net #openejb
>
> Romain Manni-Bucau
> Twitter: @rmannibucau
> Blog: http://rmannibucau.wordpress.com/
> LinkedIn: http://fr.linkedin.com/in/rmannibucau
> Github: https://github.com/rmannibucau
>
>
>
> 2012/12/14 avrono :
> > Maven looks like a minefield which I am not sure I have time to beat.
> Ode for
> > 'make' ...
> >
> > As I understand it you want me to deploy (create) a TomEE Server instance
> > with my WebApp deployed and then send that to you ?
> >
> > I have my TomEE installation /home/TomEE/
> >
> > conf is /home/TomEE/conf (obvuously)
> >
> > And then Eclipse project is /home/workspace/SOMEPRJ (with /build   /src
> > /WebContent)
> >
> >
> > I need some guidance on deploying this in a useful manner
> >
> >
> >
> > --
> > View this message in context:
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659635.html
> > Sent from the OpenEJB User mailing list archive at Nabble.com.
>



-- 
Jean-Louis

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

ok basically

create the following structure:

src
   main
   java
   
   tomee
   conf
  tomee.xml

then install maven
(http://www.apache.org/dyn/closer.cgi/maven/maven-3/3.0.4/binaries/apache-maven-3.0.4-bin.zip),
set in your console JAVA_HOME to your java installation then M2_HOME
to the folder where maven is (once the zip is extracted) and finally
add to the path M2_HOME/bin.

then simply run mvn clean package tomee:run

if you need more help i'll be on IRC freenode.net #openejb

Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/14 avrono :
> Maven looks like a minefield which I am not sure I have time to beat. Ode for
> 'make' ...
>
> As I understand it you want me to deploy (create) a TomEE Server instance
> with my WebApp deployed and then send that to you ?
>
> I have my TomEE installation /home/TomEE/
>
> conf is /home/TomEE/conf (obvuously)
>
> And then Eclipse project is /home/workspace/SOMEPRJ (with /build   /src
> /WebContent)
>
>
> I need some guidance on deploying this in a useful manner
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659635.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Maven looks like a minefield which I am not sure I have time to beat. Ode for
'make' ...

As I understand it you want me to deploy (create) a TomEE Server instance
with my WebApp deployed and then send that to you ?

I have my TomEE installation /home/TomEE/ 

conf is /home/TomEE/conf (obvuously)

And then Eclipse project is /home/workspace/SOMEPRJ (with /build   /src   
/WebContent) 


I need some guidance on deploying this in a useful manner



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659635.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

https://gist.github.com/4284311 should work,

then add tomee.xml in src/main/tomee/conf and code in src/main/java

to test it locally (once maven is installed): mvn clean package tomee:run

Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/14 avrono :
> Romain,
>
> I have not used Maven before - any chance of getting a minimal pom.xml ?
>
>
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659632.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Romain, 

I have not used Maven before - any chance of getting a minimal pom.xml ?





--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659632.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

do you think you can reproduce the issue (with tomee-maven-plugin for
instance) and share your sample?

i just tested again and i had no issue.

Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/14 avrono :
> Hi Romain,
>
> It is only in Catalina and not in openejb.mbeans .
> However in opebejb.mbeans there is an entry from web.xml and some defaults
> 
>
>
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659624.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Hi Romain, 

It is only in Catalina and not in openejb.mbeans . 
However in opebejb.mbeans there is an entry from web.xml and some defaults






--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659624.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

Hmm, isnt the datasource in openejb mbeans?

Please check url and all the config (check tomee didnt adjust some settings)
Le 14 déc. 2012 01:34, "avrono"  a écrit :

> Hi Romain,
>
> I can see the DataSource using JMX under DataSource and also under Resource
> -> Context
>
>
> Catalina:type=DataSource,context=/PRSX,host=localhost,class=javax.sql.DataSource,name="avronDB"
>
> Is there anything specific I should be looking for ?
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659608.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Hi Romain, 

I can see the DataSource using JMX under DataSource and also under Resource
-> Context

Catalina:type=DataSource,context=/PRSX,host=localhost,class=javax.sql.DataSource,name="avronDB"

Is there anything specific I should be looking for ?



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659608.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

I will try do so ... Let you know



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659604.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

can you connect through JMX to check the config of the datasource is
fine please?

maybe you'll need to add jmxEnabled = true in the properties of the
datasource definition

Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/13 avrono :
> Romain,
>
> Yes it is there. I can connect using DriverManager...
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659596.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Romain,

Yes it is there. I can connect using DriverManager...



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659596.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Romain Manni-Bucau]

did you put mysql driver in tomee/lib?

Romain Manni-Bucau
Twitter: @rmannibucau
Blog: http://rmannibucau.wordpress.com/
LinkedIn: http://fr.linkedin.com/in/rmannibucau
Github: https://github.com/rmannibucau



2012/12/13 avrono :
> Hi Neale,
>
>
> Had a similar thought. Will try another Grep ... Not found anything thus
> far.
>
>
>
> --
> View this message in context: 
> http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659560.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Hi Neale,


Had a similar thought. Will try another Grep ... Not found anything thus
far.



--
View this message in context: 
http://openejb.979440.n4.nabble.com/Unable-to-configure-MYSQL-resource-in-tomee-xml-tp4659538p4659560.html
Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Unable to configure MYSQL resource in tomee.xml

[Neale]

Hi Avrono,

The hint for me was that I was using MySQL only, and wasn't using hsqldb - 
but the error was hsqldb.


I removed all the hsqldb references and got it working.

It looks like you already removed all the hsqldb refs from tomee.xml though, 
so that's confusing.  Maybe someone else knows where hsqldb is being 
referenced?


As far as I know:
tomee.xml
 elements
META-INF/context.xml (my preference - and I had to remove the others to get 
this to be recognised)


Romain?  Jean-Louis?

Best Regards,
Neale



- Original Message - 
From: "avrono" 

To: 
Sent: Friday, December 14, 2012 6:18 AM
Subject: Re: Unable to configure MYSQL resource in tomee.xml



Hi Neale,

I had the same thought and tried to grep for any other DB references. I
guess configuration is becomming a minefield. Here is the tomee.xml








 # Specifies the maximum time an invocation could wait for the
 # singleton bean instance to become available before giving up.
 #
 # After the timeout is reached a
javax.ejb.ConcurrentAccessTimeoutException
 # will be thrown.
 #
 # Usable time units: nanoseconds, microsecons, milliseconds,
 # seconds, minutes, hours, days.  Or any combination such as
 # "1 hour and 27 minutes and 10 seconds"

 AccessTimeout = 30 seconds





 # Specifies the maximum time an invocation could wait for the
 # stateful bean instance to become available before giving up.
 #
 # After the timeout is reached a
javax.ejb.ConcurrentAccessTimeoutException
 # will be thrown.
 #
 # Usable time units: nanoseconds, microsecons, milliseconds,
 # seconds, minutes, hours, days.  Or any combination such as
 # "1 hour and 27 minutes and 10 seconds"

 AccessTimeout = 30 seconds

 #  The passivator is responsible for writing beans to disk
 #  at passivation time. Different passivators can be used
 #  by setting this property to the fully qualified class name
 #  of the PassivationStrategy implementation. The passivator
 #  is not responsible for invoking any callbacks or other
 #  processing, its only responsibly is to write the bean state
 #  to disk.
 #
 #  Known implementations:
 # org.apache.openejb.core.stateful.RAFPassivater
 # org.apache.openejb.core.stateful.SimplePassivater

 Passivator   org.apache.openejb.core.stateful.SimplePassivater

 #  Specifies the time to wait between invocations. This
 #  value is measured in minutes. A value of 5 would
 #  result in a time-out of 5 minutes between invocations.
 #  A value of zero would mean no timeout.

 TimeOut  20

 # Specifies the frequency (in seconds) at which the bean cache is checked
for
 # idle beans.

 Frequency 60

 #  Specifies the size of the bean pools for this
 #  stateful SessionBean container.

 Capacity  1000

 #  Property name that specifies the number of instances
 #  to passivate at one time when doing bulk passivation.
 #  Must be less than the PoolSize.

 BulkPassivate  100






 # Specifies the time an invokation should wait for an instance
 # of the pool to become available.
 #
 # After the timeout is reached, if an instance in the pool cannot
 # be obtained, the method invocation will fail.
 #
 # Usable time units: nanoseconds, microsecons, milliseconds,
 # seconds, minutes, hours, days.  Or any combination such as
 # "1 hour and 27 minutes and 10 seconds"

 AccessTimeout = 30 seconds

 # Specifies the size of the bean pools for this stateless
 # SessionBean container.  If StrictPooling is not used, instances
 # will still be created beyond this number if there is demand, but
 # they will not be returned to the pool and instead will be
 # immediately destroyed.

 MaxSize = 10

 # Specifies the minimum number of bean instances that should be in
 # the pool for each bean.  Pools are prefilled to the minimum on
 # startup.  Note this will create start order dependencies between
 # other beans that also eagerly start, such as other @Stateless
 # beans with a minimum or @Singleton beans using @Startup.  The
 # @DependsOn annotation can be used to appropriately influence
 # start order.
 #
 # The minimum pool size is rigidly maintained.  Instances in the
 # minimum side of the pool are not eligible for IdleTimeout or
 # GarbageCollection, but are subject to MaxAge and flushing.
 #
 # If the pool is flushed it is immediately refilled to the minimum
 # size with MaxAgeOffset applied.  If an instance from the minimum
 # side of the pool reaches its MaxAge, it is also immediately
 # replaced.  Replacement is done in a background queue using the
 # number of threads specified by CallbackThreads.

 MinSize = 0

 # StrictPooling tells the container what to do when the pool
 # reaches it's maximum size and there are incoming requests that
 # need instances.
 #
 # With strict pooling, requests will have to wait for instances to
 # become available. The pool size will never grow beyond the the
 # set MaxSize value.  The maximum amount of time a request should
 # wait is specified via the A

Re: Unable to configure MYSQL resource in tomee.xml

[avrono]

Hi Neale, 

I had the same thought and tried to grep for any other DB references. I
guess configuration is becomming a minefield. Here is the tomee.xml








  # Specifies the maximum time an invocation could wait for the
  # singleton bean instance to become available before giving up.
  #
  # After the timeout is reached a
javax.ejb.ConcurrentAccessTimeoutException
  # will be thrown.
  #
  # Usable time units: nanoseconds, microsecons, milliseconds,
  # seconds, minutes, hours, days.  Or any combination such as
  # "1 hour and 27 minutes and 10 seconds"

  AccessTimeout = 30 seconds





  # Specifies the maximum time an invocation could wait for the
  # stateful bean instance to become available before giving up.
  #
  # After the timeout is reached a
javax.ejb.ConcurrentAccessTimeoutException
  # will be thrown.
  #
  # Usable time units: nanoseconds, microsecons, milliseconds,
  # seconds, minutes, hours, days.  Or any combination such as
  # "1 hour and 27 minutes and 10 seconds"

  AccessTimeout = 30 seconds

  #  The passivator is responsible for writing beans to disk
  #  at passivation time. Different passivators can be used
  #  by setting this property to the fully qualified class name
  #  of the PassivationStrategy implementation. The passivator
  #  is not responsible for invoking any callbacks or other
  #  processing, its only responsibly is to write the bean state
  #  to disk.
  #
  #  Known implementations:
  # org.apache.openejb.core.stateful.RAFPassivater
  # org.apache.openejb.core.stateful.SimplePassivater

  Passivator   org.apache.openejb.core.stateful.SimplePassivater

  #  Specifies the time to wait between invocations. This
  #  value is measured in minutes. A value of 5 would
  #  result in a time-out of 5 minutes between invocations.
  #  A value of zero would mean no timeout.

  TimeOut  20

  # Specifies the frequency (in seconds) at which the bean cache is checked
for
  # idle beans.

  Frequency 60

  #  Specifies the size of the bean pools for this
  #  stateful SessionBean container.

  Capacity  1000

  #  Property name that specifies the number of instances
  #  to passivate at one time when doing bulk passivation.
  #  Must be less than the PoolSize.

  BulkPassivate  100






  # Specifies the time an invokation should wait for an instance
  # of the pool to become available.
  #
  # After the timeout is reached, if an instance in the pool cannot
  # be obtained, the method invocation will fail.
  #
  # Usable time units: nanoseconds, microsecons, milliseconds,
  # seconds, minutes, hours, days.  Or any combination such as
  # "1 hour and 27 minutes and 10 seconds"

  AccessTimeout = 30 seconds

  # Specifies the size of the bean pools for this stateless
  # SessionBean container.  If StrictPooling is not used, instances
  # will still be created beyond this number if there is demand, but
  # they will not be returned to the pool and instead will be
  # immediately destroyed.

  MaxSize = 10

  # Specifies the minimum number of bean instances that should be in
  # the pool for each bean.  Pools are prefilled to the minimum on
  # startup.  Note this will create start order dependencies between
  # other beans that also eagerly start, such as other @Stateless
  # beans with a minimum or @Singleton beans using @Startup.  The
  # @DependsOn annotation can be used to appropriately influence
  # start order.
  #
  # The minimum pool size is rigidly maintained.  Instances in the
  # minimum side of the pool are not eligible for IdleTimeout or
  # GarbageCollection, but are subject to MaxAge and flushing.
  #
  # If the pool is flushed it is immediately refilled to the minimum
  # size with MaxAgeOffset applied.  If an instance from the minimum
  # side of the pool reaches its MaxAge, it is also immediately
  # replaced.  Replacement is done in a background queue using the
  # number of threads specified by CallbackThreads.

  MinSize = 0

  # StrictPooling tells the container what to do when the pool
  # reaches it's maximum size and there are incoming requests that
  # need instances.
  #
  # With strict pooling, requests will have to wait for instances to
  # become available. The pool size will never grow beyond the the
  # set MaxSize value.  The maximum amount of time a request should
  # wait is specified via the AccessTimeout setting.
  #
  # Without strict pooling, the container will create temporary
  # instances to meet demand. The instances will last for just one
  # method invocation and then are removed.
  #
  # Setting StrictPooling to false and MaxSize to 0 will result in
  # no pooling. Instead instances will be created on demand and live
  # for exactly one method call before being removed.

  StrictPooling = true

  # Specifies the maximum time that an instance should live before
  # it should be retired and removed from use.  This will happen
  # gracefully.  Useful for situations where bean instances are
  # designed to hold potentially exp

Re: Unable to configure MYSQL resource in tomee.xml

[Neale]

Hi Avron,

Can you paste your entire tomee.xml?

I had the same problem when I started using TomEE because of the default 
database definitions in there.  If you remove the other definitions, it 
should use the database you defined.


Best Regards,
Neale

- Original Message - 
From: "avrono" 

To: 
Sent: Friday, December 14, 2012 5:43 AM
Subject: Unable to configure MYSQL resource in tomee.xml



Hi,

I am having a problem with configuring a database connection. I Have 
managed

to write to the database using   DriverManager but not with @Resource.

I have the following in my tomee.xml


 JdbcDriver com.mysql.jdbc.Driver
 JdbcUrl jdbc:mysql://localhost:3306/mydb
 UserName myuser
 Password mypass
 JtaManaged true



in my ManagedBean, I have

@Resource(name="MyDataSource", type=javax.sql.DataSource.class)
Private DataSource dataSource;


I have a @PostConstruct

with 

try {
 connection = dataSource.getConnection();
} catch (Exception ex) {
ex.printStackTrace();
}


The Connection does not throw an exception , however when I try write to 
the

connection

try {
  stmt = connection.createStatement();
  stmt.executeUpdate(insert_string)
} catch (Exception ex) {
  ex.printStackTrace()
}


I get

Query is java.sql.SQLSyntaxErrorException: user lacks privilege or object not 
found:

ITEM
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.tomcat.jdbc.pool.interceptor.StatementDecoratorInterceptor$StatementProxy.invoke(StatementDecoratorInterceptor.java:238)
at $Proxy83.executeUpdate(Unknown Source)
at com.prsx.ItemAdder.addItem(ItemAdder.java:101)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.el.parser.AstValue.invoke(AstValue.java:278)
at 
org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)

at
org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70)
at
org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:68)
at javax.faces.component.UICommand.broadcast(UICommand.java:120)
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286)
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375)
at 
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)

at
org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38)
at
org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170)
at
org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not
found: ITEM
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getTable(Unknown Source)
at org.h