May I suggest a workaround. Assuming the CMP field for the description is
"Description", add another string field to the class called
"DescriptionCache". Then...
in the ejbCreate do this:
this.DescriptionCache = this.Description;
this.Description = null;
now in the corresponding ejbPostCreate:
this.Description = this.DescriptionCache;
this.DescriptionCache = null;
...and now use explicit JDBC to update the description
This should work because your ejbCreate is called right at the start of the
generated ejbCreate, before the CMP code is executed.
Joe
-----Original Message-----
From: Bryan (Mailing Lists) [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, December 02, 2000 3:34 PM
To: [EMAIL PROTECTED]
Subject: STILL MORE Re: CMP and PostgreSQL "TEXT" datatype?
Here is the exact output from the JOnAS execution window giving the
PostgreSQL JDBC driver error, when I try to insert a String column around
10k long:
Failed to create bean in database
The SQL Statement is too long - insert into Customer_History (id,
id_customer, id_admin, timestamp, description) values (2015, 37515, 1,
'2000-12-02 09:00:16.259', 'Logged E-Mail To Customer:....
....
[what follows is a 10k email message]
....
')
at org.postgresql.Connection.ExecSQL(Connection.java:324)
at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.j
ava:
126)
at
com.nextalarm.EJB.JOnASCustomerHistoryBeanCustomerHistory.createData(JOn
ASCu
stomerHistoryBeanCustomerHistory.java:184)
at
com.nextalarm.EJB.JOnASCustomerHistoryBeanCustomerHistoryHome.create(JOn
ASCu
stomerHistoryBeanCustomerHistoryHome.java:50)
at
com.nextalarm.EJB.JOnASCustomerHistoryBeanCustomerHistoryHome_Skel.send(
JOnA
SCustomerHistoryBeanCustomerHistoryHome_Skel.java:42)
at
org.objectweb.david.libs.protocols.giop.GIOPProtocol$ServerSession_Low.s
end(
GIOPProtocol.java:638)
at
org.objectweb.jonathan.libs.protocols.tcpip.TcpIpProtocol$Session.run(Tc
pIpP
rotocol.java:431)
at
org.objectweb.jonathan.libs.resources.JScheduler$JJob.run(JScheduler.jav
a:25
2)
System Exception in create or finder method:javax.ejb.EJBException
This puzzles me because I thought JOnAS used prepared statements for
inserts; however, the above error message (coming out of the PostgreSQL
driver) seems to indicate a direct statement is occuring, rather than a
prepared one. Maybe it's being translated internally by the JDBC driver
from
a prepared statement to a regular one.
In any case, help would be appreciated; how else on earth can one insert
columns >8k into PostgreSQL via CMP?
Thanks in advance,
Bryan
----- Original Message -----
From: "Bryan (Mailing Lists)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 01, 2000 5:35 PM
Subject: MORE Re: CMP and PostgreSQL "TEXT" datatype?
> By the way, I should also add that I have already been using "String",
but
> when I try to insert a value that's pretty long (e.g. 10k bytes), I get
an
> exception from the PostgreSQL driver, "Query too long" or something like
> that.
>
> Thanks in advance,
> Bryan
>
>
> ----- Original Message -----
> From: "Bryan (Mailing Lists)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, December 01, 2000 2:29 PM
> Subject: CMP and PostgreSQL "TEXT" datatype?
>
>
> > Can someone please tell me which Java class I should use in a JOnAS CMP
> bean
> > to represent the "TEXT" datatype in PostgreSQL?
> >
> > The TEXT datatype is not described anywhere in the JOnAS "Bean
> Programmer's
> > Guide".
> >
> > Thank you,
> > Bryan
> >
> >
> >
> > ----
> > To unsubscribe, send email to [EMAIL PROTECTED] and
> > include in the body of the message "unsubscribe jonas-users".
> > For general help, send email to [EMAIL PROTECTED] and
> > include in the body of the message "help".
>
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
