properly way to lookup a java.sql.Connection from the connection pool

2004-01-28 Thread Christopher Tava
dear ojb user group,
 
could you kindly tell me the properly way to look a connection from the connection 
pool?
 
i have used the following call, but i get a socked closed exception.

Connection conn =

pBroker.serviceConnectionManager().getConnection();

2004-01-27 10:45:46,609 [RMI TCP Connection(126)-162.86.116.94] ERROR 
[com.server.TBean] java.sql.SQLException: Io exception: Socket closed

 

your assistance is much appreciated,

chris

 

 


-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

java.lang.ClassNotFoundException: org.apache.ojb.broker.util.collections.RemovalAwareCollection

2004-01-13 Thread Christopher Tava
Dear OJB User Group,
 
I am using OJB in jboss and making an EJB connection to the server and it 
seems like the client application is trying to down a server side class.
 
Any suggestion as to what can be the problem that cause the rmi classloader to 
reference the RemovalAwareCollection.
 
Is ojb always returning a java.util.Collection?  I see a ManageableCollection class in 
the broker package?  Does that have anything to do with it?
 
Thank you in advance for you much needed reply.

Sincerely,
Chris
 
 


-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

does QueryBySQL work?

2003-10-22 Thread Christopher Tava
Dear OJB user group,
 
Is QueryBySQL supported?  if so, are there any limitations?
 
thank you,
chris


-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

problem mapping differnent object to one table

2003-10-21 Thread Christopher Tava
has anyone been successfully mapping two objects to the same table??
to be more specific, i would like distinct object instances for objectAId and distinct 
object instances for objectBId in seperate queries.
 
 select distinct objectA_id from tableAB;
 select distinct objectB_id from tableAB;
 


i have used the distinct clause on the QueryCriteria class but i have not been 
successfully, because OJB wants to concatenate objectAId and objectBid together in the 
following sql;
 
 select distinct objectA_id, objectB_id  from tableAB;
 
why does OJB combine objectA_id and objectB_id in the select clause of the query if 
two class descriptors exist for the same table?  
 
i did try the reportQuery to restrict the columns.  i got the sql that is generated 
seems to be correct.  however ojb is throwing an invalid class cast exception which i 
don't understand.
 
any thoughts are much appreciated?
 
 
 

 
   
 
 

 
   
 



-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

dynamic database connections and schemas

2003-10-21 Thread Christopher Tava
dear ojb user list,
 
i was asked to describe my thoughts about dynamic database connections and schemas.
 
See below,
chris tava
 
let's suppose you are tasked with writing data to multiple databases accounts with the 
same schema.  let's call the schema, the v1.0.0 schema.  
 
when i use the word schema i am refering to the physcial model - relational database 
model.  obviously, using the OJB tool you can create an object.attribute to relational 
table.column map (O-R map).  and you can use the PBKey class to make a connection to 
any account using a specific O-R map.
 
PBKey pbKey = new PBKey("v1.0.0",getAccountName(), getAccountPass()); 
 
PersistenceBroker pBroker = pBrokerFactory.createPersistenceBroker(pbKey); 
 
now, let's suppose the next version of the system comes out and you have a new 
database schema, let's call the v2.0.0 schema.  and let's suppose only a few of the 
database accounts are updated at a given time.  
 
therefore, if you have some key identifier in your system that determines which 
version of the schema at particular database account is using, then you can use this 
information to make a connection to the specific database accounts using specific 
schemas.
 
if (schemaVersion.equals("v1.0.0") {
   PBKey pbKey = new PBKey("v1.0.0",   
   getAccountName(),getAccountPass());
}
else if (schemaVersion.equals("v2.0.0") {
   PBKey pbKey = new PBKey("v2.0.0",   
   getAccountName(),getAccountPass());
}






-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

huge fan of ojb, huge

2003-07-19 Thread Christopher Tava
I worked through all of the gory details of getting
ojb wired into jboss.  i know have a dynamic
persistence mechanism that writes data to any schema
on the fly.  i don't think cmp supports that!

great job guys!!!

I am going to read more ojb source to see if i can contribute...

__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



java.lang.LinkageError: loader constraints violated when linking javax/transaction/Synchronization class

2003-07-19 Thread Christopher Tava

I am trying to get a PersistenceBroker from a
SessionBean w/ the database configured in the
repository_database.xml file.

I have followed the deployment instructions to the T
and I double checked it to no avail.

It seems like I have made progress but the Jboss
transaction manager is not happy.

Any thoughts?


pBrokerFactory.getInstance().defaultPersistenceBroker();



java.lang.LinkageError: loader constraints violated
when linking javax/transaction/Synchronization class
at org.jboss.tm.TxCapsule.(TxCapsule.java:152)
at
org.jboss.tm.TxCapsule.getInstance(TxCapsule.java:124)
at org.jboss.tm.TxManager.begin(TxManager.java:113)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:158)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
at
org.jboss.ejb.StatelessSessionContainer.invokeHome(StatelessSessionContainer.java:300)
at org.jboss.ejb.Container.invoke(Container.java:730)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at 



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



rc3 valid archive?

2003-07-17 Thread Christopher Tava
Is this a valid archive?  
 http://db.apache.org/builds/ojb/1.0.rc3/db-ojb-1.0.rc3-src.tar
 

because I get a I/O error with the tar -x command.
 
what about the winzip format?
 
 
 
 


-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!