Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account
List archives
Videos
Answers

hive-0.6 don't connection mysql in metastore

Meeting notes from the August Hive Contributors Meeting
(49 lines)		 Having a Connections Leak with the Hive Server
(16 lines)
Aug 30, 2010
Lei Liu
Lei Liu
 
I use hive-0.6 an use mysql as metasore, but hive don't connection the
mysql.

2010-08-30 13:28:24,982 ERROR [main] util.Log4JLogger(125): Failed
initialising database.
Invalid URL:
jdbc:mysql://127.0.0.1:3306/hive6?createDatabaseIfNotExist=true
org.datanucleus.exceptions.NucleusDataStoreException: Invalid URL:
jdbc:mysql://127.0.0.1:3306/hive6?createDatabaseIfNotExist=true
    at
org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:536)
    at
org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:290)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown
Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at
org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:588)
    at
org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:300)
    at
org.datanucleus.ObjectManagerFactoryImpl.initialiseStoreManager(ObjectManagerFactoryImpl.java:161)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:583)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:286)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:182)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at javax.jdo.JDOHelper$16.run(JDOHelper.java:1958)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.jdo.JDOHelper.invoke(JDOHelper.java:1953)
    at
javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159)
    at
javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:803)
    at
javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698)
    at
org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:191)
    at
org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:208)
    at
org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:153)
    at
org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:128)
    at
org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:54)
    at
org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:83)
    at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:276)
    at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:228)
    at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:374)
    at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:166)
    at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:125)
    at
org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.<init>(HiveServer.java:79)
    at
org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:85)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:110)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at my.examples.multithreadquery.SimpleSql.main(SimpleSql.java:21)
Caused by: java.sql.SQLException: Invalid URL: jdbc:mysql://
127.0.0.1:3306/hive6?createDatabaseIfNotExist=true
    at
org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:76)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:110)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
    at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
    at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    at
org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:521)
    ... 38 more



I find hive0.6 to connection mysql with
org.apache.hadoop.hive.jdbc.HiveDriver.  I think that is wrong, it should
use com.mysql.jdbc.Driver to connection mysql.
Below is my conifguration:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
 
<value>jdbc:mysql://127.0.0.1:3306/hive6?createDatabaseIfNotExist=true
</value>
  <description>JDBC connect string for a JDBC
metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
  <description>Driver class name for a JDBC
metastore</description>
</property>


<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
  <description>username to use against metastore
database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>root</value>
  <description>password to use against metastore
database</description>
</property>
Reply
Tags: mysqlurlinvaliddatabase
Similar Threads
Mysql Connection Pool asks for closing connection?
Hi I'm using glassfish server, and config a connection pool with
MysqlConnectionPoolDataSource implementation.

I find that when I close session, the connection is closed. (in log:
java.sql.connection - xxx connection closed)

I'm wondering if the connection is closed, how would it make a pool? And
if I config

<transactionManager type="MANAGED">
<property name="closeConnection" value="false" />
</transactionManager>
the connection is not closed, only session is closed. Then the pool ran
out of connections very soon.

So, with conn closed, is it still a efficient pool? thanks.
Mysql exception caused byclosed connection
Hi,
i have a problem with MYSQL.
When i try to perform a query (a simple select) i receive an exception.
This happens only when i wait (doing nothing) for a 2 minutes. After this
next queries works well.
It seems that the connection was unexplectly closed.
I thinked about a socket timeout on a firewall, but my collegues (net
team)
guarantee me that there ins't any firewall in the connection between the
front end server and the database server.
So i really don't know why this happens.
I tryed with "autoReconnectForPools=true" in a mysql connection string,
but
the problem still persist.
Anyone has suggests?
Thanks
Davide

P.S. i'm using cayenne 3.0


[27-05-2010 14:05:39.751] *** error.
[27-05-2010 14:05:39.751] com.mysql.jdbc.CommunicationsException:
Communications link failure due to underlying exception:
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] ** BEGIN NESTED EXCEPTION **
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] java.net.SocketException
[27-05-2010 14:05:39.751] MESSAGE: Broken pipe
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] STACKTRACE:
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] java.net.SocketException: Broken pipe
[27-05-2010 14:05:39.751]       at
java.net.SocketOutputStream.socketWrite0(Native Method)
[27-05-2010 14:05:39.751]       at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
[27-05-2010 14:05:39.751]       at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
[27-05-2010 14:05:39.751]       at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
[27-05-2010 14:05:39.751]       at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
[27-05-2010 14:05:39.751]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.751]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
...........
.........
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] ** END NESTED EXCEPTION **
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751]
[27-05-2010 14:05:39.751] Last packet sent to the server was 0 ms ago.
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
[27-05-2010 14:05:39.751]       at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
[27-05-2010 14:05:39.751]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.751]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
[27-05-2010 14:05:39.751]       at
org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
......................
[27-05-2010 14:05:39.757] *** error.
[27-05-2010 14:05:39.757]
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:
Connection.close() has already been called. Invalid operation in this
state.
[27-05-2010 14:05:39.757]       at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
[27-05-2010 14:05:39.757]       at
com.mysql.jdbc.Connection.getMutex(Connection.java:3755)
[27-05-2010 14:05:39.757]       at
com.mysql.jdbc.Connection.rollback(Connection.java:5251)
[27-05-2010 14:05:39.757]       at
com.caucho.sql.UserConnection.rollback(UserConnection.java:650)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.InternalTransaction.processRollback(InternalTransaction.java:123)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.ExternalTransaction.rollback(ExternalTransaction.java:130)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:869)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
[27-05-2010 14:05:39.757]       at
org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
.................
[27-05-2010 14:05:39.760] ** BEGIN NESTED EXCEPTION **
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760] java.net.SocketException
[27-05-2010 14:05:39.760] MESSAGE: Broken pipe
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760] STACKTRACE:
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760] java.net.SocketException: Broken pipe
[27-05-2010 14:05:39.760]       at
java.net.SocketOutputStream.socketWrite0(Native Method)
[27-05-2010 14:05:39.760]       at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
[27-05-2010 14:05:39.760]       at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
[27-05-2010 14:05:39.760]       at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
[27-05-2010 14:05:39.760]       at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2744)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
[27-05-2010 14:05:39.760]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.760]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:422)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:69)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:395)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:392)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:121)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:743)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:333)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:96)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1278)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1267)
[27-05-2010 14:05:39.760]       at
it..................rpreferenceloader.utils.SingleUserPreferenceService.loadByUid(SingleUserPreferenceService.java:50)
[27-05-2010 14:05:39.760]       at
it.matrix.mobi.virgilio.userpreferenceloader.utils.SingleIstatReaderService.load(SingleIstatReaderService.java:56)
[27-05-2010 14:05:39.760]       at
it.matrix.mobi.virgilio.micro.local.eventi.bean.EventiLocalBean.init(EventiLocalBean.java:39)
[27-05-2010 14:05:39.760]       at
sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
[27-05-2010 14:05:39.760]       at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[27-05-2010 14:05:39.760]       at
java.lang.reflect.Method.invoke(Method.java:597)
[27-05-2010 14:05:39.760]       at
com.caucho.el.MethodExpr.getValue(MethodExpr.java:96)
[27-05-2010 14:05:39.760]       at
com.caucho.el.Expr.evalObject(Expr.java:224)
[27-05-2010 14:05:39.760]       at
_jsp._canali._eventi._listing__jsp._jspService(_listing__jsp.java:215)
[27-05-2010 14:05:39.760]       at
com.caucho.jsp.JavaPage.service(JavaPage.java:61)
[27-05-2010 14:05:39.760]       at
com.caucho.jsp.Page.pageservice(Page.java:587)
[27-05-2010 14:05:39.760]       at
com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:195)
[27-05-2010 14:05:39.760]       at
com.caucho.tools.profiler.ProfilerFilter.doFilter(ProfilerFilter.java:147)
[27-05-2010 14:05:39.760]       at
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
[27-05-2010 14:05:39.760]       at
it.matrix.mobi.virgilio.micro.servlet.SetCookieSupportFilter.filter(SetCookieSupportFilter.java:37)
[27-05-2010 14:05:39.760]       at
it.matrix.mobi.virgilio.micro.generic.GenericFilter.doFilter(GenericFilter.java:45)
[27-05-2010 14:05:39.760]       at
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
[27-05-2010 14:05:39.760]       at
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
[27-05-2010 14:05:39.760]       at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:266)
[27-05-2010 14:05:39.760]       at
com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:435)
[27-05-2010 14:05:39.760]       at
com.caucho.server.port.TcpConnection.run(TcpConnection.java:678)
[27-05-2010 14:05:39.760]       at
com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:721)
[27-05-2010 14:05:39.760]       at
com.caucho.util.ThreadPool$Item.run(ThreadPool.java:643)
[27-05-2010 14:05:39.760]       at java.lang.Thread.run(Thread.java:619)
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760] ** END NESTED EXCEPTION **
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760]
[27-05-2010 14:05:39.760] Last packet sent to the server was 0 ms ago.
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2759)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
[27-05-2010 14:05:39.760]       at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
[27-05-2010 14:05:39.760]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.760]       at
com.caucho.sql.UserPreparedStatement.executeQuery(UserPreparedStatement.java:90)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:71)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
[27-05-2010 14:05:39.760]       at
org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
[27-05-2010 14:05:39.760]       ... 35 more
Cayenne with Axis2: Mysql connection Problems
Hi,

i'm using Cayenne for a while. and it worked perfect.  But since i try to
connect it with Apache Axis 2, i won't get a connection to mysql. I placed
all config files in WEB-INF/classes and all jars to the .aar File. 

When i try to test the service i get the return failure: 

[v.3.0RC3 Mar 29 2010 13:42:23] Error detecting database type: Access
denied
for user 'user'@'localhost' (using password: NO)

I didn't change the cayenne confs. and all my regular apps are still
working
fine.

Any Ideas?
Created: (HIVE-1571) hive.metastore.uris is missing its definition in hive-default.xml
hive.metastore.uris is missing its definition in hive-default.xml
Created: (HIVE-1461) Clean up references to 'hive.metastore.local'
Clean up references to 'hive.metastore.local'
Created: (HIVE-1554) Hive Unable to start due to metastore exception
Hive Unable to start due to metastore exception
Lost old tables in hive metastore after installing a new version of hive
I built hive from SVN, and am running into the following issue: I
can't seem to access any of my old tables, that is, SHOW TABLES
doesn't return any entries.  I can create new tables, and they show up
in HDFS in /user/hive/warehouse alongside the old ones.  Likewise,
when I run the old version of hive, it doesn't see the tables created
with the new version.  It seems that the new and the old hive binary
are using two separate databases.  In hive-default.xml for both
versions I have
	<property>
	  <name>javax.jdo.option.ConnectionURL</name>
	 
<value>jdbc:derby:;databaseName=metastore_db;create=true</value>

Can anyone tell me how to make the two versions of hive use the same
metastore database?... or at least how to import my old tables into
the metastore db for the new hive version?

Thanks,
--Leo
Created: (HIVE-1465) hive-site.xml ${user.name} not replaced for local-file derby metastore connecti
hive-site.xml ${user.name} not replaced for local-file derby metastore
connection URL
Created: (HIVE-1539) Concurrent metastore threading problem
Concurrent metastore threading problem