• Post Reply Bookmark Topic Watch Topic
  • New Topic

Jboss-interbase error  RSS feed

 
sang tran
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I'm working on JBoss and Firebird,the InterBase's config is interbase-service.xml that is in "[JBOSS_HOME]/server/default/deploy":
I cannot implement relationship between entity EJB (2.0) . If EJB A have one-to-many relationship with EJB B, I can get data from A,
if the relationship is not one-to-many, i get an exception when I get data from A :
----------
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.ServerException: Load failed
Embedded Exception
[interclient][interbase] dynamic SQL Error .
SQL code = -206
unknown column
QUOCGIA
----------
quocgia is CMR property of A in the relationship to B
Could you show me why I get this errors. Thanks !
-----------
this is the intebase-service.xml:
----------
<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server 3.0 RC1 Configuration for local JDataStore datasource -->
<!-- From Brent Thompson www.protegra.com/javagroup.html -->
<!-- ===================================================================== -->
<server>
<!-- ==================================================================== -->
<!-- Copy these jar's from your JBuilder6/lib to your jboss's lib -->
<!-- dx.jar,jdsserver.jar,jds.jar -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->

<mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" name="jboss.jca:service=LocalTxCM,name=InterBaseDS">
<!-- Include a login module configuration named DataStoreDBRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "InterBaseDBRealm">
<authentication>
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
flag = "required">
<module-option name = "principal">sysdba</module-option>
<module-option name = "userName">sysdba</module-option>
<module-option name = "password">masterkey</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=InterBaseDS</module-option>
</login-module>
</authentication>
</application-policy>
-->
<!--
NOTE: the application-policy name attribute must match SecurityDomainJndiName, and the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you are configuring here.
-->
<!--comment out this line if you want component managed security or want
to use the default values in the ManagedConnectionFactoryProperties -->
<attribute name="SecurityDomainJndiName">InterBaseDBRealm</attribute>
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=LocalTxDS,name=InterBaseDS">
<attribute name="JndiName">InterBaseDS</attribute>

<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL" type="java.lang.String">jdbc:interbase://localhost/c:/accounts.gdb</config-property>
<config-property name="DriverClass" type="java.lang.String">interbase.interclient.Driver</config-property>
<!--set these only if you want only default logins, not through JAAS-->
<config-property name="UserName" type="java.lang.String">SYSDBA</config-property>
<config-property name="Password" type="java.lang.String">masterkey</config-property>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" name="jboss.jca:service=LocalTxPool,name=InterBaseDS">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--criteria indicates if Subject (from security domain) or app supplied
parameters (such as from getConnection(user, pw)) are used to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>

</server>
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!