Re: UNSUSCRIBE

[Max]

Re: Setting Up News Application on Orion

[Max]

Hi, Brandy

Try the next:

  Stop your orion server
  Edit persistence-name in 
  cmp-field-mapping tag in orion-ejb-jar.xml 
  file to fit your needs. Persistence-name is a column name corresponding to EJB 
  field.
  Start server
Probably,stopping orion isnot even 
required

  - Original Message - 
  From: 
  B. 
  Dawkins 
  To: Orion-Interest 
  Sent: Thursday, May 17, 2001 9:59 
PM
  Subject: Setting Up News Application on 
  Orion
  
  
  Hi,
  
  I am trying to set up the News Application Demo on Orion and I get the 
  following information:
  Auto-creating table: create table com_evermind_ejb_NewsItem (id Number 
  not null primary key, submitter VARCHAR2(255) null, text VARCHAR2(255) null, 
  subject VARCHAR2(255) null, parent NUMBER null) Warning:Error creating table: 
  ORA-00904:invalid column name.
  
  I know why the error is occurring (Date is a reserve word in Oracle) but 
  where is this SQL file located so I could change the column name?
  
  Thanks,
  Brandy
  
  Get your FREE download of MSN Explorer at http://explorer.msn.com
  

a problem with MS Access through ODBC

[Max]

Hi,

I've configured orion 1.4.8 datasource to MS Access DB through ODBC and
wrote a simple CMP ProductEJB and a couple of JSP to experiment on. The
first one to retrieve records works fine, it calls productHome.findAll().
Next JSP was supposed to add record to DB. It takes a HTML form fields and
calls productHome.create( id, name, group, fullName) that throws the
following:

com.evermind[Orion/1.4.8 (build 10374)].server.rmi.OrionRemoteException:
Transaction was rolled back: Database error: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.

In ODBC log I found corresponding lines:

JAVA.EXE -jar o fde84813:fdf246d7 EXIT  SQLPrepare  with return code 0
(SQL_SUCCESS)
  HSTMT   0x08f816d0
  UCHAR * 0x00712040 [  -3] insert into ProductEJB (name,
group, fullName, id) VALUES (?, ?, ?, ?)\ 0
  SDWORD-3

JAVA.EXE -jar o fde84813:fdf246d7 ENTER SQLNumParams
  HSTMT   0x08f816d0
  SWORD * 0x08f0f878

JAVA.EXE -jar o fde84813:fdf246d7 EXIT  SQLNumParams  with return code 0
(SQL_SUCCESS)
  HSTMT   0x08f816d0
  SWORD * 0x08f0f878 (4)

JAVA.EXE -jar o fde84813:fdf246d7 ENTER SQLBindParameter
  HSTMT   0x08f816d0
  UWORD1
  SWORD1 SQL_PARAM_INPUT
  SWORD1 SQL_C_CHAR
  SWORD1 SQL_CHAR
  UDWORD   255
  SWORD0
  PTR0x00712d60
  SDWORD 7
  SDWORD *0x

JAVA.EXE -jar o fde84813:fdf246d7 EXIT  SQLBindParameter  with return code 0
(SQL_SUCCESS)
...
skipped
...
JAVA.EXE -jar o fde84813:fdf246d7 ENTER SQLExecute
  HSTMT   0x08f816d0

JAVA.EXE -jar o fde84813:fdf246d7 EXIT  SQLExecute  with return code -1
(SQL_ERROR)
  HSTMT   0x08f816d0

  DIAG [37000] [Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement. (-3502)

As for me, I don't see any systax error in insert into ProductEJB (name,
group, fullName, id) VALUES (?, ?, ?, ?)\ 0

Besides, this INSERT statement is made by orion, how could I affect it?

Any suggestions?

Max Bubnov

Re: a problem with MS Access through ODBC

[Max]

I've discovered that group is reserved word in MS Access so a table field
can't have such name. That was the reason of syntax error.

Thanks to all,
Max Bubnov