[GENERAL] DataBase Problem
I am having problem as : Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(Hi bernateTransactionManager.java:677) at org.springframework.transaction.support.AbstractPlatformTransactionManager.d oRollbackOnCommitException(AbstractPlatformTransactionManager.java:850) at org.springframework.transaction.support.AbstractPlatformTransactionManager.p rocessCommit(AbstractPlatformTransactionManager.java:737) at org.springframework.transaction.support.AbstractPlatformTransactionManager.c ommit(AbstractPlatformTransactionManager.java:678) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitT ransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr ansactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect iveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro xy.java:204) at $Proxy57.generateReport(Unknown Source) ... 106 more Caused by: org.hibernate.TransactionException: JDBC rollback failed at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:204) at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(Hi bernateTransactionManager.java:674) ... 114 more Caused by: java.sql.SQLException: Couldn't perform the operation rollback: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs). at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:2 07) at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.jav a:87) at org.postgresql.PGConnection$$EnhancerByProxool$$4e6ef3b1.rollback(generated ) at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTra nsaction.java:217) at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196) ... 115 more Pls guide me.Thanks you.
[GENERAL] Performance with Boolean datatype
Hi, I would like to know is there any perf differences between case 1: when i use ( ...where validate=FALSE) [validate as Boolean] case 2: when i use ( ... where validate=1) [validate as int(1)] Thanks DEVI.G
[GENERAL] PostgreSQL connect error
Hi Friends, I wrote a sample php program that connects to PostgreSQL DB. == I was able to run the PHP program from the command prompt as postgres user not as anyother user $ php pgsql.php == I was not able execute the same file from the web browser. FATAL ERROR- undefined function pg_connect(). How to resolve this issue? Please help. Thanks DEVI.G
Re: [GENERAL] PostgreSQL connect error
Hi , As john suggested, i tried setting up the env .. but that dosen't help out. I tried with IP, instead of localhost in pg_hba.conf.. just trail error approach... Now.. i'm getting the error as FATAL: role apache does not exist Can U help me out here!! Thanks DEVI.G - Original Message - From: Thomas Pundt mli...@rp-online.de To: devi d...@visolve.com; pgsql-general@postgresql.org Sent: Tuesday, March 10, 2009 2:53 PM Subject: Re: [GENERAL] PostgreSQL connect error devi schrieb: Hi Friends, I wrote a sample php program that connects to PostgreSQL DB. == I was able to run the PHP program from the command prompt as postgres user not as anyother user $ php pgsql.php == I was not able execute the same file from the web browser. FATAL ERROR- undefined function pg_connect(). How to resolve this issue? Please help. Thanks DEVI.G Apparently your php CLI binary has support for PostgreSQL compiled in, your web server not. Resolving this highly depends on your platform; it might be as easy as installing an RPM and restarting the web server, or you needing to recompile PHP with PostgreSQL support compiled in. Ciao, Thomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL connect error
Hi Richard, Thanks it works.. DEVI.G - Original Message - From: Richard Huxton d...@archonet.com To: devi d...@visolve.com Cc: thomas.pu...@rp-online.de; pgsql-general@postgresql.org Sent: Tuesday, March 10, 2009 3:39 PM Subject: Re: [GENERAL] PostgreSQL connect error devi wrote: Hi , As john suggested, i tried setting up the env .. but that dosen't help out. I tried with IP, instead of localhost in pg_hba.conf.. just trail error approach... There is no need to use trial and error - this is covered in the manuals: http://www.postgresql.org/docs/current/static/client-authentication.html Now.. i'm getting the error as FATAL: role apache does not exist Can U help me out here!! You're trying to connect with a username of apache and you don't have that set up in the database. Stop. Make a good hot cup of tea/coffee and read through the section of the manual mentioned above. Disable access from the internet (listen_addresses) and set up trust access as a first step. Connect as the postgres user (from psql), add a new database user (e.g. test) with a password (see the manuals for details). Create a database owned by them. Now try logging in as that user - no password should be necessary. Edit the pg_hba.conf to require passwords for all users apart from postgres which you can leave as ident. Restart the postgresql server and try reconnecting as your test user. You should now need a password. If all that's working, try connecting as your test user from php. Don't forget to check result codes when you connect to the database or send a query etc. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Checkpoints questions
Hi, Hope this helps http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Thanks DEVI.G - Original Message - From: Henrik [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Tuesday, March 04, 2008 3:28 PM Subject: [GENERAL] Checkpoints questions Hi list, I'm using 8.3 and I've started looking at the new checkpoint features. As a starter does anyone have some clues how to analyse this: db=# select * from pg_stat_bgwriter; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-+ +---+--+-+--- 118 | 435 |1925161 | 126291 |7 | 1397373 | 2665693 Thanks! //Henke ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.4/1309 - Release Date: 3/3/2008 6:50 PM ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] rule question
Hi, CREATE RULE dosen't require any lock. It is carried out in the parser level. But there will be ACCESS SHARE lock over the tables which are being queried are acquired automatically. Thanks DEVI.G - Original Message - From: Tim Rupp [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Friday, February 29, 2008 8:47 AM Subject: [GENERAL] rule question Hey list, Does CREATE RULE require an exclusive lock on the table it's making a rule for? For instance, if an insert is being done on the table, and you do 'create rule', it will wait for said insert to finish? Thanks, -Tim ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.21.1/1302 - Release Date: 2/27/2008 4:34 PM ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] restoring pgdump.sql
Hi I am trying to restore a pgdump.sql file. i am very much in need of help. i first went to pgAdmin III and created two database ( postgres and anuradha)... properties of anuradha :: 1) owner = ofbiz 2) encoding = 'UTF8' 3)connected ? yes 4) allow connections? yes properties of postgres ::: 1) owner = postgres 2) encoding = SQL_ASCII 3)connected ? yes 4) allow connections? yes the encoding of my pgdump.sql is UNICODE...so i thought i should try to restore it in the database anuradha as it has UTF8 encoding.i select anuradha database and click on Execute SQL queries icon on the toolbar.i then opened my pgdmp.sql file but it gave me an error ERROR: syntax error at or near \ SQL state: 42601 Character: 387817. So i seperated my pgdump.sql into two tables.one is creation.doc which consists of only the commands to create new tables and the other is datas.doc which contains the datas i.e. the COPY ..FROM STDIN; statments and lots of data. i opened creation.doc in the SQL query page of pgAdmin and executed the commands and the tables got created in the database anuradha. but i haven't been able to do the same with datas.doc. So i tried a different option .I went to the command prompt of postgreSQL and typed the command psql -U postgres pgdump.sql ( pgdump.sql is the real file with create and copy commands and data). but i got the following message on the command prompt C:\Program Files\PostgreSQL\8.2\binpsql -U postgres pgdump.sql psql: could not connect to server: Invalid argument (0x2726/10022) Is the server running on host ??? and accepting TCP/IP connections on port 5432? i also tried by changing the username to ofbiz and achinta(my postmaster is logged on as achinta.I checked this out by goin to the services of control panel). Any help would be appreciated.Thanks in advance. -Anuradha - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.