Hey all, We are trying to get the subversion head versions of both adempiere and libero to compile and play nice. But we are still getting some wierd sql errors when we try and create a client. Their are many many errors that all seem to be exactly the same they are:
[WARNING] [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[WARNING] [c3p0] Another error has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block ] which will not be reported to listeners!org.postgresql.util.PSQLException: ERROR:
current transaction is aborted, commands ignored until end of transaction block
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.compiere.model.MSequence.getNextID(MSequence.java:137)
at org.compiere.util.DB.getNextID(DB.java:1402)
at org.compiere.model.PO.saveNew(PO.java:2256)
at org.compiere.model.PO.save(PO.java:1883)
at org.compiere.model.MSetup.createClient(MSetup.java:306)
at org.compiere.apps.form.VSetup.run(VSetup.java:439)
at org.compiere.apps.form.FormFrame$2.run(FormFrame.java:401)
A brief outline of the process we followed to do the install is
1. Check out the head version of both libero and adempiere
2. Build adempiere
3. Build libero
4. Rebuild adempiere (to get the libero.jar into the install)
5. Set up the database. (Create database, run the pljava deployer, drop the sqlj schema, import the dump file)
6. Run the 330-trunk database migrations
7. Copy EE01.zip into the packages directory
8. Run silent setup and start the app server.
9. Launch the Adempiere client
10. Add the EE01 entity type
11. Pack in the EE01.zip
12. Copy libero.jar into the packages/packages/EE01/lib directory.
13. Re-run silentsetup and start the server.
Then we we get the above error when trying to create the client.
Are we doing something blatantly wrong? My method is sort of a hybridized version of all the information I could find on the web for doing this and seems to get me the furthest along.
-Cheers
Dominic
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Download my vmware image with a fully functional libero install on adempiere from the subversion head at www.graysonconsulting.biz/files.html. It even has all the build tools I used. I hope this will help you! Also join me in irc.freenode.net #adempiere and I can help you more with setting up libero.
-Tim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey all, We are trying to get the subversion head versions of both adempiere and libero to compile and play nice. But we are still getting some wierd sql errors when we try and create a client. Their are many many errors that all seem to be exactly the same they are:
[WARNING] [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
[WARNING] [c3p0] Another error has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block ] which will not be reported to listeners!org.postgresql.util.PSQLException: ERROR:
current transaction is aborted, commands ignored until end of transaction block
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.compiere.model.MSequence.getNextID(MSequence.java:137)
at org.compiere.util.DB.getNextID(DB.java:1402)
at org.compiere.model.PO.saveNew(PO.java:2256)
at org.compiere.model.PO.save(PO.java:1883)
at org.compiere.model.MSetup.createClient(MSetup.java:306)
at org.compiere.apps.form.VSetup.run(VSetup.java:439)
at org.compiere.apps.form.FormFrame$2.run(FormFrame.java:401)
*** 2007-11-29 02:01:26.872 Adempiere Log (CLogConsole) ***
A brief outline of the process we followed to do the install is
1. Check out the head version of both libero and adempiere
2. Build adempiere
3. Build libero
4. Rebuild adempiere (to get the libero.jar into the install)
5. Set up the database. (Create database, run the pljava deployer, drop the sqlj schema, import the dump file)
6. Run the 330-trunk database migrations
7. Copy EE01.zip into the packages directory
8. Run silent setup and start the app server.
9. Launch the Adempiere client
10. Add the EE01 entity type
11. Pack in the EE01.zip
12. Copy libero.jar into the packages/packages/EE01/lib directory.
13. Re-run silentsetup and start the server.
Then we we get the above error when trying to create the client.
Are we doing something blatantly wrong? My method is sort of a hybridized version of all the information I could find on the web for doing this and seems to get me the furthest along.
-Cheers
Dominic
Download my vmware image with a fully functional libero install on adempiere from the subversion head at www.graysonconsulting.biz/files.html. It even has all the build tools I used. I hope this will help you! Also join me in irc.freenode.net #adempiere and I can help you more with setting up libero.
-Tim
thanks a lot!
I've downloaded that, but have a deadline this week and wont have time to try it out until next week.
will will see you on IRC.
Cheers. Dominic