DataBase BC - error

[Amit R]

Some javascript/style in this post has been disabled (why?)

Hi,

I am new to OpenESB. I am trying to read data from a file and write into db. But, there seems to be some problems with parametric query.

My query is simple: insert into Employee ( address , id ) values ( ? , 1 ) where address value is read from the file.

I get the error:
Resource entry is missing from the resource bundle
java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
......
Failed to write message:.
java.lang.Exception: Failed to denormalize message.
......
Caused by: javax.jbi.messaging.MessagingException: Error occured while executing SQL.insert into dbo.Employee ( address , id ) values ( ? , 1 ) Reason: Unable to convert normalized message content to prepared statement, Error occured during populating PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!

Please find the complete error attached in the mail.
I tried searching on forum but there seems to be no fixed solution for this. Is there a problem in Db BC files or am I missing something?

thanks
Amit

[Andy Knight]

Some javascript/style in this post has been disabled (why?)

Please provide the complete project for analysis

	Andy Knight Principal Engineer, Field Assist Support Team Sun Microsystems, Inc. Java House, Guillemont Park, Minley Road, Blackwater Camberley, Surrey GU17 9QG United Kingdom Home office: [phone] Mobile: [phone] Skype: aprknight Email: [hidden email] Blog: http://blogs.sun.com/andky

On 30 Jun 2009, at 12:58, Rana Amit wrote:

Hi,

I am new to OpenESB. I am trying to read data from a file and write into db. But, there seems to be some problems with parametric query.

My query is simple: insert into Employee ( address , id ) values ( ? , 1 ) where address value is read from the file.

I get the error:
Resource entry is missing from the resource bundle
java.util.MissingResourceException: Can't find resource for bundle java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
......
Failed to write message:.
java.lang.Exception: Failed to denormalize message.
......
Caused by: javax.jbi.messaging.MessagingException: Error occured while executing SQL.insert into dbo.Employee ( address , id ) values ( ? , 1 ) Reason: Unable to convert normalized message content to prepared statement, Error occured during populating PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!

Please find the complete error attached in the mail.
I tried searching on forum but there seems to be no fixed solution for this. Is there a problem in Db BC files or am I missing something?

thanks
Amit

[Amit R]

Hi Andy,

please find the project (BPEL Module and CASA) attached in the mail.
I am using the latest GlassFish ESB (v2.1).

thanks
Amit

-----Original Message-----
From: Andy Knight [mailto:[hidden email]]
Sent: Tue 30/06/2009 14:10
To: [hidden email]
Subject:  Re: DataBase BC - error
 
Please provide the complete project for analysis

         Andy Knight
Principal Engineer, Field Assist Support Team
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road, Blackwater
Camberley, Surrey GU17 9QG United Kingdom
Home office: [phone]
Mobile: [phone]
Skype: aprknight
Email: [hidden email]
Blog: http://blogs.sun.com/andky


On 30 Jun 2009, at 12:58, Rana Amit wrote:

>
> Hi,
>
> I am new to OpenESB. I am trying to read data from a file and write  
> into db. But, there seems to be some problems with parametric query.
>
> My query is simple: insert into Employee ( address , id ) values  
> ( ? , 1 ) where address value is read from the file.
>
> I get the error:
> Resource entry is missing from the resource bundle
> java.util.MissingResourceException: Can't find resource for bundle  
> java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
> ......
> Failed to write message:.
> java.lang.Exception: Failed to denormalize message.
> ......
> Caused by: javax.jbi.messaging.MessagingException: Error occured  
> while executing SQL.insert into dbo.Employee ( address , id ) values  
> ( ? , 1 ) Reason: Unable to convert normalized message content to  
> prepared statement, Error occured during populating  
> PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!
>
> Please find the complete error attached in the mail.
> I tried searching on forum but there seems to be no fixed solution  
> for this. Is there a problem in Db BC files or am I missing something?
>
> thanks
> Amit
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

[Amit R]

hi,

you can open using Winrar and you will find the 2 folders.

Maybe the email client messed up the name and types. Sorry for that.

Amit

Amit R wrote:

Hi Andy,

please find the project (BPEL Module and CASA) attached in the mail.
I am using the latest GlassFish ESB (v2.1).

thanks
Amit

-----Original Message-----
From: Andy Knight [mailto:[e-mail]]
Sent: Tue 30/06/2009 14:10
To: [e-mail]
Subject:  Re: DataBase BC - error
 
Please provide the complete project for analysis

         Andy Knight
Principal Engineer, Field Assist Support Team
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road, Blackwater
Camberley, Surrey GU17 9QG United Kingdom
Home office: [phone]
Mobile: [phone]
Skype: aprknight
Email: [e-mail]
Blog: http://blogs.sun.com/andky


On 30 Jun 2009, at 12:58, Rana Amit wrote:

>
> Hi,
>
> I am new to OpenESB. I am trying to read data from a file and write  
> into db. But, there seems to be some problems with parametric query.
>
> My query is simple: insert into Employee ( address , id ) values  
> ( ? , 1 ) where address value is read from the file.
>
> I get the error:
> Resource entry is missing from the resource bundle
> java.util.MissingResourceException: Can't find resource for bundle  
> java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
> ......
> Failed to write message:.
> java.lang.Exception: Failed to denormalize message.
> ......
> Caused by: javax.jbi.messaging.MessagingException: Error occured  
> while executing SQL.insert into dbo.Employee ( address , id ) values  
> ( ? , 1 ) Reason: Unable to convert normalized message content to  
> prepared statement, Error occured during populating  
> PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!
>
> Please find the complete error attached in the mail.
> I tried searching on forum but there seems to be no fixed solution  
> for this. Is there a problem in Db BC files or am I missing something?
>
> thanks
> Amit
>




 
---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]

[phoenix_hua]

Hi,Amit R
I thank you donot use  "insert into Employee ( address , id ) values  ( ? , 1 ) ",you  should use "insert into Employee ( address , id ) values  ( ? , 1 )",if you want to fix id to "1",you can set in the mapper!

regards
Phoenix_hua

Amit R wrote:

hi,

you can open using Winrar and you will find the 2 folders.

Maybe the email client messed up the name and types. Sorry for that.

Amit

Amit R wrote:

Hi Andy,

please find the project (BPEL Module and CASA) attached in the mail.
I am using the latest GlassFish ESB (v2.1).

thanks
Amit

-----Original Message-----
From: Andy Knight [mailto:[e-mail]]
Sent: Tue 30/06/2009 14:10
To: [e-mail]
Subject:  Re: DataBase BC - error
 
Please provide the complete project for analysis

         Andy Knight
Principal Engineer, Field Assist Support Team
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road, Blackwater
Camberley, Surrey GU17 9QG United Kingdom
Home office: [phone]
Mobile: [phone]
Skype: aprknight
Email: [e-mail]
Blog: http://blogs.sun.com/andky


On 30 Jun 2009, at 12:58, Rana Amit wrote:

>
> Hi,
>
> I am new to OpenESB. I am trying to read data from a file and write  
> into db. But, there seems to be some problems with parametric query.
>
> My query is simple: insert into Employee ( address , id ) values  
> ( ? , 1 ) where address value is read from the file.
>
> I get the error:
> Resource entry is missing from the resource bundle
> java.util.MissingResourceException: Can't find resource for bundle  
> java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
> ......
> Failed to write message:.
> java.lang.Exception: Failed to denormalize message.
> ......
> Caused by: javax.jbi.messaging.MessagingException: Error occured  
> while executing SQL.insert into dbo.Employee ( address , id ) values  
> ( ? , 1 ) Reason: Unable to convert normalized message content to  
> prepared statement, Error occured during populating  
> PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!
>
> Please find the complete error attached in the mail.
> I tried searching on forum but there seems to be no fixed solution  
> for this. Is there a problem in Db BC files or am I missing something?
>
> thanks
> Amit
>




 
---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]

[Li Jin]

Hi,
I am trying to use jmsjca and activemq for my project. After I deploy sun-jms-adapter.rar to my jboss, I got the following error.

org.jboss.deployment.DeploymentException: Error for ActivationSpec class com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec as JavaBean; - nested throwable: (java.beans.IntrospectionException: No property found for: reconnectInterval on JavaBean: com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec)
        at org.jboss.deployment.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:53)
        at org.jboss.resource.deployment.ActivationSpecFactory.createActivationSpec(ActivationSpecFactory.java:135)
        at org.jboss.resource.deployment.RARDeployment.createActivationSpec(RARDeployment.java:254)
        at org.jboss.resource.deployment.RARDeployment.internalInvoke(RARDeployment.java:218)
        at org.jboss.system.ServiceDynamicMBeanSupport.invoke(ServiceDynamicMBeanSupport.java:156)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.createActivationSpec(JBossMessageEndpointFactory.java:464)
        at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.startService(JBossMessageEndpointFactory.java:218)

Thanks a lot!
Li

[Frank Kieviet]

Some javascript/style in this post has been disabled (why?)

Li, can you check what values you are specifying for the activationspec? “reconnectInterval” is not one of them. See http://wiki.open-esb.java.net/Wiki.jsp?page=JMSJCA-readme for an overview of valid parameters for the activation spec.

 

 

---

From: [hidden email] [mailto:[hidden email]] On Behalf Of Li Jin
Sent: Wednesday, July 01, 2009 10:04
To: [hidden email]
Subject: JMSJCA deployment error:

 

Hi,
I am trying to use jmsjca and activemq for my project. After I deploy sun-jms-adapter.rar to my jboss, I got the following error.

org.jboss.deployment.DeploymentException: Error for ActivationSpec class com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec as JavaBean; - nested throwable: (java.beans.IntrospectionException: No property found for: reconnectInterval on JavaBean: com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec)
        at org.jboss.deployment.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:53)
        at org.jboss.resource.deployment.ActivationSpecFactory.createActivationSpec(ActivationSpecFactory.java:135)
        at org.jboss.resource.deployment.RARDeployment.createActivationSpec(RARDeployment.java:254)
        at org.jboss.resource.deployment.RARDeployment.internalInvoke(RARDeployment.java:218)
        at org.jboss.system.ServiceDynamicMBeanSupport.invoke(ServiceDynamicMBeanSupport.java:156)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.createActivationSpec(JBossMessageEndpointFactory.java:464)
        at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.startService(JBossMessageEndpointFactory.java:218)

Thanks a lot!
Li

[Li Jin]

Hi Frank,

Got it! The problem is that we used jboss provided adaptor before and I have to remove related definition in standardjboss.xml otherwise jboss assume activationspec has that property.
Thanks again
Li

Frank Kieviet <[hidden email]>
Sent by: [hidden email]

07/01/2009 10:22 AM

Please respond to
[hidden email]

To	[hidden email]
cc
Subject	RE: JMSJCA deployment error:

Li, can you check what values you are specifying for the activationspec? “reconnectInterval” is not one of them. See http://wiki.open-esb.java.net/Wiki.jsp?page=JMSJCA-readme for an overview of valid parameters for the activation spec.
 
 

---

From: [hidden email] [mailto:[hidden email]] On Behalf Of Li Jin
Sent: Wednesday, July 01, 2009 10:04
To: [hidden email]
Subject: JMSJCA deployment error:
 

Hi,
I am trying to use jmsjca and activemq for my project. After I deploy sun-jms-adapter.rar to my jboss, I got the following error.

org.jboss.deployment.DeploymentException: Error for ActivationSpec class com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec as JavaBean; - nested throwable: (java.beans.IntrospectionException: No property found for: reconnectInterval on JavaBean: com.stc.jmsjca.unifiedjms.RAUnifiedActivationSpec)
       at org.jboss.deployment.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:53)
       at org.jboss.resource.deployment.ActivationSpecFactory.createActivationSpec(ActivationSpecFactory.java:135)
       at org.jboss.resource.deployment.RARDeployment.createActivationSpec(RARDeployment.java:254)
       at org.jboss.resource.deployment.RARDeployment.internalInvoke(RARDeployment.java:218)
       at org.jboss.system.ServiceDynamicMBeanSupport.invoke(ServiceDynamicMBeanSupport.java:156)
       at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
       at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.createActivationSpec(JBossMessageEndpointFactory.java:464)
       at org.jboss.ejb.plugins.inflow.JBossMessageEndpointFactory.startService(JBossMessageEndpointFactory.java:218)

Thanks a lot!
Li

[Amit R]

Hi Phoenix,

I did not get what you want to say as both your statements look the same (except for the space before closing quotes).

I made the "id" as IDentity column in my db and modified my query as:
insert into dbo.Employee ( address ) values ( ? )
but still get the same error.

I tried changing my db driver from JTDS to MS SQL, but then get error of "jdbc type 4" as the driver and db are incompatible.

So, I am not sure how to proceed ?

thanks
Amit

Hi,Amit R
I thank you donot use  "insert into Employee ( address , id ) values  ( ? , 1 ) ",you  should use "insert into Employee ( address , id ) values  ( ? , 1 )",if you want to fix id to "1",you can set in the mapper!

regards
Phoenix_hua


hi,

you can open using Winrar and you will find the 2 folders.

Maybe the email client messed up the name and types. Sorry for that.

Amit



Hi Andy,

please find the project (BPEL Module and CASA) attached in the mail.
I am using the latest GlassFish ESB (v2.1).

thanks
Amit

-----Original Message-----
From: Andy Knight [mailto:[e-mail]]
Sent: Tue 30/06/2009 14:10
To: [e-mail]
Subject:  Re: DataBase BC - error
 
Please provide the complete project for analysis

         Andy Knight
Principal Engineer, Field Assist Support Team
Sun Microsystems, Inc.
Java House, Guillemont Park, Minley Road, Blackwater
Camberley, Surrey GU17 9QG United Kingdom
Home office: [phone]
Mobile: [phone]
Skype: aprknight
Email: [e-mail]
Blog: http://blogs.sun.com/andky


On 30 Jun 2009, at 12:58, Rana Amit wrote:

>
> Hi,
>
> I am new to OpenESB. I am trying to read data from a file and write  
> into db. But, there seems to be some problems with parametric query.
>
> My query is simple: insert into Employee ( address , id ) values  
> ( ? , 1 ) where address value is read from the file.
>
> I get the error:
> Resource entry is missing from the resource bundle
> java.util.MissingResourceException: Can't find resource for bundle  
> java.util.PropertyResourceBundle, key DBBC_E00714.DN_Failed_PS_Param
> ......
> Failed to write message:.
> java.lang.Exception: Failed to denormalize message.
> ......
> Caused by: javax.jbi.messaging.MessagingException: Error occured  
> while executing SQL.insert into dbo.Employee ( address , id ) values  
> ( ? , 1 ) Reason: Unable to convert normalized message content to  
> prepared statement, Error occured during populating  
> PreparedStatement.Reason: !DBBC_E00714.DN_Failed_PS_Param!
>
> Please find the complete error attached in the mail.
> I tried searching on forum but there seems to be no fixed solution  
> for this. Is there a problem in Db BC files or am I missing something?
>
> thanks
> Amit

[phoenix_hua]

Hi,Amit
It's my mistake!
My mean is you shoud use "insert into Employee ( address , id ) values ( ? , ? )"  instead of "insert into Employee ( address , id ) values ( 1 , ? )"
Regards
Phoenix_hua