ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | architecture List | November 2005 Index

<--  Date Index  --> <--  Thread Index  -->

runnnig the eb example with Mysql


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  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.