[JBoss-user] [Installation & Configuration] - Re: JBoss, SQL Server, EJB problem

2004-11-04 Thread tfrith 
I figured out the problem.

I wasn't reading the stack trace closely enough at first.

The problem was that /server/default/conf/standardjbosscmp-jdbc.xml was missing 
the "mssql-get-generated-keys" entity-command:

 

It's needed to retrieve PKs that are generated by sql server's IDENTITY columns when 
new records are created and my EJBs require it.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853964#3853964

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853964


---
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Installation & Configuration] - Re: JBoss, SQL Server, EJB problem

2004-11-04 Thread tfrith 
I did double-check the driver jars - they are there.

Here's some more info:
I deployed the app successfully using the same db backup & ear file as on my dev box.
I double checked that all the server jars in \lib & server\default\lib are the same as 
the jars on our working dev boxes.
I added a new servlet to the ear that retrieved a db connection (using the same JNDI 
name & datasource that our ejbs use), 
queried the db (using plain jdbc) and printed out the result.
This worked fine so this proves our database/datasource/jdbc drivers are setup 
properly.
 
On startup, our app retrieves a db record using a local cmp, called from a remote 
session bean.
The error occurs when the cmp is called so we suspect the error is related to a 
descriptor or the entity container.

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853951#3853951

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853951


---
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Installation & Configuration] - JBoss, SQL Server, EJB problem

2004-11-02 Thread tfrith 
I'm using SQL Server 2000, JBoss 3.2.1, and the microsoft jdbc driver.
On my development machine (Win XP pro) the app works fine.
On the server (Win server 2003 small bus edition) I get exceptions deploying the EJBs 
(see stack trace below).

The database port (1433) is open and I've confirmed sql server is listening on it. Sql 
server log does not show any connection attempts (failed or successful). I've 
double-checked database name, user, password, jndi name.  The user can log into the 
database successfully via MS Query Analyzer.
Any ideas?

My mssql-ds.xml file looks like this:

  | Marketing
  | 
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=marketing
  | com.microsoft.jdbc.sqlserver.SQLServerDriver
  | myUserName
  | myPassword
  | 

>From the system.log:
2004-11-02 18:02:13,843 ERROR [org.jboss.ejb.EntityContainer] Starting failed
  | org.jboss.deployment.DeploymentException: Could not load class: 
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityCommandMetaData.(JDBCEntityCommandMetaData.java:61)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:699)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:303)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:737)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:430)
  | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:372)
  | at 
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)
  | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:339)
  | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
  | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
  | at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
  | at $Proxy11.start(Unknown Source)
  | at org.jboss.system.ServiceController.start(ServiceController.java:392)
  | at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
  | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | at $Proxy22.start(Unknown Source)
  | at org.jboss.ejb.EjbModule.startService(EjbModule.java:329)
  | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
  | at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
  | at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
  | at $Proxy11.start(Unknown Source)
  | at org.jboss.system.ServiceController.start(ServiceController.java:392)
  | at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
  | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
  | at $Proxy19.start(Unknown Source)
  | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:540)
  | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
  | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:824)
  | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
  | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
  | at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
  | at org.jboss.mx.util.MBeanPr

[JBoss-user] [Datasource Configuration] - Retrieving CMP datasource at runtime

2004-02-25 Thread tfrith 
JBoss 3.2.1, CMP 2.0

My CMP datasource is set in the defaults section of jbosscmp-jdbc.xml.

How can I retrieve the value of the datasource setting at runtime? (or any other 
defaults defined here, for that matter).

I'd like to use the same one for some BMPs but not have to change it anywhere except 
in the one xml file.

A little code snippet showing how to get this value from within my app would be 
appreciated.

Tim

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3823010#3823010

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3823010


---
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user