Re: TomEE + maven jar hell

2012-12-13 Thread Romain Manni-Bucau
If you got it maybe share it here, it can be useful for others Le 14 déc. 2012 08:20, "robertlee" a écrit : > sorry, it's a maven dependency related issue, I shouldn't post the issue > here. TomEE is great. > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/TomEE-mav

Re: TomEE + maven jar hell

2012-12-13 Thread robertlee
sorry, it's a maven dependency related issue, I shouldn't post the issue here. TomEE is great. -- View this message in context: http://openejb.979440.n4.nabble.com/TomEE-maven-jar-hell-tp4659515p4659610.html Sent from the OpenEJB User mailing list archive at Nabble.com.

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread Howard W. Smith, Jr.
David, I corrected that as you stated, and I made sure the code was as you recommended, and I've updated the JIRA with test results. Windows Server 2008 64bit is still fast, Windows SErver 2003 32bit is 'still' slow and locking the database. On Thu, Dec 13, 2012 at 7:02 PM, David Blevins wrote:

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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=DataSou

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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://open

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 2:41 PM, "Howard W. Smith, Jr." wrote: > Question... > > My last/latest implementation/version of AirportShuttleProcessingBean is a > @Stateless EJB that calls many other @Stateless EJB (DAO). Should I keep > PersistentContext in AirportShuttleProcessingBean, or can > Airpo

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 3:57 PM, "Howard W. Smith, Jr." wrote: > David, I did as you recommended. I got an exception related to the ejbTimer > and JTA. please see my latest 2 post on the JIRA. My bad, should be @TransactionAttribute(NOT_SUPPORTED) -- even hard for me to remember the right names

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread Howard W. Smith, Jr.
David, I did as you recommended. I got an exception related to the ejbTimer and JTA. please see my latest 2 post on the JIRA. https://issues.apache.org/jira/browse/OPENEJB-1968 Need to leave my desk for little bit. Thanks. On Thu, Dec 13, 2012 at 4:06 PM, David Blevins wrote: > If you're willin

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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: openejb.xml

2012-12-13 Thread Romain Manni-Bucau
wrong "foo" is the standard. java:... names are not. You can use java:openejb/Resource/foo too i guess...but well not better ;) OpenEJB 4.5.1 should support java:global or java:app (can't remember) names for datasources. But well clearly not something portable between application servers. about r

RE: openejb.xml

2012-12-13 Thread Baker, Trevor
Hi Romain, I agree Arquillian in fully embedded is not easy to get right. Been playing around with it for weeks. :-) Not only that but OpenEJB has to deal with different JPA providers too. I understand the desire to load stuff off of file://... because don't have to re-package all the code into

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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/rmannibu

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 2:01 PM, "Howard W. Smith, Jr." wrote: > Thanks for the response. Guess what... the 2 beans along with the names and > all... is exactly what I did 'yesterday', the only thing I did 'not' do was > mark each of the beans according to what you mentioned. Right, the annotation

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 1:53 PM, David Blevins wrote: > > On Dec 13, 2012, at 1:17 PM, "Howard W. Smith, Jr." > wrote: > >> David, >> >> 1. definitely not using @Asynchronous; that was no good at all >> >> 2. Actually, it was 2 seconds on the Windows Server 2008 64-bit 16GB RAM... >> always >>

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread Howard W. Smith, Jr.
David, Thanks for the response. Guess what... the 2 beans along with the names and all... is exactly what I did 'yesterday', the only thing I did 'not' do was mark each of the beans according to what you mentioned. I will try that, ASAP might not be able to report about it until a little late

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 1:17 PM, "Howard W. Smith, Jr." wrote: > David, > > 1. definitely not using @Asynchronous; that was no good at all > > 2. Actually, it was 2 seconds on the Windows Server 2008 64-bit 16GB RAM... > always > > 3. Always 5 to 10 minutes to process 1 or 2 emails on Windows Se

Re: openejb.xml

2012-12-13 Thread Romain Manni-Bucau
about root url with 1.5.1 it should be the build dir (well we look at classpath persistence.xml so if resources is in the classpath...) but you can avoid it specifying your entities. From arquillian in fully embedded mode that's not so easy to get it right (you can specify it using new StringAsset(

RE: openejb.xml

2012-12-13 Thread Baker, Trevor
I'm hoping to use config files instead of doing it programmatically. I tried a src/test/resources/dbUnit-persistence.xml once before with Arquillian putting it into the archive as META-INF/persistence.xml. Sadly, the PU's root url passed to hibernate was incorrect and hibernate didn't obviously

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
So, I haven't settled on any particular EE container. I like the fact I can manage the different Glassfish aspects via a web interface and that it is so "reference" and just works. I disagree with the not working statement as the nature of this thread is: it didn't work out of the box with TomE

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Howard W. Smith, Jr.
I recommend 1.5.1 and I prefer it over Glassfish? Why, because I don't make sticking with it...to make it work. TomEE and CDI-managed-beans and the not-so-real Apache Derby database on my slow/old Windows Server 2003 32bit 4GB RAM is performing just as good as Glassfish 3.1.2.2. I'm just learning

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Romain Manni-Bucau
personally i use Intellij Idea (Ultimate but to be honest i only use community features excepting for spring integration which is awesome). i love the tomee maven plugin (@others: i know :p) and abuse of it I think Jon is using eclipse @Jon: right? Romain Manni-Bucau Twitter: @rmannibucau Blog:

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
Hey, that's good. I take it you're an Eclipse user then? I really want to like Eclipse, but I find there are just too many things where I have to lay my hands on that would work out of the box with Netbeans. At the same time, Netbeans currentlt doesn't let me generate JSF pages from Entity Bean

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread Howard W. Smith, Jr.
David, 1. definitely not using @Asynchronous; that was no good at all 2. Actually, it was 2 seconds on the Windows Server 2008 64-bit 16GB RAM... always 3. Always 5 to 10 minutes to process 1 or 2 emails on Windows Server 2003 32-bit 4GB RAM 4. As noted on the JIRA, I tried the TransactionAttri

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Romain Manni-Bucau
you'll not get issue with your management, the 1.5.1 release passed, we just wait Jean-Louis to push binaries on repo1 :) Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmannibucau 2012/

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
It does when you check the "Enable Context and Dependency Injection" check box. Kay Wrobel MIS Associate *Hawk Electronics, Inc.* 800-THE-HAWK 800-843-4295 kwro...@hawkusa.com On 12/13/2012 03:08 PM, Romain Manni-Bucau wrote: Question from a none netbeans user: when creating a new JavaE

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
Romain + Howard: I completely removed 1.5.0 and downloaded latest 1.5.1 snapshot (apache-tomee-1.5.1-20121212.041901-106-plus.tar.gz), extracted it to /usr/local/java, started the server and copied the war file to the webapps folder. I then opened the app URL again and now I get: Message is: b

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Romain Manni-Bucau
Question from a none netbeans user: when creating a new JavaEE 6 project netbeans doesn't create a beans.xml? 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 Howard

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Howard W. Smith, Jr.
I struggled getting mine to work as well, but I was advised to either add beans.xml to WEB-INF or META-INF folder. I learned that in NetBeans, for META-INF, you create a new folder in the same folder that contain all your java code. Netbeans does not like META-INF/beans.xml, you get squiggly lines

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 13, 2012, at 12:27 PM, "Howard W. Smith, Jr." wrote: > David, > > Yes, please refer to the following (and see what I wrote at the beginning > of that comment), thanks. > > https://issues.apache.org/jira/browse/OPENEJB-1968#comment-13531442 > So first note, the @TransactionAttribute(v

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
Thanks, Howard. For this simple example, I don't need to set up and Resources just yet. I've seen the documentation pages regarding the topics you mentioned and am aware of them. This is just too simple of an example, and it's failing miserably right now. You see, I am evaluating Java EE as

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Romain Manni-Bucau
well as said by oward first give a try to the last version then don't move/remove/add these jar before you need it: asm-3.3.1.jar (added that when I was evaluating batoo jpa) derby.jar eclipselink.jar el-api-2.2 el-impl-2.2 javax.mail joda-time-2.0 (to replace joda-time-1.6.2 which already exists

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
@Romain: Well, the tag was automatically added by Netbeans when I created the project. I commented it out when I re-targeted the project to Glassfish or Glassfish would throw a deploy exception. So with the project targeted to Glassfish, I clicked in "Clean and Build" on the Project node and

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Howard W. Smith, Jr.
Kay, Welcome to TomEE, and glad to see someone that is interested in doing what I did at least one month ago. Please note/do the following: 1. Download TomEE Plus 1.5.1 (SNAPSHOT) instead of 1.5.0; 1.5.0 did not work at all for me as my environment is Windows Server 2003 & 2008; 1.5.1 resolves a

Re: openejb.xml

2012-12-13 Thread Romain Manni-Bucau
hmm jndi.properties is not managed by openejb directly in your case byt InitialContext IIRC why not simply passing these properties to openejb when starting the container? Note: "new" EJBContainer API ignores jndi.properties IIRC for the datasource you can create a conf folder (in ".") and add o

Re: Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Romain Manni-Bucau
hmm, org.apache.myfaces.webapp.StartupServletContextListener is useless but that's not it did yuo put a beans.xml? does it work in manual mode (put your war in webapps then bin/catalina.sh run)? Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
profile just this part :p (without front etc) 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 Howard W. Smith, Jr. : > Sorry, don't understand what you're trying to

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread Howard W. Smith, Jr.
David, Yes, please refer to the following (and see what I wrote at the beginning of that comment), thanks. https://issues.apache.org/jira/browse/OPENEJB-1968#comment-13531442 On Thu, Dec 13, 2012 at 3:11 PM, David Blevins wrote: > The description of EmailStatelessBean still looking beans and f

Re: openejb.xml

2012-12-13 Thread Neale
Hi Trevor, Can you tell us your changes/findings so we can adjust the docs to make it easier for everyone else? Best Regards, Neale - Original Message - From: "Baker, Trevor" To: Sent: Friday, December 14, 2012 7:10 AM Subject: RE: openejb.xml Fixed some line-ending weirdness.

Simple Netbeans CDI Web Application Not Working

2012-12-13 Thread Kay Wrobel
Hi everybody. I am new to TomEE and am having problems with the very basics of getting a simple CDI Application to work from Netbeans 7.2. I have added TomEE Plus 1.5.0 as a server via the Tools->Servers->Add Server... steps. The problem I have is as follows: I create a simple Web Applicatio

Re: Why are Tomcat's threads more costly than background threads?

2012-12-13 Thread David Blevins
On Dec 11, 2012, at 7:10 PM, "Howard W. Smith, Jr." wrote: > Shaking my head... test results were not good at all. > > 1. @StatelessEJB EmailStatelessBean has @Schedule getEmails() > 2. @EmailStatelessBean has multiple @EJB references to @Stateless > (sessionfacade) classes that are the DAO cl

RE: openejb.xml

2012-12-13 Thread Baker, Trevor
Fixed some line-ending weirdness. -Original Message- From: Baker, Trevor [mailto:crba...@mail.ubc.ca] Sent: Thursday, December 13, 2012 12:07 PM To: users@openejb.apache.org Subject: openejb.xml Hi, I have the following jndi.properties: java.naming.factory.initial=org.apache.opene

openejb.xml

2012-12-13 Thread Baker, Trevor
Hi, I have the following jndi.properties: java.naming.factory.initial=org.apache.openejb.client.LocalInitialContextFactory # create a new data source at: java:/openejb/Resource/dbUnitDS dbUnitDS=new://Resource?type=DataSource dbUnitDS.JdbcUrl=jdbc:h2:mem:arquillian;DB_CLOSE_DELAY=-1 dbUnitDS.Jdb

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Sorry, don't understand what you're trying to say here. @Schedule is used to poll or check an email server for 'specific' emails, and the emails of interest has JSON embedded, and that JSON are populated into POJOs via Gson, and then the fun begins... saving that little bit of data to multiple tab

Re: DB access is very slow

2012-12-13 Thread Neale
Hi Romain, Ah ok that makes sense. I'm still fairly new to EE thinking ;-) So if I deploy a new TomEE app, I should use JTA and modify tomee.xml to use my DB descriptor - not the Tomcat method of context.xml? Is this the best doc page on how to configure it? http://tomee.apache.org/container

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Interesting what you mentioned about JavaEE7, I remember you advising me to use tomee.xml and even 'questioned' me... why are you not using tomee.xml instead of context.xml... remember that? :) Well, I'm definitely using JTA, and if I understand you correctly, I think you are recommending to remo

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
well your @Schedule == polling no server, it sounds weird by design @Neale: the default datasource will be a feature of JavaEE 7. Context.xml stuff should be better on 1.5.1 but we clearly use tomee.xml by default (and not context.xml) because of jta management at least that's said the issues are

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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 ... N

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Honestly, my preference would be to use @Schedule; I don't want to bug the users and ask/make/require them to click a button to download this data from email server. TomEE examples has @Schedule on a Singleton bean (I think that's what I remember, when I saw it). I saw the same in a (BalusC) stacko

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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: DB access is very slow

2012-12-13 Thread Neale
Actually I'd recommend removing the default HSQLDB reference in tomee.xml I'm not sure if it's used for one of the examples or what it's used for, but every time I"ve deployed a TomEE instance I've had to remove/disable it manually because it overrides my real database definition (META-INF/con

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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

Re: DB access is very slow

2012-12-13 Thread Neale
Definitely ask him about all the @stuff. That's his area! - Original Message - From: "Howard W. Smith, Jr." To: Sent: Friday, December 14, 2012 6:09 AM Subject: Re: DB access is very slow Thank you very much Neale for all your responses. I have been open to searching around for a

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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. # # A

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
hard to come back now ;) back on the topic, Well Howard think you should try to share with us some sample (not the full app please) i used a lot Geronimo transaction manager and i used ( a bit less) @Schedule and it worked fine i could understand OpenJPA begin slower on derby but geronimo not

Re: DB access is very slow

2012-12-13 Thread Neale
Romain is great :-) - Original Message - From: "Howard W. Smith, Jr." To: Sent: Friday, December 14, 2012 6:09 AM Subject: Re: DB access is very slow Thank you very much Neale for all your responses. I have been open to searching around for a good java web host, but just didn't fin

Re: Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread 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: "avron

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Thank you very much Neale for all your responses. I have been open to searching around for a good java web host, but just didn't find it necessary...yet. At some point, I may be interested in your TomEE hosting service; when the project reaches a larger scope of endusers. Right now, I think we are

Unable to configure MYSQL resource in tomee.xml

2012-12-13 Thread avrono
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 Pas

Re: DB access is very slow

2012-12-13 Thread Neale
Hi Howard, Your discussions are very interesting - I haven't unsubscribed from the TomEE list yet even though there is such high volume. Lately I actually quite enjoy following your progress. There are a lot of emails - but just don't get too off-topic ;-) Try a few things on your own, then

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Thanks Will! On Thu, Dec 13, 2012 at 1:41 PM, Will Hoover wrote: > If you want speed/performance/flexibility/scalability I would recommend H2 > Database: > > http://www.h2database.com > > There's a really handy comparison matrix (Derby/HSQLDB/MySQL/PostgreSQL): > > http://www.h2database.com/html

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Smiling...forgot to mention... the database would have been much larger (if I kept all the 'historic' / obsolete data from 1998, but decided to keep only 3 years worth of data, and archive the rest in the old dBase IV database files) )... the first version of my app, dBase IV app, created in 1994/1

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Agreed about Romain, he is very amazing. Noted about HyperSQL, will avoid that, and understood about 17mb = "playing". This is a new app that I've developed and it's being used every day for 'business', so definitely not playing, but I do want to move to prime-time and a faster database, so I will

RE: DB access is very slow

2012-12-13 Thread Will Hoover
If you want speed/performance/flexibility/scalability I would recommend H2 Database: http://www.h2database.com There's a really handy comparison matrix (Derby/HSQLDB/MySQL/PostgreSQL): http://www.h2database.com/html/features.html#comparison The nice thing about H2 Database is it can potentially

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
okay, thanks! On Thu, Dec 13, 2012 at 1:26 PM, José Luis Cetina wrote: > I recommend to you Mysql too. I always used with jpa openjpa or > eclipselink for now without problems. >

Re: DB access is very slow

2012-12-13 Thread Neale
HyperSQL is another toy. The specs below are great, Derby looks good in some cases, bad in others. But once again this is a very small test database. You might get 10% performance increase moving your database from derby to mysql, or you might get a 10% performance loss. If you plan to use i

Re: DB access is very slow

2012-12-13 Thread José Luis Cetina
I recommend to you Mysql too. I always used with jpa openjpa or eclipselink for now without problems. El dic 13, 2012 12:21 PM, "Romain Manni-Bucau" escribió: > MySQL, don't even try hsqldb if your app has users > > then http://dbcopyplugin.sourceforge.net/ should help ;) > > Romain Manni-Bucau

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Great, thanks Romain. Is MySQL still Open Source? I thought they are under Oracle umbrella now...and I would assume there is a license or fee involved. right? On Thu, Dec 13, 2012 at 1:20 PM, Romain Manni-Bucau wrote: > MySQL, don't even try hsqldb if your app has users > > then http://dbcopyplug

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
MySQL, don't even try hsqldb if your app has users then http://dbcopyplugin.sourceforge.net/ should help ;) 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 Howard

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
That's the benchmark website that I've been referring to, and that is what I've been using to justify apache derby. I don't know how reliable this website is though. :) On Thu, Dec 13, 2012 at 1:13 PM, Romain Manni-Bucau wrote: > > yep, more or less same note can apply to windows i guess :p > > t

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Neale, Thanks for the responses and suggestions; much appreciated. I will definitely consider another database. I need to take some time and dump all of the 'real' data (and the schema), and make sure the SQL and schema will work well with a 'real' database. For the most part, it is all SQL-92, e

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
Hey, yep, more or less same note can apply to windows i guess :p that's said, i'm not sure of the data but here some figures: http://www.jpab.org/EclipseLink/Derby/server/OpenJPA/Derby/server.html don't know why OpenJPA is so slow @Mark: any idea? FYI the same with MySQL: http://www.jpab.org/E

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
hahaha, it is funny. :) i will definitely consider another database, thanks. On Thu, Dec 13, 2012 at 12:08 PM, Romain Manni-Bucau wrote: > funny what you call fast sounds slow for me :p > > > that's said maybe try antoher database (mysql?) >

Re: DB access is very slow

2012-12-13 Thread Neale
Hi Howard, Derby is an in-memory java-based DB, so with a 100mb database it performs great. Once you start putting real data into it, it fails horribly. It's designed for testing, and never for production (read the docs). Please never use it as a "production" database. We had a customer h

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
funny what you call fast sounds slow for me :p that's said maybe try antoher database (mysql?) maybe the openjpa dictionnary is bad (maybe ask openjpa btw) Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: ht

Re: DB access is very slow

2012-12-13 Thread Neale
How big is the DB? Do you have indexes? It should be lightning fast (1000+ requests per minute) for small DB name/address lookups. Have you tried a real DB like MariaDB/MySQL/PgSQL? Derby is pretty terrible if the database is substantial... good for testing small projects though. Best Regard

Re: EAR IN TOMEE

2012-12-13 Thread José Luis Cetina
But i have a ejb module (jar file) and a war file they are not in a ear. Thats why Romain told that its not possible. 2012/12/13 rmpestano > right... IMHO it should work, producers methods were designed for that - > initialize components with 'special' contructor -. Here we have something > li

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
Neale, Yes, real server that I maintain, myself, definitely 4GB RAM and Windows Server 2003 = 32bit. :) Howard On Thu, Dec 13, 2012 at 10:07 AM, Neale wrote: > Hi Howard, > > Is this a real server (ie: real hardware), or a VPS that says it has "4gb > RAM, 32bit"? > > Neale > > - Original M

Re: DB access is very slow

2012-12-13 Thread Neale
Hi Howard, Is this a real server (ie: real hardware), or a VPS that says it has "4gb RAM, 32bit"? Neale - Original Message - From: "Howard W. Smith, Jr." To: Sent: Friday, December 14, 2012 1:49 AM Subject: Re: DB access is very slow only queries i do is to small lookup tables..

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
only queries i do is to small lookup tables... address/phone/email address type to get the database entity. at most, those tables have 3 to 5 rows of really really small data... Business, home, mobile (phone)... file database? 'Apache' Derby locks on windows... when i first developed this (few da

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
maybe you just do too much queries and the schedul is called too often...and you are on a file database right? so it locks on windows... Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.com/ LinkedIn: http://fr.linkedin.com/in/rmannibucau Github: https://github.com/rmann

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
haha okay... it is primarily a file server, also has some other software running on it, another database engine (Microsoft SQL, I think, but that's not my software), that database engine is accessed by client software on laptops connected to the LAN as well as remote connection (windows remote des

Re: DB access is very slow

2012-12-13 Thread Romain Manni-Bucau
that's not the usage of the machine :p 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 Howard W. Smith, Jr. : > same machine > > On Thu, Dec 13, 2012 at 8:05 AM, Jo

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
same machine On Thu, Dec 13, 2012 at 8:05 AM, José Luis Cetina wrote: > Where is your database, localhost?

Re: DB access is very slow

2012-12-13 Thread Howard W. Smith, Jr.
I had research my emails for this... Dual Core Xeon Processor 5050 2x2MB Cache, 3.00GHz, 667MHz FSB, PE 2900 Dual Core Xeon 2nd Processor 5050, 2x2MB Cache, 3.00GHz 667MHz FSB, PE 2900 2GB 533MHz (4x512MB), Single Ranked DIMMs (replaced by 4GB RAM) 80GB, SATA, 3.5-inch 7.2K RPM Hard Drive 1TB, SAT

Re: DB access is very slow

2012-12-13 Thread José Luis Cetina
Where is your database, localhost? El dic 13, 2012 12:27 AM, "Romain Manni-Bucau" escribió: > Do you have the machine usage (cpu+mem+io)? > > Glassfish is not faster, eclipselink is not faster in general (depend what > you do). Maybe you need to configure openjpa sequence to set bigger > allocati

Re: TomEE + maven jar hell

2012-12-13 Thread Romain Manni-Bucau
Hi, which version? can you share your sample? 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 robertlee : > normally I would hate to throw undigested problem to f

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Howard W. Smith, Jr.
I know what I must do. Stateless ejb to stateless ejb is not how I normally do things. I usually do updates by injecting the CDI managed beans and that bean does update. Managed bean call other managed bean, and then that managed bean updates database via stateless ejb. On Dec 13, 2012 5:01 AM, "Ho

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Howard W. Smith, Jr.
agreed on all accounts. I may be open to increasing timeout to 30minutes. i really don't know why this takes so long... I have one page where user can enter a bunch of stuff, and that page saves more data then this operation does... and it takes 1 or 2 seconds when user click Save button on that A

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Romain Manni-Bucau
great to hear you go further with TomEE ;) (lol) well think next step is to identify why you are so slow since i guess you last more than 10mn you can configure the timeout to be 30mn but think it is a very bad idea ;) Romain Manni-Bucau Twitter: @rmannibucau Blog: http://rmannibucau.wordpress.c

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Howard W. Smith, Jr.
I didn't get that far with glassfish; i think i remember errors on startup, trying to get the timerservice as resource. i left it alone. this is first time i really used @schedule. On Thu, Dec 13, 2012 at 4:11 AM, Romain Manni-Bucau wrote: > once again the issue is probably not directly in tomee

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Romain Manni-Bucau
once again the issue is probably not directly in tomee since we use it for quite a long time you should just try to identify why a timeout is quite explicit as error, what was the one of glassfish for transactions? think it is 10mn in tomee by default Romain Manni-Bucau Twitter: @rmannibucau Blo

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Howard W. Smith, Jr.
Below is what I'm entering on the JIRA. very very interesting...and baffling! Just as I did not like the behavior of @Schedule in Glassfish, i'm not liking the behavior of @Schedule in TomEE. I have been developing my own timers without Timer service...just use joda DateTime or java.util.Date. I m

Re: TomEE EjbTimerServiceImpl ejbTimeout exception while completing container transaction

2012-12-13 Thread Howard W. Smith, Jr.
the following has the same test results too. i'm changing my implementation a bit. will share more based on (or after) test results. On Thu, Dec 13, 2012 at 2:38 AM, Howard W. Smith, Jr. < smithh032...@gmail.com> wrote: > Okay, I tried the following, > > @TransactionAttribute(value = TransactionA