EJB mapping error on MSSQL TEXT datatype columns (Weblogic)

subscribe 2003-09-11 03:33:29
I used bottom-up mapping from existing tables to CMPs and everything
appeared to be fine until I tried to add Finder methods against tables
that contain SQL Server Text datatype columns -- the EJB deployment
descriptor saved okay, but when I tried to generate the Deploy and RMIS
code, I got this error message:

WQRY0115E: internal metadata mapping error. View mytablenameBean has a
type mismatch for field 10.

The 10th column listed in the mapping for this table is of datatype
Text, mapped to java.lang.String.I can run this bean, the method getter and setter of TEXT field can access database correctly.

This same error appears for another table that has 2 Text columns (type
mismatch for fields 25 and 31, which are Text datatype columns) when I
try to define Finder methods on that table.

On another table that does not have any Text datatypes, I can define
Finder methods with no problems.

I'm using WSAD 5.0 and generating EJB 1.1 / 2.0 beans with MS SQL 2k

I found that in ejbModule/websphere_deploy/MSSQLSERVER_V7_1/ directory

Bean_AdaptorBinding.java file,
TEXT field is mapping to
com.ibm.ObjectQuery.engine.OSQLSymbols._LVARCHAR
other field is mapping to
com.ibm.ObjectQuery.engine.OSQLSymbols._VARCHAR

BeanFunctionSet.java file, TEXT fiels is mapping to
java.sql.Types.LONGVARCHAR
other field is mapping to java.sql.Types.VARCHAR

Any suggestions? Thanks,
...全文
36 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
subscribe 2003-09-15
  • 打赏
  • 举报
回复
up
subscribe 2003-09-11
  • 打赏
  • 举报
回复
多谢各位,我这个贴子在三个栏目都发了。贴子见下:
另:我是在Websphere下开发,但知道weblogic组下面高手很多,借宝地一用

j2ee http://expert.csdn.net/Expert/topic/2249/2249323.xml?temp=.1732599
websphere http://expert.csdn.net/Expert/topic/2249/2249328.xml?temp=.3200495
weblogic http://expert.csdn.net/Expert/topic/2249/2249345.xml?temp=.1583216

1,220

社区成员

发帖
与我相关
我的任务
社区描述
企业软件 中间件技术
社区管理员
  • 中间件
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧