I have been given a task of showing how to connect to an external database using JBoss. I am using a standalone version of Hypersonic. I have created a new hsqldb-ds.xml file that I think should be connecting to the external db.
| <datasources> | <local-tx-datasource> | <jndi-name>HypersonicDS</jndi-name> | <connection-url>jdbc:hsqldb:hsql://localhost/bookdb</connection-url> | <driver-class>org.hsqldb.jdbcDriver</driver-class> | <user-name>sa</user-name> | <password></password> | <min-pool-size>5</min-pool-size> | <max-pool-size>20</max-pool-size> | <idle-timeout-minutes>0</idle-timeout-minutes> | <track-statements/> | <metadata> | <type-mapping>Hypersonic SQL</type-mapping> | </metadata> | <depends>jboss:service=Hypersonic</depends> | </local-tx-datasource> | <mbean code="org.jboss.jdbc.HypersonicDatabase" | name="jboss:service=Hypersonic"> | <attribute name="Port">1701</attribute> | <attribute name="Silent">true</attribute> | <attribute name="Database">default</attribute> | <attribute name="Trace">false</attribute> | <attribute name="No_system_exit">true</attribute> | </mbean> | </datasources> | When I put a new version of this file in the default/deploy directory I get a message that the Datasource has been bound to the name 'java:HypersonicDS'. In my Java app I am connecting successfully to the naming service, but I get a NameNotFoundException when I try and access the JNDI name. I have tried several different versions. I am trying to get this to work before I deploy an Entity bean that uses the external Hypersonic database. Thanks. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849895#3849895 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849895 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
