[JBoss-user] [EJB/JBoss] - Re: 4.0.x classloader NoClassDefFoundException

2005-03-07 Thread abcolson
I found my problem.  Recall the initial error was 
java.lang.NoClassDefFoundError: epi/projects/ComplianceProjectParticipantDTO

This was very misleading because it had me chasing ghosts such as class loader 
issues.  The real problem was that this class used a third party interface 
(DTO) that was not in the java class path for JBoss. 

(See http://www.jboss.org/index.html?module=bb&op=viewtopic&t=51103)

Once I put the third party jar with the DTO interface under the lib directory 
for my JBoss deployment things worked fine.

BTW, I tested with JBoss versions 4.0.0RC2 and  4.0.1sp1, so it would appear 
that my problem had nothing to do with the above mentioned class loader issues 
with 4.0.0.

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

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


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [EJB/JBoss] - Re: 4.0.x classloader NoClassDefFoundException

2005-03-04 Thread abcolson
Same errors in JBoss version 3.2.6.

BTW, the only differences ( from "jar tf") between the "bad" jar and one that 
works is the presence of the DTO classes in the bad jar (about 6) as noted 
previously in my first post.

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

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


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [EJB/JBoss] - Re: 4.0.x classloader NoClassDefFoundException

2005-03-04 Thread abcolson
Latest update...

I get the same errors with jboss-4.0.1sp1.

As stated previously by jjmuhlestein maybe the class loading scheme will be 
fixed in the next release.

Does anybody know when the next release will be?

Anything we can do in the mean time?

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

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


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [EJB/JBoss] - Re: 4.0.x classloader NoClassDefFoundException

2005-03-04 Thread abcolson
I have a simplified version of the same problem.  Using JBoss 4.0.0RC2 I have 

app.ear
Â|__ app-ejb.jar
   |__epi/projects/ComplianceProjectParticipantDTO.class
Â|__epi/projects/cmp/ComplianceProjectParticipant.class

The error is

anonymous wrote :  WARN  [EJBDeployer] Verify failed; continuing
  | java.lang.NoClassDefFoundError: epi/projects/ComplianceProjectParticipantDTO

The class is there plain for everybody to see, not even buried in a sub jar as 
in the original post.

Here is some background...

Originally the app deployed fine.  I decided to add DTOs (Data Transfer 
Objects/EJB View objects).  Each EJB has a corresponding DTO class which 
mirrors the data methods but doesn't have the EJB functionality.  Hence each 
EJB has getData()/setData() methods which utilizes its DTO counterpart.

Perhaps of curious note is that the EJB and its DTO are not in the same package 
(see above), but I don't know why this should matter.

I haven't yet tried any of the less desirable work-arounds; I was hoping the 
problem was fixed but noone posted the solution yet.

Any input is appreciated.

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

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


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Data Type Mapping

2005-01-05 Thread abcolson
Here is a new twist.

The reason my java.lang.String gets mapped to VARCHAR(256) and not VARCHAR(255) 
is because of some sort of Hypersonic dependancy, i.e. JBoss is pulling 
VARCHAR(256) mapping from the Hypersonic mappings instead of VARCHAR(255) from 
the MS ACCESS mapping.

Example:

1) I removed all the type-mapping elements from standardjbosscmp-jdbc.xml 
except for MS ACCESS...the result was a burp when JBoss tried to create my 
complianceproject table upon startup which complained about Hypersonic errors.

2) I then added back in the Hypersonic type-mapping into 
standardjbosscmp-jdbc.xml and changed the java.lang.String mapping from 
VARCHAR(256) to VARCHAR(255)...the table was created fine.

The question of the day is:  Why is this happening?

Where else does JBoss get db mapping information from?  I removed 
standardjaws.xml  (What is this for anyways?) from the conf directory and my 
table was still created fine. 

Any insight is appreciated.
Tony



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

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


---
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almosthttp://www.thinkgeek.com/sfshirt
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Data Type Mapping

2005-01-04 Thread abcolson
Greetings List,

I am using jboss-4.0.0RC2 with MS Access.  I had to create my own mappings in 
standardjbosscmp-jdbc.xml (If anyone knows of one that already exists that may 
solve alot of my problems).

In the type mapping I have the defaults set up as 


  | 
  |
  |   java:/DefaultDS
  |   MS ACCESS
  | 
  |   true
  |   false
  |   false
  |   30
  |   false
  |   true
  |   false
  |   foreign-key
  |   
  |  on-load
  |  1000
  |  *
  |   
  |   1000
  |   false
  | 
  |   
  |  
UUIDKeyGeneratorFactory
  |  java.lang.String
  |  VARCHAR
  |  VARCHAR(32)
  |   
  | 
  |   
  |   
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler
  |
  | 

and in the type mapping section I have

  
  |  MS ACCESS
  | .
  | .
  | .
  |  
  | java.lang.String
  | VARCHAR
  | VARCHAR(255)
  |  
  | .
  | .
  |   
  | 

Additionally, my msaccess-ds.xml file is

anonymous wrote : 
  |   
  | DefaultDS
  | 
  | 
  | jdbc:odbc:EpidemiologyWebData
  | 
  | 
  | 
  | 
  | sun.jdbc.odbc.JdbcOdbcDriver
  | 
  | 
  | 
  |   
  | 
  |   
  |   
  | MS ACCESS
  |   
  | 
  | 
  | 

Upon startup I get the following error

anonymous wrote : 18:31:48,640 ERROR [EntityContainer] Starting failed 
jboss.j2ee:jndiName=ejb/UserLocal,service=EJB
  | org.jboss.deployment.DeploymentException: Error while creating table 
complianceproject; - nested throwable: (java.sql.SQLException: [Microsoft][ODBC 
Microsoft Access Driver] Size of field 'name' is too long.)
  | 

Looking in the odbc log I see

anonymous wrote : tools.jar org.j e7c-878   EXIT  SQLExecDirect  with 
return code -1 (SQL_ERROR)
  | HSTMT   04F42960
  | UCHAR * 0x03F31410 [  -3] "CREATE TABLE 
complianceproject (name VARCHAR(256), deadline TIMESTAMP, instructions 
VARCHAR(256))\ 0"
  | SDWORD-3
  | 
  | DIAG [37000] [Microsoft][ODBC Microsoft Access Driver] Size of 
field 'name' is too long. (-1506) 
  | 
  | 
  | 

My question is why is this happening?  It appears that I have set the max to be 
255.  Where else could the 256 be coming from?

Thanks
Tony

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

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


---
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almosthttp://www.thinkgeek.com/sfshirt
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: BUG: Bean Deployment Exception

2004-12-28 Thread abcolson
Hi Alex,

Yes, I downloaded the source and tracked it down to a SQL problem but it looks 
fine.  In my test servlet I only use the User ejb (although I have defined a 
few others, one of which has a relation with User).

Here is the relevant data:

Stack Trace:

anonymous wrote : java.lang.IllegalStateException: 
createBeanClassInstanceCommand == null
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createBeanClassInstance(JDBCStoreManager.java:570)
  | at 
org.jboss.ejb.plugins.CMPPersistenceManager.createBeanClassInstance(CMPPersistenceManager.java:124)
  | at 
org.jboss.ejb.EntityContainer.createBeanClassInstance(EntityContainer.java:224)
  | at 
org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java:146)
  | at 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:96)
  | at 
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
  | at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
  | at 
org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:41)
  | at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:109)
  | at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
  | at 
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:129)
  | at 
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:106)
  | at 
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
  | at 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
  | at 
org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:508)
  | at org.jboss.ejb.Container.invoke(Container.java:881)
  | at 
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:342)
  | at 
org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:118)
  | at $Proxy112.findAll(Unknown Source)
  | 

The ejb-jar.xml entry is

 
  | 
  |findAll
  |
  |
  | 
  | ![CDATA[SELECT DISTINCT OBJECT(t) FROM User t]]
  |  
  | 
(The defined attributes match exactly the field definitions, all text and a 
long int for the primary key).

The jbosscmp-jdbc.xml file includes

  
  |  User
  |  true
  |  true
  |  false
  |  true
  |  user
  | 
  |  
  | id
  | id
  | 
  | 
  |  
  | firstName
  | firstName
  | 
  | 
  |  
  | lastName
  | lastName
  | 
  | 
  |  
  | email
  | email
  | 
  | 
  |  
  | phone
  | phone
  | 
  | 
  |  
  | tieline
  | tieline
  | 
  | 
  |  
  | password
  | password
  | 
  | 
  |  
  | title
  | title
  | 
  | 
  |  
  | loginName
  | loginName
  | 
  | 
  | 
  |   
  | 

Additionally, I turned on trace logging and get the following:

anonymous wrote : 2004-12-28 08:57:23,125 TRACE 
[org.jboss.ejb.plugins.LogInterceptor] Start method=findAll
  | 2004-12-28 08:57:23,125 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
Current transaction in MI is null2004-12-28 08:57:23,125 TRACE 
[org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED for findAll timeout=0 
  | 2004-12-28 08:57:23,125 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
Thread came in with tx null
  | 2004-12-28 08:57:23,125 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
Starting new tx TransactionImpl:XidImpl[FormatId=257, GlobalId=LJ301825/5, 
BranchQual=, localId=5]
  | 2004-12-28 08:57:23,125 TRACE [org.jboss.ejb.plugins.EntityInstancePool] 
Get instance [EMAIL PROTECTED] epi.cmp.UserCMP
  | 2004-12-28 08:57:23,125 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
TxInterceptorCMT: In finally
  | 2004-12-28 08:57:23,125 ERROR [org.jboss.ejb.plugins.LogInterceptor] 
RuntimeException in method: public abstract java.util.Collection 
epi.cmp.UserLocalHome.findAll() throws javax.ejb.FinderException:
  | java.lang.IllegalStateException: createBeanClassInstanceCommand == null
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createBeanClassInstance(JDBCStoreManager.java:570)
  | at 
org.jboss.ejb.plugins.CMPPersistenceManager.createBeanClassInstance(CMPPersistenceManager.java:124)
  | at 
org.jboss.ejb.EntityContainer.createBeanClassInstance(EntityContainer.java:224)
  | at 
org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java:146)
  | at 
org.jboss.ejb.plugins.EntityInstanc

[JBoss-user] [Persistence & CMP/JBoss] - BUG: Bean Deployment Exception

2004-12-21 Thread abcolson
When deploying a bean I get the following exception in the log.  It looks like 
a deployment bug and does not give me a hint on what is wrong (if anything) 
with my setup or .ear.

I am using JBoss 4.0.0RC2 with MS Access.

Debugging hints would be appreciated.

Thanks
Tony

anonymous wrote : 
  | 2004-12-21 09:59:10,265 ERROR [org.jboss.ejb.EntityContainer] Starting 
failed jboss.j2ee:jndiName=ejb/FaqLocal,service=EJB
  | java.lang.StringIndexOutOfBoundsException: String index out of range: 0
  | at java.lang.String.charAt(String.java:444)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCFunctionMappingMetaData.initFromString(JDBCFunctionMappingMetaData.java:44)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCFunctionMappingMetaData.(JDBCFunctionMappingMetaData.java:29)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCTypeMappingMetaData.(JDBCTypeMappingMetaData.java:181)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:243)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:67)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:726)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:419)
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:363)
  | at 
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)
  | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
  | at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
  | at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
  | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:236)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  | at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:848)
  | at $Proxy0.start(Unknown Source)
  | at org.jboss.system.ServiceController.start(ServiceController.java:373)
  | 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.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:236)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  | at $Proxy65.start(Unknown Source)
  | at org.jboss.ejb.EjbModule.startService(EjbModule.java:394)
  | at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
  | at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
  | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  | at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  | at java.lang.reflect.Method.invoke(Method.java:324)
  | at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  | at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  | at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  | at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:236)
  | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  | at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:848)
  | at $Proxy0.start(Unknown Source)
  | at org.jboss.system.ServiceController.start(ServiceController.java:373)
  | 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.interceptor.ReflectedDispatcher.invoke(Re

[JBoss-user] [Messaging, JMS & JBossMQ] - Creating JMS_MESSAGES: Invalid SQL

2004-12-20 Thread abcolson
Hello Users,

I am using Jboss 4.0.0RC2 with an MS Access database.

Apparently Jboss does not provide the datatype mappings for MS Access so I have 
tried to create my own, which may be part of the problem.

Ths issue is when I start up JBoss I get the following error:

anonymous wrote : 2004-12-20 14:58:40,203 DEBUG 
[org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: 
CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION 
VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY 
KEY (MESSAGEID, DESTINATION) )
  | java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax 
error in CREATE TABLE statement.
  | 

When I try the exact sql in Access I do in fact get 2 errors:

1) Keyword "CACHED"
2) MESSAGEBLOB OBJECT

I put in a mapping changing OBJECT to OLEOBJECT.  However, I don't exactly know 
what to do about "CACHED"; I tried to map it to nothing via the 
function-mapping element.

After all this I still get the same error.

Question:

Should JBoss be using my mapped definitions for Access for these JMS 
transactions?  It doesn't appear that it does.

I also tried enabling the TRACE functionality in the log4j.xml file:

   
  |  
  |
  | 

to look at the transformed SQL according to my mappings; no dice.

I am wondering if I may have to physically modify the code in 
hsqldb-jdbc2-service.xml, but I don't like that idea.

Insights appreciated, and thank you.
Tony

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

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


---
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-12 Thread abcolson
Hi Alexey,

It worked.  The JBoss version 3.2.4RC1 does fix the quote problem and my database test 
application works as expected.

Thanks to all who helped me.

Alexey, email me at [EMAIL PROTECTED]  I have something I would like to tell you 
privately.

Cheers Everybody

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

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


---
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the
one installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-08 Thread abcolson
Hi Alexey,

Thanks alot.  I downloaded the HEAD branch of JBoss-3.2 from sourceforge (I assume 
this is correct) and verified that the SQLUtil.fixTableName() function has the fix for 
the quotes.

However, there appears to be an error with the build and I didn't see any 
documentation or a README file.  I know this is starting to get off topic so either I 
can post to another forum or if you like you could give me alternative contact 
information for yourself.

But quickly, it appears that the directories are not set up correctly.  Specifically, 
there seems to be a '-' character instead of a '\' character when looking for 
directories like apache-tomcat41, beanshell-beanshell, etc.  Granted I am only about 
beginner-intermediate with ant, but this seemed strange.  Here is the short log when I 
typed build.bat:


  | configure:
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
apache.tomcat41.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\apache-tomcat41 not 
found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
apache.tomcat50.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\apache-tomcat50 not 
found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
beanshell.beanshell.classpath: 
C:\jboss-3.2.4\jboss-3.2\thirdparty\beanshell-beanshell\lib not found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
jfreechart.jfreechart.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\jfreechart\lib 
not found.
  |  [echo] groups:  default
  |  [echo] modules: 
common,jmx,system,naming,aop,j2ee,remoting,transaction,server,security,messaging,connector,cluster,varia,webservice,iiop,management,cache,tomcat,console,compatibility,aspects,media
  | 
  | init:
  | 
  | _buildmagic:modules:most:
  | 
  | ==
  | ==  Executing 'most' in module 'common'...
  | ==
  | 
  | _buildmagic:init:
  | 
  | configure:
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
apache.tomcat41.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\apache-tomcat41 not 
found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
apache.tomcat50.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\apache-tomcat50 not 
found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
beanshell.beanshell.classpath: 
C:\jboss-3.2.4\jboss-3.2\thirdparty\beanshell-beanshell\lib not found.
  | Caught exception (org.apache.tools.ant.BuildException) while expanding 
jfreechart.jfreechart.classpath: C:\jboss-3.2.4\jboss-3.2\thirdparty\jfreechart\lib 
not found.
  | 
  | _default:task-init:
  | 
  | init:
  | 
  | _buildmagic:build-bypass-checker:
  | 
  | _buildmagic:build-bypass-notice:
  | 
  | _buildmagic:build-bypass-check:
  | 
  | jars:
  | 
  | _buildmagic:init:
  | 
  | init:
  | 
  | _buildmagic:mbean-bypass-checker:
  | 
  | _default:compile-mbean-sources:
  | 
  | BUILD FAILED
  | 
  | file:C:/jboss-3.2.4/jboss-3.2/common/../tools/etc/buildmagic/buildmagic.ent:439: 
taskdef class xdoclet.modules.jmx.JMXDocletTask cannot be found
  | at org.apache.tools.ant.taskdefs.Definer.addDefinition(Definer.java:236)
  | at org.apache.tools.ant.taskdefs.Definer.execute(Definer.java:162)
  | at org.apache.tools.ant.Task.perform(Task.java:341)
  | at org.apache.tools.ant.Target.execute(Target.java:309)
  | at org.apache.tools.ant.Target.performTasks(Target.java:336)
  | at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
  | at org.jboss.tools.buildmagic.task.CallTarget.execute(CallTarget.java:141)
  | at org.apache.tools.ant.Task.perform(Task.java:341)
  | at org.apache.tools.ant.Target.execute(Target.java:309)
  | at org.apache.tools.ant.Target.performTasks(Target.java:336)
  | at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
  | at org.jboss.tools.buildmagic.task.Ant.execute(Ant.java:261)
  | at 
org.jboss.tools.buildmagic.task.module.ExecuteModules$1.run(ExecuteModules.java:361)
  | at 
org.jboss.tools.buildmagic.task.module.ExecuteModules.executeModule(ExecuteModules.java:376)
  | at 
org.jboss.tools.buildmagic.task.module.ExecuteModules.execute(ExecuteModules.java:241)
  | at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:193)
  | at org.apache.tools.ant.Task.perform(Task.java:341)
  | at org.apache.tools.ant.Target.execute(Target.java:309)
  | at org.apache.tools.ant.Target.performTasks(Target.java:336)
  | at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
  | at org.apache.tools.ant.Project.executeTargets(Project.java:1255)
  | at org.apache.tools.ant.Main.runBuild(Main.java:609)
  | at org.apache.tools.ant.Main.start(Main.java:196)
  | at org.apache.tools.ant.Main.main(Main.java:235)
  | Caused by: java.lang.ClassNotFoundException: xdoclet.modules.jmx.JMXDocletTas

[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-07 Thread abcolson
Hi loubyansky,

Thanks for your input.  This is helpful.  2 questions:

1) What is the relationship between these 2 code segments (i.e. do they interact with 
each other)?

2) What approach do you suggest: a) Finding a better database driver, b) 
Download/Compile JBoss 3.2.4RC2?

I think option 2 seems to be the better choice, although more work.  I have used the 
PostgresQL drivers with other programs (i.e. dbadmin) and didn't have problems, so I 
am skeptical about finding a better driver.

Also, are you a JBoss developer?  You seem to be very knowledgable.  If so, do you 
know when 3.2.4 will be released with the fix?

Thanks
Tony

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

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


---
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-06 Thread abcolson
Hi loubyansky,

anonymous wrote : The lower case should not cause any problems as the driver must have 
supported it. This check is done in the org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.

I am u nclear as to what driver you are referring to: jboss driver or postgresql 
driver?

As a point of information, postgresql is case sensitive.  So, if jboss/cmp is casting 
data to lowercase, this is a problem.  And, it does appear to do this.  Consider the 
following debug trace:

2004-06-03 22:44:36,743 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
SQL: SELECT id FROM "questions" WHERE id=?

I think this is the actual SQL getting passed to PostgreSQL.  Maybe there is a cmp 
flag or some mechanism to instruct it not to do this.  I am currently researching this.

Do you have any further input or ideas?

Thanks
Tony




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

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


---
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-04 Thread abcolson
Hi loubyansky,

anonymous wrote : So you are missing jbosscmp-jdbc.xml?

Good Call!  For some reason this wasn't making it in.

I put it in and tried it and although it didn't work completely, the generated sql did 
in fact use the table name "questions" and not "question".

But, as you recall from previous posts, the table should be "Questions", with a big 
"Q".  For some reason, the table name gets converted to lower case.  I put quotes in 
the table name and the quotes do get incorporated into the sql statement, but it still 
gets converted to lower case.

I'll look into the case issue tomorrow and let you know.  If you know, please tell me 
how to do it.

Thanks
Tony



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

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


---
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-02 Thread abcolson
Hi loubyansky,

anonymous wrote : I have an imression that the deployment descriptors you post here 
are not used. How do you package the EJB JAR and what is its contents?

Interesting idea.  I hadn't thought of that.  Here is a breakdown

jar -tf FiboApp.ear
  | 
  | META-INF/
  | META-INF/MANIFEST.MF
  | META-INF/application.xml
  | FiboEJB.jar
  | FiboWeb.war


jar -tf FiboEJB.jar
  | 
  | META-INF/
  | META-INF/MANIFEST.MF
  | META-INF/ejb-jar.xml
  | META-INF/jboss.xml
  | tutorial/
  | tutorial/ejb/
  | tutorial/ejb/FiboBean.class
  | tutorial/ejb/QuestionBean.class
  | tutorial/ejb/QuestionCategoryBean.class
  | tutorial/interfaces/
  | tutorial/interfaces/Fibo.class
  | tutorial/interfaces/FiboHome.class
  | tutorial/interfaces/Question.class
  | tutorial/interfaces/QuestionCategory.class
  | tutorial/interfaces/QuestionCategoryHome.class
  | tutorial/interfaces/QuestionHome.class

META-INF/ejb-jar.xml looks fine.  I checked specifically the  
and it was as I changed it previously to "Questions".

Do you see anything wrong here?

Thanks
Tony



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

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


---
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-06-01 Thread abcolson
Well, I have some news, but I don't know how thrilled I am with it.

First, without changing anything WRT my Question bean and descriptors, nor without 
redeploying, I added a view in my database called "question" which maps to "Questions" 
and maps the fields like category_id to categoryid.

The result...it worked.

But it seems like a hack.  I just spent half the day cursing about Microsoft and now 
this.  There has to be something else we can do, especially since legacy database 
schemas will not always conform.  And with PostgreSQL, quotes are needed to 
distinguish not only spaces but case, like "Questions" from "questions".

Not to mention, BTW, that you can only read from a view, which, of course, is a 
problem.

In response to loubyansky:

anonymous wrote : There is no bug wrt . The problem is the space 
in the table name. It should be quoted in queries but it's not. This can be considered 
as a bug in JBossCMP. While it's not fixed you have to use table names that can be 
used w/o quotes.

Could you please elaborate on distinguishing a bug with  and 
JBossCMP?  Knowing what I do (which is only at the novice level) I don't see how we 
can make this distinction with the information at hand, i.e. it is all JBoss to me.

Note also that my test case with Question worked without doing anything to 
QuestionCategory or descriptors, so again I am suspect of this analysis.

But if it is a bug with the container, and it is not JBoss's responsibility to fix it, 
from who and where can I get another one?

In response to ironbird:

anonymous wrote : I don't understand you don't have a deployment error. With JBoss 
3.2.3, I have a deployment error "Error in jbosscmp-jdbc.xml : datasource-mapping not 
found" if I do the same thing. 
  | 

Perhaps it is because of my standardjbosscmp-jdbc.xml file


  | 
  |
  |   java:/PostgresDS
  |   
  | 
  |   PostgreSQL 7.2
  | 
  |   false
  |   false
  |   false
  |   30
  |   false
  |   true
  |   false
  |   foreign-key
  |   
  |  on-load
  |  1000
  |  *
  |   
  |   1000
  | 
  |   
  |  UUIDKeyGeneratorFactory
  |  java.lang.String
  |  VARCHAR
  |  VARCHAR(32)
  |   
  | 
  |   
  | 
  |
  | 
  |
  | 
  |   
  |  PostgreSQL 7.2
  |  SELECT ?1 FROM ?2 WHERE ?3 FOR 
UPDATE
  |  CONSTRAINT ?1 PRIMARY KEY 
(?2)
  |  ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) 
REFERENCES ?4 (?5)
  |  ?1
  |  t
  |  _
  |  32
  |  true
  |  TRUE
  |  FALSE
  | 
  |  
  | concat
  | (?1 || ?2)
  |  
  |  
  | substring
  | substring(?1 FROM ?2 FOR ?3)
  |  
  |  etc.
  | etc.
  | etc.



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

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



---
This SF.Net email is sponsored by the new InstallShield X.
>From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-05-31 Thread abcolson
Hi ironbird,

Here's the latest...

anonymous wrote : You think that the error is for your questions bean. I think the 
error is for your QuestionCategory bean. 
  | Try to activate cmp plugin traces to see the generated SQL in jboss log file. 

The reason I think this is that I am not instantiating a QuestionCategory bean 
anyplace and I am only instantiating a Question bean once in a test servlet.  When I 
go to that servlet (and after turning on log4j tracing) I get

2004-05-31 22:35:09,054 TRACE [org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy] 
Resized cache for bean QuestionCategory: old capacity = 100, new capacity = 50
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.system.Registry] lookup 
1524151178=jboss.j2ee:jndiName=ejb/tutorial/Fibo,service=EJB
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start 
method=create
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current 
transaction in MI is null
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED 
for create
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came 
in with tx null
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Starting 
new tx TransactionImpl:XidImpl [FormatId=257, GlobalId=pegasus//5, BranchQual=]
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] 
TxInterceptorCMT: In finally
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.LogInterceptor] End 
method=create
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.system.Registry] lookup 
102234528=jboss.j2ee:jndiName=ejb/tutorial/Question,service=EJB
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.LogInterceptor] Start 
method=findByPrimaryKey
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Current 
transaction in MI is null
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] TX_REQUIRED 
for findByPrimaryKey
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Thread came 
in with tx null
  | 2004-05-31 22:35:10,095 TRACE [org.jboss.ejb.plugins.TxInterceptorCMT] Starting 
new tx TransactionImpl:XidImpl [FormatId=257, GlobalId=pegasus//7, BranchQual=]
  | 2004-05-31 22:35:10,105 TRACE [org.jboss.ejb.plugins.EntityInstancePool] Get 
instance [EMAIL PROTECTED] tutorial.ejb.QuestionBean
  | 2004-05-31 22:35:10,105 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
Executing SQL: SELECT id FROM question WHERE id=?
  | 2004-05-31 22:35:10,105 TRACE 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
Set parameter: index=1, jdbcType=BIGINT, value=1
  | 2004-05-31 22:35:10,105 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
Find failed
  | java.sql.SQLException: ERROR:  Relation "question" does not exist

which is what I expected: a PreparedStatement with one parameter.

BTW, when I did a grep SELECT server.log I got the following:

  SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM JMS_TRANSACTIONS
  |   SELECT_MAX_TX = SELECT MAX(TXID) FROM JMS_MESSAGES
  |   SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, ESSAGEBLOB FROM JMS_MESSAGES 
WHERE DESTINATION=?
  |   SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE 
MESSAGEID=? AND DESTINATION=?
  |   DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN 
(SELECT TXID FROM  JMS_TRANSACTIONS) AND TXOP=? 2004-05-31 22:22:21,180 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.QuestionCategory] Entity 
Exists SQL: SELECT COUNT(*) FROM questioncategory WHERE id=?
  | 2004-05-31 22:22:21,320 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.QuestionCategory#findByPrimaryKey]
 SQL: SELECT id FROM questioncategory WHERE id=?
  | 2004-05-31 22:22:21,340 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Question] Entity Exists SQL: 
SELECT COUNT(*) FROM question WHERE id=?
  | 2004-05-31 22:22:21,380 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
SQL: SELECT id FROM question WHERE id=?
  | 2004-05-31 22:22:55,379 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Question#findByPrimaryKey] 
Executing SQL: SELECT id FROM question WHERE id=?

So maybe some of these other sql statements are causing the problem.

anonymous wrote : No, the EJB spec from SUN says that the where clause in EJB-QL must 
refers to the abstract schema name of your bean, which is QuestionCategory, not 
QuestionCategoryBean. So your EJB-QL should be 
  | Code: 
  | 
  | SELECT OBJECT(qcb) FROM QuestionCategory qcb WHERE qcb.id = ?1

Well, then there may be two bugs with JBoss 3.2.3:

Bug #1 Non Recognition Of 

When I tested without my re-definition of findByPrimaryKey(), 
I changed Question descriptor in ejb-jar.xml to
  
  |  
  |  Q

[JBoss-user] [Persistence & CMP/JBoss] - Re: Mapping Entity Beans to Database Tables

2004-05-31 Thread abcolson
Thanks for the feedback, guys.  But I am not sure I understand your recommendations.

anonymous wrote : Try removing or commenting the from your ejb-jar.xml to rule that 
out, since it isn't needed for findByPrimaryKey(). 

I think maybe all the words didn't come through.  I am unclear on what exactly you 
suggest removing.

anonymous wrote : I'm wondering why it's looking for a relation. That seems really odd 
since you didn't define any relationships. 
  | 

I think this might be a slip in terminology.  It appears to be either a PostgresQL 
message or a java message i.e. java.sql.SQLException: ERROR:  Relation "question" does 
not exist

BTW, when I create a view called "question" which is simply a "SELECT * FROM 
Questions" the table is mapped but then I get field mapping errors (makes sense if it 
is the same mapping pattern problem)

anonymous wrote : I think the problem is the space in your Question Categories. This 
don't work, even in sql. 

I don't think this is the problem.  PostgresQL seems to be case sensitive and 
translates everything you type in a sql statement to lowercase unless you put it in 
quotes.  Same goes for spaces.  So in PostgresQL,

SELECT * FROM "Question Categories" works fine.

At some point I need to investigate the quoting issue, but I can't do that as long as 
JBoss keeps looking for "question" and not "questions".


anonymous wrote : Your bean abstract schema name is QuestionCategory not 
QuestionCategorybean. 
  | It's surprising you have no errors at deployment. 
  | 

Do you mean QuestionCategoryBean (upper case B)?

Actually, I am using XDoclet to generate the descriptors and this is what it generates 
by default.  Do I really need to alter this?  I am actually confused on what 
 is used for so I can't comment on the issue of no deployment 
errors regarding abstract schema names.

I did try changing the schema in my Question example to QuestionBean and that didn't 
seem to help.

Here are the XDoclet headers for my 2 cases:

QuestionBean:
/**
  |  * @author colson
  |  *
  |  * @ejb.bean name="Question"
  |  *   display-name = "Question  EJB"
  |  *   description = "EJB that manages a Question"
  |  *   view-type = "remote"
  |  *   jndi-name = "ejb/tutorial/Question"
  |  *   cmp-version = "2.x"
  |  *   primkey-field = "id"
  |  *
  |  * @ejb.persistence table-name = "Questions"
  |  * 
  |  * @ejb.finderdescription = "Lookup Question By ID"
  |  *signature = "tutorial.interfaces.Question 
findByPrimaryKey(java.lang.Long)"
  |  *result-type-mapping = "Local"
  |  *query = "SELECT OBJECT(qb) FROM QuestionBean qb WHERE qb.id = ?1"
  |  *   
  |  * @ejb.resource-refres-ref-name = "jdbc/PostgresDS"
  |  *  res-type = "javax.sql.DataSource"
  |  *  res-auth = "Container"
  |  *  
  |  * @jboss.resource-ref  res-ref-name = "jdbc/PostgresDS"
  |  *  jndi-name = "java:/PostgresDS"
  |  * 
  |  * @jboss.persistence table-name = "Questions"
  |  *datasource = "java:/PostgresDS"
  |  * 
  |  * To change the template for this generated type comment go to
  |  * Window>Preferences>Java>Code Generation>Code and Comments
  |  */
  | 

QuestionCategoryBean:

/**
  |  * @author colson
  |  *
  |  * 
  |  * @ejb.bean name="QuestionCategory"
  |  *   display-name = "Question Category EJB"
  |  *   description = "EJB that manages a Question Category"
  |  *   view-type = "remote"
  |  *   jndi-name = "ejb/tutorial/QuestionCategory"
  |  *   cmp-version = "2.x"
  |  *   primkey-field = "id"
  |  * 
  |  * @ejb.persistence table-name = "Question Categories"
  |  * 
  |  * 
  |  * 
  |  * @ejb.finderdescription = "Lookup Question Category By ID"
  |  *signature = "tutorial.interfaces.QuestionCategory 
findByPrimaryKey(java.lang.Long)"
  |  *result-type-mapping = "Local"
  |  *query = "SELECT OBJECT(qcb) FROM QuestionCategoryBean qcb WHERE 
qcb.id = ?1"
  |  * 
  |  * @ejb.resource-refres-ref-name = "jdbc/PostgresDS"
  |  *  res-type = "javax.sql.DataSource"
  |  *  res-auth = "Container"
  |  *  
  |  * @jboss.resource-ref  res-ref-name = "jdbc/PostgresDS"
  |  *  jndi-name = "java:/PostgresDS"
  |  * 
  |  * 
  |  * 
  |  * To change the template for this generated type comment go to
  |  * Window>Preferences>Java>Code Generation>Code and Comments
  |  */
  | 

Thanks for all the tips!
Tony

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

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



---
This SF.Net email is sponsored by: Oracle 10g
Get certified on 

[JBoss-user] [Persistence & CMP/JBoss] - Mapping Entity Beans to Database Tables

2004-05-30 Thread abcolson
Greetings,

I am using JBoss 3.2.3 with Postgres and encountering issues mapping beans/attributes 
to tables/fields.  My table/field names sometimes have spaces and/or other characters 
that don't exactly match the bean, such as:

anonymous wrote : Mapping entity bean "Question" => Table "Questions"
  | Mapping entity bean "QuestionCategory" => Table "Question Categories"
  | Mapping entity bean getter getParentId() => Field "parent_id"
Here are my descriptors and stack trace when I try to access the "Questions" table:

ejb-jar.xml:


  | http://java.sun.com/dtd/ejb-jar_2_0.dtd";>
  | 
  | 
  | 
  |
  |Generated by XDoclet
  | 
  |
  | 
  |   
  |   
  |  
  |  Fibo EJB
  | 
  |  Fibo
  | 
  |  tutorial.interfaces.FiboHome
  |  tutorial.interfaces.Fibo
  |  tutorial.ejb.FiboBean
  |  Stateless
  |  Container
  | 
  |   
  | 
  |  
  | 
  |   
  |   
  |  
  |  Question EJB
  | 
  |  Question
  | 
  |  tutorial.interfaces.QuestionHome
  |  tutorial.interfaces.Question
  | 
  |  tutorial.ejb.QuestionBean
  |  Container
  |  java.lang.Long
  |  False
  |  2.x
  |  Questions
  |  
  | 
  | id
  |  
  |  
  | 
  | question
  |  
  |  
  | 
  | categoryId
  |  
  |  
  | 
  | level
  |  
  |  id
  | 
  |  
  | jdbc/PostgresDS
  | javax.sql.DataSource
  | Container
  |  
  | 
  |  
  | 
  | 
  |findByPrimaryKey
  |
  |   java.lang.Long
  |
  | 
  | Local
  | 
  |  
  |   
  |   
  | 
  |   
  |  
  |  Question Category EJB
  | 
  |  QuestionCategory
  | 
  |  tutorial.interfaces.QuestionCategoryHome
  |  tutorial.interfaces.QuestionCategory
  | 
  |  tutorial.ejb.QuestionCategoryBean
  |  Container
  |  java.lang.Long
  |  False
  |  2.x
  |  QuestionCategory
  |  
  | 
  | id
  |  
  |  
  | 
  | name
  |  
  |  
  | 
  | parentId
  |  
  |  id
  | 
  |  
  | jdbc/PostgresDS
  | javax.sql.DataSource
  | Container
  |  
  | 
  |  
  | 
  | 
  |findByPrimaryKey
  |
  |   java.lang.Long
  |
  | 
  | Local
  | 
  |  
  |   
  |   
  | 
  |  
  | 
  |   
  |  
  | 
  |
  | 
  |
  | 
  |
  |
  |  
  | 
  |
  | 
  |
  | 
  |
  | 
  |
  | 
  |
  |
  | 
  | 
 

jbosscmp-jdbc.xml


  | http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd";>
  | 
  | 
  |
  |
  | 
  |
  | 
  |  
  | 
  |   
  |  Question
  |  java:/PostgresDS
  |  
  |  Questions
  | 
  |  
  | id
  | id
  | 
  | 
  |  
  | question
  | question
  | 
  | 
  |  
  | categoryId
  | category_id
  | 
  | 
  |  
  | level
  | level
  | 
  | 
  | 
  |   
  | 
  |   
  |  QuestionCategory
  |  Question Categories
  | 
  |  
  | id
  | id
  | 
  | 
  |  
  | name
  | name
  | 
  | 
  |  
  | parentId
  | parent_id
  | 
  | 
  | 
  |   
  | 
  |
  | 
  | 
  | 

jboss.xml

  | http://www.jboss.org/j2ee/dtd/jboss_3_0.dtd";>
  | 
  | 
  | 
  |
  | 
  |  
  | 
  |   
  |  Question
  |  ejb/tutorial/Question
  |  
  | jdbc/PostgresDS
  | java:/PostgresDS
  |  
  | 
  |   
  |   
  |  QuestionCategory
  |  ejb/tutorial/QuestionCategory
  |  
  | jdbc/PostgresDS
  | java:/PostgresDS
  |  
  | 
  |   
  | 
  |   
  |  Fibo
  |  ejb/tutorial/Fibo
  | 
  |   
  | 
  |
  | 
  |
  |
  | 
  | 
  | 

Stacktrace:
Find failed: java.sql.SQLException: ERROR:  Relation "question" does not exist
  | 
  | javax.ejb.FinderException: Find failed: java.sql.SQLException: ERROR:  Relation 
"question" does not exist
  | 
  | at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:238)
  | at 
org.j

[JBoss-user] [JCA/JBoss] - Re: Postgres & JBoxx 3.2.3: jdbc not bound

2004-05-25 Thread abcolson
Thank you.  I no longer get the stack trace error.

I did look through the forums; must have missed the magic post last month.

BTW, where is this behavior documented?  The standardjbosscmp-jdbc.xml file itself 
doesn't indicate this format.

Thanks again,
Tony

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

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



---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [JCA/JBoss] - Re: Postgres & JBoxx 3.2.3: jdbc not bound

2004-05-24 Thread abcolson
Please forgive me.  Here is the stack trace as requested...

org.jboss.deployment.DeploymentException: Error: can't find data source: 
jdbc/PostgresDS; - nested throwable: (javax.naming.NameNotFoundException: jdbc not 
bound)
at 
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:143)
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:420)
at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:357)
at 
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at sun.reflect.GeneratedMethodAccessor5.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:546)
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
at $Proxy14.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:394)
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:546)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy27.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at sun.reflect.GeneratedMethodAccessor5.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:546)
at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
at $Proxy14.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:394)
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:546)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy12.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
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:642)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
at sun.reflect.GeneratedMethodAccessor18.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:546)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
at $Proxy6.deploy(Unknown Source)
at 
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
at 
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
at 
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
at sun.reflect.GeneratedMethodAccessor5.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)
   

[JBoss-user] [JCA/JBoss] - Postgres & JBoxx 3.2.3: jdbc not bound

2004-05-24 Thread abcolson
I am using JBoss 3.2.3 and trying to configure a Postgres data source for use with an 
Entity bean called "Question".

I am getting Question bean deployment exceptions like:

org.jboss.deployment.DeploymentException: Error: can't find data source: 
jdbc/PostgresDS; - nested throwable: (javax.naming.Name
NotFoundException: jdbc not bound)

However, as I have read the forums and documentation, everything seems to be in order 
and I can't figure out why.  Here are my config files:

ejb-jar:
 
jdbc/PostgresDS
javax.sql.DataSource
Container
 

jboss.xml:
 
jdbc/PostgresDS
java:/PostgresDS
 

postgres-ds.xml


  
PostgresDS
jdbc:postgresql://horse:5432/NNT
org.postgresql.Driver
dbadmin
wizzard

SELECT 'INITIAL DB CONNECTION WORKED'


SELECT 'VALID CONNECTION FROM 
POOL'

  



jmx-console output:

 java:comp namespace of the Question bean:
   +- env
   |   +- jdbc
   |   |   +- PostgresDS[link -> java:/PostgresDS]

AND

 java: Namespace
   +- SecurityProxyFactory
   +- PostgresDS


Thanks for any ideas.
Tony

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

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


---
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] [Installation & Configuration] - Re: deployer.jar missing in JBoss-3.2.3

2004-03-12 Thread abcolson
I'm having the same problem.  What is the solution?

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

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


---
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user