VJDBC?
niklas woermann
nwoe at privat.utfors.se
Wed Mar 19 16:13:36 CST 2003
Hi!
i am not having any success whatsoever with the jdbc driver.
Since i am a new to coldfusion there might be some simple thing that i do wrong,
but i have tried all different variations of setting the path to the jar file and the path to the database and the only result i ever get is;
Connection verification failed for data source: ica8b
[]java.sql.SQLException: No suitable driver available for ica8b, please check the driver setting in jrun-resources.xml, error: com.paradigmasoft.valentina.vjdbc
The root cause was that: java.sql.SQLException: No suitable driver available for ica8b, please check the driver setting in jrun-resources.xml, error: com.paradigmasoft.valentina.vjdbc
the settings that i found in the jrun-resources.xml file are;
- <data-source>
<dbname>ica8b</dbname>
<driver>com.paradigmasoft.valentina.vjdbc</driver>
<url>jdbc:valentina://127.0.0.1/val_db/ica8.vdb</url> this is the url where the database is, i notice the other connections go for a specific port number here!
<username>assa</username>
<password>2C3CF3A439A6EADB94EE2B46C81D0142</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>ica8b</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>
</data-source>
TIA
niklas woermann
More information about the Valentina
mailing list