error 08001 local database
Hi, I just install derby on my laptop and I'm trying to create a new database. The first time I try to write the command in ij but error 08001 has appear. The second time I just copy and paste the command from the tutorial page and I had have the same result. ij connect 'jdbc:derby:MyDbTest;create=true'; ERROR 08001: No suitable driver found for jdbc:derby:MyDbTest;create=true After the installation I've add this to .bashrc export PATH=$PATH:/usr/share/javadb/bin/ export DERBY_HOME=/usr/share/javadb I copy the exit of sysinfo if somebody could show me the problem - Información de Java Versión de Java: 1.8.0_25 Proveedor de Java: Oracle Corporation Inicio Java: /opt/jdk/jdk1.8.0_25/jre Classpath de Java: /usr/share/javadb/lib/derby.jar:/usr/share/javadb/lib/derbynet.jar:/usr/share/javadb/lib/derbytools.jar:/usr/share/javadb/lib/derbyclient.jar Nombre del SO: Linux Arquitectura del SO: amd64 Versión del SO: 3.13.0-45-generic Nombre usuario Java: portatil Dir. inicial usuario:/home/portatil Dir. usuario:/home/portatil/Documentos/Desarrollo/DB java.specification.name: Java Platform API Specification java.specification.version: 1.8 - Información de Derby JRE - JDBC: Java SE 6 - JDBC 4.0 [/usr/share/javadb/lib/derby.jar] 10.3.2.1 - (599110) [/usr/share/javadb/lib/derbytools.jar] 10.3.2.1 - (599110) [/usr/share/javadb/lib/derbynet.jar] 10.3.2.1 - (599110) [/usr/share/javadb/lib/derbyclient.jar] 10.3.2.1 - (599110) -- -- Información de entorno local -- Entorno local actual: [español/España [es_ES]] Se encontró soporte para el entorno local: [cs] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [de_DE] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [es] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [fr] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [hu] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [it] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [ja_JP] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [ko_KR] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [pl] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [pt_BR] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [ru] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [zh_CN] versión: 10.3.2.1 - (599110) Se encontró soporte para el entorno local: [zh_TW] versión: 10.3.2.1 - (599110) --
Re: error 08001 local database
On 2/7/2015 2:46 AM, Ignacio Yuste Lopez wrote: ij connect 'jdbc:derby:MyDbTest;create=true'; ERROR 08001: No suitable driver found for jdbc:derby:MyDbTest;create=true Which of the 3 ways of running ij that are documented here http://db.apache.org/derby/docs/10.11/getstart/tgsrunningij.html did you use? I copy the exit of sysinfo if somebody could show me the problem Versión de Java: 1.8.0_25 This is very new. [/usr/share/javadb/lib/derby.jar] 10.3.2.1 - (599110) This is very old. Why did you select such an old version of Derby? Does your problem persist if you use Derby 10.11? thanks, bryan
Re: error 08001 local database
hi, I use the first way. I installed java using directly but derby with the repository of Ubuntu. Ignacio Yuste López Camilo Jose Cela 8 Portal 2 3º puerta 6 Las Rozas de Madrid, 28232 Madrid On Sun, Feb 8, 2015 at 5:36 PM, Bryan Pendleton bpendleton.de...@gmail.com wrote: On 2/7/2015 2:46 AM, Ignacio Yuste Lopez wrote: ij connect 'jdbc:derby:MyDbTest;create=true'; ERROR 08001: No suitable driver found for jdbc:derby:MyDbTest;create=true Which of the 3 ways of running ij that are documented here http://db.apache.org/derby/docs/10.11/getstart/tgsrunningij.html did you use? I copy the exit of sysinfo if somebody could show me the problem Versión de Java: 1.8.0_25 This is very new. [/usr/share/javadb/lib/derby.jar] 10.3.2.1 - (599110) This is very old. Why did you select such an old version of Derby? Does your problem persist if you use Derby 10.11? thanks, bryan
updating a maximum of 2 records
Hi
I am trying to code for the ability to update either two records (the two
records which have the latest date time) or just one (the record which has
the latest date time) for the profit field
If two_time is TRUE, then two records are requiring updating, otherwise just
the one record
The records which need updating have 999.99 in the profit field initially
There are x+2 records in the database
At the moment, no updating is taking place - any idea why ?
// if we have two records to update
// i.e. the penultimate record which was closed at the last clock-in point
// and the ultimate record which was opened at the same time and has since
closed
if ((two_time) (!initialize) (myCanTrade) (myCurrPositionValue 0))
{
// retrieve the last two records
rs = s.executeQuery(SELECT * FROM TABLE ORDER BY Trading_Date ASC,
+ Trading_Time ASC OFFSET x ROWS FETCH NEXT 2 ROWS ONLY);
rs.next();
String Date2 = rs.getString(Trading_Date);
int Time2 = rs.getInt(Trading_Time);
s.setCursorName(MYCURSOR);
rs = s.executeQuery(SELECT * FROM TABLE WHERE Date = + Date2 + AND Time
= + Time2 + FOR UPDATE);
rs.next();
conn.prepareStatement(UPDATE TABLE SET PROFIT_LOSS = prev_profit WHERE
CURRENT OF MYCURSOR).executeUpdate();
prev_profit = 0;
//move on to the last record
rs.next();
String Date3 = rs.getString(Trading_Date);
int Time3 = rs.getInt(Trading_Time);
s.setCursorName(MYCURSOR);
rs = s.executeQuery(SELECT * FROM TABLE WHERE Date = + Date3 + AND Time
= + Time3 + FOR UPDATE);
rs.next();
conn.prepareStatement(UPDATE TABLE SET PROFIT_LOSS = profit WHERE CURRENT
OF MYCURSOR).executeUpdate();
two_time =false;
} // end of updating the last two records
else {
// else, if we have just the one record to update
// retrieve and output date and time of the latest record from the table
// providing this is not the first trade and we are about to open a new
trade !
if ((!initialize) (myCanTrade) (myCurrPositionValue 0)) {
psUpdate = conn.prepareStatement(UPDATE TABLE SET PROFIT_LOSS=? WHERE
PROFIT_LOSS = 999.99);
statements.add(psUpdate);
psUpdate.setDouble(1, profit);
psUpdate.executeUpdate();
}
} // end of updating latest record
*
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/updating-a-maximum-of-2-records-tp143764.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
