[Riyad Kalla]

X.Chen I’m glad everything is working now.

[ssprastogi]

Hello friends
I write sample hibernate project.
Run it and then face output as
0
null
null
0
a table has four column id,name,city,age in oracle 10g database.
reply please

[ahmad_aljallad]

Dear all

I have seemlier problem for all the previous posts i know it’s old
But i need some help am receiving this error :
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
469 [main] INFO proxool.ProxoolFacade – Proxool 0.8.3 (14-Dec-2003 16:06)
859 [main] INFO cfg.Configuration – processing extends queue
859 [main] INFO cfg.Configuration – processing collection mappings
891 [main] INFO cfg.Configuration – processing association property references
891 [main] INFO cfg.Configuration – processing foreign key constraints
906 [main] INFO connection.ProxoolConnectionProvider – Configuring Proxool Provider using existing pool in memory: proxool.oreka135709
906 [main] INFO connection.ProxoolConnectionProvider – autocommit mode: false
1078 [main] ERROR proxool.ProxoolDriver – Problem
java.sql.SQLException: Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1502)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1031)
at net.sf.oreka.HibernateManager.configure(HibernateManager.java:97)
at net.sf.oreka.test.FillDatabase.main(FillDatabase.java:36)
1094 [main] WARN cfg.SettingsFactory – Could not obtain connection metadata
java.sql.SQLException: Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1502)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1031)
at net.sf.oreka.HibernateManager.configure(HibernateManager.java:97)
at net.sf.oreka.test.FillDatabase.main(FillDatabase.java:36)
1125 [main] INFO dialect.Dialect – Using dialect: org.hibernate.dialect.MySQLMyISAMDialect
1141 [main] INFO transaction.TransactionFactoryFactory – Using default transaction strategy (direct JDBC transactions)
1141 [main] INFO transaction.TransactionManagerLookupFactory – No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1141 [main] INFO cfg.SettingsFactory – Automatic flush during beforeCompletion(): disabled
1141 [main] INFO cfg.SettingsFactory – Automatic session close at end of transaction: disabled
1141 [main] INFO cfg.SettingsFactory – Scrollable result sets: disabled
1141 [main] INFO cfg.SettingsFactory – JDBC3 getGeneratedKeys(): disabled
1141 [main] INFO cfg.SettingsFactory – Connection release mode: null
1141 [main] INFO cfg.SettingsFactory – Maximum outer join fetch depth: 1
1141 [main] INFO cfg.SettingsFactory – Default batch fetch size: 1
1141 [main] INFO cfg.SettingsFactory – Generate SQL with comments: disabled
1141 [main] INFO cfg.SettingsFactory – Order SQL updates by primary key: disabled
1141 [main] INFO cfg.SettingsFactory – Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1141 [main] INFO ast.ASTQueryTranslatorFactory – Using ASTQueryTranslatorFactory
1141 [main] INFO cfg.SettingsFactory – Query language substitutions: {}
1141 [main] INFO cfg.SettingsFactory – Second-level cache: enabled
1141 [main] INFO cfg.SettingsFactory – Query cache: disabled
1141 [main] INFO cfg.SettingsFactory – Cache provider: org.hibernate.cache.HashtableCacheProvider
1141 [main] INFO cfg.SettingsFactory – Optimize cache for minimal puts: disabled
1141 [main] INFO cfg.SettingsFactory – Structured second-level cache entries: disabled
1156 [main] INFO cfg.SettingsFactory – Statistics: disabled
1156 [main] INFO cfg.SettingsFactory – Deleted entity synthetic identifier rollback: disabled
1156 [main] INFO cfg.SettingsFactory – Default entity-mode: pojo
1266 [main] INFO impl.SessionFactoryImpl – building session factory
1922 [main] INFO impl.SessionFactoryObjectFactory – Not binding factory to JNDI, no JNDI name configured
1922 [main] INFO impl.SessionFactoryImpl – Checking 0 named queries
1969 [main] ERROR proxool.ProxoolDriver – Problem
java.sql.SQLException: Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:136)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24)
at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:264)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1070)
at net.sf.oreka.HibernateManager.configure(HibernateManager.java:105)
at net.sf.oreka.test.FillDatabase.main(FillDatabase.java:36)
1969 [main] WARN util.JDBCExceptionReporter – SQL Error: 1044, SQLState: 42000
1969 [main] ERROR util.JDBCExceptionReporter – Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
1984 [main] ERROR oreka.HibernateManager – Hibernate error:org.hibernate.exception.GenericJDBCException
1984 [main] ERROR proxool.ProxoolDriver – Problem
java.sql.SQLException: Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:136)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24)
at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:264)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1070)
at net.sf.oreka.test.FillDatabase.main(FillDatabase.java:39)
1984 [main] WARN util.JDBCExceptionReporter – SQL Error: 1044, SQLState: 42000
1984 [main] ERROR util.JDBCExceptionReporter – Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
Exception in thread “main” org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:136)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:24)
at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:264)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1070)
at net.sf.oreka.test.FillDatabase.main(FillDatabase.java:39)
Caused by: java.sql.SQLException: Access denied for user ‘ahmad_admin1’@’%’ to database ‘test’
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)
at org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222)
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
… 7 more
1984 [Shutdown Hook] INFO proxool.oreka135709 – Shutting down ‘oreka135709’ pool immediately [Shutdown Hook]
1984 [Shutdown Hook] ERROR proxool.ShutdownHook – Problem calling “get cause” on IllegalStateException.
java.lang.reflect.InvocationTargetException
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:585)
at org.logicalcobwebs.proxool.ShutdownHook.remove(ShutdownHook.java:40)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:238)
at org.logicalcobwebs.proxool.ProxoolFacade.shutdown(ProxoolFacade.java:220)
at org.logicalcobwebs.proxool.ShutdownHook.run(ShutdownHook.java:99)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.IllegalStateException: Shutdown in progress
at java.lang.Shutdown.remove(Shutdown.java:104)
at java.lang.Runtime.removeShutdownHook(Runtime.java:218)
… 9 more

can any one help me

[Author]

Posts