Hi,
Thx so much for your document..
I have been working on db for several days and cant get my stateless session bean
connnect to db
I have fixed the problem now..
One of the difficult is what name should I use in order to lookup the db source in
my ejb
Most of the mails which I read all says names like "jdbc/myDataSource", which doesnt
work
But when I change to "java:comp/env/jdbc/myDataSource" it works
Can any one tells me whats the difference between these two names
Thx again..
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Henry Voyer (hotmail)
Sent: Wednesday, August 23, 2000 1:41 PM
To: jBoss
Subject: [jBoss-User] More info on configuring Interbase with jboss
Hi fellow programmers.
Couple of weeks ago i had problems configuring interbase.
I havent done an extensive testing but this configuration seems to work:
1- More information on the mapping can be found at:
http://www.inprise.com/devsupport/appserver/faq/CMP_Data_Access.html
And a overall information on this database at:
http://www.inprise.com/devsupport/appserver/faq/
2- from the mailing list i found:
define datasource in jboss.conf (as above)
<MLET CODE = "org.jboss.jdbc.DataSourceImpl"
ARCHIVE="jboss.jar,interclient.jar" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String"
VALUE="jdbc:interbase://localhost/e:/dev/db.gdb">
<ARG TYPE="java.lang.String" VALUE="Interbase">
<ARG TYPE="java.lang.String" VALUE="interbase.interclient.Driver">
<ARG TYPE="java.lang.String" VALUE="sysdba">
<ARG TYPE="java.lang.String" VALUE="masterkey">
</MLET>
add a resource ref in ejb-jar.xml
<resource-ref>
<description />
<res-ref-name>jdbc/interbase</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and tie it to the pool in jboss.xml
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>jdbc/interbase</res-name>
<jndi-name>Interbase</jndi-name>
</resource-manager>
</resource-managers>
your code will refer to this as "java:comp/env/jdbc/interbase"
And most important:
when configuring the database : USE the Database dialect 1 for the tables.
Hope this going to help
henry voyer
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
�˛���m�ۢ�.���X��
+�)�v�,r����칻 �&ލ�,�� ��ߖ+-�x � �c롹^���
+�)�v�,r�
