Failed ! First run with OJB

Ken Hu <[email protected]>
Newsgroups gmane.comp.jakarta.ojb.user
Message-ID <[email protected]>
Dear All:

I am a newbie to Apache OJB.
I dowload the binary package and some tutorials then I start to give it
a try.
Extract the contents from Tutorial2 and then put them to
ojb-blank/src/java, the build is fine.

The database information stored in build.properties are:

jcdAlias=default
databaseName=test
databaseUser=ctu
databasePassword=ta1hs1ung
.............
............
# For MySQL this would look like:
dbmsName=MySQL
jdbcLevel=3.0
jdbcRuntimeDriver=com.mysql.jdbc.Driver
urlProtocol=jdbc
urlSubprotocol=mysql
urlDbalias=//192.168.2.202/${databaseName}

When I execute the Application.class , I got :

Welcome to the OJB ODMG tutorial application


[0] List all product entries
[1] Enter a new product
[2] Edit a product entry
[3] Delete a product entry
[4] Quit Application
type in number to select a use case

Then I input 0 to list all stored prodcuts , but I got the folowing
errors:

================================================================================================
 Could not borrow connection from pool. Active/Idle instances in
pool=0/0. org.apache.ojb.broker.metadata.JdbcConnectionDescriptor:
org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1a42792[
  jcd-alias=default
  default-connection=false
  dbms=MySQL
  jdbc-level=3.0
  driver=com.mysql.jdbc.Driver
  protocol=jdbc
  sub-protocol=mysql
  db-alias=//192.168.2.202/test
  user=sa
  password=*****
  eager-release=false
  ConnectionPoolDescriptor={removeAbandonedTimeout=300,
testWhileIdle=false, logAbandoned=false, testOnReturn=false,
timeBetweenEvictionRunsMillis=-1, minIdle=0, numTestsPerEvictionRun=10,
removeAbandoned=false, maxIdle=-1, fetchSize=0, whenExhaustedAction=0,
minEvictableIdleTimeMillis=600000, testOnBorrow=true, maxActive=30,
maxWait=10000}
  batchMode=false
  useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
  ignoreAutoCommitExceptions=false

sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@12a55aa[
     sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
     Properties={grabSize=20, autoNaming=true, seq.start=200000}
]
]
        at
org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl.checkOutJdbcConnection(Unknown Source)
        at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.lookupConnection(Unknown Source)
        at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Unknown Source)
        ... 16 more
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Error
getting Connection from DriverManager with url
(jdbc:mysql://192.168.2.202/test) and driver (com.mysql.jdbc.Driver)
        at
org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.newConnectionFromDriverManager(Unknown Source)
        at org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
$ConPoolFactory.makeObject(Unknown Source)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
        ... 19 more
Caused by: java.sql.SQLException: Access denied for user:
'sa@sqlserver' (Using password: NO)
================================================================================================

Well , I think I have speicified the correct username and password in
build.properties, I don't know  why it still use sa@sqlserver as
username to get a connection . 
Does anyone have the similar experience with me ?
Please give me some help , thanks !

Ken

-- 
潮             ⊿憡             Ken Hu          [email protected]

摮舐€∩遢砍
http://www.mmti.com.tw

啣€: 擃撣802€銝剜迤銝€頝1204F-7
餉店: 07-7279337 璈: 120
喟: 07-7279377
銵: 0937083880
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.