Hey before we move on with this... did you configure the jboss.xml to point
to your database? Please refer to the documentation online for this.
If you have configured it properly and the CMP engine can't find your pool
then let us know.
You can also define the MS=SQL server as the default pool, will make your
life easier, remove everyone else.
marc
|-----Original Message-----
|From: [EMAIL PROTECTED]
|[mailto:[EMAIL PROTECTED]]On Behalf Of Olivier Doucet
|Sent: Wednesday, December 20, 2000 7:18 AM
|To: [EMAIL PROTECTED]
|Subject: [jBoss-User] Connecting JBoss and MS SQL Server
|
|
|Hello,
|
|I am currently trying to adapt EJB's developped under J2EE to JBoss. I
|simply copy the ear file to the deploy directory. The beans get deployed
|fine, except for the database configuration.
|
|Under J2EE, I am working with a MS SQLServer database referenced
|in the JNDI
|as jdbc/SQLServer.
|I configured my driver under the jboss.conf, jboss.jcml and
|jboss.properties. Each time a database name is request I type
|jdbc/SQLServer.
|
|The database pool is initalized correctly. I get the following messages :
|[jdbc/SQLServer] Initializing
|[jdbc/SQLServer] Initialized
|and a bit later
|[jdbc/SQLServer] Starting
|[jdbc/SQLServer] XA Connection pool jdbc/SQLServer bound to
|java:/jdbc/SQLServer
|[jdbc/SQLServer] Started
|
|When I try to use the database, the container keeps finding the default
|datasource. For BMP I resolved the problem by setting up the default Data
|Source to my MSSQL database.
|But when I try to start CMP, the database is not found.
|
|So here are my questions :
| - From the log you can see, what is the JNDI name stored by Jboss
|(jdbc/SQLServer or java:/jdbc/SQLServer) ?
| - How can I get the list of name known by the server ?
| - How are database connection handled by JBoss ? It seams
|that there is a
|default data source for BMP (where is it defined ?) and not fot CMP.
|
|Can someone help me ?
|
|Thanks
|
|Olivier Doucet
|
|
|--
|--------------------------------------------------------------
|To subscribe: [EMAIL PROTECTED]
|To unsubscribe: [EMAIL PROTECTED]
|List Help?: [EMAIL PROTECTED]
|
|
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
