Forum/Форум для новичков[JAVA]/[error] гс и лс серверы пишут ошибку баз

[error] гс и лс серверы пишут ошибку баз

7 replies79 viewsCurrently viewing: 1

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 03:59 PM

Поставил сервер, пытаюсь включить логин сервер, пишет ошибку. В чем проблема?

логин сервер:
<script type='text/javascript'>
mytagid = Math.floor( Math.random() * 100 );
document.write("

» Нажмите, чтобы показать текст - нажмите опять, чтобы скрыть... «

Factory(LocalSessionFactoryBean.java:816)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:734)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1333)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:217)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:381)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:93)
at net.l2emuproject.L2Registry.loadRegistry(L2Registry.java:63)
at net.l2emuproject.loginserver.L2LoginServer.<init>(L2LoginServer.java:
124)
at net.l2emuproject.loginserver.L2LoginServer.main(L2LoginServer.java:79
)

WARN : SQL Error: 0, SQLState: 08001
ERROR : No suitable driver
WARN : Could not obtain connection metadata java.sql.SQLException: No suitable d
river
at java.sql.DriverManager.getDriver(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1298)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSession
Factory(LocalSessionFactoryBean.java:816)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessi
onFactory(LocalSessionFactoryBean.java:734)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPr
opertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.initializeBean(AbstractAutowireCapableBeanFactory.java:1333)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getOb
ject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistr
y.getSingleton(DefaultSingletonBeanRegistry.java:217)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBe
an(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean
(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finish
BeanFactoryInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refres
h(AbstractApplicationContext.java:381)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<i
nit>(ClassPathXmlApplicationContext.java:93)
at net.l2emuproject.L2Registry.loadRegistry(L2Registry.java:63)
at net.l2emuproject.loginserver.L2LoginServer.<init>(L2LoginServer.java:
124)
at net.l2emuproject.loginserver.L2LoginServer.main(L2LoginServer.java:79
)

INFO : Loaded 127 server names
INFO : ..................................................
INFO : System Time: 18-02-2009 06:26:42 PM
INFO : ..................................................
INFO : OS: Windows XP Build: 5.1
INFO : OS Arch: x86
INFO : ..................................................
INFO : ..................................................
INFO : Avaible CPU(s): 2
INFO : Processor(s) Identifier: x86 Family 15 Model 6 Stepping 5, GenuineIntel

INFO : ..................................................
INFO : ..................................................
INFO : Runtime Information
INFO : Current Free Heap Size: 1 mb
INFO : Current Heap Size: 4 mb
INFO : Maximum Heap Size: 63 mb
INFO : ..................................................
INFO : ..................................................
INFO : Java Platform Information
INFO : Java Runtime Name: Java™ SE Runtime Environment
INFO : Java Version: 1.6.0_05
INFO : Java Class Version: 50.0
INFO : ..................................................
INFO : ..................................................
INFO : Virtual Machine Information (JVM)
INFO : JVM Name: Java HotSpot™ Client VM
INFO : JVM installation directory: C:\Program Files\Java\jre1.6.0_05
INFO : JVM version: 10.0-b19
INFO : JVM Vendor: Sun Microsystems Inc.
INFO : JVM Info: mixed mode, sharing
INFO : ..................................................
INFO : ..................................................
INFO : LoginManager initiating
INFO : Cached 10 KeyPairs for RSA communication
INFO : Stored 20 keys for Blowfish communication
WARN : Could not load driverClass com.mysql.jdbc.Driver java.lang.ClassNotFoundE
xception: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver
ManagerDataSource.java:100)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:117)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:377)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:263)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at net.l2emuproject.loginserver.services.GameserversServices$$EnhancerBy
CGLIB$$e0caac56.getAllGameservers(<generated>)
at net.l2emuproject.loginserver.manager.GameServerManager.load(GameServe
rManager.java:208)
at net.l2emuproject.loginserver.manager.GameServerManager.<init>(GameSer
verManager.java:112)
at net.l2emuproject.loginserver.manager.GameServerManager.getInstance(Ga
meServerManager.java:81)
at net.l2emuproject.loginserver.L2LoginServer.<init>(L2LoginServer.java:
137)
at net.l2emuproject.loginserver.L2LoginServer.main(L2LoginServer.java:79
)

WARN : SQL Error: 0, SQLState: 08001
ERROR : No suitable driver
WARN : SQL Error: 0, SQLState: 08001
ERROR : No suitable driver
Exception in thread "main" org.springframework.transaction.CannotCreateTransacti
onException: Could not open Hibernate Session for transaction; nested exception
is org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:550)
at org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.getTransaction(AbstractPlatformTransactionManager.java:377)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:263)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:101)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:635)
at net.l2emuproject.loginserver.services.GameserversServices$$EnhancerBy
CGLIB$$e0caac56.getAllGameservers(<generated>)
at net.l2emuproject.loginserver.manager.GameServerManager.load(GameServe
rManager.java:208)
at net.l2emuproject.loginserver.manager.GameServerManager.<init>(GameSer
verManager.java:112)
at net.l2emuproject.loginserver.manager.GameServerManager.getInstance(Ga
meServerManager.java:81)
at net.l2emuproject.loginserver.L2LoginServer.<init>(L2LoginServer.java:
137)
at net.l2emuproject.loginserver.L2LoginServer.main(L2LoginServer.java:79
)
Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connecti
on
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.
java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:
57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326
)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegi
n(HibernateTransactionManager.java:509)
... 11 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataS
ource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag
erDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti
on(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.
getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager
.java:423)
... 16 more

LoginServer terminated abnormaly

LoginServer terminated

Для продолжения нажмите любую клавишу . . .
скрыть

");
document.close();

PS Ява последняя, также пробовл на нескольких веб серверах

4ybais

User

Бывалый

Posts: 114

На форуме с: 07/03/2008

Репутация: +99

Рейтинг: 0

· 02/18/2009, 04:02 PM

А ты настроил конфиги?

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:04 PM

ну да:
PS база l2db, логин root пароль root

# ================== #========================#
# L2EMU PROJECT PACK # Network Configuration #
# ================== #========================#

# ================================================================================
================= #
# This is the network configuration file. Here you can set up the connection for your Loginserver. #
# Usually you have to change the LoginServerHostName option to #
# - 127.0.0.1 (if you want to play alone / testing purpose) #
# - LAN IP* (if you want to play from another computer in the network) #
# - WAN IP** (if you want to play with friends over internet) #
# - Support => http://www.l2emu.net #
# - If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig" #
# - If you want to get you WAN IP, visit http://www.whatismyip.com or www.showip.com #
# ================================================================================
================= #

# ==========
# Connection
# ==========

# Bind ip of the loginserver, use 0.0.0.0 to bind on all available IPs
LoginServerHostName = 127.0.0.1
LoginServerPort = 2106

# The port, ip on which login will listen for GameServers
LoginPort = 9014
LoginHostName = 127.0.0.1

# The delay between IP Update Time.
# set this delay in minutes after which the login updates the gameservers IP's
# (usefull when ip is dynamic)
# (0 = disabled) in Minutes
IpUpdateTime = 10

# Telnet is disabled by default.
EnableTelnet = false

# ============
# Port Related
# ============
# This is the port telnet server will bind to
StatusPort = 12345

# ============
# Pass Related
# ============
# If the following is not set, a random password is generated on server startup.
# StatusPW = somePass

# =====
# Hosts
# =====
# This list can contain IPs or Hosts of clients you wish to allow.
# Hosts must be resolvable to an IP.
# The format is as follows:
# ListOfHosts = 0.0.0.0,host,0.0.0.1,host2,host3,host4,0.0.0.3
# Make sure there are no spaces between hosts/ips
ListOfHosts = 127.0.0.1,localhost

# --------------------
# Database Information
# --------------------

# Define MySQL Driver
Driver = com.mysql.jdbc.Driver

# here you have some more drivers:
# Driver = org.hsqldb.jdbcDriver
# Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

# Define MySQL Driver URL.
URL = jdbc:mysql://localhost/l2db

# here you have some more urls:
# URL = jdbc:hsqldb:hsql://localhost/L2Emu_DB
# URL = jdbc:sqlserver://localhost/database = L2Emu_DB/user = sa /password = (your pass)

# Your login to Database (default = root)
Login = root

# Your password to database (default = root)
Password = root

# Define how many connections are allowed on your database.
MaximumDbConnections = 10

dddd

User

Новичок

Posts: 24

На форуме с: 01/18/2009

Репутация: +2

Рейтинг: 0

· 02/18/2009, 04:18 PM

ты базу точно залил правильно???

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:21 PM

да, ошибок не выдало

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:53 PM

гейм сервер запускается, значит ошибка не в яве. А еще у кого с этой сборкой проблемы были?

ki11er

Author

Новичок

Posts: 10

На форуме с: 12/23/2008

Рейтинг: 0

· 02/18/2009, 06:20 PM

у ему по умолчание база L2emu_db залей в нее все и будет ок

Topic is closed for replies

Forum/Форум для новичков[JAVA]/[error] гс и лс серверы пишут ошибку баз

[error] гс и лс серверы пишут ошибку баз

7 replies79 viewsCurrently viewing: 1

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 03:59 PM

» Нажмите, чтобы показать текст - нажмите опять, чтобы скрыть... «

");
document.close();

PS Ява последняя, также пробовл на нескольких веб серверах

4ybais

User

Бывалый

Posts: 114

На форуме с: 07/03/2008

Репутация: +99

Рейтинг: 0

· 02/18/2009, 04:02 PM

А ты настроил конфиги?

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:04 PM

dddd

User

Новичок

Posts: 24

На форуме с: 01/18/2009

Репутация: +2

Рейтинг: 0

· 02/18/2009, 04:18 PM

ты базу точно залил правильно???

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:21 PM

да, ошибок не выдало

vaansk

Author

Новичок

Posts: 5

На форуме с: 02/18/2009

Рейтинг: 0

· 02/18/2009, 04:53 PM

гейм сервер запускается, значит ошибка не в яве. А еще у кого с этой сборкой проблемы были?

ki11er

Author

Новичок

Posts: 10

На форуме с: 12/23/2008

Рейтинг: 0

· 02/18/2009, 06:20 PM

у ему по умолчание база L2emu_db залей в нее все и будет ок

Topic is closed for replies