Mail Archive Home | architecture List | November 2005 Index
| <-- Date Index --> | <-- Thread Index --> |
Hello My name is Claudio Im from Argentina and Im new to Jonas.
I began, learning Jonas a week ago and I have it now installed. I was trying
to run the eb example to test the Mysql connection with Jonas but I hava some
problems when I try to run the example I dont know if it is the database
configuration or something else.
This is the way I have configured Mysql on the Jonas.properties file
jonas.service.dbm.datasource Mysql
#######################MYSQL###############MYSQL################MYSQL#################MYSQL
###################### MySQL DataSource configuration example
#
datasource.name jdbc_1
datasource.url jdbc:mysql://localhost/test
datasource.classname org.gjt.mm.mysql.Driver
datasource.username jonas
datasource.password jonas
datasource.mapper rdb.mysql
#####
# ConnectionManager configuration
#
# JDBC connection checking level.
# 0 = no special checking
# 1 = check physical connection is still open before reusing it
# 2 = try every connection before reusing it
jdbc.connchecklevel 0
# Max age for jdbc connections
# nb of minutes a connection can be kept in the pool
# By default mySQL has a timeout every 8 hours, use a value of 7h
jdbc.connmaxage 420
# Maximum time (in mn) a connection can be left busy.
# If the caller has not issued a close() during this time, the connection
# will be closed automatically.
jdbc.maxopentime 60
# Test statement
jdbc.connteststmt select 1
# JDBC Connection Pool size.
# Limiting the max pool size avoids errors from database.
jdbc.minconpool 10
jdbc.maxconpool 30
# Sampling period for JDBC monitoring :
# nb of seconds between 2 measures.
jdbc.samplingperiod 30
# Maximum time (in seconds) to wait for a connection in case of shortage.
# This may occur only when maxconpool is reached.
jdbc.maxwaittime 5
# Maximum of concurrent waiters for a JDBC Connection
# This may occur only when maxconpool is reached.
jdbc.maxwaiters 100
######################################################################
When I try to run the eb example I got this error
JonasAccountImpl_408171955Bean.ejbFindAllAccounts : Failed to find beans from
database in ejbFindAllAccounts
java.sql.SQLException: Table not foung in statement [select accno_ from
accountsample_]
at org.hsqldb.jdbc.Util.throwError (Unknown Source)
.......
By the way the table in the database is created and funtioning well
use test;
create table accountsample_ (
accno_ integer primary key,
customer_ varchar(30),
balance_ numeric(15, 4)
);
insert into accountsample_ values(101, 'Antoine de St Exupery', 200.00);
insert into accountsample_ values(102, 'alexandre dumas fils', 400.00);
insert into accountsample_ values(103, 'conan doyle', 500.00);
insert into accountsample_ values(104, 'alfred de musset', 100.00);
insert into accountsample_ values(105, 'phileas lebegue', 350.00);
insert into accountsample_ values(106, 'alphonse de lamartine', 650.00);
I really hope you can help me out
Thanks on advance
Claudio Veas
| <-- Date Index --> | <-- Thread Index --> |
Powered by MHonArc.
Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.