Re: Failed ! First run with OJB

I suppose you have problem with privileges:

Caused by: java.sql.SQLException: Access denied for user:
'sa@sqlserver' (Using password: NO)

Try to connect to the database using plain JDBC to see if your
connection parameters are OK.

Ozkan

Ken Hu wrote:
> 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
>
>