Hi Per
sure, steps are as follows:
jboss.jcml:
Create a mbean instance like the following. Name the DB-pool whatever you like, here
I've used NewsPool. Default for login and password for Access 97 with ODBC is empty
<mbean>
<mbean name="DefaultDomain:service=XADataSource,name=NewsPool">
<attribute name="URL">jdbc:odbc:hund</attribute>
<attribute name="JDBCUser" />
<attribute name="Password" />
</mbean>
jboss.conf:
<MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="NewsPool">
<ARG TYPE="java.lang.String" VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>
Remember to copy the rt.jar to <JBOSS>\lib\ext directory. You should find rt.jar under
<JRE 1.3>\lib
jboss.properites:
jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver,org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver
ejb-jar.xml:
......
<resource-ref>
<description>A link to newsDB</description>
<res-ref-name>jdbc/newsDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
....
jboss.xml:
....
<resource-managers>
<resource-manager res-class="org.jboss.ejb.deployment.JDBCResource">
<res-name>jdbc/newsDB</res-name>
<res-jndi-name>NewsPool</res-jndi-name>
</resource-manager>
</resource-managers>
...
from my java code, calling the pool via JNDI:
....
Context initial = new InitialContext();
ds = (DataSource)initial.lookup("java:comp/env/jdbc/newsDB");
return ds.getConnection();
.....
A little explaining:
jdbc:odbc:hund is the URL to my Access database. Make the ODBC like this:
control Panel->ODBC DataSources:
under user-dsn->add
thoose Microsoft Access Driver (*.mdb)->apply
name your datasource name (here I've used hund)
click choose and point it to your *.mdb file
apply
...
The JdbcOdbcDriver will now read your URL like jdbc:odbc:<your datasource name>
Next step is to make a connection to the DB-pool via JNDI:
any connection to jdbc is created using the namespace: jdbc/<your choice>, seeing it
from the ejb-jar.xml point of view it should therefore read like above. From your code
it's a little different. In order to get a reference to the JNDI you use the following
syntax: java:comp/env/jdbc/<your choice>. As you can see from my snippets I've used
NewsDB as <your choice>
The only thing missing now is telling Jboss to connect to the DB-pool whenever it gets
a call to jdbc/<your choice>. This mapping is done in jbos.xml.
That's it.
Hope it helps, otherwise let me know and I'll see what I can do to help.
Please be aware that this solution only works with Session beans. If you need entity
beans instead, you'll need to set up the jaws.xml file among other. I can't help you
here, I haven't tried it out yet.
Cheers
Kris Kristensen
[EMAIL PROTECTED]
-----Oprindelig meddelelse-----
Fra: Per Nyfelt <[EMAIL PROTECTED]>
Til: jBoss <[EMAIL PROTECTED]>
Dato: 3. januar 2001 12:51
Emne: RE: [jBoss-User] MS Access 97 and stateless session beans
Hi Kris,
Any chance you could list the steps you had to go through to make it work and post
it here? I often start out with Access in the early phase of a project when the data
model is constantly changing before switching to MySQL but suffer from not having to
get Access to work with either JBoss or J2EE ref. impl so I end up playing crazy games
to get around that. I think there are more people out there who would benefit greatly
from a JBoss - Access mini-howto -maybe your experience could serve as a start of a
such...
Best regards,
Per
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Kris Kristensen
Sent: Wednesday, January 03, 2001 1:20 AM
To: Jboss-support
Subject: [jBoss-User] MS Access 97 and stateless session beans
Hi there!
I've managed to set up a connection pool for MS access 97 (JDBC-ODBC) and using
stateless session beans to connect to this pool and it actually works! So If there are
anybody out there trying to do the same without success, I'm willing to help you with
snippets from my configuration.
Cheers
Kris Kristensen
[EMAIL PROTECTED]
ps. Couldn't have done it without help from Jay Walters and Michel de Groot, so
thank's a lot for your help.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
