[JBoss-user] [Persistence & CMP/JBoss] - Re: More than one datasource possible?

[abrynils]

You can define datasources for the individual entity beans in the 
jbosscmp-jdbc.xml file or for each deployment unit using the default clause in 
the same file. I have no personal experience with this but it is listed in one 
of my books, "JBoss 3.0 Deployment and Administrator handbook" published by 
wrox. Thus you at least have a starting point to find information on the 
subject.

Hope this is of help.
regards,
Anders

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

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


---
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

[JBoss-user] [Persistence & CMP/JBoss] - CMP error when deploying in Jboss4 (works in Jboss3.2.5)

[abrynils]

Hi

I have an application developed for and running on JBoss 3.2.5. When i deploy 
it in JBoss4.0
i get an exception (TransactionRolledbackLocalException) when i try to retrive 
a CMP attribute, see Code and output below. I can include more code and trace 
if neccesary to solve the problem but i limit it at this time to not do an 
information overload. Any help would be appriciated.

Thanks,
Anders

Code:

 public void removeCustomer(String name) { 

System.out.println("CustomerHandlerBean removeCustomer");
try 
{
LocalCustomer customer = customerHome.findByPrimaryKey(name);
System.out.println("findByPrimaryKey OK");
System.out.println("customer object as String: " 
+customer.toString());
System.out.println("customer name: " +customer.getName());
customer.remove();
System.out.println("customer.remove() executed");
} catch (Exception ex) {
throw new EJBException(ex.getMessage());
}
}

Output:

10:37:09,832 INFO  [STDOUT] CustomerHandlerBean removeCustomer
10:37:09,838 INFO  [STDOUT] findByPrimaryKey OK
10:37:09,839 INFO  [STDOUT] customer object as String: 
ejb/MyCustomerTest:Anders10:37:09,843 ERROR [LogInterceptor] 
TransactionRolledbackLocalException in method: public abstract java.lang.String 
no.apertus.ejb.LocalCustomer.getName(), causedBy:
java.sql.SQLException: Unexpected token in statement [SELECT position, 
btaddress FROM CUSTOMERNEWEJBTABLE WHERE (name=?)]
at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:355)



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

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


---
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user