component output="false"{
this.name = "application-name"; // name of the application
this.datasources["datasource_name"] = { class: 'net.ucanaccess.jdbc.UcanaccessDriver' , connectionString: 'jdbc:ucanaccess://path_to_zour_site_root/base/name_of_access_base.accd' };
}
<cfprocessingdirective pageencoding="utf-8" suppresswhitespace="yes">
<cfdbinfo datasource="#datasource_name#"
name="name_of_access_base"
table="<name_of_any_table_in_access_base>"
type="tables"
/>
<cfdump var="#name_of_access_base" label="base" expand="yes" />
</cfprocessingdirective>
Thanks a lot for help.
No success for the moment.
I have located the jar files in c:\Program Files\Lucee\
That’s where all lucee jar files are,
And I found there : hypersonic-hsqldb.jar
Which I renamed to : hypersonic-hsqldb_old.jar (so not usable)
I left the files like :
ucanaccess-3.0.3.1.jar and its lib as sub-directory
When I declared the datasource in Lucee (first method), I got this message :
Could not initialize class net.ucanaccess.jdbc.UcanaccessDriver
Do you think some files are not located correctly ?
Thanks for any advise.
Pierre.
De : lu...@googlegroups.com [mailto:lu...@googlegroups.com] De la part de Milan Markovic
Envoyé : mercredi 20 janvier 2016 21:13
À : Lucee
Objet : [Lucee] Re: setting an access (mdb file) datasource
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/gA3NuJLWxvo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/01b54bc1-0e49-4467-b1ec-06bda240f25f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
|
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/a1c826a3-b17e-4172-8e35-654ed22ca12e%40googlegroups.com.
OK, sorry,
I did not notice the new “hsqldb.jar”,
Make sense , it must replace the old one at same place.
So all ucanaccess jar files are in c:\program files\lucee (not in a lib dir)
I restarted Tomcat, OK
I declared the datasource,
AND IT WORKS , GREAT.
I will able to use Lucee, now,
Last thing to check , is the search engine.
(all my sites use Access, small sites with few users or information systems,
Also I may have many access mdb files for a single site, for different functions)
Access is simple and very flexible. For the moment, I never have the obligation to upgrade to MySQL or MSSql.
Thanks a lot, Pierre.
De : lu...@googlegroups.com [mailto:lu...@googlegroups.com] De la part de Milan Markovic
Envoyé : vendredi 22 janvier 2016 12:27
À : Lucee
Objet : [Lucee] Re: setting an access (mdb file) datasource
Are you sure you're all jar copied to the folder where it was old hypersonic-hsqldb.jar?
Milan
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/gA3NuJLWxvo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/80e822a5-7055-48bf-aad7-5bf97902e8ce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Lucee 4.5.2.018 Error (database) | |
Message | UCAExc:::3.0.3.1 Cannot write indexes of this type due to unsupported collating sort order SortOrder[1036(0)] for text index (Db=nadinefrance.mdb;Table=famille;Index=0) |
SQL | update famille set nb_prod=3 where id_fam=10 |
DatabaseName | Ucanaccess for access db(Jet) using hasqldb |
DatabaseVersion | V2000 [VERSION_4] |
DriverName | Ucanaccess |
DriverVersion | 3.0.3.1
|
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/gA3NuJLWxvo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/abc048a8-2a87-4ce9-a119-6a90d9e6d90d%40googlegroups.com.
Thanks for your answer,
Compact and repair database did not solve the problem.
I found the problem by modifying the field type from :
“Numeric long integer” to “Numeric integer” (not long)
This is OK for the 32000 maximum value (I do not need more).
Could you help on “collation mode to general on the database” , I never used this.
What is this concept, Is that to do with field types ?
Also, for information, in spite of the error message,
The SQL was been done, the update was done, but the process stopped with the error.
Thanks again for assistance.
Pierre.
De : lu...@googlegroups.com [mailto:lu...@googlegroups.com] De la part de Milan Markovic
Envoyé : lundi 1 février 2016 00:36
À : Lucee
Objet : Re: [Lucee] Re: setting an access (mdb file) datasource
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAJc2C%2BZGcB6aKJJdpCfjfUcGURgc63vZ8H_UF64FsvhSvknCDw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Hi Pierre,
See the following links:
Message | UCAExc:::3.0.3.1 Cannot write indexes of this type due to unsupported collating sort order SortOrder[1036(0)] for text index (Db=nadinefrance.mdb;Table=famille;Index=0) |
SQL | insert into famille (apellation_fam,description_fam,active_fam,order_fam,famille_fam,date_crea) values ('Ppp','Ppp',1,17,0,{d '2016-02-01'}) |
DatabaseName | Ucanaccess for access db(Jet) using hasqldb |
DatabaseVersion | V2000 [VERSION_4] |
DriverName | Ucanaccess |
DriverVersion | 3.0.3.1 |
Datasource | C013_nadinefrance |
Stacktrace ... | The Error Occurred in C:\Tomcat\webapps\ROOT\sites\nadinefrance\admin_photo\create_famille_save.cfm: line 60 58: (apellation_fam,description_fam,active_fam,order_fam,famille_fam,date_crea) I did change all numeric long integer fields to numeric integer. This solved the problem, the first time. But now I get it again. I do not see what I can do. Thank you far any advise, help, support in using the Ucanaccess driver. (this problem appear in update and insert SQL) |
To unsubscribe from this group and all its topics, send an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/abc048a8-2a87-4ce9-a119-6a90d9e6d90d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/gA3NuJLWxvo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAJc2C%2BZGcB6aKJJdpCfjfUcGURgc63vZ8H_UF64FsvhSvknCDw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Message | com.healthmarketscience.jackcess.util.ErrorHandler |
Cause | java.lang.ClassNotFoundException |
Thanks a lot,
Yes with all files, it does work.
Great.
I will check more deeply tomorrow.
Thanks again,
Pierre.