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
