Use the JMC (JRun Management Console) on port 8000 - you may need to start the admin server for this - to add the data sources in the same way you would with the ColdFusion Administrator.
On Monday, Aug 11, 2003, at 12:18 US/Pacific, Angel Stewart wrote: > Ok..according to the ablecommerce support article, here's the problem > with 6.1 and Able: > > "For installations using JRun, the neo-query.xml and jrun-resources.xml > files are no longer synchronized. As a result, JRun users running the > J2EE configuration must add data sources to both ColdFusion > (neo-query.xml) and JRun (jrun-resources.xml)." > > I assume this would be an issue for other programs making similar use > of > these Jrun services. > > So...I now need to manually edit the jrun-resources.xml file in order > to > add all the Ablecommerce datasources. > > These are acbtest2...gvidirect_tt etc. etc. > > I am COMPLETELY lost looking at the sample XML data for a postgresql > database. What the heck would I use for a Microsoft Access database? > > I looked at the neo-query.xml file, but it isn't laid out the same way > as the jrun-resources.xml file... > So I tried to pull the relevant data and apply it to the appropriate > area in the jrun-resources.xml file.... > > Can anyone help?? > > <data-source> > <dbname>gvidirect_tt</dbname> > <driver>MSAccess</driver> > > <url>jdbc:sequelink:msaccess:// > localhost:19998;serverDatasource=gvidirec > t_tt</url> > <username /> > <password /> > <encrypted>true</encrypted> > > <encryption-class>jrun.security.JRunCrypterForTwofish</encryption- > class> > <native-results>true</native-results> > <remove-on-exceptions>true</remove-on-exceptions> > <pool-statements>false</pool-statements> > <initial-connections>0</initial-connections> > <connection-timeout>1200</connection-timeout> > <transaction-timeout>20</transaction-timeout> > <cache-enabled>false</cache-enabled> > <cache-size>5</cache-size> > <cache-refresh-interval>30</cache-refresh-interval> > <jndi-name>gvidirect_tt</jndi-name> > <poolname>Pool</poolname> > <minimum-size>0</minimum-size> > <maximum-size>2147483647</maximum-size> > <user-timeout>1200</user-timeout> > <skimmer-frequency>420</skimmer-frequency> > <shrink-by>5</shrink-by> > <maximum-soft>true</maximum-soft> > <debugging>false</debugging> > <disable-pooling>false</disable-pooling> > <isolation-level>READ_COMMITTED</isolation-level> > </data-source> > ??? > > I get an error saying it does not recognise the name of the > driver....MSAccess.....what's the correct name? > Where would I get this info? > > -Gel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
