Mapping for CHAR in jaws.xml
sunil_mundluri Feb 25, 2003 5:38 AMHi !
I've a CHAR field in my CMP. Want to knwo what is the mapping for this in POSTGRESQL. I tried the following, but in vain.
<cmp-field>
<field-name>chrc</field-name>
<column-name>chrc</column-name>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR(1)</sql-type>
</cmp-field>
I also tried
<cmp-field>
<field-name>chrc</field-name>
<column-name>chrc</column-name>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</cmp-field>
With tis things in place , I could get the data with a finder methd but failed when another method is called on this.
javax.transaction.TransactionRolledbackException: Load failed; nested exception is:
java.lang.IllegalArgumentException; nested exception is:
java.rmi.ServerException: Load failed; nested exception is:
java.lang.IllegalArgumentException
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:188)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:347)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:127)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170)
at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:436)
at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:412)
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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:536)
I'm using JBOSS 2.4.6 and PSTGRESQL 7.2 version. Can anybody help me with correct mapping for POSTGRESQL.