Ответов

[rojkovalex]

Помогите разобраться с проблемой. Прописал под старую базу сервера сборку той же команды ,но более свежую версию. И теперь выскакивает ошибка при подключении клиента под старым логином следущего содержания:
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts0_.lastServerId' in 'field list'
WARN : The account [бла-бла-бла] was not found in account table.could not load an
entity: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла]
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts_.lastServerId' in 'field list'
Exception in thread "pool-1-thread-2" org.hibernate.exception.SQLGrammarExceptio
n: could not retrieve snapshot: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла
]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1052)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(S
tatefulPersistenceContext.java:246)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abst
ractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at com.l2emu.loginserver.dao.impl.BaseRootDAOHib.saveOrUpdate(BaseRootDA
OHib.java:85)
at com.l2emu.loginserver.dao.impl.AccountsDAOHib.createOrUpdate(Accounts
DAOHib.java:70)
at com.l2emu.loginserver.services.AccountsServices.addOrUpdateAccount(Ac
countsServices.java:124)
at com.l2emu.loginserver.services.AccountsServices$$FastClassByCGLIB$$1a
3f8ebe.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at com.l2emu.loginserver.services.AccountsServices$$EnhancerByCGLIB$$166
916b.addOrUpdateAccount(<generated>)
at com.l2emu.loginserver.manager.LoginManager.handleAccountNotFound(Logi
nManager.java:654)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:531)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:495)
at com.l2emu.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.
java:294)
at com.l2emu.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthL
ogin.java:122)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'accounts_.lastServerId' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1885)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1025)
... 27 more
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts0_.lastServerId' in 'field list'
WARN : The account [бла-бла-бла2] was not found in account table.could not load a
n entity: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла2]
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts_.lastServerId' in 'field list'
Exception in thread "pool-1-thread-5" org.hibernate.exception.SQLGrammarExceptio
n: could not retrieve snapshot: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла
2]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1052)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(S
tatefulPersistenceContext.java:246)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abst
ractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at com.l2emu.loginserver.dao.impl.BaseRootDAOHib.saveOrUpdate(BaseRootDA
OHib.java:85)
at com.l2emu.loginserver.dao.impl.AccountsDAOHib.createOrUpdate(Accounts
DAOHib.java:70)
at com.l2emu.loginserver.services.AccountsServices.addOrUpdateAccount(Ac
countsServices.java:124)
at com.l2emu.loginserver.services.AccountsServices$$FastClassByCGLIB$$1a
3f8ebe.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at com.l2emu.loginserver.services.AccountsServices$$EnhancerByCGLIB$$166
916b.addOrUpdateAccount(<generated>)
at com.l2emu.loginserver.manager.LoginManager.handleAccountNotFound(Logi
nManager.java:654)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:531)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:495)
at com.l2emu.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.
java:294)
at com.l2emu.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthL
ogin.java:122)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'accounts_.lastServerId' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1885)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1025)
... 27 more
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts0_.lastServerId' in 'field list'
WARN : The account [бла-бла-бла2] was not found in account table.could not load a
n entity: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла2]
WARN : SQL Error: 1054, SQLState: 42S22
ERROR : Unknown column 'accounts_.lastServerId' in 'field list'
Exception in thread "pool-1-thread-3" org.hibernate.exception.SQLGrammarExceptio
n: could not retrieve snapshot: [com.l2emu.loginserver.beans.Accounts#бла-бла-бла
2]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1052)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(S
tatefulPersistenceContext.java:246)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abst
ractSaveEventListener.java:512)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveO
rUpdate(DefaultSaveOrUpdateEventListener.java:80)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpda
te(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
at com.l2emu.loginserver.dao.impl.BaseRootDAOHib.saveOrUpdate(BaseRootDA
OHib.java:85)
at com.l2emu.loginserver.dao.impl.AccountsDAOHib.createOrUpdate(Accounts
DAOHib.java:70)
at com.l2emu.loginserver.services.AccountsServices.addOrUpdateAccount(Ac
countsServices.java:124)
at com.l2emu.loginserver.services.AccountsServices$$FastClassByCGLIB$$1a
3f8ebe.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at com.l2emu.loginserver.services.AccountsServices$$EnhancerByCGLIB$$166
916b.addOrUpdateAccount(<generated>)
at com.l2emu.loginserver.manager.LoginManager.handleAccountNotFound(Logi
nManager.java:654)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:531)
at com.l2emu.loginserver.manager.LoginManager.loginValid(LoginManager.ja
va:495)
at com.l2emu.loginserver.manager.LoginManager.tryAuthLogin(LoginManager.
java:294)
at com.l2emu.loginserver.clientpackets.RequestAuthLogin.run(RequestAuthL
ogin.java:122)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown co
lumn 'accounts_.lastServerId' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1885)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSna
pshot(AbstractEntityPersister.java:1025)
... 27 more

[rojkovalex]

Спасибо, разобрался, вопрос снимаю.